Best Practices on Extending CEBS Taxonomies

From XBRLWiki

(Difference between revisions)

Current revision

Contribution dated 2007-11-02

1 Abstract
2 Status
3 Modularity
4 National Taxonomy Customisation COREP - FINREP

Abstract

This document describes the best practices on how to extend CEBS (Committee of European Banking Supervisors) taxonomies. The Committee of European Banking Supervisors (CEBS) has published XBRL taxonomies for the common reporting framework COREP (COmmon REPorting) for the new solvency ratio for credit institutions and investment firms and for the standardised financial reporting framework (FINREP) for credit institutions operating in the EU. These taxonomies are available on the website of the CEBS http://www.c-ebs.org and on the project related websites http://www.corep.info and http://www.finrep.info. Comment

[edit]

Status

This draft document is created by members of the XBRL network of the CEBS. Taxonomy editors that are extending the CEBS taxonomies (COREP and/or FINREP)are invited to add comments, experiences and suggestions for improvement on how to extend these taxonomies in a practical way.

KS: As a first approach I've added chapter 7 of the COREP-FINREP documentation that deals with the extension of these taxonomies.

[edit]

Modularity

Each supervisor decides on the scope of reporting, thus the Discoverable Taxonomy Sets (DTS) of the CEBS XBRL Network are constructed as modular as possible. This means that the taxonomy can be easily extended or restricted.

Each template taxonomy consists of one template taxonomy that imports one template specific primary taxonomy and none or several common primary taxonomies as well as none or several dimension taxonomies, according to the corresponding COREP template. The primary taxonomy name starts with prefix "p-" and the dimension taxonomy with "d-".

This modular structure guarantees a flexible maintenance of an extensible model that can be reused in other places. Furthermore, the modular structure eases the national adaptation of the COREP or FINREP taxonomy. It is needed to know the elements with the same meaning used in different templates, i. e. for a generic database mapping. The maintenance of these elements can be reduced and the relations between templates can be identified easily. In the COREP taxonomy elements with the same meaning were identified by business experts and extracted in separate primary taxonomies for each template group. In the FINREP taxonomy exists one common primary taxonomy that imports the IFRS taxonomy.

Each template taxonomy name starts with the prefix “t-“. Compared to primary and dimensional taxonomies, a template taxonomy has neither its own presentation linkbase nor a reference linkbase. The main purpose of a template taxonomy is to define the relations between primary and dimensional items, which means to describe which combinations of dimensions are valid for a primary item and which are invalid. This is done in the definition linkbase according to the rules described in the Dimensions 1.0 Specification.

To reach this modularity the FINREP taxonomy has been changed from a monolithic version to a modular one. The monolithic appproach with only one entry point consisted of only one template and one primary taxonomy, that contained primaries, hypercubes and dimension elements, and several dimension taxonomies. The monolythic version had only one xml file per linkbase type. In comparison to this the modular structure has different primary and template taxonomies for each FINREP template and therefore several entry points. Because all FINREP specific primaries are summarized in one common taxonomy both approaches are equivalent on instance document basis. A monolythic structure could be rebuild by importing all modular template taxonomies in one envelope taxonomy. The versions 1.0 and 1.2 of the FINREP taxonomy provided both approaches. The successive version 1.3 contains only the modular design.

[edit]

National Taxonomy Customisation COREP - FINREP

Extending the COREP and FINREP taxonomies is a similar process. In this document a COREP template is used for demonstration purposes; however, all the information provided below holds true for FINREP, as well. Please always take into account that FINREP modularisation is achieved by the use of extended link roles in only one primary taxonomy.

The COREP - FINREP taxonomies have been developed to be customisable – that means extensible and restrictive – by national supervisors. To facilitate the customisation of the taxonomies, the framework is as modular as possible and the structure of the taxonomies is similar to the construction of the CEBS COREP - FINREP templates. This means that the templates consist of measure and dimensions which are combined in a table. Therefore, the COREP taxonomy set consists of measure (primary dimension), dimension and template taxonomies.

