ORDER_MED_6
Description:
This table enables you to report on medications ordered. This table should be used with ORDER_MED.

Primary Key
Column Name Ordinal Position
ORDER_MED_ID 1

Column Information
Name Type Discontinued?
1 ORDER_MED_ID NUMERIC No
The unique identifier for the medication order record.
2 AUTH_SER_ADDRESS_ID VARCHAR No
The unique ID for the address of the order's authorizing provider. It is used to identify an address using the address unique ID (I SER 21000) stored in the provider record.
3 ORDER_SER_ADDR_ID VARCHAR No
The unique ID for the address of the order's ordering provider. It is used to identify an address using the address unique ID (I SER 21000) stored in the provider record.
4 SUP_SER_ADDRESS_ID VARCHAR No
The unique ID for the address of the order's supervising provider. It is used to identify an address using the address unique ID (I SER 21000) stored in the provider record.
5 TEMP_LONG_TERM_IN_C_NAME VARCHAR No
The category number for the temporary long-term indicator for unsigned orders.
May contain organization-specific values: No
Category Entries:
No
Yes in MDL
No in MDL
Yes Unsigned
No Unsigned
6 PRIORITIZED_INST_UTC_DTTM DATETIME (UTC) No
This item stores the prioritized instant (date and time) for an order in UTC time zone. It represents the most relevant date and time an action was taken on an order.
7 PRIORITIZED_INST_DTTM DATETIME (Local) No
This item stores the prioritized instant (date and time) for an order in local time zone. It represents the most relevant date and time an action was taken on an order.
8 NEXT_SCH_INST_AT_DISCON_DTTM DATETIME (Local) No
The next scheduled date and time for the order at the time of discontinue.
9 NEXT_SCH_AT_DISCON_OFF_SCH_YN VARCHAR No
Indicates whether the next scheduled time of the order at the time of discontinue is off-schedule. 'Y' indicates that the next scheduled time was off-schedule. 'N' or NULL indicate that the next scheduled time was not off-schedule.
May contain organization-specific values: No
Category Entries:
Yes
No
10 ORD_SIG_HAS_IOU_YN VARCHAR No
Indicates whether Indications of Use are present in the patient sig. 'Y' indicates Indications of Use are present in the patient sig. 'N' or NULL indicate that Indications of Use are not present in the patient sig.
The category values for this column were already listed for column: NEXT_SCH_AT_DISCON_OFF_SCH_YN
11 MED_DIRECTIONS_LONG VARCHAR No
Contains the directions for taking a medication order.
12 USER_CHANGED_END_TIME_YN VARCHAR No
Indicates whether the end time is entered by a user. This is only populated for unsigned medication orders. 'Y' indicates the end time is entered by a user. 'N' or NULL indicate that the end time is not entered by a user.
May contain organization-specific values: No
Category Entries:
No
Yes
13 ORIG_MED_DIRECTIONS_LONG VARCHAR No
Contains the original directions for taking a medication order.
14 NO_REIMBURS_CODESET VARCHAR No
Holds the code set of the selected reimbursement code.
15 STANDING_COUNT INTEGER No
This item stores a numeric value for the count of the order that goes along with the standing count type, indicating the number of hours, days, weeks, or occurrences for which the order will take place.
16 STANDING_COUNT_TP_C_NAME VARCHAR No
This count type goes along with the count from ORD-34040 to indicate the number of hours, days, weeks, or occurrences for which the order will take place.
May contain organization-specific values: No
Category Entries:
Days
Weeks
Hours
Occurrences
Months
Years
17 COUNT_RANGE VARCHAR No
This item stores a ranged value for the count of the order that goes along with the standing count type, indicating the number of hours, days, weeks, or occurrences for which the order will take place. Currently only available in Finland.
18 COUNT_RANGE_STND_TP_C_NAME VARCHAR No
This ranged count type goes along with the count from ORD-34042 to indicate the number of days, weeks, months, years, or occurrences for which the order will take place. Currently only available in Finland.
The category values for this column were already listed for column: STANDING_COUNT_TP_C_NAME
19 ORDER_START_TM DATETIME (Local) No
The time when the medication order is to start.
20 PROTOCOLLED_ORDER_ID NUMERIC No
For an order that was placed from an imaging protocol, this item contains the protocolled imaging procedure order from which the order was placed.