V_EHI_AUDIT_CVG_MEM_2

Description:

This view contains audit information for coverage records for the purpose of EHI export. This view only contains data for items that correspond to a specific member on the coverage. This member-specific data is split across multiple views. This specific view contains data for the following related groups: 9510, 18160, 18400, 18971, 19100, 19120, and 19400. Note that no data from this view will be included in the export if a date is not set in I EAF 995 - COVERAGE AUDIT TRAIL EXPORT CUTOFF DATE.

Primary Key

Column Name	Ordinal Position
COVERAGE_ID	1
CHANGE_TIME	2
CHANGED_DATA_ELEMENT	3
LINE	4

Column Information

	Name	Type	Discontinued?
1	COVERAGE_ID	NUMERIC	No
	The ID of the coverage record that was changed.
2	PAT_ID	VARCHAR	No
	The ID of the patient associated with this coverage.
3	CHANGE_TIME	DATETIME (Local)	No
	The time the information in the record was changed.
4	LINE	INTEGER	No
	A value needed when the item that changed was multiple response.
5	NEW_VALUE_EXTERNAL	VARCHAR	No
	The value after the change, in external format. This column shows the translated external value as of when the column was last extracted.
6	NEW_VALUE_INTERNAL	VARCHAR	No
	The value after the change, in internal format.
7	OLD_VALUE_INTERNAL	VARCHAR	No
	The value before the change, in internal format.
8	CHANGED_DATA_ELEMENT	VARCHAR	No
	The name of the Clarity table and column corresponding to the changed data.
9	ITEM	VARCHAR	No
	The item number for the information that was changed.
10	USER_ID	VARCHAR	No
	The ID of the user that made the change.
11	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.