V_EHI_AUDIT_HTR

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

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	This column stores the unique identifier for the hospital billing transaction.
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
	This item stores the user who changed the hospital temporary transaction items while the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
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
	This item stores the instant of data change on a hospital temporary transaction when a hospital billing transaction is in its temporary state.
6	ITEM_CHANGE_LINE	INTEGER	No
	This item stores on which item line a hospital temporary transaction item changes. It is only set for multiple response item value changes. It is part of the hospital billing transaction audit history.
7	OLD_VALUE_INTERNAL	VARCHAR	No
	This item stores the previous value of the changed hospital temporary transaction item when the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
8	OLD_VALUE_EXTERNAL	VARCHAR	No
	This item stores the previous value, in an external format, of the changed hospital temporary transaction item when the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
9	NEW_VALUE_INTERNAL	VARCHAR	No
	This item stores the new value of the changed hospital temporary transaction item when a hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
10	NEW_VALUE_EXTERNAL	VARCHAR	No
	This item stores the new value, in an external format, of the changed hospital temporary transaction item when the hospital billing transaction is in its temporary state. It is part of the hospital billing transaction audit history.
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.