V_EHI_ORD_ITM_AUDIT_TRL

Description:

This view contains an audit history of several Orders items, along with human-readable versions of the old and new values and references to Clarity columns that extract those items.

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	OLD_VALUE_INTERNAL	VARCHAR	No
	Contains the old value for the item that was changed.
4	NEW_VALUE_INTERNAL	VARCHAR	No
	Contains the new value for the item that was changed.
5	OLD_VALUE_EXTERNAL	VARCHAR	No
	Contains the old value for the item that was changed, in external format. This column shows the translated external value as of when the column was last extracted.
6	NEW_VALUE_EXTERNAL	VARCHAR	No
	Contains the new value for the item that was changed, in external format. This column shows the translated external value as of when the column was last extracted.
7	ITEM_CHNG_USER_ID	VARCHAR	No
	Contains the ID of the user who changed the item.
8	ITEM_CHNG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	ITEM_CHANGE_DTTM	DATETIME (Local)	No
	Contains the instant the item was changed.
10	CHANGED_DATA_ELEMENT	VARCHAR	No
	The table and column descriptor associated with the item in the ITEM column.
11	ITEM	VARCHAR	No
	The item number for the item that was changed.