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...

Rule ID: DQC_0246 US GAAP comment period closes September 30, 2026.
View: as part of public exposure version v31

Investment Identifier Axis Key Validation

Rule ID: DQC.US.0246
Status: Public Review
Public Review: August 15 - September 30, 2026

Rule Function

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:

Assertion 10948 — Unique Security Name

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.

Assertion 10949 — Valid Keys

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

Assertion 10950 — No Duplicate Keys

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.

Assertion 10951 — Valid Key Values

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.

Assertion 10952 — Required Keys Present

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.

Problem Solved by the Rule

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.

Example Rule Messages

Assertion 10948 — Duplicate Security Name

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

Assertion 10949 — Invalid Keys

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

Assertion 10950 — Duplicate Keys

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

Assertion 10951 — Invalid Key Values

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

Assertion 10952 — Missing Required Keys

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

Rule element ID index

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

Technical Details

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:

  1. The dimension member value is split by | — the first segment is the security name, the second segment contains the key-value pairs.
  2. Key-value pairs are cleaned by removing spaces around = signs, then split by spaces to extract individual KEY=value pairs.
  3. Each pair is split by = 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:

  • Each security name (before the |) is unique across all InvestmentIdentifierAxis members.
  • Only approved keys are used (AFF, GEB, GEO, IND, ISS, TYP, VRB).
  • No key is repeated within a single dimension member.
  • Key values match the allowed domain members for each key.
  • All five required keys (AFF, GEO, IND, ISS, TYP) are present.

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