LabComm captures and stores data from analysers in an SQL compliant database.

Data is available in many formats, including via ODBC, HL7 format, CSV, XML etc HL7 data is supplied as files or TCP/IP sockets.

Examples of HL7 data are shown below, with examples from different analysers.

 

  1. MSH|^~\&|LabDriver|access2|||20100908112907||ORU^R01|3707|P|2.3|||ER|NE|
  2. PID|1||094854|||||| OBR|1|HCV1||^^|||||||||||Serum||||||||||F|
  3. OBX|1|CE|^HCVPLUS~1|1|0.09^Non-React.|S/CO||N|||F|||20100908110751|||
Source code

IL Gem

Access2 600

There are two example files here. In the first example the analyser will send a numeric value (6.13)

  1. MSH|^~\&|LabDriver|access2|||20100920122050||ORU^R01|3722|P|2.3|||ER|NE|
  2. OBR|1|LYPHOCHEK1||^^|||||||||||Serum||||||||||F|
  3. OBX|1|NM|^TBhCG2~1|1|6.13|IU/L||N|||F|||20100920115827|||
Source code

In the second example it will send a numerical value (0.09) as well as a Character value (Non - Reactive)

Many analysers do this and it allows the lab to choose the cut-off values, creating a category between Positive and Negative, often called  "Indeterminate". Samples with this intermediate status are usually repeated.

  1. MSH|^~\&|LabDriver|access2|||20100908112907||ORU^R01|3707|P|2.3|||ER|NE|
  2. PID|1||094854||||||
  3. OBR|1|HCV1||^^|||||||||||Serum||||||||||F|
  4. OBX|1|CE|^HCVPLUS~1|1|0.09^Non-React.|S/CO||N|||F|||20100908110751|||
Source code

Becton Dickinson Bacteriological Analyser

  1. MSH|^~\&|LabComm^Becton
  2. Dickinson^V1.0^^^|Bactec|||20101106132754||ORU^R01|260|P|2.3|||ER|NE|
  3. PID|1||||||||
  4. OBR|1|08M999936||^^^MGIT_960_GND||||||||||||||||||||||
  5. OBX|1|CE|^GND_MGIT~430141836690|1|INST_POSITIVE^200^A/D13||||||P||||||
Source code

Siemens Clinitek Status Urine analyser

Comments sent from this analyser are captured in a ^Comment field

In this case the comments captured are "Visibly bloody urine may cause falsely elevated PRO results"

  1. MSH|^~\&|LabDriver^SIEM^Clinitek
  2. Status^POCT1-A/Clinitek^2.400:0002^2.2.0.0^18774|Clinitek01|||20130224133012||ORU^R01|6|P|2.3|||ER|NE|
  3.  
  4. PID|1||5632||JONES^PETE||||
  5. OBR|1|5632|5632||||20121215111300|||||||||||||||||||
  6. OBX|1|NM|^GLU|1|250|mg/dL|||||F|||20121215111300|||
  7. OBX|2|ST|^KET|1|Negative||||||F|||20121215111300|||
  8. OBX|3|ST|^SG|1|>=1.030||||||F|||20121215111300|||
  9. OBX|4|ST|^BLO|1|Large||||||F|||20121215111300|||
  10. OBX|5|NM|^pH|1|6.5||||||F|||20121215111300|||
  11. OBX|6|NM|^PRO|1|100|mg/dL|||||F|||20121215111300|||
  12. OBX|7||^Comment|1|CRSNote1^Visibly bloody urine may cause falsely elevated PRO results|||||||||20121215111300|||
  13. OBX|8|ST|^NIT|1|Positive||||||F|||20121215111300|||
  14. OBX|9|ST|^LEU|1|Negative||||||F|||20121215111300|||
  15. OBX|10||^Comment|1|CRSNote1^High SG may cause falsely lowered LEU results|||||||||20121215111300|||
  16. OBX|11|ST|^COL|1|Yellow||||||F|||20121215111300|||
  17. OBX|12|ST|^CLA|1|Clear||||||F|||20121215111300|||
Source code

VetScan Veterinary Haematology analyser

This Veterinary haematology analyser analyser will send charts for values where there is a distribution.

LabComm allows the user to selectively choose which parameters to select.

In this case we see RBC, WBC, EOS and Platelets values.

  1. WBC^Graph,
  2. RBC^Graph,
  3. PLT^Graph,
  4. EOS^Graph
