Electronic Data Collection Systems in HCSO - PowerPoint PPT Presentation

Electronic data collection systems in hcso
1 / 12

  • Uploaded on
  • Presentation posted in: General

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

Electronic Data Collection Systems in HCSO

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)

Connections of kshxml to other systems in hcso

Connections of KSHXML to other systems in HCSO

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

Electronic data collection systems in hcso

Thank you for your attention!

  • Login