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

The process begins by extracting data from the clinical laboratory database
using the LSDE processor. Multiple files are regenerated until the extraction is complete.

Afterward, the LSDE formats the data into the required structure. The formatted data is transmitted to the external servers, including SQL databases, warehouses, and 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. Generate ad-hoc reports on the receiving server.
2. Transmit laboratory data and results to other networks.
3. Create SQL queries for laboratory results on a SQL server.
4. There is no need to develop MUMPS user programs on the
laboratory system.
5. Develop web pages and applications using the extracted
laboratory data.
6. This will decrease the load on the laboratory 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