Friday, 3 August 2012

Sample HL7 Files

Sample Result file from CCHIT

MSH|^~\&|^CCHITLabs^L-CL|^CCHIT^L-CL|^^|^^|20100407121000||ORU^R01^ORU_R01|20100407121000|P|2.5.1|0001||AL||||MT-ORU-2_R1 
PID|1|12|00000333^^^^AN||Grayson^Jim^^^^^L||19430309|M|||834 Ocean Vista Avenue^Apt. 202^Santa Monica^CA^90401||3105552233
ORC|RE|||3^EHR-System
OBR|1|3^EHR-System|LAB003^^CCHIT^L-CL|087-0714^Lipid Panel, Serum^99Lab^80061^Lipid Panel, Serum^C4|||20100407151000||||L|||||PRO1000#^Butler^Internist^E^^Dr^MD^^^^^^EI||||RO||20100407121000|||F
OBX|1|NM|13457-7^LDL Cholesterol^LN||90|mg/dL|< 99||||F|||||^DOE^JOHN|||||||AccuLabs^^^^^CLIA^^^^10D987432|432 Administration Ave.^^St. Louis^MO^63146|^Smith^John^^^Dr.^MD
NTE|0|L|
OBX|2|NM|14646-4^HDL Cholesterol^LN||60|mg/dL|40-59|H|||F|||||^DOE^JOHN|||||||AccuLabs^^^^^CLIA^^^^10D987432|432 Administration Ave.^^St. Louis^MO^63146|^Smith^John^^^Dr.^MD
NTE|0|L|
OBX|3|NM|14647-2^Total Cholesterol^LN||120|mg/dL|< 199||||F|||||^DOE^JOHN|||||||AccuLabs^^^^^CLIA^^^^10D987432|432 Administration Ave.^^St. Louis^MO^63146|^Smith^John^^^Dr.^MD
NTE|0|L|
OBX|4|NM|14927-8^Triglycerides^LN||100|mg/dL|< 149||||F|||||^DOE^JOHN|||||||AccuLabs^^^^^CLIA^^^^10D987432|432 Administration Ave.^^St. Louis^MO^63146|^Smith^John^^^Dr.^MD
NTE|0|L|


Human readable text for the above result file


image


Sample Result file from NIST  - File 1


MSH|^~\&|^NISTLabs^L-CL^|^NIST^L-CL|^^|^^|20100407121000||ORU^R01^ORU_R01|20100407121000|P|2.5.1|0001||AL||||MT-ORU-2_R1 
PID|1|9999|PT20^^^^AN||Grayson^Jim^^^^^L||19430309|M|||834 Ocean Vista Avenue^Apt. 202^Santa Coloradonica^CA^90401||3105552233
ORC|RE|||ORD003-1^EHR-System
OBR|1|ORD003-1^EHR-System|LAB003^^NIST^L-CL|087-0714^Comprehensive Metabolic Panel^99Lab^80061^Comprehensive Metabolic Panel^C4|||20100407151000||||L||||Arterial catheter|000100^Butler^Internist^E^^Dr^MD^^^^^^EI||||RO||20100407121000||CH|F
OBX|1|NM|13457-7^Fasting Blood Glucose^LN||178|mg/dl|70-100 mg/dl|H|||F|||20100407121000||^DOE^JOHN|||||||Milton Street Laboratory^^^^^CLIA^^^^10D987432|40025 Milton Street^^Aurora^Colorado^80011|^Smith^John^^^Dr.^MD
SPM||||^Arterial catheter||||||||||||||||||||HEM^Hemolyzed|
OBX|2|NM|14682-9^Creatinine^LN||1.0|mg/dL|0.5-1.4||||F|||||^DOE^JOHN|||||||Milton Street Laboratory^^^^^CLIA^^^^10D987432|40025 Milton Street^^Aurora^Colorado^80011|^Smith^John^^^Dr.^MD
SPM||||^Arterial catheter||||||||||||||||||||HEM^Hemolyzed|
OBX|3|NM|14647-2^BUN^LN||18|mg/dL|7-30||||F|||||^DOE^JOHN|||||||Milton Street Laboratory^^^^^CLIA^^^^10D987432|40025 Milton Street^^Aurora^Colorado^80011|^Smith^John^^^Dr.^MD
SPM||||^Arterial catheter||||||||||||||||||||HEM^Hemolyzed|