Source code

  1. MSH|^~\&|LabComm^VetScan
  2. HM5^252604^^^|VetScan|||20111217114551||ORU^R01|42|P|2.3|||ER|NE|
  3. PID|1||||||||
  4. OBR|1|0|0||||20110301100300|||||||||||||||||||
  5. OBX|1||^WBC|1|0.06|10^9/l|0.00-0.00|N|||F|||20110301100300|||
  6. OBX|2||^RBC|1|0.00|10^12/l|0.00-0.00|N|||F|||20110301100300|||
  7. OBX|3||^HGB|1|0.0|g/dl|0.0-0.0|N|||F|||20110301100300|||
  8. OBX|4||^HCT|1|0.00|%|0.00-0.00|N|||F|||20110301100300|||
  9. OBX|5||^MCV|1|0|fl|0-0|N|||F|||20110301100300|||
  10. OBX|6||^MCH|1|0.0|pg|0.0-0.0|N|||F|||20110301100300|||
  11. OBX|7||^MCHC|1|0.0|g/dl|0.0-0.0|N|||F|||20110301100300|||
  12. OBX|8||^PLT|1|13|10^9/l|0-0|N|||F|||20110301100300|||
  13. OBX|9||^PCT|1|0.01|%|0.00-0.00|N|||F|||20110301100300|||
  14. OBX|10||^MPV|1|9.8|fl|0.0-0.0|N|||F|||20110301100300|||
  15. OBX|11||^LYM|1|0.00|10^9/l|0.00-0.00|N|||F|||20110301100300|||
  16. OBX|12||^MON|1|0.00|10^9/l|0.00-0.00|N|||F|||20110301100300|||
  17. OBX|13||^NEU|1|0.00|10^9/l|0.00-0.00|N|||F|||20110301100300|||
  18. OBX|14||^LY%|1|0.0|%|0.0-0.0|N|||F|||20110301100300|||
  19. OBX|15||^MO%|1|0.0|%|0.0-0.0|N|||F|||20110301100300|||
  20. OBX|16||^NE%|1|0.0|%|0.0-0.0|N|||F|||20110301100300|||
  21. OBX|17||^EOS|1|0.01|10^9/l|0.00-0.00|N|||F|||20110301100300|||
  22. OBX|18||^EO%|1|0.0|%|0.0-0.0|N|||F|||20110301100300|||
  23. OBX|19||^BAS|1|0.00|10^9/l|0.00-0.00|N|||F|||20110301100300|||
  24. OBX|20||^BA%|1|0.0|%|0.0-0.0|N|||F|||20110301100300|||
  25. OBX|21||^WBC^Scale(fl)|1|400||||||F|||20110301100300|||
  26. OBX|22||^WBC^Channels|1|256||||||F|||20110301100300|||
  27. OBX|23||^WBC^WMarker1|1|16||||||F|||20110301100300|||
  28. OBX|24||^WBC^WMarker2|1|0||||||F|||20110301100300|||
  29. OBX|25||^WBC^WMarker3|1|0||||||F|||20110301100300|||
  30. OBX|26||^WBC^Graph|1|0^0^0^0^0^0^0^0^0^0^0^14^14^14^14^14^14^14^12^10^9^8^7^6^5^4^3^3^2^2^2^2^2^2^2^2^2^2^2^1^1^1^1^0^0^0^0^0^0^0^0^1^1^1^1^2^2^2^2^2^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0||||||F|||20110301100300|||
  31. OBX|27||^RBC^Scale(fl)|1|200||||||F|||20110301100300|||
  32. OBX|28||^RBC^Channels|1|256||||||F|||20110301100300|||
  33. OBX|29||^RBC^RMarker1|1|38||||||F|||20110301100300|||
  34. OBX|30||^RBC^Graph|1|0^0^1^1^2^3^3^4^3^3^2^2^1^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0||||||F|||20110301100300|||
  35. OBX|31||^EOS^Scale(fl)|1|400||||||F|||20110301100300|||
  36. OBX|32||^EOS^Channels|1|256||||||F|||20110301100300|||
  37. OBX|33||^EOS^EMarker1|1|36||||||F|||20110301100300|||
  38. OBX|34||^EOS^Graph|1|0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^1^1^2^2^3^3^2^2^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^1^1^2^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^1^1^2^1^1^0^0^0^0^0^0^0^0^0^1^1^2^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^1^1^2^1^1^1||||||F|||20110301100300|||
  39. OBX|35||^PLT^Scale(fl)|1|50||||||F|||20110301100300|||
  40. OBX|36||^PLT^Channels|1|256||||||F|||20110301100300|||
  41. OBX|37||^PLT^PMarker1|1|11||||||F|||20110301100300|||
  42. OBX|38||^PLT^PMarker2|1|151||||||F|||20110301100300|||
  43. OBX|39||^PLT^Graph|1|0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^1^3^4^4^6^7^8^8^9^9^9^9^8^8^7^7^7^6^6^6^5^5^4^4^3^2^2^2^1^1^1^1^1^1^1^1^2^2^2^2^2^2^1^1^1^1^1^1^0^0^0^0^0^0^1^1^1^1^1^1^1^1^1^1^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0||||||F|||20110301100300|||<span style="font-size: 10pt;">
