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|

4 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
  4. We are a third party technical support service. Avast Customer Support is here to help you out with the whole procedure to Download Avast Antivirus online, We not only fix your Avast Support related issues but will guide with how to get started with your new Avast product once it gets installed successfully. Call on our Toll Free no. 1 855 966 3855
    Gmail Customer service is a third party technical support service for Gmail users when they face any technical issue or error in their Gmail account. Our Gmail Customer Support team solves issues like forgot Gmail account password, Gmail configuration or Sync issues, recover deleted emails and many more. Toll Free number (800) 986-9271
    How you install or reinstall Office 365 or Office 2016 depends on whether your Office product is part of an Office for home or Office for business plan. If you're not sure what you have, see what office com setup products are included in each plan and then follow the steps for your product. The steps below also apply if you're installing a single, stand-alone Office application such as Access 2016 or Visio 2016. Need Help with office setup Enter Product Key? Call 1-800-000-0000 Toll Free
    Norton Tech Support is a third party service provider and not in any way associated with Norton or any of its partner companies. We offer support for Norton products and sell subscription based additional warranty on computer and other peripheral devices. Call our Toll Free number 1 855 966 3855
    Other Services
    Norton Toll Free , Office-Setup , office.com/setup.

    ReplyDelete