CVG_MEM_RISK_ADJ_FACT_HX

Description:

The historical values of the CVG_MEM_RISK_ADJ_FACT table over time.

Primary Key

Column Name	Ordinal Position
CVG_ID	1
LINE	2
CVG_ITM_HX_REL_ACT_GUID	3

Column Information

	Name	Type	Discontinued?
1	CVG_ID	NUMERIC	No
	The unique identifier for the coverage record.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this record.
3	PAT_ID	VARCHAR	No
	The member that the risk adjustment factor applies to.
4	EFF_DATE	DATETIME	No
	The effective date of the risk adjustment factor.
5	TERM_DATE	DATETIME	No
	The termination date of the risk adjustment factor.
6	RISK_ADJ_FACT_MODEL_C_NAME	VARCHAR	No
	The model of the risk adjustment factor. May contain organization-specific values: Yes Category Entries: CMS-HCC Part C CMS-HCC Part D CMS-HCC Part A CMS-HCC Part B
7	RISK_ADJ_FACT_TYPE_C_NAME	VARCHAR	No
	The type of the risk adjustment factor. May contain organization-specific values: Yes Category Entries: Community Community Post Graft 4-9 (ESRD) Community Post Graft 10+ (ESRD) Community Full Dual Community Partial Dual Community Non-Dual Dialysis (ESRD) New Enrollee New Enrollee Dialysis (ESRD) New Enrollee Post Graft 4-9 (ESRD) New Enrollee Post Graft 10+ (ESRD) Graft I (ESRD) Graft II (ESRD) Institutional Institutional Post Graft 4-9 (ESRD) Institutional Post Graft 10+ (ESRD) New Enrollee Chronic Care SNP PACE Dialysis Factor PACE New Enrollee Dialysis Factor PACE Community Post Graft 4-9 PACE Institutional Post Graft 4-9 PACE New Enrollee Post Graft 4-9 PACE Community Post Graft 10+ PACE Institutional Post Graft 10+ PACE New Enrollee Post Graft 10+ PACE Community Full Dual PACE Community Partial Dual PACE Community Non-Dual PACE Graft I PACE Graft II Community Post Graft 4-9 (ESRD) Full Dual Community Post Graft 4-9 (ESRD) Partial Dual Community Post Graft 4-9 (ESRD) Non-Dual Community Post Graft 10+ (ESRD) Full Dual Community Post Graft 10+ (ESRD) Partial Dual Community Post Graft 10+ (ESRD) Non-Dual Dialysis (ESRD) Full Dual Dialysis (ESRD) Partial Dual or Non-dual Institutional Dialysis (ESRD) Full Dual Institutional Dialysis (ESRD) Partial or Non-Dual Institutional Post Graft 4-9 (ESRD) Full Dual Institutional Post Graft 4-9 (ESRD) Partial Dual Institutional Post Graft 4-9 (ESRD) Non-Dual Institutional Post Graft 10+ (ESRD) Full Dual Institutional Post Graft 10+ (ESRD) Partial Dual Institutional Post Graft 10+ (ESRD) Non-Dual Community Non-Low Income Continuing Enrollee Community Low Income Continuing Enrollee Institutional Continuing Enrollee New Enrollee Community Non-Low Income Non-ESRD New Enrollee Community Non-Low Income New Enrollee Community Low Income Non-ESRD New Enrollee Community Low Income ESRD New Enrollee Institutional Non-ESRD New Enrollee Institutional ESRD PACE New Enrollee Community Low Income Non-ESRD PACE New Enrollee Community Non-Low Income Non-ESRD PACE New Enrollee Institutional Non-ESRD PACE New Enrollee Institutional ESRD PACE New Enrollee Community Low Income ESRD PACE New Enrollee Community Non-Low Income ESRD PACE Community Non-Low Income Continuing Enrollee PACE Community Low Income Continuing Enrollee PACE Institutional Continuing Enrollee
8	RSK_ADJ_FACTOR	NUMERIC	No
	The risk adjustment factor.
9	ITM_HX_START_LOCAL_DTTM	DATETIME (Local)	No
	The start instant of when the coverage/line combination is valid in local time.
10	ITM_HX_START_UTC_DTTM	DATETIME (UTC)	No
	The start instant of when the coverage/line combination is valid in UTC.
11	ITM_HX_END_LOCAL_DTTM	DATETIME (Local)	No
	The end instant of when the coverage/line combination is valid in local time.
12	ITM_HX_END_UTC_DTTM	DATETIME (UTC)	No
	The end instant of when the coverage/line combination is valid in UTC.
13	CVG_ITM_HX_REL_ACT_GUID	VARCHAR	No
	This ID links this audit batch to one or more actions in the coverage action history table.