XBRL Module Part 3 XBRL Framework Credits Prepared
XBRL Module Part 3: XBRL Framework Credits Prepared by: Sponsored by: Rajendra P. Srivastava Ernst & Young Professor University of Kansas Ernst & Young, LLP (August 2005) 1
Outline l XBRL Framework – – l l XBRL Taxonomies Ø XBRL Linkbases (Label , Reference, Presentation, Calculation, and Definition) Instance Document USFR XBRL Taxonomy Structure Anatomy of an XBRL Taxonomy - XBRL Schema – Attributes and Linkbases Anatomy of an XBRL Instance Document l Anatomy of XBRL - Extending a taxonomy l Anatomy of XBRL - Consuming an XBRL Instance Document 2 l Snippets of Instance Document and Linkbases l
Anatomy of an XBRL Taxonomy XBRL Framework Schema. xsd Linkbases. xml Label 3 Presentation Calculation Reference Footnote Definition
Anatomy of an XBRL Taxonomy-Schema According to XBRL 2. 1 Specification released by XBRL International: “A taxonomy is defined as an XML Schema and the set of directly referenced extended links and any extended links that are nested within the XML Schema. ” In other words: A Taxonomy is made up of a group of interrelated XML files: XML Schema File (. xds file) and Linkbase Files (. xml files) XML Schema The XBRL taxonomy schema file defines the actual concepts (elements) that form the basis of a taxonomy. It stores their names, data types, period type, how they can be utilized, etc. The properties of schema elements are defined in the XBRL 2. 1 Specification. 4
Anatomy of an XBRL Taxonomy Linkbase Files 1. 2. 3. 4. 5. 5 6. An XBRL linkbase file contains the explicit relationship definitions between the concepts defined in the XBRL schema. In general there are six linkbase types defined by the XBRL version 2. 1 specification: The label linkbase allows the user to attach labels with different roles and languages to a given concept. The reference linkbase allows the user to attach external information (authoritative sources) to concepts. The presentation linkbase defines how concepts are nested and ordered. The calculation linkbase defines how values of concepts should, for example, sum up from one to another. The definition linkbase allows the user to define additional semantics and relationships. The footnote linkbase allows the user to relate a footnote description to a concept
Naming Taxonomy Element l XBRL naming conventions follow XML convention. – – – 6 Names must start with a letter or a underscore “_”. Names can contain any combination of letters, numbers, underscores “_”, dashes “-”, or periods “. ” Names must not contain any other characters. Names must not start with letters xml (or XML or Xml. . ). Names cannot contain spaces. Names (tags) are case sensitive. l Each name within a taxonomy must be unique and must start with an alpha character or the underscore character. l Element names should not be interpreted as containing a "hierarchical" structure l Taxonomy structure is expressed in the XBRL linkbases
US Financial Reporting Taxonomy Structure SEC Certification (usfr-seccert) Primary Terms Elements (usfr-pte) Financial Service Terms Elements (usfr-fste) Primary Terms Relationships (usfr-ptr) Financial Service Terms Relationships (usfr-fstr) Management Report (usfr-mr) Accountants Report (usfr-ar) MD&A (usfr-mda) Investment Management Elements (usfr-ime) Commercial & Industrial (us-gaap-ci) Insurance Entities (us-gaap-ins) Banking and Savings Institutions (us-gaap-basi) Company Extension 7 Instance Document Investment Management (us-gaap-im)
Anatomy of an XBRL Taxonomy - XBRL Schema Element, Attributes, and Linkbase Examples There are several basic attributes of an XBRL element that provide the detail about them. In the example below, “Cash. Equivalents” has a unique element name which also identifies its source taxonomy, a data type (monetary), balance type (debit), and a period type (instant) which defines how it is reported at a given instant or duration. Attribute Basic Element Attributes 8 Example XBRL Name Usfr-pte: Cash. Equivalents Data Type Monetary/String, etc. Balance Type Debit/Credit Period Type Instant/Duration
Anatomy of an XBRL Taxonomy - XBRL Schema Element, Attributes, and Linkbase Examples In addition to the basic attributes, each element has a set of defined relationships with the taxonomy linkbases. In the example below, “Cash. Equivalents” has a human readable label, a reference to authoritative literature (SEC), a presentation hierarchy and a calculation summation. Linkbase Label Relationships To Other Elements & Information (Linkbases) Reference Presentation Calculation 9 Example e. g. , “Cash and Cash Equivalents” Name Rule Number Chapter Paragraph : SEC Regulation S-X : 7 : 3 : 2 Cash and Cash Equivalent Accounts Receivable Trade, Net Inventories, Net Total Current Assets = Cash and Cash Equivalents + Accounts Receivable Trade, Net + Inventories, Net + …
Anatomy of an XBRL Instance Document Tagged Value: The main function of the instance document is to store financial data tagged with elements from a referenced taxonomy (containing element definitions and Meta data) for reporting. Instance Component Example Tagged Value Cash and cash Equivalents : US$ 575, 000 (1) XBRL Name, i. e. , Tag Usfr-pte: Cash. Equivalents Unit: An instance document contains a unit for each type of measured data tagged. Currencies and shares are the most common examples of Units of measure in Financial Reporting. 10 UNIT Attribute ID Measure Example USD $ , Shares etc.
Anatomy of an XBRL Instance Document Precision or Decimal are used on numeric values. In this example, a Precision of 9 is given. This means that the first 9 digits, counting from the left, starting at the first non-zero digit of the value are known to be trustworthy for the purposes of computations to be performed using that numeric fact. A Decimal of 2 would indicate that the value of the numeric fact is known to be correct to 2 decimal places. Precision Or Decimal: Example Precision = 9, Decimal = 2 Contexts: Every piece of financial data in an instance document must be associated with a context. A context provides additional meta data, particularly the period it is reported in. In addition, each context can also provide Segment (Ex. Business Unit or Revenue Center) and Scenario (Additional information Ex. Restated, Unaudited, etc. ) information. Attribute Contexts 11 Example Period Instant: As of 31 -12 -2004 Segment Financial Printing, Outsourcing etc. Scenario Audited, Pro-forma, Restated
Anatomy of an XBRL Instance Document: Footnotes Footnote Link: Footnote Links allow for the creation of structured text annotations between facts. Example Footnote Link: 12 (1) Cash and Cash Equivalents-All highly liquid investments with original maturities of three months or less at date of purchase are carried at cost plus accrued interest, which approximates fair value, and are considered to be cash equivalents. All other investments not considered to be cash equivalents are separately categorized as investments.
Anatomy of XBRL - Extending a taxonomy One of the most powerful and versatile aspects of XBRL is taxonomy extensibility. This allows a taxonomy to reference other taxonomies and define its own set of relationships and information (presentation, calculation, labels, etc. ) around those taxonomies, in addition to adding new unique elements in the extension schema itself. 13
Anatomy of XBRL - Consuming an XBRL Instance Document 1. Using XBRL enabled software a user accesses an entity’s Instance Document through the internet. 2. The Instance Document references the entity’s Extension Taxonomy which contains information and relationships specific to that entity. 3. The entity Extension Taxonomy references a Public Taxonomy and extends it. 14 4. The Entity Instance Document, Extension Taxonomy and Public Taxonomy reference the XBRL Technical Specification Schema for compliance with the 2. 1 specification.
Balance Sheet: Taxonomy Element and Instance Data Reporting period December 31 ASSETS 2004 2003 US$000, 000 $634 $575 2, 101 1, 804 1, 515 1, 374 $4, 250 $3, 753 Cash and Cash Equivalents (1) Accounts receivable, less allowance for doubtful accounts of $88 and $80 Inventories Total current assets Taxonomy Schema Snippet <element name="Cash and Cash Equivalent" type="xbrl: monetary. Item. Type" substitution. Group="xbrli: Item" xbrli: period. Type="instant" xbrli: balance="debit" nillable="true" 15 /> Instance Document Snippet <usfr-pte: Cash. Equivalents context. Ref=“Y-2003" unit. Ref="U-Monetary“ decimals="0"> 575000000 </usfr-pte: Cash. Equivalents> Instance value id="usfr-pte_Cash. Equivalents" Unit of Measure Taxonomy Element Current Assets:
Balance Sheet: Presentation Hierarchy and Linkbase December 31 ASSETS 2004 2003 US$000, 000 $634 $575 2, 101 1, 804 1, 515 1, 374 $4, 250 $3, 753 Current Assets: Cash and Cash Equivalents (1) Accounts receivable, less allowance for doubtful accounts of $88 and $80 Inventories Total current assets Presentation Linkbase Snippet <presentation. Link xlink: type="extended“ xlink: role=“http: //www. xbrl. org/us/fr/li/role/Statement. Financial. Position” xlink: title=“Statement of Financial Position”> <loc xlink: type="locator" xlink: href=“http: //www. xbrl. org/us/fr/common/pte/2005 -02 -28/usfr-pte-200502 -28. xsd#usfr-pte_Total. Current. Assets" xlink: label="usfr-pte_Total. Current. Assets"/> <loc xlink: type="locator" xlink: href="http: //www. xbrl. org/us/fr/common/pte/2005 -02 -28/usfr-pte-2005 -0228. xsd#usfr-pte_Cash. Equivalents" xlink: label="usfr-pte_Cash. Equivalents"/> <loc xlink: type="locator" xlink: href="http: //www. xbrl. org/us/fr/common/pte/2005 -02 -28/usfr-pte-2005 -0228. xsd#usfr-pte_Accounts. Receivable. Trade. Net“ xlink: label="usfr-pte_Accounts. Receivable. Trade. Net"/> <presentation. Arc xlink: type="arc“ xlink: arcrole="http: //www. xbrl. org/2003/arcrole/parent-child" xlink: from="usfr-pte_Total. Current. Assets" xlink: to="usfr-pte_Cash. Equivalents" order="1”/> <presentation. Arc xlink: type="arc“ xlink: arcrole="http: //www. xbrl. org/2003/arcrole/parent-child" xlink: from="usfr-pte_Total. Current. Assets" xlink: to="usfr-pte_Accounts. Recievabale. Trade. Net" order=“ 2”/> … </presentation. Link> 16
Balance Sheet: Label Linkbase December 31 ASSETS 2004 2003 US$000, 000 $634 $575 2, 101 1, 804 1, 515 1, 374 $4, 250 $3, 753 Current Assets: Cash and Cash Equivalents (1) Accounts receivable, less allowance for doubtful accounts of $88 and $80 Inventories Total current assets Label Link Snippet <label. Link xlink: type="extended” xlink: role="http: //www. xbrl. org/2003/role/link"> <label xlink: type="resource” xlink: role="http: //www. xbrl. org/2003/role/label" xlink: label=“usfr-pte_Cash. Equivalents_en” xml: lang="en">Cash and Cash Equivalents</label> <loc xlink: type="locator" xlink: href="usfr-pte-2005 -02 -28. xsd#usfr-pte_Cash. Equivalents" xlink: label="usfr-pte_Cash. Equivalents"/> <label. Arc xlink: type="arc“ xlink: arcrole=“http: //www. xbrl. org/2003/arcrole/concept-label” xlink: from="usfr-pte_Cash. Equivalents“ xlink: to="usfr-pte_Cash. Equivalents_en“/> </label. Link> 17
Statement of Financial Position to XBRL – Calculation Summations December 31 ASSETS 2004 2003 US$000, 000 $634 $575 2, 101 1, 804 1, 515 1, 374 $4, 250 $3, 753 Current Assets: Cash and Cash Equivalents (1) Accounts receivable, less allowance for doubtful accounts of $88 and $80 Inventories Total current assets Calculation Linkbase Snippet <calculation. Link xlink: type="extended" xlink: role="http: //www. xbrl. org/2003/role/link"> <loc xlink: type="locator" xlink: href="usfr-pte-2005 -02 -28. xsd#usfr-pte_Total. Current. Assets" xlink: label="usfr-pte_Total. Current. Assets"/> <loc xlink: type="locator" xlink: href="usfr-pte-2005 -02 -28. xsd#usfr-pte_Cash. Equivalents" xlink: label="usfr-pte_Cash. Equivalents"/> 18 <calculation. Arc xlink: type="arc" xlink: arcrole=“http: //www. xbrl. org/2003/arcrole/summationitem” xlink: from="usfr-pte_Total. Current. Assets" xlink: to="usfr-pte_Cash. Equivalents" order=“ 1” weight="1“ use=“optional”/> </calculation. Link>
Status and Expected Evolution of XBRL l Financial Reporting Taxonomies Architecture 1. 0: Recommendation dated 2005 -04 -25 ( (http: //www. xbrl. org/technical/guidance/FRTARECOMMENDATION-2005 -04 -25. rtf) describes the architecture of financial reporting taxonomies using XBRL and establishes rules and conventions to achieve consistency through: – Representation: Taxonomies should use similar XBRL structures to represent similar relationships among concepts. – Modularity: Taxonomies should have a common approach to grouping taxonomy content at a file level. – Evolution: Taxonomies developed based on the proposed architecture can be extended or revised using similar approaches l XBRL specification 2. 1 achieves consistency by making numerous improvements: – Interoperability: – Cost of implementation – Clarity Future XBRL specifications l 19
References for Taxonomy Package and a Sample l Bovee, M. Ettredge, R. P. Srivastava, M. Vasarhelyi. 2002. Does the Year 2000 XBRL Taxonomy Accommodate Current Business Financial Reporting Practice? Journal of Information Systems, Vol. 16, No. 2: 165 -182. l SEC (Security and Exchange Commission). 2002. Full Disclosure, Regulation FD. http: //www. sec. gov/answers/regfd. htm. l Vasal, V. K. , and R. P. Srivastava. 2002. e. Xtensible Business Reporting Language (XBRL) –The Digital Language of Business: An Indian Perspective. Indian Accounting Review, Vol. 6, No. 1 (June) 41 -59. l XBRL. Org. 2005. Extensible Business Reporting Language (XBRL) 2. 1 RECOMMENDATION - 2003 -12 -31 + Corrected Errata - 2005 -04 -25 at http: //www. xbrl. org/Spec. Recommendations/. l XBRL. Org. XBRL GL. http: //www. xbrl. org/GLTaxonomy/. http: //www. xbrl. org/technical/guidance/FRTARECOMMENDATION-2005 -04 -25. rtf l 20
- Slides: 20