Filing Infrastructure at Bundesbank XIV European Banking Authority XBRL Workshop hosted by EBA Kathrin Jansen

1. Filing Infrastructure at Bundesbank XIV European Banking Authority XBRL Workshop hosted by EBA Kathrin Jansen

2. Presentation overview • General Conditions (slides 3-7) • Actual System • Planned System

3. 1. General conditions • Reporting System • The Deutsche Bundesbank is responsible for collecting data relating to • External sector statistics, Banking statistics • Banking supervision

4. 1. General conditions • Banking Supervision • The Deutsche Bundesbank • performs a key operational task by helping • to secure a financially sound banking industry and, • ultimately the stability of the financial system

5. 1. General conditions • Banking Supervision • In Cooperation with the • Federal Financial Supervisory Authority (FFSA /BaFin) • The Deutsche Bundesbank is responsible for the • continuous oversight of • the solvency, • liquidity and • risk management systems

6. 1. General conditions • Supervisory Information System • roughly 2000 Credit and Financial Institutions • 800 internal User Credit Banks Cooperative Banking Institutions Saving Banks FinanceservicesInstitutions Mortgage Banks Finance Companies Banks withspecialtasks Payment Institutes

7. 1. General conditions • New Requirements • due to the European harmonisation processes • in the supervisory reporting system • CoRep / FinRep Framework • Article 74 of the amended CRD • (2006/48/EG u. 2006/49/EG, CRD III, CRD IV) • competent authorities shall apply • uniform formats, frequencies and dates of reporting • by 31 Dezember 2012  New System

8. Presentation overview • General Conditions • Actual System (slides 9-12) • Planned System

9. 2. Actual System • Actual Filing Infrastructure • Electronic Submission • Online Submission • Formats • XML – electronic submission: 92% oftheinstitutes • XBRL– electronic submission: 6% oftheinstitutes • XBRL– online submission: 1% oftheinstitutes • Paper 1% oftheinstitutes

10. 2. Actual System • Limits of the actual system • presentation orientated (reports and positions) • not multidimensional Information for each Cell: Report name: MKRAK Reporting period: 2010-06-30Position number: 01003Position type: AmountUnit: 1000

11. 2. Actual System • Data withintheeuropeansystem • Identificationcode: 1106001 • Reporting period: 2010-06-30 • Area: Solv • Capital Requirement • Risk Type • CreditRisk • Approach • Standard Approach • Exposure Class • Central Governments • Type oftheposition • Total amount • Portfolio • Bank book • monetaryAmount: 300.000 Data within the position related system Identification code: 1106001 Reporting period: 201006 Report name: CA Position nubmer: 142001 Amount: 300.000 Measure Dimension Domain member Dimension Domain member Dimension Domain member Dimension Domain member Dimension Domain member

12. 2. Actual System instance.XML instance.XBRL instance.XBRL online E-file Supervisor Submitter

13. Data Entry (XBRL) Supervisor ExtraNet Submission (XML, XBRL) XML und XBRL Instance Application Server 2. Actual System Submitter Analyses and Reports FilingProcess incl. Validation and Aggregation Database

14. 2. Actual System • The legacy system • has historically grown over several years • the banking supervisors know the functions an processes

15. 2. Actual System • The legacy system • the xml-based data exchange format is a proprietary format • we get already XBRL files, but the data is mapped into the report orientated structure of the legacy system • semantical information are lost  From a technically point of view the underlying data model is insufficient for the new challenges

16. Presentation overview • General Conditions • Actual System • Planned System (slides 14-18)

17. 3. Planned System • Electronic Submission • Online Submission Feedback Fomula Validation And electronical feedback Submitter Supervisor

18. Data Entry (XBRL) Supervisor ExtraNet Submission (XML, XBRL) XML und XBRL Instance Anwendungs-Server Submitter Analyses and Reports FilingProcess W Oracle XBRL Extension W Relational DW Database Server

19. 3. Planned System • Schedule • Start: April/Mai 2011 • Test System: July 2012 • Productive Operation: January 2013 April/May 2011 July 2012 January 2013 Implementation and migration of data Test and Integration Support with the introduction Operation

20. 3. Planned System • Standard Software • tight time constraints • shortage of human resources • IT strategy • forcore XBRL processingcomponents High quality Time and costsaving close to thespecification

21. 3. Planned System Standard Software Components Filingprocess Taxonomy Management Analyses Taxonomy Editor Data Warehouse + Reporting Software Designer forVisualization Data EntryComponent TaxonomyRepository Oracle XBRL Extension DB

22. 3. Planned System • Challenges • tight time constraints • final versions of Taxonomies: available in 2012 • shortage of human resources • Matrix organization • (involvement of different groups) • new technologies • Oracle XBRL Extensions Data Base • Integration of software components • (e.g. Data Entry, Validator, ...) • Data Warehouse

23. 3. Planned System • Advantages • Change from a template centred approach to a data centred approach • only validated data reach the system and are saved in the Data base • the process is more automated • the submitter gets an electronic feedback • the supervisors have only to clarify difficult issues

24. Thank you for your attention!