Skip to main content

APRA Connect Taxonomy Artefacts

Last updated: 25 May 2023

APRA Connect taxonomy artefacts are provided to help entities prepare data for submission on APRA Connect. 

The artefacts include the data dictionary, validations, reporting taxonomy and XSD (to validate files).

Artefacts should be used in conjunction with the relevant reporting standard. Where there is a difference between the artefacts and the reporting standard, the reporting standard should be referenced for final versions of definitions and reporting instructions.

Authorised deposit-taking institutions (ADIs)

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

General Insurance

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.

Life insurance and friendly societies

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. 

Private Health Insurance

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. 

Superannuation

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.

Support material

APRA Connect taxonomy artefacts - streamed 1 April 2021 provides an overview of the APRA Connect taxonomy artefacts. 

Expression Functions Guide

The Expression Functions Guide describes the Expression function used in the validation of data submitted via APRA Connect and should be used in conjunction with the published taxonomy artefacts.

Expression functions execute standard logical/mathematical/date/string functions. Each type of expression is described in detail.


Explanatory Notes 

The following explanatory notes are to assist entities in using the artefacts.

Data dictionary

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. 

Reporting taxonomy

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.

Validation file

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.

XSD files

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. 

Industry

Reporting Standard

Collection name

XSD file name

Superannuation

SRS 605.0

RSE structure

SUP_uSTRUCT.xsd

Superannuation

SRS 606.0

RSE profile

SUP_uPROFILE.xsd

SuperannuationSRS 606.1RSE Profile Fees And Costs ArrangementsSUP_uPROFFEECO.xsd

Superannuation

SRS 611.0

Member accounts

SUP_uMEMAC.xsd

Superannuation

SRS 705.0

Performance components

SUP_uPERFCOMP.xsd

Superannuation

SRS 705.1

Performance benchmark

SUP_uPERFBENCH.xsd

SuperannuationSRS 705.1Investment ObjectivesSUP_uINVOBJ.xsd
SuperannuationSRS 705.1Investment Objectives (External)SUP_uINVOBJEX.xsd
SuperannuationSRS 550.0Asset Allocation - Part ASUP_uAAA.xsd
SuperannuationSRS 550.0Asset Allocation - Part BSUP_uAAB.xsd

Superannuation

SRF 251.0

Insurance arrangements

SUP_uINSAR.xsd

Superannuation

SRS 706.0

Fees and costs

SUP_uFEECO.xsd

Superannuation

SRS 332.0

Expenses

SUP_uEXP.xsd

Superannuation

SRS 605.0 and SRS 706.0

Attestation

SUP_uATT.xsd

Private Health Insurance

HRS 605.0

Private Health Insurance Reform Data Collection

PHI_uREFORM.xsd

ADIARS 110.0Capital AdequacyADI_uCAPAD.xsd
ADIARS 112.0Capital Adequacy - Standardised Approach to Credit RiskADI_uCRSTD.xsd
ADIARS 113.0Capital Adequacy - Internal Ratings-based Approach to Credit RiskADI_uCRIRB.xsd
ADIARS 115.0Operational RiskADI_uOPRISK.xsd

Using APRA Connect

Refer to the APRA Connect support material which includes the Guide and frequently asked questions. Contact the team at dataanalytics@apra.gov.au.

Technical issues?
 

Log a support request with the Service Desk at support@apra.gov.au and ensure that you include the ABN of the entity the issue relates to.

For urgent issues call +61 2 9210 3400 between 9am and 5pm AEST weekdays.

Need help with myGovID or RAM?
 

Please refer to the Australian Government's published material to find out more about the Digital Identity systemmyGovID and RAM.