Filetype Excel XLS | Posted on 22 Jun 2022 | 3 years ago
Authentication
digital resources
239x Filetype XLS File size 0.06 MB Source: 38.111.163.21
Sheet 1: ReadMe
| NOTE: | This CSV schema must be used in order to transmit COVID laboratory results electronically. The data fields must appear in the designated order using a comma as the delimiter. No other commas may be used in the file. Any data result in the Mapping tab in the Optionality data field marked as R is required and must be populated. All other data fields are listed as RE, required but can be sent empty. Please NOTE: Message Control ID field is a required field and MUST be globally unique for every single row of data per sending laboratory CLIA. Messages will fail if this field is not globally unique. Additional updates will be made to this schema to accommodate HHS required data fields. | |||||||||||
| Last Updated: | 7/20/2020 | |||||||||||
| HL7 Component | CSV Field Name | Optionality | Comments |
| MSH-4 | Sending Laboratory CLIA | R | CLIA number of laboratory sending CSV file |
| MSH-7 | Message Date | R | Date of Message being sent (YYYYMMDD) |
| MSH-10 | Message Control ID | R | Must be globally unqiue per MSH-4 |
| PID-3.1 | Patient Identifier | RE | Medical Record Number or Patient Account Number, Social Security Number, etc. |
| PID-3.5 | Patient Identifier Type | RE | MR, SS, XX, etc. |
| PID-5.1 | Patient Last Name | R | No numeric values accepted |
| PID-5.2 | Patient First Name | R | No numeric values accepted |
| PID-8 | Patient Sex | R | Accepted values include (M, F, U, H, O, T) |
| PID-7 | Patient Date of Birth | R | Use following format: YYYYMMDD |
| PID-10 | Patient Race | RE | May use HL7 codes or text values (e.g. White, Black, Other, Asian, Unknown) |
| PID-11.1 | Patient Address Street 1 | RE | |
| PID-11.2 | Patient Address Street 2 | RE | |
| PID-11.3 | Patient Address City | RE | |
| PID-11.4 | Patient Address State | RE | Use OH |
| PID-11.5 | Patient Address Zip | RE | 5-digit zip is sufficient |
| PID-13 | Patient Phone Number | RE | Use following format: 6145551212 |
| PID-22 | Patient Ethnicity | RE | Standard format |
| ORC-21 | Ordering Facility Name | RE | |
| ORC-22.1 | Ordering Facility Address Street 1 | RE | |
| ORC-22.2 | Ordering Facility Address Street 2 | RE | |
| ORC-22.3 | Ordering Facility Address City | RE | |
| ORC-22.4 | Ordering Facility Address State | RE | Use OH |
| ORC-22.5 | Ordering Facility Address Zip | RE | 5-digit zip is sufficient |
| ORC-23 | Ordering Facility Phone | RE | Use following format: 6145551212 |
| ORC-24.1 | Ordering Provider Address Street 1 | RE | |
| ORC-24.2 | Ordering Provider Address Street 2 | RE | |
| ORC-24.3 | Ordering Provider Address City | RE | |
| ORC-24.4 | Ordering Provider Address State | RE | Use OH |
| ORC-24.5 | Ordering Provider Address Zip | RE | 5-digit zip is sufficient |
| OBR-4 | Test Order Code | R | May send LOINC code (e.g. 94500-6) or local test code description (e.g. NOVEL CORONAVIRUS PCR) |
| OBR-16.2 | Ordering Provider Last Name | RE | |
| ORB-16.3 | Ordering Provider First Name | RE | |
| OBR-17 | Ordering Provider Phone | RE | Use following format: 6145551212 |
| OBR-25 | Order Status | RE | Accepted values include P or F or C |
| OBX-2 | Result Code Type | RE | Accepted values include L or SCT |
| OBX-3 | Test Code | R | May send LOINC code, preferred, (e.g. 94500-6) or local test code description (e.g. NOVEL CORONAVIRUS PCR) |
| OBX-5 | Result Code | R | May send SNOMED code, preferred, (e.g. 260373001) or local result code description (e.g. Detected) |
| OBX-6 | Result Units | RE | |
| OBX-7 | Reference Range | RE | Examples include (Negative, Not Detected, etc.) |
| OBX-8 | Abnormal Flag | RE | May send HL7 codes (e.g. A, AA, N, HH, etc. ) |
| OBX-11 | Test Result Status | R | Accepted values include P, F, and C |
| OBX-19 | Test Result Date | R | Use following format: YYYYMMDD |
| OBX-23.10 | Performing Lab CLIA | R | Use CLIA number (e.g. 36D0329129) |
| OBX-23.1 | Performing Lab Name | RE | |
| OBX-24.2 | Performing Lab Address | RE | |
| OBX-24.3 | Performing Lab Address City | RE | |
| OBX-24.4 | Performing Lab Address State | RE | Use OH |
| OBX-24.5 | Performing Lab Address Zip | RE | 5-digit zip is sufficient |
| SPM-2 | Specimen ID | R | Value must allow you laboratory to re-identify the patient |
| SPM-4 | Specimen Type | R | May send SNOMED code, preferred, (e.g. 258500001), or local specimen type description (e.g. Nasopharyngeal swab) |
| SPM-17 | Specimen Collect Date | R | Use following format: YYYYMMDD |
| Sending Laboratory CLIA | 34D0655059 |
| Message Date | ,20200516 |
| Message Control ID | ,20200515001-SH11 |
| PatientIdentifier | ,123456789 |
| Patient Identifier Type | ,SS |
| Patient Last Name | ,Duck |
| Patient First Name | ,Donald |
| PatientSex | ,M |
| Patient Date of Birth | ,19900101 |
| Patient Race | ,White |
| Patient Address Street 1 | ,246 N. High |
| Patient Address Street 2 | ,4th Floor |
| Patient Address City | ,Columbus |
| Patient Address State | ,OH |
| Patient Address Zip | ,43215 |
| Patient Phone Number | ,6145551212 |
| Patient Ethnicity | ,Non-hispanic |
| Ordering Facility Name | ,St Lukes Hospital |
| Ordering Facility Address Street 1 | ,5901 Monclova Rd |
| Ordering Facility Address Street 2 | ,4th Floor |
| Ordering Facility Address City | ,Maumee |
| Ordering Facility Address State | ,OH |
| Ordering Facility Address Zip | ,43537-1841 |
| Ordering Facility Phone | ,4198935911 |
| Ordering Provider Address Street 1 | ,ProviderMainSt |
| Ordering Provider Address Street 2 | ,ProviderAddress2 |
| Ordering Provider Address City | ,Canton |
| Ordering Provider Address State | ,OH |
| Ordering Provider Address Zip | ,44708-5463 |
| Test Order Code | ,NOVEL CORONAVIRUS PCR |
| Ordering Provider Last Name | ,Dumbledore |
| Ordering Provider First Name | ,Albus |
| Ordering Provider Phone | ,6145552323 |
| Order Status | ,F |
| Result Code Type | ,L |
| Test Code | ,94500-6 |
| Result Code | ,260373001 |
| Result Units | , |
| Reference Range | ,NOT DETECTED |
| Abnormal Flag | ,A |
| Test Result Status | ,F |
| Test Result Date | ,20200515 |
| Performing Lab CLIA | ,36D0350532 |
| Performing Lab Name | ,OSU WEXNER MEDICAL CENTER CLINICAL LABORATORY |
| Performing Lab Address | ,LabStreet |
| Performing Lab Address City | ,Columbus |
| Performing Lab Address State | ,OH |
| Performing Lab Address Zip | ,43202 |
| Specimen ID | ,F19935 |
| Specimen Type | ,NP SWAB |
| Specimen Collect Date | ,20200514 |
no reviews yet
Please Login to review.
