LSDE Extraction - Labins Consulting Services

Laboratory (ETL) Data Extraction

ETL stands for Extract, Transform, Load. is a
process used in data warehousing and data
integration to move data from various sources
into a centralized data repository.

LSDE Processor

Proccess begains by extracting data from the clinical labortorydatabase by the LSDE processor. Multiple files are created until the extraction is completed after which the LSDE processes data into the required format. Formatted data is then transmitted to external servers. (SQL, Warehouse, web servers).

The data integration process combines, cleans, and organizes data from multiple sources into a single, consistent data set for the Clinical Laboratory System. Data is extracted from Cache/M global arrays, formatted, and transferred to external servers.

The process starts with extracting data from the clinical laboratory database using the LSDE processor. Multiple files are generated until the extraction is fully completed. Afterward, the LSDE formats the data into the required structure. Once formatted, the data is loaded onto external servers, which may include SQL databases, data warehouses, and web servers.

Once transferred, this data can be accessed using SQL statements or programming languages such as Java, C#, C++, or Visual Basic. The data opens up a world of possibilities! It can be harnessed for dynamic queries, insightful reports, interactive spreadsheets, eye-catching web pages, and so much more. Let your creativity run wild as you transform information into a powerful tool!

The diagram above illustrates the basic
extraction processes. Lab data can be
extracted in real-time and either copied
to a LSDE directory on your Laboratory
Information System (LIS) for extraction
or transferred to an external LSDE
system for the same purpose.

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 that allows you to configure and control the extraction process. Extraction control utility is install as LAB function LSDE.

Laboratory Extracted Data

The standard LSDE process begins by extracting all lab data
from the LIS system, converting it to specifications, transferring
The standard LSDE process starts by extracting all laboratory
data from the LIS system, converting it to required specifications,
transferring it to external servers, and verifying the transferred
data.it to external servers, and verifying the transferred data.

1. Create Ad-hoc reports on receiving server
2. Transmit lab data and results to other networks
3. Create SQL queries of lab results on a SQL server
4. No need to create Mumps user programs on the lab
system
5. Create web pages and applications from the extracted
lab data
6. Decreases the load on the lab system

List of extracted data, which is fully customizable to your requirements.

1. Patient demographics
2. Data dictionaries (tests, departments, tube types , etc.)
3. Patients results
4. Method codes
5. Accession number history
5. Customize to extract data you specify from LIS systems (Gen Lab, AP,Micro)

Once full extraction has completed it is converted an loaded into your new database.

LIS it is kept update using LSDE incremental process. Once a day(recommended) LSDE scans transaction global ^LTN searching for specific transaction types.

Unlock the full potential of your laboratory systems by downloading and watching our comprehensive video on the extraction process. While the video highlights Sunquest Laboratory as a case study, the insights shared are highly applicable to other leading systems like Cerner, Epic, McKesson, and Meditech.
Do not miss the opportunity to access valuable technical data and essential software installation worksheets that will streamline your operations. Empower your team and enhance your efficiencies today!

Download LIS Data Extract Utility Documentation Download Video and Worksheet

For more detailed information download documentation:

Call us we look forward to helping you.
7am - 6pm Mon - Fri (Pacific Standard Time)
Phone: 317-938-6892
Email: support@labins.com