APRA Connect Taxonomy Artefacts

The following reporting taxonomy artefacts are effective for the second parallel reporting period of the New Capital Framework.

Changes to taxonomy artefacts

Changes to the taxonomy artefacts – including validation rules that have been restricted for one or more entities – are detailed in the following spreadsheet.
The spreadsheet is broken into changes to: 

• Schemas: alignment of business definitions to the reporting standard, correcting spelling mistakes and altering the mandatoriness of objects.
• Amended validation rules: new, amended or deleted validation rules
• Rule restrictions: rules that have been restricted for a given period, entity or number of entities

On 27 September 2022, APRA finalised changes to the capital and reporting frameworks for insurance in response to the introduction of the new accounting standard Australian Accounting Standards Board 17 Insurance Contracts (AASB 17).

The revised prudential and reporting standards will come into effect from 1 July 2023.

The information paper, response paper, final prudential and reporting standards and non-confidential submissions can be found at: Round four – Response Paper and Final Standards - Finalisation of the integration of AASB 17 into the capital and reporting frameworks for insurers and updates to the LAGIC framework. 

The taxonomy artefacts contain a subset of the collection to enable early familiarisation and to support entities as they practice data preparation and submission in APRA Connect test environment from early April 2023. 

This release includes the Statement of Financial position. The Statement of Financial position is a primary financial statement required under the AASB 17 

Transitionary tool for selected collections (Playback spreadsheets)

For the following priority returns, APRA has prepared Playback spreadsheets to assist entities in preparing the returns. 

• GRS 114.0 Asset Risk Charge
• GRS 114.0.G Asset Risk Charge
• GRS 115.0.G Outstanding Claims Liabilities – Insurance Risk Charge
• GRS 115.1.G Premiums Liabilities – insurance Risk Charge

The Playback spreadsheets have worksheet(s) which show summaries and calculations from the data items. The Playback spreadsheets are a transition tool that may be used for performing data quality checks through reviewing summaries and calculations from the data items. Insurers are to use form layouts within the taxonomy artefacts to upload data to APRA Connect. 

Playback spreadsheets are currently in draft. APRA will release the final versions of Playback spreadsheets when it releases the final taxonomy artefacts.

On 27 September 2022, APRA finalised changes to the capital and reporting frameworks for insurance in response to the introduction of the new accounting standard Australian Accounting Standards Board 17 Insurance Contracts (AASB 17).

The revised prudential and reporting standards will come into effect from 1 July 2023.

The information paper, response paper, final prudential and reporting standards and non-confidential submissions can be found at: Round four – Response Paper and Final Standards - Finalisation of the integration of AASB 17 into the capital and reporting frameworks for insurers and updates to the LAGIC framework. 

This release includes the Statement of Financial position. The Statement of Financial position is a primary financial statement required under the AASB 17.

Transitionary tool for selected collections (Playback spreadsheets)

For the following priority returns, APRA has prepared Playback spreadsheets to assist entities in preparing the returns. 

• LRS 114.0 Asset Risk Charge
• LRS 200.0 Capital Adequacy Supplementary Information

The Playback spreadsheets have worksheet(s) which show summaries and calculations from the data items. The Playback spreadsheets are a transition tool that may be used for performing data quality checks through reviewing summaries and calculations from the data items. Insurers are to use form layouts within the taxonomy artefacts to upload data to APRA Connect. 

Playback spreadsheets are currently in draft. APRA will release the final versions of Playback spreadsheets when it releases the final taxonomy artefacts. 

HRS 605.0 Private Health Insurance Reform Data Collection, commenced in March 2021, collects information on a private health insurer’s (PHI’s) implementation of the Government’s private health insurance reforms announced in October 2017.

PHI Capital framework

On 27 September 2022, APRA finalised the capital framework for private health insurers.

The new framework enhances policyholder protection by seeking to ensure that private health insurers maintain an appropriate level of financial resilience to absorb unanticipated losses.

The Response Paper and finalised reporting standards are available at: Review of the private health insurance capital framework. 

The taxonomy artefacts contain a subset of the collection to enable early familiarisation and to support entities as they practice data preparation and submission in APRA Connect test environment from early April 2023.

This release includes the Statement of Financial position. The Statement of Financial position is a primary financial statement required under the AASB 17

Changes to taxonomy artefacts

Changes to the taxonomy artefacts – including validation rules that have been restricted for one or more entities – are detailed in the following spreadsheet.

The spreadsheet is broken into changes to: 

• Schemas: alignment of business definitions to the reporting standard, correcting spelling mistakes and altering the mandatoriness of objects.
• Amended validation rules: new, amended or deleted validation rules.
• Rule restrictions: rules that have been restricted for a given period, entity or number of entities.

Transitionary tool for selected collections (Playback spreadsheets)

For the following priority returns, APRA has prepared Playback spreadsheets to assist entities in preparing the returns. 