In order to build extension taxonomies, the use of a taxonomy editing tool is recommended for their creation and maintenance. Links to useful XBRL tools for evaluation are available on the XBRL International website (http://www.xbrl.org).

[edit]

National extension structure

National extensions will use the COREP taxonomy as a base. Extensions are done by creating new taxonomies and importing the corresponding COREP taxonomies. So, the national extension taxonomy contains all the functionality of the underlying COREP taxonomy. Changes are made in the national extensions without amending the base COREP taxonomy. The national extension taxonomy can overwrite all the rules that are defined in the imported COREP taxonomy.

[edit]

Categorisation of national taxonomy extensions

Customisations can be made on:

labels
references
the template structure
calculations.

The following chapters deal with these customisations and how these changes can be made easily for national extension taxonomies.

[edit]

Definition of the target namespace

All extension taxonomies should share the same structure for the target namespace.
None of the schema files should use a default namespace. The namespace should be declared explicitly and have defined prefix.

The URL of the target namespace should consists of the following hierarchies:

URL of the national central bank
juridiction
reporting type
appriviation that delimites the scope
project name
version date

The target namespaces of COREP as well as FINREP follow these rules: http://www.c-ebs.org/eu/fr/esrs/corep/2005-09-30/

URL	http://www.c-ebs.org
juridiction	eu
reporting type	fr (financial reporting)
appriviation that delimites the scope	esrs (European System Reporting Standard)
project name	corep (COmmon solvency ratio REPorting framework)
version date	2005-09-30

The assigning of names within the extension taxonomy should follow the naming conventions which were introduced by the COREP/FINREP taxonomies. Hence, the first letter of a taxonomy defines the type of taxonomy:

“d” for dimensional taxonomies whose values are recorded in the context element,
“p” for taxonomies containing elements that appear in isolation in the XBRL instance report
“t” for taxonomies containing a mix of dimensional and value-related taxonomies.

[edit]

Creating extension taxonomy

All customisations start with the creation of a reference to the COREP taxonomy. This is done by building a new national taxonomy and importing the corresponding COREP taxonomy.

To customise a COREP template, a national taxonomy (i.e. “t-me-ISO country code-2006-MM-dd”) must be created. After setting up all the properties and the national namespace, the corresponding taxonomy of COREP should be imported.

After the import, the national extension taxonomy possesses the complete functionality of the underlying COREP taxonomy.

[edit]

Customisation of labels

The labels of the COREP taxonomy contain the captions of the columns and rows of the templates and can be used to create reports. For example, the receipt of an XBRL instance document could be transformed into other formats as Adobe Pdf or Microsoft Excel to enable easier viewing of the data. In such documents, the labels are used to hide the technical element name. To generate reports in the national language, the English labels of the COREP taxonomy should be translated accordingly. This is done by adding a label linkbase to the extension taxonomy. In this way, each national supervisor can create a COREP dictionary to present reports in one or more languages.

[edit]

Customisation of references

The COREP templates are based on the EU directive of Basel II. Therefore, references to this EU law will be added to the elements of the COREP taxonomies in version 1.0. If a national law exists that defines what must be reported, this law should be added as a reference because it overrides the rules of the EU directive.

Additional references are added by extending the national taxonomy with another reference linkbase.

A reference to the COREP base taxonomy can be removed by prohibiting the use of the reference arc.

The references build a good glossary because by following the reference of an element, the explanation of what has to be reported can be found in the EU directive or in the national law. No further descriptions are needed.

The COREP taxonomy uses a specific reference structure that accommodates the structure of the EU directive. The national law might have a different structure. To customise the reference structure, the basic reference linkbase should be extended by adding additional elements.

[edit]

Customisation of the template structure

This sub-chapter briefly describes the following use cases and how they can be incorporated in the national extension taxonomy:

adding or removing columns and rows;
reordering the hierarchical structure of a template;
restricting cells from being reported (adding “grey cells”);
removing dimensions from a template;
providing choices among dimensions.

Extensions are explained here by using a small section of the FIRB CRM template with two dimensions (see the template below).

[edit]

Adding or removing columns and rows

A national supervisor might decide that a column defined in the COREP structure is not needed for the reporting in his country, and so he wants to remove this column. Or else, he needs further information in the template and wants to add an additional column that is not defined in the COREP superset.

A column is removed by prohibiting the use of the arc between the measure and its superordinate parent element. An additional measure will be added in the national extension taxonomy and will be placed in the desired position in the presentation and definition linkbases by adjustment of the order attribute.

Column C has to be removed and column F has to be added. So, the original structure “ABCDE” changes to “ABDEF”.

The order of the measures in a template is represented in a hierarchical structure in the presentation and definition linkbases of a taxonomy, as shown below.

Column C is removed by prohibiting the use of the arc between the measure and its superordinate parent element (MKR SA EQU (measure)). An additional measure (column F) will be added in the national extension taxonomy and will be placed in the desired position in the presentation and definition linkbases.

[edit]

Reordering the hierarchical structure of a template

The structure of a template can be changed by reordering the measures. If a new measure is added to a parent measure element, it will be positioned at the end of the hierarchical structure. The positioning of new measures as well as for existing can be changed if it is required by the national supervisor.

In this example, column F should move between the columns B and D.

In the hierarchical structure, the reordering of the measures is done by changing the order attribute in the presentation and definition linkbases.

[edit]

Restricting cells from being reported

Every cell of a template is a combination of a measure and one or more dimensions. Some row/column combinations are not valid for the EU directive of Basel II and must not be reported. They are marked in grey inside the COREP templates. National taxonomies can extend or override those restrictions.

In the example below, the new measure is only valid for the parent element “EQUITIES IN TRADING BOOK” and its child “General Risk”.

The COREP taxonomy defines the general binding between the measures and their corresponding dimensions in the definition linkbase of each template taxonomy. This is done by defining a hypercube that contains abstract dimension item elements for each defined dimension and domain elements of the dimension taxonomies. For the explicit dimensions, the corresponding domain-member elements are assigned to the domain.

To restrict the cell of the example above from being reported, the national extension taxonomy must define an abstract element, called hypercube. This hypercube element must be placed inside an additional extended linkrole of the definition linkbase.

The hypercube will contain the abstract dimension element of the template with the arcrole “.../hypercube-dimension” and the subordinated child element that has to be excluded with the arcrole “…/dimension-domain”. If more than one child should be excluded, all these elements can be assigned as child elements of the dimension element with the arcrole “…/dimension-domain”; or, the abstract domain element of the dimension is assigned to the dimension element and all subordinated child elements of the dimension will get children of these domain element with the arcrole “…/domain-member”. It is also possible to refer to all child elements of the dimension by using the targetRole attribute on the “…/dimension-domain” arc that points to the general link role

[edit]

Removing dimensions from a template

A banking supervisor can decide that a dimension of a COREP template is not needed for his national purposes. In the example below the dimension “National Market” should be deleted.

The national taxonomy can be created to reflect this requirement by removing the connection between the abstract measure element and the dimension that is not needed in the definition linkbase of the template taxonomy.

In the example above the definition of the hypercubes has to be changed by prohibiting the arc between the hypercube element and the dimension element.

[edit]

Providing choices among dimensions

If a banking supervisor decides that one of two or more possible dimensions has to be used for a national COREP template, it can define this choice inside the template as well as in the taxonomy. In the example below, either Dimension SA or Dimension IRB has to be used in the national template.

So, a measure can be reported in combination with one or more of the other dimensions and dimension SA, or in combination with one or more of the other dimensions and dimension IRB, but dimensions SA and IRB cannot be used together.

The national supervisor has to define a hypercube with one abstract dimension element in this national extension for those dimensions that are built as choice, and further dimension elements for the possible other dimensions. The domain elements of both dimensions are assigned to this dimension element with the arcrole “…/dimension-domain”. The child elements of the dimensions are listed below the domain element.

Now it is ensured that only one child element of either of the two domains can be used together with other possible dimension items that are listed in the hypercube. In the example above, the hypercube would be connected with the abstract domain element of the primary dimension (measure) taxonomy with the arcrole “…/all”.

[edit]

Adding dimensions to a template

A supervisor might decide that an additional breakdown for a total is needed. This means that additional columns are added to a template.
Example: The CRD group consolidation of the FINREP taxonomy does not provided possibilities to model both, the IFRS group and the CRD group, as consolidation scope. Supervisors who want to provide these additional information have to extend their taxonomy by adding a new dimension.

The first "column" (IFRS Scope) represents the total amount and matches up with the information that should be reported in those countries that do not include this breakdown.

From a technical perspective a new dimension taxonomy and its corresponding linkbases have to be created which includes the new members. The first column "IFRS Scope" is also added to this taxonomy but as a default member. [Excursus: If the arc role "http://xbrl.org/int/dim/arcrole/dimension-default" is set on a dimension member than this dimension member is the default and it must not appear in a context of an instance. If the primary is used in an instance without a reference to a dimension member than it must be assigned to the default.]

In the example above a new dimension "Activity" has been created with the default dimension value "IFRS Scope".

These changes should not have any influence on the core taxonomy. The linking of the primary items of the core taxonomy and the new dimension must be implemented at extension level. The country specific template taxonomy has to import the new dimension taxonomy and define the additional links.

With this approach we achieve compatibility between instance documents of countries using this breakdown and those who do not include the activity dimension in their extension of FINREP because the "IFRS Scope" member has been modelled as the default value of the new dimension.

Because this example is a real business case the CEBS XBRL network has provided an optional module to be downloaded from the following website:
Link: Optional module for the dimension activity
The advantages of this approach are the reuse of the elements of the core taxonomy and the compatibility to other extensions of the FINREP taxonomy.

[edit]

Customisation of calculations

The calculation linkbase is used to define summations among measures in the measure taxonomies and to define aggregator-contributor relationships among dimension members of the corresponding dimension taxonomies.

The definition of calculations in the measure taxonomies enables the validation inside one context. Given that the measures of one row of a template are contained in one context because each row belongs to a different dimension, it is not possible to do the calculation across dimensions. In the future, the formula linkbase will support cross-context summations.

The national supervisors through the national taxonomies can extend and restrict the definitions of the calculation linkbases. It is done in the same way as before; by adding new element trees (adding calculations) or prohibiting arcs (removing calculations) in the linkbase.

Retrieved from "http://xbrlwiki.info/index.php?title=Best_Practices_on_Extending_CEBS_Taxonomies"

-[[Image:Corep_finrep_logo.gif]]
+[[Image:Eurofiling-pp.jpg]]
 <br/><br/>
 Contribution dated 2007-11-02
 <tr><td bgcolor="#FFFF99">KS: As a first approach I've added chapter 7 of the COREP-FINREP documentation that deals with the extension of these taxonomies.
 </td></tr></table>
+===Modularity===
+Each supervisor decides on the scope of reporting, thus the Discoverable Taxonomy Sets (DTS) of the CEBS XBRL Network are constructed as modular as possible. This means that the taxonomy can be easily extended or restricted.
+Each template taxonomy consists of one template taxonomy that imports one template specific primary taxonomy and none or several common primary taxonomies as well as none or several dimension taxonomies, according to the corresponding COREP
+template. The primary taxonomy name starts with prefix "p-" and the dimension taxonomy with "d-".
+[[Image:Corep_modular.gif]]
+This modular structure guarantees a flexible maintenance of an extensible model that can be reused in other places. Furthermore, the modular structure eases the national adaptation of the COREP or FINREP taxonomy. It is needed to know the elements with the same meaning used in different templates, i. e. for a generic database mapping. The maintenance of these elements can be reduced and the relations between templates can be identified easily. In the COREP taxonomy elements with the same meaning were identified by business experts and extracted in separate primary taxonomies for each template group. In the FINREP taxonomy exists one common primary taxonomy that imports the IFRS taxonomy.
+[[Image:Finrep_modular.gif]]
+Each template taxonomy name starts with the prefix “t-“. Compared to primary and dimensional taxonomies, a template taxonomy has neither its own presentation linkbase nor a reference linkbase. The main purpose of a template taxonomy is to define the
+relations between primary and dimensional items, which means to describe which combinations of dimensions are valid for a primary item and which are invalid. This is done in the definition linkbase according to the rules described in the Dimensions 1.0 Specification.
+To reach this modularity the FINREP taxonomy has been changed from a monolithic version to a modular one. The monolithic appproach with only one entry point consisted of only one template and one primary taxonomy, that contained primaries, hypercubes and dimension elements, and several dimension taxonomies. The monolythic version had only one xml file per linkbase type. In comparison to this the modular structure has different primary and template taxonomies for each FINREP template and therefore several entry points. Because all FINREP specific primaries are summarized in one common taxonomy both approaches are equivalent on instance document basis. A monolythic structure could be rebuild by importing all modular template taxonomies in one envelope taxonomy. The versions 1.0 and 1.2 of the FINREP taxonomy provided both approaches. The successive version 1.3 contains only the modular design.
 ==National Taxonomy Customisation COREP - FINREP==
 *	the template structure
 *	calculations.
 The following chapters deal with these customisations and how these changes can be made easily for national extension taxonomies.
+===Definition of the target namespace===
+All extension taxonomies should share the same structure for the target namespace.<br/>
+None of the schema files should use a default namespace.
+The namespace should be declared explicitly and have defined prefix.<br/>
+The URL of the target namespace should consists of the following hierarchies:
+* URL of the national central bank
+* juridiction
+* reporting type
+* appriviation that delimites the scope
+* project name
+* version date
+The target namespaces of COREP as well as FINREP follow these rules:
+http://www.c-ebs.org/eu/fr/esrs/corep/2005-09-30/
+<table border="1" width="60%" cellspacing="0" cellpadding="0">
+<tr><td style="background-color:#EEEEEE;padding:3px;">URL</td>
+<td style="padding:3px;">http://www.c-ebs.org</td></tr>
+<tr><td style="background-color:#EEEEEE;padding:3px;">juridiction</td>
+<td style="padding:3px;">eu</td></tr>
+<tr><td style="background-color:#EEEEEE;padding:3px;">reporting type</td>
+<td style="padding:3px;">fr (financial reporting)</td></tr>
+<tr><td style="background-color:#EEEEEE;padding:3px;">appriviation that delimites the scope</td>
+<td style="padding:3px;">esrs (European System Reporting Standard)</td></tr>
+<tr><td style="background-color:#EEEEEE;padding:3px;">project name</td>
+<td style="padding:3px;">corep (COmmon solvency ratio REPorting framework)</td></tr>
+<tr><td style="background-color:#EEEEEE;padding:3px;">version date</td>
+<td style="padding:3px;">2005-09-30</td></tr>
+</table>
+<br/>
+The assigning of names within the extension taxonomy should follow the naming conventions which were introduced by the COREP/FINREP taxonomies. Hence, the first letter of a taxonomy defines the type of taxonomy:
+*	“d” for dimensional taxonomies whose values are recorded in the context element,
+*	“p” for taxonomies containing elements that appear in isolation in the XBRL instance report
+*	“t” for taxonomies containing a mix of dimensional and value-related taxonomies.
 ===Creating extension taxonomy===
 Now it is ensured that only one child element of either of the two domains can be used together with other possible dimension items that are listed in the hypercube. In the example above, the hypercube would be connected with the abstract domain element of the primary dimension (measure) taxonomy with the arcrole “…/all”.
-====Adding dimensions from a template====
+====Adding dimensions to a template====
 A supervisor might decide that an additional breakdown for a total is needed. This means that additional columns are added to a template.<br/>Example: The CRD group consolidation of the FINREP taxonomy does not provided possibilities to model both, the IFRS group and the CRD group, as consolidation scope. Supervisors who want to provide these additional information have to extend their taxonomy by adding a new dimension.
-[[Image:Adding_columns.gif]]
+[[Image:Adding dim columns.gif]]
 The first "column" (IFRS Scope) represents the total amount and matches up with the information that should be reported in those countries that do not include this breakdown.
+From a technical perspective a new dimension taxonomy and its corresponding linkbases have to be created which includes the new members. The first column "IFRS Scope" is also added to this taxonomy but as a default member. [Excursus: If the arc role "http://xbrl.org/int/dim/arcrole/dimension-default" is set on a dimension member than this dimension member is the default and it must not appear in a context of an instance. If the primary is used in an instance without a reference to a dimension member than it must be assigned to the default.]
+[[Image:Adding_dimensions.gif]]
+In the example above a new dimension "Activity" has been created with the default dimension value "IFRS Scope".<br/><br/>
+These changes should not have any influence on the core taxonomy. The linking of the primary items of the core taxonomy and the new dimension must be implemented at extension level. The country specific template taxonomy has to import the new dimension taxonomy and define the additional links.
+[[Image:Extension structure.gif]]
+With this approach we achieve compatibility between instance documents of countries using this breakdown and those who do not include the activity dimension in their extension of FINREP because the "IFRS Scope" member has been modelled as the default value of the new dimension.
+Because this example is a real business case the CEBS XBRL network has provided an optional module to be downloaded from the following website:<br/> [http://corep.info/finrepTaxonomy/taxonomy.html Link: Optional module for the dimension activity]
+<br/>The advantages of this approach are the reuse of the elements of the core taxonomy and the compatibility to other extensions of the FINREP taxonomy.
 ===Customisation of calculations===

Best Practices on Extending CEBS Taxonomies

From XBRLWiki

Current revision

Contents

Abstract

Status

Modularity

National Taxonomy Customisation COREP - FINREP

National extension structure

Categorisation of national taxonomy extensions

Definition of the target namespace

Creating extension taxonomy

Customisation of labels

Customisation of references

Customisation of the template structure

Adding or removing columns and rows

Reordering the hierarchical structure of a template

Restricting cells from being reported

Removing dimensions from a template

Providing choices among dimensions

Adding dimensions to a template

Customisation of calculations

Views

Personal tools

Navigation

Search

Toolbox