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.