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 |
Superannuation | SRS 606.1 | RSE Profile Fees And Costs Arrangements | SUP_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 |
Superannuation | SRS 705.1 | Investment Objectives | SUP_uINVOBJ.xsd |
Superannuation | SRS 705.1 | Investment Objectives (External) | SUP_uINVOBJEX.xsd |
Superannuation | SRS 550.0 | Asset Allocation - Part A | SUP_uAAA.xsd |
Superannuation | SRS 550.0 | Asset Allocation - Part B | SUP_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 |
ADI | ARS 110.0 | Capital Adequacy | ADI_uCAPAD.xsd |
ADI | ARS 112.0 | Capital Adequacy - Standardised Approach to Credit Risk | ADI_uCRSTD.xsd |
ADI | ARS 113.0 | Capital Adequacy - Internal Ratings-based Approach to Credit Risk | ADI_uCRIRB.xsd |
ADI | ARS 115.0 | Operational Risk | ADI_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 system, myGovID and RAM.