• HRS 114.0  Asset Risk Charge
• HRS 115.0 Insurance Risk Charge

The Playback spreadsheets have worksheet(s) which show summaries and calculations from the data items. The Playback spreadsheets are a transition tool that may be used for performing data quality checks through reviewing summaries and calculations from the data items. Insurers are to use form layouts within the taxonomy artefacts to upload data to APRA Connect. 

Playback spreadsheets are currently in draft. APRA will release the final versions of Playback spreadsheets when it releases the final taxonomy artefacts. 

On March 3 2023, APRA released the response paper and 9 final reporting standards for the minor amendments to SDT Phase 1 reporting. The Response Paper and finalised reporting standards are available at: Consultation on Superannuation Data Transformation Minor Amendments.

The final reporting taxonomy artefacts are linked below. 

Changes to taxonomy artefacts

Changes to the taxonomy artefacts – including validation rules that have been restricted for one or more entities – are detailed in the following spreadsheet.

The spreadsheet is broken into changes to: 

• Schemas: alignment of business definitions to the reporting standard, correcting spelling mistakes and altering the mandatoriness of objects.
• Amended validation rules: new, amended or deleted validation rules
• Rule restrictions: rules that have been restricted for a given period, entity or number of entities.
• Release notes: known issues which will be resolved before the first submissions and/or additional information regarding a release.

The APRA Data Dictionary contains all the elements and their properties used in the collections in APRA Connect. The Excel based data dictionary includes detailed properties of data types and enumerations; this information can be used by entities when setting up their own systems and processes for defining data. 

The Reporting Taxonomies contain all the elements and their properties, relevant to the selected collection. The Excel based reporting taxonomy includes the following worksheets:

• 'Schema’ contains the collection name, schema properties and the embedded hole constraint file which displays each table and the allowed values that are relevant in the selected collection.
   
• ‘Elements’ contains only the elements and their properties that are relevant in the selected collection.
   
• ‘Data types’ contains the data types that may be used for each of the defined elements within the selected collection. Each data type is either based on a specific base data type or is an enumeration.
   
• ‘Enumerations’ contains the enumerations in the selected collection, along with all of the allowed values (regardless of the selected collection).
   
• ‘Form Set’ contains detailed information for the return name and label (used throughout APRA Connect to identify the return).
   
• ‘Folders’ contains (where relevant) detailed information for a return that can include multiple instances of the same form (for example, State based forms).
   
• ‘Forms’ contains properties for the forms in a return.
   
• ‘Rules’  contains rules relating to the selected collection. A full list of rules – across all collections - is available in the Validation Rules spreadsheet.
   
• ‘Entity Details’ displays the layout of the form that captures the entity specific Name, ABN and Reporting End Date. This worksheet can be used as a template for entities uploading via Excel.
   
• Form layouts for each of the specific forms in the selected collection. This worksheet can be used as a template for entities uploading via Excel. For example, the worksheet may be titled SRF_705_0_Table_1 in the Performance Components collection for Superannuation.

The Validation Rules file contains details of the validation rules, relevant to the selected industry, including:

• ‘Rule ID’ is a unique identifier for each rule.
   
• ‘Rule Name’ will be shown in APRA Connect when a rule is triggered (if APRA hasn’t provided a name, the Rule ID will show instead).
   
• ‘Rule Version’ will indicate the version of the rule.
   
• ‘Schema Name’ references the schema name specified in the corresponding Reporting Taxonomy.
   
• ‘Business Description’ is a simple, plain English description of the validation rule.
   
• ‘Error Message’ is the failure message that will be displayed when the rule triggers; APRA Connect syntax is used to dynamically change the text displayed. The syntax is based loosely on the Excel formula syntax.
   
• ‘Section rule applies to’ references the specific table or List (which can be found on the Elements tab of the corresponding Reporting Taxonomy) that the rule relates to. If the rule is evaluating multiple tables, this field will reference the entire form.
   
• ‘Rule Type’ indicates if the rule is an Error and has to be resolved before submitting or a Warning that entities must provide an explanation for the discrepancy in order to submit the return.
   
• ‘Rule Expression’ is the failure expression that is evaluated; APRA Connect syntax is used to define the rule. If the expression returns false, it means the rule has failed and the failure message will be displayed.
   
• ‘Rule Constraint’ is an expression that will restrict the rule from evaluating in certain circumstances; APRA Connect syntax is used to define the constraint. If the constraint expression returns true or is empty the validation rule will execute.

The purpose of the XSD file is to validate the XML file being uploaded to APRA Connect. Each draft XSD file contains important information including:

• GUID is the unique identifier for the collection and should be included in the header of any XML file that will be uploaded into APRA Connect.
   
• Version number identifies the version of the collection and should be included in the header of any XML file that will be uploaded into APRA Connect.
   
• The XSD can be used by entities in third party software to generate and validate XML files.
   
• The XML schema is W3C compliant.

Summary of XSD files and corresponding reporting standard and collection name.