5.2 Duplicate Facts

In a data point model, an individual fact may appear on more than one table.  In an XBRL instance, it is not possible to determine from which table a duplicate fact originates since duplicate facts contain the exact same XBRL tag - in fact, duplicate facts are only inserted into the XBRL instance once regardless of how many times they appear across the set of tables being submitted.

Duplicate facts and Report Authority

In Report Authority, duplicate facts are treated as separate data points and can be mapped to different data sources and consequentially could have different values.  In this case, Report Authority will report "Inconsistent Duplicate Facts" errors on validation.

Because a fact can only be inserted into the XBRL instance once, Report Authority will insert the value of the first occurrence of a particular data point into the XBRL instance and omit the values of all other occurrences.  Since the values of all duplicate facts should be the same, any software which is parsing the XBRL instance will read the value of the single fact and interpret it to be the value of that data points in all tables.

If a Report Authority document contains different values for a duplicate fact, only the value of the first occurrence will be inserted in the XBRL instance and therefore the value of this data point across all tables will be interpreted to be this value. For this reason, if any Inconsistent Duplicate Fact validation failures are ignored, you may receive inconsistent and unexpected validation failures when submitting the XBRL to your supervisor compared with the validation results in Report Authority.

Resolving inconsistent duplicate fact errors

When validating reports, you will be prompted to resolve inconsistent duplicate fact errors before trying to resolve any validation errors. Inconsistent duplicate fact errors will be displayed in the validation pane.

In the below example, the validation pane is grouped by Category and then Validation Message:

This helps to group the duplicate facts that should be the same value. If you select the inconsistent duplicate fact error it will automatically select the error within the report and can be viewed in the Tables pane.

Duplicate facts and Stated Accuracy

XBRL validations are often tolerant of small differences. The tolerance can increase depending on the number of data objects used in a validation rule and the Stated Accuracy set for the document.

This does not, however, apply to the inconsistent duplicate fact checks, because this is not an XBRL business validation rule.  All differences will be shown regardless of the amount that the facts do not agree. 

This includes the example where one fact is reported with a "0" and one fact which is left empty. Even though empty cells are often interpreted as "0"s in validation rules - in the XBRL - either both facts will be reported as empty or as "0"s.  There is a conceptual difference between reporting a "0" and not reporting a fact which is why these will be flagged.

Duplicate facts and the CRD IV taxonomies

Data point IDs are displayed in the annotated table layouts issued by the EBA in Excel format.  Duplicate facts will contain the same data point ID.  An example is Equity instruments held for trading which has an ID of 11112 and appears in table F 01.01:

...and table F 04.01:

The EBA validation rules contain a rule category "Identity" (which contain the "_i" suffix) to identify the validation rules relating to duplicate facts. (Note that these rules are not implemented in the XBRL since it is not possible to determine from the XBRL from which table a duplicate fact originates).

Duplicate facts and the Solvency II taxonomies

Duplicate facts are listed in the EIOPA Solvency II Validations Excel file in the sheet titled "Identical datapoints":

Still need help? Contact Us Contact Us