Order List Import Tool

This wiki page is to document how Order list items (Compendium of tests) data needs to be constructed in order to import using WebChart’s Order List Import Tool.

  • File format: Data file shall be formatted in Comma Separated Values (CSV).
  • The first row of the file shall contain column header information.
  • Each subsequent row shall represent an order item.
  • The Order Type is specified on the upload file form. Each item in the list will be imported with the specified type.

Column Definition

The order list column definition shall contain all columns listed below regardless if their is a value or not.

  • R = Required
  • O = Optional
NameTypeRequiredComments
Order namechar 2^24 (16MB)RThis is the short form name or mneumonic of the order item
Order detail descriptionchar 2^24 (16MB)ODetailed description of the order item
Order codechar 30RUnique order code for this order item
LOINC codechar 50OLOINC code
CPT codechar 30OCPT code
Collection instructionschar 2^24 (16MB)OSpecial instructions for at the time of collection
Patient instructionschar 2^24 (16MB)OInstructions for the patient prior to collection
Force separate orderchar 1OIf (Y)es, force a separate order to be placed, If (N)o, all this item to be grouped with other order items in a single order

Examples of CSV

Order List Example

This example shows how to import multiple order items into the complete order list.

  
  
Order name,Order detail description,Order code,LOINC code,CPT code,Collection instructions,Patient instructions,Force separate order  
CPSA,Complexed PSA (cPSA),LAB5725,33667-7,84153,"Container: Purple top tube, Storage: Room temperature",Patient fasting not required,N  
BILTO,Bilirubin Total,LAB5017,1975-2,82247,SST,,N  
CREAT,Creatinine,LAB5023,,82565,SST,,N  
GLU,Glucose,LAB5062,14749-6,82947,SST,,N  
BSS,"Occult Blood Screening, Stool",LAB5093,,82270,Non sterile container,,N  
  

  
  

Sample CSV files

Here is a sample CSV file to download and view in a text editor or a spreadsheet program. File:Order list.csv


WebChart Documentation

Page Created:
Last Updated:
Last Build: Mon, 14 Nov 2022 01:22:36 EST
WikiGDrive Version: 64fa77a2dd4586094b6074a78ed6769886b60894