Sample Result file from NIST - File 2


MSH|^~\&|^NISTLabs^L-CL^|^NIST^L-CL|^^|^^|20100407121000||ORU^R01^ORU_R01|20100407121000|P|2.5.1|0001||AL||||MT-ORU-2_R1 
PID|1|8888|PT21^^^^AN||Mark^Peter^^^^^L||19430309|M|||834 Ocean Vista Avenue^Apt. 202^Santa Coloradonica^CA^90401||3105552233
ORC|RE|||ORD003-1^EHR-System
OBR|1|1^EHR-System|LAB003^^NIST^L-CL|087-0714^Electrolyte panel^99Lab^80061^Electrolyte panel^C4|||20100407151000||||L|||||2^Robinson^William^E^^Dr^MD^^^^^^EI||||RO||20100407121000||CH|F
OBX|1|NM|2951-2^Serum Sodium^LN||141|meq/l|135-146||||F|||20100407121000||^DOE^JOHN|||||||Oakton Crest Laboratories^^^^^CLIA^^^^10D987432|5570 Eden Street^^Oakland^California^94607|^Smith^John^^^Dr.^MD
OBX|2|NM|2823-3^Serum Potassium^LN||4.3|meq/l|3.5-5.3||||F|||20100407121000||^DOE^JOHN|||||||Oakton Crest Laboratories^^^^^CLIA^^^^10D987432|5570 Eden Street^^Oakland^California^94607|^Smith^John^^^Dr.^MD



 


Sample Result file from NIST - File 3


MSH|^~\&|^NISTLabs^L-CL^|^NIST^L-CL|^^|^^|20100407121000||ORU^R01^ORU_R01|20100407121000|P|2.5.1|0001||AL||||MT-ORU-2_R1 
PID|1|7777|PT22^^^^AN||Daniel^Scott^^^^^L||19430309|M|||834 Ocean Vista Avenue^Apt. 202^Santa Coloradonica^CA^90401||3105552233
ORC|RE|||ORD003-1^EHR-System
OBR|1|1^EHR-System|LAB003^^NIST^L-CL|087-0714^Lipid profile^99Lab^80061^Lipid profile^C4|||20100407151000||||L|||||2^Robinson^William^E^^Dr^MD^^^^^^EI||||RO||20100407121000||CH|F
OBX|1|NM|14438-6^Total cholesterol^LN||162|mg/dl|<200||||F|||20100407121000||^DOE^JOHN|||||||Aloha Laboratories^^^^^CLIA^^^^10D987432|575 Luau Street^^Honolulu^Hawaii^96813|^Smith^John^^^Dr.^MD
SPM||||||||||||||||||||||||HEM^Hemolyzed|
OBX|2|NM|48090-5^HDL cholesterol^LN||43|mg/dl|>=40|H|||F|||20100407121000||^DOE^JOHN|||||||Aloha Laboratories^^^^^CLIA^^^^10D987432|575 Luau Street^^Honolulu^Hawaii^96813|^Smith^John^^^Dr.^MD
SPM||||||||||||||||||||||||HEM^Hemolyzed|
OBX|3|NM|55440-2^LDL cholesterol^LN||84|mg/dl|<100||||F|||20100407121000||^DOE^JOHN|||||||Aloha Laboratories^^^^^CLIA^^^^10D987432|575 Luau Street^^Honolulu^Hawaii^96813|^Smith^John^^^Dr.^MD
SPM||||||||||||||||||||||||HEM^Hemolyzed|
OBX|4|NM|14445-1^Triglycerides^LN||127|mg/dl|<150||||F|||20100407121000||^DOE^JOHN|||||||Aloha Laboratories^^^^^CLIA^^^^10D987432|575 Luau Street^^Honolulu^Hawaii^96813|^Smith^John^^^Dr.^MD
SPM||||||||||||||||||||||||HEM^Hemolyzed|

3 comments:

  1. We are Laboratory Compliance Consultants which help you identify the right strategy and goals for your clinical laboratories specific needs.CLIA

    ReplyDelete
  2. can you post source read and write file *.hl7. i need you help. thanks you!

    ReplyDelete
  3. Hello Senthil Sir

    If the Above Sample HL7 files dumped into SQL Server table in single column then how can we populate or if it is single text file, then how to read in Through TSQL query to get all columns from that file

    ReplyDelete