Skip to content

Latest commit

 

History

History
105 lines (93 loc) · 2.95 KB

order-list-import-tool.md

File metadata and controls

105 lines (93 loc) · 2.95 KB
id title date version lastAuthor mimeType links source wikigdrive
1G40DAPnlx7F9X5xRDxMUVkRSk50Ec_5HEyUdvk7yK_I
Order List Import Tool
2024-01-25T13:02:09.403Z
88
auhrick
text/x-markdown
0008bcbb1563384efe0a28ada6f97e9432e65f10

This 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 there is a value or not.

  • R = Required
  • O = Optional
Name Type Required Comments
Order name char 2^24 (16MB) R This is the short form name or mneumonic of the order item
Order detail description char 2^24 (16MB) O Detailed description of the order item
Order code char 30 R Unique order code for this order item
LOINC code char 50 O LOINC code
Billing code char 30 O CPT code
Collection instructions char 2^24 (16MB) O Special instructions for at the time of collection
Patient instructions char 2^24 (16MB) O Instructions for the patient prior to collection
Force separate order char 1 O If (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.

{{% pre %}}


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

{{% /pre %}}

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