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).