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 labortory database by the LSDE processor.

Multiple files are created until the extraction is completed after
which the LSDE processses data into the required format.

Formatted data is then transmitted to external servers. (SQL, Warehouse, web servers).

Data integration process that combines, cleans and organizes data
Clinical Laboratory System from multiple sources into a single,
consistent data set.

Extraction from Cache/M global arrays are formatted and transferred
to external servers where the data can be accessed via SQL statements \
or other programming languages such as java, C#, C++, VB, etc. where
it can files be use for query, reports, spreadsheets, web pages, and more.

If there’s, something specific you need help with feel free to contact us.

Diagram above shows the basic extraction
processes; lab data can be extracted in
real-time, copied to a LSDE directory on
your LIS system where extraction takes
place or copied to an external LSDE
system for extraction. After a full LAB data
extraction has occurred you can configure
the process to perform incremental
extractions real-time, hourly, daily, weekly or
even longer.

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

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 extracted
lab data
6. Decreases load on the lab system

The standard -(out of the box) LSDE
process starts by extracting all lab
data from the LIS system, converting
it to specifications transferring it to
external servers, and verifying
transfer data.

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.

Below is a video takes about 14 minutes to view it explains the entire
xtraction process. The video uses Sunquest laboratory as an example
but applies to other laboratory systems such as Cerner, Epic, Mckesson,
and Meditech. Watch the video below, you can download this video alone
with software installation worksheets.

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