English French German Italian Portuguese Russian Spanish

There are two standard identifiers used in laboratory test & QC samples. These are the SID (Sample ID) or LabNo which refers to a sample and a PID (Patient ID) which refers to the Patient

The SID is usually printed as a barcode label and stuck on the sample tube. Most analysers scan and read the barcode label when they process the sample. 

Problem

LabNo or SID-01

One analyser sends our SID in the PID field

Requirement

LabNo or SID-02

We want to use the SID or LabNo as the identifier

We store the sample with the printed SID barcode

LabComm Solution

LabNo or SID-03

An analyser specific option allows us to choose which field to extract the SID from

We don`t want to store blank or empty records that have no identifiers

We have the option to discard records without a SID or PID as we have no means of tracing these records to a patient or visit.

Some analysers can send graphical data such as a chart or plot. The data can be captured and stored, both in the DB and in HL7 format.

Problem

graphical data-01

A veterinary Haematology analyser such as VetScan HM5 analyser sends the cell distributions for a blood sample. Some of the test results such as RBC (Red Blood Cells)  WBC (White Blood Cells) and PLT (Platelets) are displayed as graphs as well as numeric results. 

Requirement

graphical data-02

We want to store the plots and charts in a standard format so we can produce lab reports that display the charts the analyser has sent.

LabComm Solution

 

The data stream is processed by LabComm

We extract the graphical data. Thsi data is stored in two tables, one of the tables stores the points and the values and the other stores the Parameters such as WBC^Channels and WBC^Scale(fl)

In addition, we export the data in an HL7 format, where requested

Note that there does not seem to be a standard for graphical data formats and so each analyser`s graphical data has to be processed and interfaced to separately

If you use the ODBC database connection to connect to the LabComm DB, we can convert the test codes sent from the analyser into codes your LIMS, reporting or other IT systems require. The easiest solution is to supply a numeric id (integer) as a testcode. What does this mean?

The Roche/Hitachi cobas e411 analyser sends a test code 10 which is the code for TSH. The Abbott Architect sends a code ^531~CMV IgG. You would like to translate these codes to a set of numeric values to match those used by your system.

This is part of the test code mapping the LabComm system can provide. In all cases the only value that the analyser sends is parameter, the other values are attached using a trigger function in the database. This converts unfriendly names into recognisable test codes. The long test name and short test names are added that way.

The following test codes are sent from the Abbott Architect

Parameter
^149~HBsAg Qual
^161~Anti-HCV
^442~HTLV-I/II
^531~CMV IgG
^541~CMV IgM
^561~Syphilis
^580~Anti-HBcII

 

These are easy to interpret as we have the numeric test code and a recognisable short test name. However, most analysers simply send a numeric code which would look this:

 

Parameter - numeric
^149
^161
^442
^531
^541
^561
^580

 

We then setup a Test code translation table. You have provided the numbers in the TestID column

 

ParameterTestNameShortTestNameTestID
^149~HBsAg QualHep B surface antibodyHep B sur Ab16
^161~Anti-HCVAnti-HCV (Hep C antibody)Hep C  Ab4
^442~HTLV-I/IIAnti-HTLV I & IIHTLV8
^531~CMV IgGCMV IgG (Cytomegalovirus)CMV IgG6
^541~CMV IgMCMV IgM (Cytomegalovirus)CMV IgM7
^561~SyphilisVDRL (Syphilis)Syphilis5
^580~Anti-HBcIIAnti-HBc (Hep B core antibody)Hep B core Ab14

 

The TestID`s are from a file you have provided. You can now store the results for CMV IgG against your TestID number 6. This makes analyser interfacing really easy!

We may want to convert and standardise units in test & QC data. 

 

Problem

0106TestUProblem

One analyser sends data for Calcium in conventional units 

mg/dL

A second analyser sends mEq/L

A third  analyser sends mmol/l

Requirement

0206TestURequirement

We want to use SI Units

These will be mmol/L for Calcium

LabComm Solution

0306TestUSolution

We find two fields in the database called UnitsOrig and Units.

UnitsOrig has our original values mg/dL, mEq/L or mmol/l

Units has mmol/L.

We need to be aware that we are doing two different things.

Converting mmol/l  to mmol/L is a simple label change to correct the case (L).

mEq/L to mmol/L requires a conversion factor.

We store both our original and revised values and need to compare them in order to validate the system and the conversion

An analyser sends a character result and you want to record it as Positive, Negative or Indeterminate

Different analsyers send these results with different values.

+ and -


The Biomerieux BacT/ALERT is automated microbial detection system.
http://www.biomerieux-usa.com/servlet/srt/bio/usa/dynPage?doc=USA_PRD_LST_G_PRD_USA_6

Results are sent with values + and -


BACTEC MGIT 960 Mycobacterial Detection System
http://www.bd.com/ds/productCenter/MT-BactecMgit960.asp

Results are sent with values INST_POSITIVE and INST_NEGATIVE


Abbott Diagnostics Architect Immunochemistry
http://international.abbottdiagnostics.com/products/instruments_by_platform/default.cfm?sys_id=204&lang=ENG

Results are sent with values Nonreactive and Reactive


Beckman Access 2 Immunology Analyzer
https://www.beckmancoulter.com/wsrportal/wsr/diagnostics/clinical-products/immunoassay/access-2/index.htm

Results are sent with values Nonreactive and Reactive

In addition to these Positive or Negative results some of the analyser with send a numeric value with an S/CO (Standard cutoff rate)