ORDER_RXVER_NOADSN

Description: |
The ORDER_RXVER_NOADSN contains medication order verification information that has one value per order.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_MED_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_MED_ID | NUMERIC | No |
The unique ID of the medication order (prescription) record. NOTE: This is an internal unique identifier for ORD master file records in this table and cannot be used to link to CLARITY_MEDICATION.
2 | RX_DC_VRFY_USER_ID | VARCHAR | No |
The user ID who verifies discontinued order.
3 | RX_DC_VRFY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
4 | RX_DC_VRFY_INSTANT | DATETIME (Local) | No |
The date and time the discontinued order was verified in calendar format.
5 | LAST_VERIFY_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. This is the most recent verification contact for an order. This column is frequently used to link to the CONTACT_DATE_REAL column of the ORDER_DISP_INFO table.
6 | MEDICATION_ACCESS_STS_C_NAME | VARCHAR | No |
This item holds the status of med access for the order.
May contain organization-specific values: No
Category Entries:
Not Needed
In Progress
Released
7 | MEDAC_REL_RSN_C_NAME | VARCHAR | No |
If an order was released from medication access in the bulk release workflow, this item will document the reason.
May contain organization-specific values: Yes
No Entries Defined