recent commits & change log
Aug 18, 2026 - Update from CP v31 for public...
Aug 17, 2026 - Updated rule 246 to works with...
Aug 17, 2026 - Update rule submission forms f...
Aug 18, 2026 - Update from CP v31 for public...
Aug 17, 2026 - Updated rule 246 to works with...
Aug 17, 2026 - Update rule submission forms f...
Rule ID: DQC.US.0246
Status: Public Review
Public Review: August 15 - September 30, 2026
Purpose:
The purpose of Rule DQC.US.0246 is to validate the use of key-value pairs within the InvestmentIdentifierAxis dimension on a Schedule of Investments (SOI). When filers use the pipe-delimited format (SecurityName|KEY1=value1 KEY2=value2 ...) on the InvestmentIdentifierAxis, this rule ensures the format is correct, keys are valid, values are valid, required keys are present, and the security name portion is unique.
Conditions:
The rule consists of five assertions:
Fires when the security name (the portion before the | character) is not unique across all InvestmentIdentifierAxis dimension members that use the key format. Each security title must be unique for each investment identifier.
Fires when a key used in the KEY=value pairs is not one of the approved keys. The approved keys are:
| Key | Description | Allows Extension | Allows Standard |
|---|---|---|---|
| AFF | Investment Issuer Affiliation | No | Yes |
| GEB | Geographic Basis | No | Yes |
| GEO | Geographic Location | No | Yes |
| IND | Industry | Yes | Yes |
| ISS | Investment Issuer Name | Yes | No |
| TYP | Investment Type Categorization | No | Yes |
| VRB | Variable Rate | Yes | Yes |
Fires when the same key appears more than once in the key-value pairs for a single security. Each key must be unique within a given dimension member value.
Fires when a key value does not match the allowed values defined for that key. The allowed values are determined by the domain members associated with each key.
Fires when one or more required keys are missing from the key-value pairs. The required keys are: AFF, ISS, and TYP. And either one of GEO or IND must be present.
The InvestmentIdentifierAxis dimension uses a structured key-value format to identify attributes of securities on a Schedule of Investments. This format follows the pattern:
SecurityName|AFF=value GEO=value IND=value ISS=value TYP=value
For example:
Mood Media Borrower, LLC, Debt investments, First Lien Term Loan|ISS=Mood_Media_Borrower_LLC TYP=Debtinvestments STY=First_Lien_Term_Loan GEO=US
Without validation, filers may use incorrect keys, invalid values, duplicate keys, or omit required keys, leading to inconsistent and unreliable data. This rule ensures the key-value format is properly structured and contains valid information.
The filing has used InvestmentIdentifierAxis dimension with keys to identify the attributes of the security. The value of the InvestmentIdentifierAxis dimension is required to be unique for each investment identifier. When using a key the security title before the | character must be unique. The following duplicate values have been identified for the InvestmentIdentifierAxis dimension: Mood Media Borrower, LLC. Please ensure that the value of the InvestmentIdentifierAxis dimension title is unique for each investment identifier.
Rule Element Id: 10948
Rule version: 29.0.0RC1
The filing has used InvestmentIdentifierAxis dimension with keys to identify the attributes of the security. The following key(s) have been identified as not being valid for the InvestmentIdentifierAxis for the security Mood Media Borrower, LLC with the non standard keys: STY. Please ensure that the keys used are valid for the InvestmentIdentifierAxis dimension.
Rule Element Id: 10949
Rule version: 29.0.0RC1
The filing has used InvestmentIdentifierAxis dimension with keys to identify the attributes of the security. The following key(s) have been identified as being duplicated for the InvestmentIdentifierAxis for the security Mood Media Borrower, LLC with the duplicated keys: GEO. Please ensure that the keys used are unique for the InvestmentIdentifierAxis dimension.
Rule Element Id: 10950
Rule version: 29.0.0RC1
The filing has used InvestmentIdentifierAxis dimension with keys to identify the attributes of the security. The following key(s) have invalid values for the InvestmentIdentifierAxis for the security Mood Media Borrower, LLC with the invalid key values: GEO=INVALID. Please ensure the keys used are valid for the InvestmentIdentifierAxis dimension.
Rule Element Id: 10951
Rule version: 29.0.0RC1
The filing has used InvestmentIdentifierAxis dimension with keys to identify the attributes of the security. The following required key(s) have been identified as missing for the InvestmentIdentifierAxis for the security Mood Media Borrower, LLC with the missing keys: AFF, TYP. Please ensure that the required keys are present for the InvestmentIdentifierAxis dimension.
Rule Element Id: 10952
Rule version: 29.0.0RC1
The rule element ID is used to identify unique elements or combinations of elements tested in the rule.
| Rule Element ID | Element |
|---|---|
| DQC.US.0246.10948 | Duplicate security names in InvestmentIdentifierAxis key format |
| DQC.US.0246.10949 | Invalid keys used in InvestmentIdentifierAxis key format |
| DQC.US.0246.10950 | Duplicate keys in InvestmentIdentifierAxis key format |
| DQC.US.0246.10951 | Invalid key values in InvestmentIdentifierAxis key format |
| DQC.US.0246.10952 | Missing required keys in InvestmentIdentifierAxis key format |
The rule operates on all dimension members of InvestmentIdentifierAxis that contain both a | character and an = character, indicating the key-value format is in use.
Parsing Logic:
| — the first segment is the security name, the second segment contains the key-value pairs.= signs, then split by spaces to extract individual KEY=value pairs.= to separate the key name from the key value.Assertion 10948 compares the list of security names (segment before |) against its deduplicated set to detect duplicates.
Assertion 10949 compares the extracted key names against the approved key set defined in $APPROVED_KEYS.
Assertion 10950 checks whether the count of keys exceeds the count of unique keys for each security.
Assertion 10951 looks up each key-value pair in the $ALLOWED-KEYS_DICTIONARY constant to verify the value is valid for the given key.
Assertion 10952 computes the set difference between required keys (AFF, GEO, IND, ISS, TYP) and the keys present in the dimension member.
Filers should ensure that:
|) is unique across all InvestmentIdentifierAxis members.The rule exists in the 2024, 2025, and 2026 US GAAP taxonomy versions.
© Copyright 2017 - 2026 XBRL US, Inc. All rights reserved.
See License for license information.
See Patent Notice for patent infringement notice.
Comment
You must be logged in to post a comment.