Source code

Horiba ES60 Haematology Analyser

This analyser will send charts and graphs and will send two test codes.

One of the test codes is its own format and the other is the Loinc code.

"RBC" is the internal code for Red Blood Cells. "^RBC"

789-9 is the Red Blood Cells Loinc code

  1. MSH|^~\&amp;|LabDriver|Horiba1|||20100112131858||ORU^R01|167|P|2.3|||ER|NE| PID|1||8122509-24||KENNY|||M|
  2. OBR|1|046570||^^|||20091207100622||||||||||||||||||F|
  3. OBX|1|NM|^MPV~776-5|1|8.3|1|||||F|||20091207100622|||
  4. OBX|2|NM|^PDW~X-PDW|1|14.9|1|||||F|||20091207100622|||
  5. OBX|3|NM|^PLT~777-3|1|288|1|||||F|||20091207100622|||
  6. OBX|4|NA|^PLT^curve|1|0^0^0^0^0^3^7^13^15^20^23^29^33^39^43^45^46^45^47^46^49^49^52^50^49^52^53^53^53^52^49^47^42^41^39^36^33^29^27^26^26^24^23^22^20^18^17^16^16^14^14^13^11^11^10^10^10^10^10^9^9^9^8^8^8^7^7^5^4^4^4^3^3^3^3^3^2^2^2^2^2^2^2^2^2^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^1^0^1^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0|||||||||20091207100622|||
  7. OBX|5|NM|^PLT^threshold|1|69|||||||||20091207100622|||
  8. OBX|6|NM|^THT~X-PCT|1|0.240|1|||||F|||20091207100622|||
  9. OBX|7|NM|^HCT~4544-3|1|42.6|1|||||F|||20091207100622|||
  10. OBX|8|NM|^HGB~717-9|1|13.9|1|||||F|||20091207100622|||
  11. OBX|9|NM|^MCH~785-6|1|31.6|1|||||F|||20091207100622|||
  12. OBX|10|NM|^MCHC~786-4|1|32.5|1|||||F|||20091207100622|||
  13. OBX|11|NM|^MCV~787-2|1|97|1|||||F|||20091207100622|||
  14. OBX|12|NM|^RBC~789-9|1|4.39|1|||||F|||20091207100622|||
  15. OBX|13|NA|^RBC^curve|1|0^0^0^0^0^0^0^0^0^0^0^0^3^3^3^2^1^1^1^1^1^1^1^3^3^5^8^14^28^40^60^85^112^143^186^194^223^199^196^193^156^145^134^112^108^96^92^101^78^84^84^74^76^67^64^63^55^53^55^44^39^41^36^36^34^29^25^22^23^21^18^18^12^15^12^8^8^8^7^5^5^6^5^3^4^3^3^3^3^2^2^2^3^3^1^1^1^1^1^1^1^1^1^0^0^0^0^0^0^1^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^4|||||||||20091207100622|||
  16. OBX|14|NM|^RDW~788-0|1|12.9|1|||||F|||20091207100622|||
  17. OBX|15|NM|^GRA#~20482-6|1|2.40|1|||||F|||20091207100622|||
  18. OBX|16|NM|^GRA%~14773-6|1|55.9|1|||||F|||20091207100622|||
  19. OBX|17|NM|^LYM#~731-0|1|1.60|1|||||F|||20091207100622|||
  20. OBX|18|NM|^LYM%~736-9|1|39.5|1|||||F|||20091207100622|||
  21. OBX|19|NM|^MON#~742-7|1|0.10|1||L|||F|||20091207100622|||
  22. OBX|20|NM|^MON%~744-3|1|4.6|1|||||F|||20091207100622|||
  23. OBX|21|NM|^WBC~804-5|1|4.1|1|||||F|||20091207100622|||
  24. OBX|22|NA|^WBC^curve|1|0^0^0^0^0^0^0^0^6^15^28^32^41^64^108^160^201^223^223^199^175^140^116^90^64^47^32^28^21^21^17^17^17^17^15^12^12^12^15^19^21^21^21^21^19^23^28^30^32^30^32^32^34^34^30^32^34^36^41^43^43^38^38^41^38^45^47^51^49^49^54^56^54^54^58^64^62^62^62^60^51^47^51^54^51^45^41^41^38^38^34^34^34^34^30^25^30^32^32^23^15^12^15^15^15^15^10^10^6^6^6^6^8^6^6^4^4^2^2^4^2^2^0^2^2^2^2^8|||||||||20091207100622|||
  25. OBX|23|CE|^WBC^threshold|1|00^00^00^19^24|||||||||20091207100622|||
Source code