ron baremans
DESCRIPTION
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. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/1.jpg)
Ron Baremans
e-Line DNB“a generic reporting system”
![Page 2: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/2.jpg)
e-Line generic solution forreporting
Data production
PublicationData transmission
StorageQualitychecks
ECB
BIS
Eurostat
NationalStatisticsBureau
Government
XML
Data-entry
XBRL
Internet
Mathematical
Plausibility DatawarehouseDepartments
![Page 3: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/3.jpg)
e-Line overview
• Internet based tool• Engine• Build your own website around it• Build your own reporting forms• Support for any language
![Page 4: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/4.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 5: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/5.jpg)
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
![Page 6: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/6.jpg)
Red “due date” for overdue reportsMenu for
editing reports
Status per report
![Page 7: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/7.jpg)
Questionnaire with drop
down menuDifferent forms in
tree
![Page 8: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/8.jpg)
Extensive layout possibilities
Menu
Use of colour White
spots
Dimensions
![Page 9: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/9.jpg)
Extensible no. rows
![Page 10: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/10.jpg)
Forms can change by interaction
![Page 11: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/11.jpg)
![Page 12: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/12.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 13: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/13.jpg)
Register
• Who are our reporters• Contact information• e-mail adresses to have the system
automatically generate e-mails
![Page 14: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/14.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 15: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/15.jpg)
Excel: specifications XML blueprints
Definition
Business
Display
Label
e-Line enginee-Line forms
![Page 16: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/16.jpg)
XML blueprints
Definition
Business
Display
Label
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• …
![Page 17: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/17.jpg)
ReportersFormsets
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:
1. ING has to report COREP IRB every quarter2. Fortis has to report the Monetary report every month3. Rabobank has to report Pillar 2 interest risk every quarter4. ABP pensionfund has to report assets report every quarter5. …
![Page 18: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/18.jpg)
![Page 19: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/19.jpg)
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
![Page 20: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/20.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 21: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/21.jpg)
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
![Page 22: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/22.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 23: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/23.jpg)
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)
![Page 24: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/24.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 25: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/25.jpg)
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
![Page 26: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/26.jpg)
BrowserWeb
server
Security(PKI)
CertificateCredentials
RegisterReportingprogress
Registerdata
Reportstorage
Reportingassessment
Time seriesdatabase
Reportingarrange-ments
e-Lineexternal
e-LineInternal
back office
Internet
![Page 27: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/27.jpg)
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
![Page 28: Ron Baremans](https://reader035.vdocuments.us/reader035/viewer/2022062323/568159f2550346895dc73af6/html5/thumbnails/28.jpg)
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