Laboratory System 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.
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.
The LSDE processor reads data from the clinical laboratory database. Multiple files are generated until the extraction is complete.
Once extracted, the data is stored in a staging area and formatted into the required structure so it is consistent before it is transferred.
The formatted data is transmitted to external servers — SQL databases, data warehouses, and web servers.
Transferred data is available through SQL statements or programming languages such as Java, C#, C++, or Visual Basic.
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.
Technical documentation, the LIS data extract utility guide, the extraction video, and installation worksheets are available from Labins.