Back to home

Laboratory System Data Extraction

Laboratory (ETL) Data Extraction

The extraction phase retrieves data from transactional systems, spreadsheets, and flat files. The data is staged in a consistent format before transformation, which prevents corrupted or faulty data from reaching the data warehouse.

Laboratory System Data Extraction (LSDE)

LSDE is a full-function application that extracts data from the laboratory system and transfers it to an external server. It can be used as a turnkey product or modified to meet your specification. The software package includes a menu-driven utility that configures and controls the extraction process, installed as the LAB function LSDE.

Data can be extracted in real time and either copied to an LSDE directory on your Laboratory Information System (LIS) or transferred to an external LSDE system for the same purpose. Accuracy of the transferred data is verified once the process completes.

How the process runs

  1. 1

    Extract

    The LSDE processor reads data from the clinical laboratory database. Multiple files are generated until the extraction is complete.

  2. 2

    Format

    Once extracted, the data is stored in a staging area and formatted into the required structure so it is consistent before it is transferred.

  3. 3

    Transfer

    The formatted data is transmitted to external servers — SQL databases, data warehouses, and web servers.

  4. 4

    Access

    Transferred data is available through SQL statements or programming languages such as Java, C#, C++, or Visual Basic.

What extracted data makes possible

  • Generate on-demand reports on the receiving server.
  • Transmit laboratory data and results to other networks.
  • Create SQL queries for laboratory results on a SQL server.
  • No need to develop MUMPS user programs for the laboratory system.
  • Develop web pages and applications using the extracted laboratory data.
  • Reduce the load on the laboratory system.

Extracted data, fully customizable

  • Patient demographics
  • Data dictionaries (tests, departments, tube types, etc.)
  • Patient results
  • Method codes
  • Accession number history
  • Custom extraction from LIS systems (Gen Lab, AP, Micro)

Keeping the extract current

Once the full extraction has completed, it is converted and loaded into your new database. The LIS copy is kept current with the LSDE incremental process: once a day, LSDE scans the transaction global ^LTN for specific transaction types.

The same approach applies to other leading systems such as Cerner, Epic, McKesson, and Meditech, not only Sunquest Laboratory.

Documentation and worksheets

Technical documentation, the LIS data extract utility guide, the extraction video, and installation worksheets are available from Labins.