Go to top of page

Validation and derivation rules

APRA uses validation rules within D2A to validate the data submitted by reporting entities. Entities are expected to correct any reporting errors identified by these rules.

Issued 13 September 2019
Validation rules all industries September 2019 xlsx 1.93 MB
Last updated September 2019
Derivation rules all industries September 2019 xlsx 488.1 KB
Last updated September 2019

Validation rules

There are two types of D2A validation rules: mandatory and confirmation rules. Mandatory rules identify data, within D2A, that contain mathematical errors and discrepancies or factual inconsistencies. Entities must correct all data that fail mandatory rules to submit data via D2A. Confirmation rules identify data, within D2A, that indicate reporting errors or require explanation. Entities are expected to correct or explain data identified by confirmation rules within D2A.

Derivation rules

Derivation rules are formulae that automatically calculate ('derive') values for attributes, in most cases using the values for other attributes as inputs.

Forthcoming issues

The rules are updated two weeks prior to the end of each quarter ending 31 March, 30 June, 30 September and 31 December. 

Direct to APRA (D2A) is the software used to encrypt and submit data.

Plain English Taxonomy (PET) describes and interprets APRA data collection requirements as set out in the prudential standards, practice guides and reporting guidelines.

Standard Business Reporting (SBR) is an Australian Government initiative led by Treasury to simplify business–to–government reporting.

For technical questions

  • Phone +61 2 9210 3400 between 9:00 am and 5:00 pm AEST
  • Email support [at] apra.gov.au

For other questions

  • Email dataanalytics [at] apra.gov.au