V_EHI_AUDIT_ETR

Description:

This view contains one row for each audited item changed on a transaction record that corresponds to a column that is configured for EHI export.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2
CHANGED_DATA_ELEMENT	3

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction 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	CHANGE_USER_ID	VARCHAR	No
	Stores the user ID of the person who performed edit operations.
4	CHANGE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	CHANGE_UTC_DTTM	DATETIME (UTC)	No
	Instant of change for the transaction history.
6	ITEM_CHANGE_LINE	NUMERIC	No
	The transaction line that was changed from transaction edit.
7	OLD_VALUE_INTERNAL	VARCHAR	No
	The edited items previous value.
8	OLD_VALUE_EXTERNAL	VARCHAR	No
	The edited items previous value, in an external format. This column shows the translated external value as of when the column was last extracted.
9	NEW_VALUE_INTERNAL	VARCHAR	No
	The edited items new value.
10	NEW_VALUE_EXTERNAL	VARCHAR	No
	The edited items new value, in an external format. This column shows the translated external value as of when the column was last extracted.
11	CHANGED_DATA_ELEMENT	VARCHAR	No
	The column descriptor that contains the metadata to be associated with data stored in columns OLD_VALUE_INTERNAL and NEW_VALUE_INTERNAL.