Lab Result CSV API

This page outlines how lab result data is formatted for import using WebChart’s Lab Result Data Import tool.

Audience

The abstract that follows should be presented to decision-makers or stakeholders interested in a general explanation of the XYZ API. Technical details are provided in the remaining sections.

Abstract

The Lab Results CSV API imports data related to lab data. CSV refers to the type of file and format of data needed to import information into an EH system. API refers to how the data interacts with the EH system. See the Import Overview  page for a more detailed explanation of terminology.
Lab results are stored in a chart as a document. A document in an EH system is used to record and store many forms data. HL7 messages send all of the information used to create a lab document. The common order segment (ORC) message with visit information (DOS) creates the document in the EH database. The observation request (OBR) message includes the order number and panel or test name to create the lab request. The observation segment (OBX) transmits the observed date, results, units, and range to create the observation. Revisions are stored as well as the date/time the results were received.
All lab results are stored both as discrete data. Discrete data can be displayed in EH as a **flowsheet,**or collection of results.

Specifications

The following detailed specifications are available for the Lab Result CSV API:

• Lab Result CSV API specifications
  • Note: The specification may be downloaded as Excel, CSV, or duplicated as an online spreadsheet under the File menu.
  • User instructions for importing data .

Column Definitions and Specific Coded Values

Definitions for the columns utilized in the specification, as well as commonly used specific coded values appear on the Data Import Standards  page.

Examples

The following examples are available in CSV format:

• 1 Lab with 1 result - File:Labimportsample2.csv
• 1 Lab with 2 results - File:Labimportsample3.csv
• 2 Labs with 2 results each - File:Labimportsample4.csv
• 3 Labs with 2 results each - File:Labimportsample5.csv

Related Pages

• Data Import Master List