APRA Updates Validation and Derivation Rules in January 2021
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. As per APRA, the rules are usually 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, Validation Rules, Derivation Rules, Reporting, D2A, 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
PRA Proposed Approach to DLT Assessments and Transition to SONIARelated Articles
EBA Clarifies Use of COVID-19-Impacted Data for IRB Credit Risk Models
The European Banking Authority (EBA) published four draft principles to support supervisory efforts in assessing the representativeness of COVID-19-impacted data for banks using the internal ratings based (IRB) credit risk models.
EP Reaches Agreement on Corporate Sustainability Reporting Directive
The European Council and the European Parliament (EP) reached a provisional political agreement on the Corporate Sustainability Reporting Directive (CSRD).
PRA Consults on Model Risk Management Principles for Banks
The Prudential Regulation Authority (PRA) launched a consultation (CP6/22) that sets out proposal for a new Supervisory Statement on expectations for management of model risk by banks.
EC Regulation Amends Standards for Calculating Credit Risk Adjustments
The European Commission (EC) published the Delegated Regulation 2022/954, which amends regulatory technical standards on specification of the calculation of specific and general credit risk adjustments.
HKMA Announces Launch of Data Repository on Sustainable Finance
The Hong Kong Monetary Authority (HKMA) announced that the Green and Sustainable Finance (GSF) Cross-Agency Steering Group has launched the information and data repositories and outlined the progress made in advancing the development of green and sustainable finance in Hong Kong.
BIS Hub Updates Work Program for 2022, Announces New Projects
The Bank for International Settlements (BIS) Innovation Hub updated its work program, announcing a set of projects across various centers.
EIOPA Issues Cyber Underwriting Proposal, Statement on Open Insurance
The European Insurance and Occupational Pensions Authority (EIOPA) published two consultation papers—one on the supervisory statement on exclusions related to systemic events and the other on the supervisory statement on the management of non-affirmative cyber exposures.
NGFS Report on Integration of G-Cubed Model into NGFS Scenarios
The Network for Greening the Financial System (NGFS) published a report that explores the feasibility of integrating the G-Cubed general equilibrium model into the NGFS suite of models.
US Senate Members Seek Details on SEC Proposed Climate Disclosure Rule
Certain members of the U.S. Senate Committee on Banking, Housing, and Urban Affairs issued a letter to the Securities and Exchange Commission (SEC)
EIOPA Consults on Review of Securitization Framework in Solvency II
The European Insurance and Occupational Pensions Authority (EIOPA) published a consultation paper on the advice on the review of the securitization prudential framework in Solvency II.