V_EHI_CVG_VERIF_HX_FILTER_PAT

Description:

EHI Filter view for audit trail of historical (i.e. old data model) coverage verification changes on a coverage record.

Primary Key

Column Name	Ordinal Position
CVG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CVG_ID	NUMERIC	No
	The ID of the coverage (CVG) 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	VERF_HX_PRV_STAT_C_NAME	VARCHAR	No
	When the verification status is changed, this column contains the old status. May contain organization-specific values: Yes
4	VERF_HX_NEW_STAT_C_NAME	VARCHAR	No
	When the verification status is changed, this column contains the new status. The category values for this column were already listed for column: VERF_HX_PRV_STAT_C_NAME
5	VERF_HX_USER_ID	VARCHAR	No
	When the verification status is changed, this column contains the user who caused the change.
6	VERF_HX_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	VERF_HX_CHANGE_DT	DATETIME	No
	When the verification status is changed, this column contains the date of the change
8	VERF_HX_NXT_RVW_DT	DATETIME	No
	When the verification status is changed, this column contains the calculated next review date.
9	VERF_HX_MEM_PAT_ID	VARCHAR	No
	When the verification status is changed at the member level, this column contains the member's patient ID.
10	CVG_PAT_EHI_IDENT	VARCHAR	No
	Semi-colon delimited list of CVG ID, LINE, and EPT_ID. This combination is used to determine how the data should be filterd for EHI exports. A non-null EPT ID means that only that patient should get the data, and a null EPT ID means that all patients on the coverage should get the data.