Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
LATIN_CODE | varchar(15) | not null | Latin Code(SIG) |
GEN_FREQ_IND | varchar(5) | null | General Frequency Indicator |
MAX_NUM_TOAS_PER_DAY | varchar(2) | null | Max Number of TOAS(Times of Administrations) Per Day |
DESCRIPTION | varchar(30) | null | Latin Code Description |
DAYS | varchar(17) | null | Days(ALL, UNSPECIFIED, or 2 digit comma separated days of week(MO,TU,WE,TH,FR,SA,SU)) |
SCHEDULED_PRN | varchar(9) | null | Scheduled or PRN(SCH or PRN) |
DAYS_ACTIVE | varchar(2) | null | Number of Days Active |
TAKEHOME_DIRECT1 | varchar(30) | null | Takehome Directions 1 |
TAKEHOME_DIRECT2 | varchar(30) | null | Takehome Directions 2 |
TAKEHOME_DIRECT3 | varchar(30) | null | Takehome Directions 3 |
TYPE_SIG | varchar(11) | null | SIG Type |
INTERVAL | varchar(6) | null | Interval. Value will be either Hours or Minutes, depending on the value of the INTERVAL_UNIT |
ADMIN_INTERVAL | varchar(4) | null | Admin Interval. Number of minutes between doses you can administer a medication. This number may not exceed 1440(the number of minutes in 1 day) |
INHOUSE_DIRECT1 | varchar(30) | null | Inhouse Directions 1 |
INHOUSE_DIRECT2 | varchar(30) | null | Inhouse Directions 2 |
INHOUSE_DIRECT3 | varchar(30) | null | Inhouse Directions 3 |
INHOUSE_DIRECT4 | varchar(30) | null | Inhouse Directions 4 |
INHOUSE_DIRECT5 | varchar(30) | null | Inhouse Directions 5 |
INHOUSE_DIRECT6 | varchar(30) | null | Inhouse Directions 6 |
TIMES | varchar(512) | null | Times of Admin(TOAS)(HH:MM,HH:MM,HH:MM,...) |
INTERVAL_UNIT | varchar(4) | null | Interval Unit(Minutes = Mins, Hours = Hrs) |
FIRST_OCC_WITHIN | varchar(4) | null | First Occurrence Within. Number of minutes from the time the order is entered that the first occurrence should occur. This number may not exceed 1440(the number of minutes in 24 hours). |
EARLY_ADMIN_WARNING | varchar(4) | null | Early Admin Warning. Number of minutes in the Past/Future you can chart an occurrence, after which a warning message will appear. |
EARLY_ADMIN_ERROR | varchar(4) | null | Early Admin Error. Number of minutes in the Past/Future you can chart an occurrence, after which an error message will appear. |
LATE_ADMIN_WARNING | varchar(4) | null | Late Admin Warning. Number of minutes in the Past/Future you can chart an occurrence, after which a warning message will appear. |
LATE_ADMIN_ERROR | varchar(4) | null | Late Admin Error. Number of minutes in the Past/Future you can chart an occurrence, after which an error message will appear. |
CPOE_MAX_NUM_DOSES | varchar(2) | null | CPOE(Computerized Physician Order Entry) Max Number of Doses |
|
|
|