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.

Illustration of a clinical team collaborating in an operating room

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.

    The extraction phase involves retrieving data from various sources, including transactional systems, spreadsheets, and flat files. Once extracted, this data is stored in a staging area to ensure it is in a consistent format before the transformation process begins.

  2. 2

    Format

    Formats the data into the required structure, which can be a multitude of languages, including SQL statements or programming languages such as Java, C#, C++, or Visual Basic.

  3. 3

    Transfer

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

  4. 4

    Access

    LSDE (Laboratory System Extraction) 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 or modified to meet your specification. LSDE software package comes with a menu driven utility.

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.

Labins team collaborating around an interactive data table during a sprint review
Labins team collaborating around an interactive data table during a sprint review

Labins Consulting Service

Laboratory systems integration, done right

25 years of laboratory information systems expertise — LIS data extraction, HL7 and instrument interfaces, implementation, training and ongoing support.

Labins Consulting Service Copyright® 2023 All Rights Reserved

Team dashboard