e-Line DNB “a generic reporting system” Ron Baremans
e-Line generic solution for reporting National Statistics Bureau Departments Data-entry Internet Plausibility Datawarehouse ECB Data production Data transmission Quality checks Storage BIS Publication Eurostat XML XBRL Mathematical Government
e-Line overview • • • Internet based tool Engine Build your own website around it Build your own reporting forms Support for any language
Browser for Reporters • Overview of reports DNB to be delivered • Fill out reports - data-entry - Importing: XML, XBRL • Quality checks: technical and business rules • Export to Excel / PDF • Multi-user handling
Status per report Menu for editing reports Red “due date” for overdue reports
Questionnaire with drop down menu Different forms in tree
Extensive layout possibilities Dimensions Use of colour White spots Menu
Extensible no. rows
Forms can change by interaction
Register • Who are our reporters • Contact information • e-mail adresses to have the system automatically generate e-mails
Excel: specifications XML blueprints Definition Business Display Print Label e-Line forms e-Line engine
XML blueprints Formset, e. g. COREP SA Definition Business Attributes: Display Print Label • frequency e. g. w/m/q/y/…) • due date e. g. 10 th working day • when available for reporter? • name e. g. COREP SA quarterly • …
Formsets Reporters Attributes: • frequency: e. g. w/m/q/y/…) Attributes: • due date: e. g. w/m/q/y/…) • frequency: 10 th working day • when availablee. g. w/m/q/y/…)day • due date: e. g. for reporter? • frequency 10 th working • name: e. g. COREP SA working day • when available 10 th quarterly • due date e. g. for reporter? • …name: e. g. COREP SA quarterly • • when available for reporter? • …name e. g. COREP SA quarterly • • … Reporting Arrangements: 1. 2. 3. 4. 5. ING has to report COREP IRB every quarter Fortis has to report the Monetary report every month Rabobank has to report Pillar 2 interest risk every quarter ABP pensionfund has to report assets report every quarter …
Reporting progress • Customized reporting obligations per reporter • Overviews of reporting progress • Who is late • Adjust due date per reporter • Reasons for delay & comments on report
Report storage • All data stored at DNB systems • Data only available for DNB after report has been sent in • DNB facilitates and guarantees back-up facilities
Reporting Assessment • Assessment of reports sent in • Adding comments • Enforce re-reporting or correct data in copies made by financial analists • Audit trail of all reports • Updates/revision reports to compare a re-reports with a previous one sent in • Changing the status of a report (concept/authorized)
Security (PKI = Public Key Infrastructure) PKI facilitates: • Login handling • Workstation independency • Digital signature with reports • DNB uses authentication based on userid and password • Strong authentication (e. g. with smartcard) easy to implement
Interface to back office systems • XML interface to back office system • e-Line works with: • Use of message queue (like in e-mail) • Transformation module to map XML on database • Back office & e-Line can be developed separately
Current status • • Operational since 2002 More than 4000 reporters 80 different reporting models Heavily automated users as well as small dataentry sites • XBRL compliant
Interested? e-mail: j. c. baremans@dnb. nl tel. : +31 20 524 32 43
Скачать презентацию e-Line DNB a generic reporting system Ron Baremans
7673631d9f27a03e236ecadd7b051ca0.ppt