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 17 September 2018
Validation rules - all industries - September 2018 xlsx 1.89 MB
Last updated September 2018
Derivation rules - all industries - September 2018 xlsx 495.47 KB
Last updated September 2018

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

December 2018: 17 December 2018.

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 software used to encrypt and submit data.

Plain English Taxonomy (PET) provides a description and interpretation of APRA data collection requirements as set out in the prudential standards, prudential practice guides and reporting guidelines.

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

Technical queries:

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

Other queries:

  • Email: dataanalytics [at] apra.gov.au