V_EHI_AUDIT_CVG_MEM_3

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: 31810. 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	OLD_VALUE_EXTERNAL	VARCHAR	No
	The value before the change, in external format. This column shows the translated external value as of when the column was last extracted.
7	NEW_VALUE_INTERNAL	VARCHAR	No
	The value after the change, in internal format.
8	OLD_VALUE_INTERNAL	VARCHAR	No
	The value before the change, in internal format.
9	CHANGED_DATA_ELEMENT	VARCHAR	No
	The name of the Clarity table and column corresponding to the changed data.
10	ITEM	VARCHAR	No
	The item number for the information that was changed.
11	USER_ID	VARCHAR	No
	The ID of the user that made the change.
12	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.