Observation Import

This wiki page is to document how observation data needs to be constructed in order to import using WebChart’s Observation data Import Tool.

  • File format: Data file shall be formated in Comma Separated Values (CSV).
  • The first row of the file shall contain column header information.
  • Each subsequent row shall represent an observation.

Column Definition

The lab result column definition shall contain all columns listed below regardless if there is a value or not.

  • R = Required
  • O = Optional
NameTypeRequiredComments
Patient IDchar 255RPatient identifier, usually an MRN
Patient Lastnamechar 100OLast name of the patient
Patient Firstnamechar 100OFirst name of the patient
Patient Classchar 1OI=Inpatient, O=Outpatient
Observation DatetimedatetimeRDate the observation took place (YYYYMMDD)
Observation Codeint 10OIdentifier of the specific observation
Observation Namechar 255RName of the specific observation
Observation Orderint 5ONumeric value to indicate the order of the observations
Observation Resultchar 64kRResult value of the observation
Observation Rangechar 30ORange for the observation
Observation Unitschar 20OUnits that the observation result is in
Observation Flagchar 10OFlag to determine N=Normal/A=Abnormal
Observation Statuschar 20OStatus of the observation, F=final, P=preliminary
Observer Codeint 10OCode to ID the person doing the observation
Commentchar 64kOComment on the observation result
Performing Labchar 30RName of lab where results took place
Encounter Ext IDchar 100OExternal identifier of encounter this obs is linked to
Encounter Interfacechar 100OInterface value used when that encounter was imported

Name Validation

If the patient’s first or last name is given, then it will be compared to the name of the patient in the database.

Examples of CSV

Please note that because of the width of a csv file, the lines have been split up for ease of reading here. A real CSV file will need to be contained in one line per record.

1 Observation

This example shows how to import 1 observation for 1 patient.

  
  
Patient ID,Patient Lastname,Patient Firstname,Patient Class,Observation Datetime,Observation Code,Observation Name,  
U111111,Doe,John,I,20110705,25,Systolic BP,  
  

  
  
  
  
  
  
Observation Order,Observation Result,Observation Range,Observation Units,  
1,100,,mmhg,  
  

  
  
  
  
  
  
Observation Flag,Observation Status,Observer Code,Comment,Performing Lab  
,F,,Result looks good,Quest  
  

  
  

2 Observations, same patient

This example shows how to import 2 observations for the same patient.

  
  
Patient ID,Patient Lastname,Patient Firstname,Patient Class,Observation Datetime,Observation Code,Observation Name,  
U111111,Doe,John,I,20110705,25,Systolic BP,  
U111111,Doe,John,I,20110705,26,Diastolic BP,  
  

  
  
  
  
  
  
Observation Order,Observation Result,Observation Range,Observation Units,  
1,100,,mmhg,  
2,70,,mmhg,  
  

  
  
  
  
  
  
Observation Flag,Observation Status,Observer Code,Comment,Performing Lab  
,F,,Results look good,Quest  
,F,,Results look good,Quest  
  

  
  

2 Observations for 2 different patients

This example shows how to import 2 lab orders with 2 observation results each.

  
  
Patient ID,Patient Lastname,Patient Firstname,Patient Class,Observation Datetime,Observation Code,Observation Name,  
U111111,Doe,John,I,20110705,25,Systolic BP,  
U111111,Doe,John,I,20110705,26,Diastolic BP,  
U222222,Doe,Jane,I,20110705,30,URO,  
U222222,Doe,Jane,I,20110705,31,BLD,  
  

  
  
  
  
  
  
Observation Order,Observation Result,Observation Range,Observation Units,  
1,100,,mmhg,  
2,70,,mmhg,  
1,Normal,,mg/dl,  
2,neg,,,  
  

  
  
  
  
  
  
Observation Flag,Observation Status,Observer Code,Comment,Performing Lab  
,F,,Test results are good,Labcorp  
,F,,Test results are good,Labcorp  
,F,,Test results are good,Labcorp  
,F,,Test results are good,Labcorp  
  

  
  

Sample CSV files

Here are sample CSV files to download and view in a text editor or a spreadsheet program. 1 Observation - File:Obsimportsample1.csv 2 Observations, same patient - File:Obsimportsample2.csv 2 Observations for 2 different patients - File:Obsimportsample3.csv


WebChart Documentation

Page Created:
Last Updated:
Last Build: Sat, 21 Jan 2023 11:44:06 EST
WikiGDrive Version: 6c6f21d9d0a63cb86fd32dec4cec30d4b470cbf5