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.