ORDER_DEFER_USERS

Description: |
This table contains information about users who have clicked the Defer Order button in Verification. The records included in this table are ORD records, and each line contains a user ID and instant.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | RX_DEFERRAL_USER_ID | VARCHAR | No |
Users who have deferred this order to a pharmacist for review. Will record each user who clicks the "Defer Order" button in Verification. Only relevant if Manual Defer in Verification is enabled (RXD 1270).
4 | RX_DEFERRAL_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | RX_DEFER_INST_DTTM | DATETIME (Local) | No |
Instants at which this order was deferred to a pharmacist for review. New values will be added each time a user clicks the "Defer Order" button in Verification. Only relevant if Manual Defer in Verification is enabled (RXD 1270).