V_EHI_AUDIT_CLP

Description:

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

Primary Key

Column Name	Ordinal Position
CLAIM_PRINT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_PRINT_ID	NUMERIC	No
	The unique identifier for the claim print record.
2	LINE	INTEGER	No
	The line number of one of the multiple values associated with a specific group of data within 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 (Local)	No
	Stores the date/time instance when the claim was edited.
6	ITEM_CHANGE_CUR_LN	INTEGER	No
	Stores the current line number.
7	ITEM_CHANGE_PREV_LN	INTEGER	No
	Stores the previous line number.
8	OLD_VALUE_INTERNAL	VARCHAR	No
	Stores the old data value that was edited.
9	OLD_VALUE_EXTERNAL	VARCHAR	No
	Stores the old data value, in an external format, that was edited.
10	NEW_VALUE_INTERNAL	VARCHAR	No
	Stores the new data value that was added to the claim.
11	NEW_VALUE_EXTERNAL	VARCHAR	No
	Stores the new data value, in an external format, that was edited.
12	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.