APRA Updates Lists of Validation and Derivation Rules in June 2020
APRA updated the lists of the Direct to APRA (D2A) validation and derivation rules for authorized deposit-taking institutions, insurers, and superannuation entities. All reporting entities, including regulated and registered financial entities, submit data to APRA via the D2A.
APRA uses validation rules within D2A to validate the data submitted by reporting entities. 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. To submit data via D2A, entities must correct all data that fail mandatory rules. Confirmation rules identify data, within D2A, that indicate reporting errors or require explanation. Entities are expected to correct any reporting errors identified by these rules. The derivation rules, however, are formulae that automatically calculate (derive) values for attributes, in most cases using the values for other attributes as inputs. The rules are updated two weeks before the end of each quarter, in particular March 31, June 30, September 30, and December 31.
Related Links
- Updated Validation Rules (XLSX)
- Updated Derivation Rules (XLSX)
- Overview of Validation and Derivation Rules
Keywords: Asia Pacific, Australia, Banking, Insurance, Pensions, Superannuation, Validation Rules, Derivation Rules, D2A, Reporting, Basel, APRA
Featured Experts

María Cañamero
Skilled market researcher; growth strategist; successful go-to-market campaign developer

Nicolas Degruson
Works with financial institutions, regulatory experts, business analysts, product managers, and software engineers to drive regulatory solutions across the globe.

David Fihrer
Skilled life insurance actuary; subject matter expert on IFRS 17 and source of earnings
Previous Article
FDIC Rule to Mitigate Effects of Participation in Liquidity ProgramsRelated Articles
PRA Finalizes Supervisory Approach for Non-Systemic Banks in UK
PRA published the policy statement PS8/21, which contains the final supervisory statement SS3/21 on the PRA approach to supervision of the new and growing non-systemic banks in UK.
EBA Finalizes Standards on Methods of Prudential Consolidation
EBA published a report that sets out the final draft regulatory technical standards specifying the conditions according to which consolidation shall be carried out in line with Article 18 of the Capital Requirements Regulation (CRR).
EBA Updates List of Other Systemically Important Institutions in EU
EBA updated the list of other systemically important institutions (O-SIIs) in EU.
BCBS Report Concludes Basel Risk Categories Can Capture Climate Risks
BCBS published two reports that discuss transmission channels of climate-related risks to the banking system and the measurement methodologies of climate-related financial risks.
UK Authorities Welcome FSB Review of their Remuneration Regime
UK Authorities (FCA and PRA) welcomed the findings of FSB peer review on the implementation of financial sector remuneration reforms in the UK.
PRA and FCA Letter on Addressing Risks from Use of Deposit Aggregators
PRA and FCA jointly issued a letter that highlights risks associated with the increasing volumes of deposits that are placed with banks and building societies via deposit aggregators and how to mitigate these risks.
MFSA to Amend Banking Act and Rules in Coming Months to Transpose CRD5
MFSA announced that amendments to the Banking Act, Subsidiary Legislation, and Banking Rules will be issued in the coming months, to transpose the Capital Requirements Directive (CRD5) into the national regulatory framework.
EC Delegated Regulation on Specialized Lending Exposures Under CRR
EC finalized the Delegated Regulation 2021/598 that supplements the Capital Requirements Regulation (CRR or 575/2013) and lays out the regulatory technical standards for assigning risk-weights to specialized lending exposures.
OSFI Proposes to Enhance Assurance Expectations for Basel Returns
OSFI launched a consultation to explore ways to enhance the OSFI assurance over capital, leverage, and liquidity returns for banks and insurers, given the increasing complexity arising from the evolving regulatory reporting framework due to IFRS 17 (Insurance Contracts) standard and Basel III reforms.
ECB Issues Results of Benchmarking Analysis of Recovery Plans of Banks
ECB published results of the benchmarking analysis of the recovery plan cycle for 2019.