Laboratory System Data Extraction  (LSDE)

 

    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.

 LIS Data Extract Summary

    LSDE (Laboratory System Data 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 application 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.

    Extracted data from LIS Cache/M global arrays are formatted and transferred to an external server
    where the data can be accessed via SQL statements or other programming languages such as java,
    C#, C++, VB, etc.  

 

    Data from the lab system is send it to a server where it can be placed into SQL tables or flat files where
   it can be used for query, reports, spreadsheets, web pages, etc.

         No need for mumps/cache user programs  
           No hassles creating AdHoc reports
           Decreases load on the lab system
           Create reports using SQL statements
           Create web pages applications from data extracted data

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

   The following data is extracted

                All Patient demographics

                Data dictionaries from lab maintenance Function MA (tests departments, tube types, etc.)

                All patient results

                Method codes

                Accession number history

    LSDE can be customized to extract any data you specify from the LIS system
    (Gen Lab, AP, Micro, and BB).

   

    After all the data has been extracted from the LIS it is kept update using LSDE
    incremental process. Once a day (recommended) LSDE scans transaction global ^LTN
    searching for specific transaction types.