V_EHI_AUDIT_ORD_RXITEMS

Description:

This table provides information on changes to specified no-add items in the order (ORD) master file formatted for the EHI export.

Primary Key

Column Name	Ordinal Position
ORDER_MED_ID	1
LINE	2
VALUE_LINE	3
CHANGED_DATA_ELEMENT	4

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	LINE	INTEGER	No
	The line number for each change.
3	VALUE_LINE	INTEGER	No
	A value is needed. For multiple response item, it is the line number for each real data or 0 for total count line. For single response item, it is 1.
4	AUDIT_LOCAL_DTTM	DATETIME (Local)	No
	The instant of change.
5	OLD_VALUE_INTERNAL	VARCHAR	No
	For audited items which store a networked record ID, this column will extract the CID of the linked record in OLD_VALUE. For other items this will extract the same value as OLD_VALUE.
6	NEW_VALUE_INTERNAL	VARCHAR	No
	For audited items which store a networked record ID, this column will extract the CID of the linked record in NEW_VALUE. For other items this will extract the same value as NEW_VALUE.
7	OLD_VALUE_EXTERNAL	VARCHAR	No
	The old value of the item in external format. Dates, categories, and networked items will display meaningful information instead of the internal value.
8	NEW_VALUE_EXTERNAL	VARCHAR	No
	The new value of the item in external format. Dates, categories, and networked items will display meaningful information instead of the internal value.
9	CHANGED_DATA_ELEMENT	VARCHAR	No
	The Clarity table and column which corresponds to the data which changed.
10	CHANGE_USER_ID	VARCHAR	No
	The unique user ID who made the change.
11	CHANGE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.