Order Question Import Tool

This wiki page is to document how Order Questions (AOE) data needs to be constructed in order to import using WebChart’s Order Questions 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 fee schedule.
  • The Order Type is specified on the upload file form. Each item in the list will be imported to the order item that matches with the specified type.

Column Definition

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

  • R = Required
  • O = Optional
Name Type Required Comments
Order code char 30 R The order code on which this question is to be asked when it is ordered.
Question code char 30 R Code that uniquely identifies the question.
Question char 200 R The Question to be asked.
Input Type 'T', 'Y', or 'R' R How the question is to be answered. The valid input types are (T)ext, (Y)esNo, and (R)adio button.
Answer List char 1024 O List of possible answers. Items must be separated by '|' (the bar/pipe character).
Asking display order int 3 O The order in which the questions are displayed.

Examples of CSV

Fee Schedule Example

This example shows how to import multiple order questions (AOE) into 1 order item with code ‘LAB5725’.

Order code,Question code,Question,Input Type,Answer List,Asking display order LAB5725,XN1,Type of Urine Collection,R,24 Hour|Random Specimen,1 LAB5725,XN2,Patient Fasting?,Y,,2 LAB5725,XN3,Source,T,,3

Sample CSV files

Here is a sample CSV file to download and view in a text editor or a spreadsheet program.

File:Order questions.csv

WebChart Documentation
Last Build: Wed, 08 Sep 2021 00:25:59 EDT Legacy Documentation