Dirk Ziegemeyer
by Dirk Ziegemeyer

Tags

  • AnaCredit
  • Reporting
  • History
  • Database
  • Validation
  • Delete
  • Software
  • Deutsche Bundesbank
  • ECB

Ziegemeyer Consulting’s AnaCredit History Reader is a software tool that enables banks to read historical AnaCredit reports and gain rapid transparency regarding data held by the Deutsche Bundesbank.

The AnaCredit History Reader generates active datasets from the XML files submitted to Deutsche Bundesbank

The software takes the XML files submitted to Deutsche Bundesbank and generates easy-to-read CSV tables with the active datasets. Its output is used by the AnaCredit Tool to generate deletion and correction reports and for cross-repdate validations.

AnaCredit reporting is cumulative

AnaCredit reports build up a history in the Bundesbank and ECB (European Central Bank) databases. Every new report is based on this history. Knowledge of this history is needed for the following reasons:

  • To report an instrument with action attribute Delete, either:
    • because it was reported by mistake, or
    • because it is no longer subject to reporting
  • To check validation rules referring to previous reporting dates
  • To identify changes in counterparty reference and loan data

Deutsche Bundesbank defines the main rules with regard to the historical AnaCredit database as follows:

  • The start date for building the historical database is the reporting date of September 2018 – see Circular 63/2018.
  • Static loan data are valid without time limit until they are explicitly terminated using the action attribute Delete.
  • Static loan data already reported as terminated are reinstated for an unlimited time where corrected for a previous reporting date. A separate new deletion report needs to be filed once the correction has been reported.

To determine the volume of static loan data with unlimited validity, the chronological order of the filed reports must be known. Bundesbank requirements regarding deletions and corrections are explained in detail in Circulars 76/2018 and 27/2019.

How it works

The AnaCredit History Reader requires the following input data:

  • List of all XML files sent to and accepted by the Bundesbank, in chronological order. This list covers reports by the reporting agent and all of its observed agents and all reports since September 2018.
  • Reporting date for which the active data records are to be created
  • All submitted and accepted XML files.

The software generates one CSV file for each AnaCredit SDMX dataset per reporting agent and each of its observed agents. It maps the Deutsche Bundesbank technical specification with respect to action attributes Replace and Delete, together with the various rules that apply to static loan data and dynamic loan data.

Use cases for the AnaCredit History Reader

The AnaCredit History Reader is a stand-alone application whose output can be used for the following purposes:

  • Deleting loan data in AnaCredit reports
  • Performing cross-repdate validations
  • Identifying changes in counterparty and loan data
  • Displaying active records for any reporting date
  • Reading AnaCredit legacy data for migration to new AnaCredit reporting software

Try it out on a no-obligation basis

See for yourself. Request a non-binding test version of the AnaCredit History Reader by e-mail.