290 likes | 451 Views
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. BIS. Storage. Publication.
E N D
e-Line DNB “a generic reporting system” Ron Baremans
e-Line generic solution forreporting National Statistics Bureau Departments Data-entry Internet Plausibility Datawarehouse ECB Data production Data transmission Quality checks BIS Storage Publication Eurostat XML Mathematical Government XBRL
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 Red “due date” for overdue reports Menu for editing reports
Questionnaire with drop down menu Different forms in tree
Extensive layout possibilities Dimensions Use of colour White spots Menu
Register • Who are our reporters • Contact information • e-mail adresses to have the system automatically generate e-mails
Definition Business Display Print Label XML blueprints Excel: specifications e-Line forms e-Line engine
Definition Business Display Print Label XML blueprints Formset, e.g. COREP SA • Attributes: • frequency e.g. w/m/q/y/…) • due date e.g. 10th working day • when available for reporter? • name e.g. COREP SA quarterly • …
Formsets Reporters • Attributes: • frequency: e.g. w/m/q/y/…) • due date: e.g. 10th working day • when available for reporter? • name: e.g. COREP SA quarterly • … • Attributes: • frequency: e.g. w/m/q/y/…) • due date: e.g. 10th working day • when available for reporter? • name: e.g. COREP SA quarterly • … • Attributes: • frequency e.g. w/m/q/y/…) • due date e.g. 10th working day • when available for reporter? • name e.g. COREP SA quarterly • … • Reporting Arrangements: • 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 data-entry sites • XBRL compliant
Interested? e-mail: j.c.baremans@dnb.nl tel.: +31 20 524 32 43