Electronic data collection systems in hcso
1 / 12

Electronic Data Collection Systems in HCSO - PowerPoint PPT Presentation

  • Uploaded on

Electronic Data Collection Systems in HCSO. Luxembourg, 15 June, 2009. kshxml@ksh.hu gergely.fejos@ksh.hu. History. 1998 – 2002: EDI (Excel macro converted workbook data to RDRMES) 2002 – 2003: webEDI (Qnr’s filled in on the web, inner communication in RDRMES)

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Electronic Data Collection Systems in HCSO' - guri

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Electronic data collection systems in hcso

Electronic Data Collection Systems in HCSO

Luxembourg, 15 June, 2009



  • 1998 – 2002: EDI(Excel macro converted workbook data to RDRMES)

  • 2002 – 2003: webEDI(Qnr’s filled in on the web, inner communication in RDRMES)

  • Feb 2004: KSHXML1(Qnr’s stored in XML4DR, formatting and checks in XSL; thick/thin clients)

  • May 2005: Intrastat(Separate system, for huge Intrastat qnr’s)

  • Sep 2005: KSHXML2(Major changes to KSHXML1, mostly for efficiency)

  • Jan 2008: KSHEMAIL(Created to skip limitations of KSHXML. Not a correct solution from security point of view. Most qnr’s can be loaded automatically. Excel based, attempt to eliminate paper-based data collection.)

  • May 2011: ELECTRA(XML based, probably new structure, new technology to display/fill in qnr’s, allow dealing with huge qnr’s (maybe even Intrastat); purpose: handle all surveys, eliminate email. – Setting up requirements.)

Kshxml xml based electronic data collection system
KSHXMLXML- based Electronic Data Collection System

Kshxml costs

  • Software development: ~1.3 million €

  • Operation costs:

    • ~ 23,000 € / year(software licenses and support)

    • ~ 60,000 € / year(HR costs)

Electronic data collection systems in hcso

Data Collection system: Clients

Internet connection


WEB server

ASP servers in Cluster mode

ASP system


Client program

ASP database


TIR server

TIR system

TIR Client programs

TIR database

Kshxml model


HCSO centre


Enterprises: on-line registration,

Agencies: paper form

Agreement administration

KSHXML system’s actions



Thick or thin client (ASZ/ASZV)

Sends and Receives Questionnaires


Transfers Questionnaires or Error lists

Loads to HCSO Database

Administers the users (Clients and HCSO’s)

Controlling rules of Questionnaires

Code lists

Mandatory Data Provisions

Personalised data


Error lists

Filling in

Error checking

Sending Questionnaires




Received Questionnaires

Kshxml workflow respondent s view
KSHXML Workflow – Respondent’s view

  • Registration: Data Supplier initiates online or by sending a paper form

  • HCSO sends back the User ID and Password to Client.

  • In every time period (monthly, quarterly, annually) HCSO sends the personalised or pre-filled questionnaires to the Respondents.

  • Respondent signs in: using the * thin client via a browser or * thick client program (downloaded and installed)

  • Respondent fills in the questionnaires on-line: on the screen (in both clients) or from a CSV file (in thick client)off-line (in thick client).

Kshxml workflow hcso s view
KSHXML Workflow – HCSO’s view

  • Questionnaires sent to HCSO have been checked by the Thick / Thin Client.

  • On sending the questionnaire, respondent receives an acknowledgement.

  • On the HCSO side (TIR) the questionnaries are loaded into the database (ADEL). A second acknowledgement (reception ack.) is sent to the Respondent.

  • In ADEL, further checks are performed on the questionnaires.

    If there are errors, the Client gets an Error list and an opportunity to correct them.

  • The data of the controlled questionnaires are then processed together with the questionnaires received on paper or by e-mail.

Information channels
Information channels

  • E-mail: kshxml@ksh.hu

  • Phone (Green Line): +36 80 200 766

  • + expert for each survey