CVG_MEM_PROGRAM_WAIVER_HX

Description:

This table stores the history of the program waivers recorded for members on a coverage. Each row represents a period of time during which one program waiver line on a coverage was valid, capturing that waiver's values as they were during that period. When a program waiver is added, changed, or removed, new rows are written so you can reconstruct what the program waiver information looked like at any point in time. Use the ITM_HX_START and ITM_HX_END columns to determine the date range each row was in effect.

Primary Key

Column Name	Ordinal Position
COVERAGE_ID	1
LINE	2
CVG_ITM_HX_REL_ACT_GUID	3

Column Information

	Name	Type	Discontinued?
1	COVERAGE_ID	NUMERIC	No
	The unique ID of the coverage record whose program waiver history is captured in this row. This column is frequently used to link to the COVERAGE table.
2	LINE	INTEGER	No
	The line number of the program waiver on the coverage record. Multiple program waivers can be associated with a single coverage, and each is stored on its own line.
3	WAIVER_PAT_ID	VARCHAR	No
	The unique ID of the member to whom this program waiver applies. This column is frequently used to link to the PATIENT table.
4	WAIVER_EFF_DATE	DATETIME	No
	The effective date of the program waiver.
5	WAIVER_TERM_DATE	DATETIME	No
	The termination date of the program waiver.
6	WAIVER_TYPE_C_NAME	NUMERIC	No
	The waiver type category ID for the program waiver. May contain organization-specific values: Yes No Entries Defined
7	WAIVER_PHONE	VARCHAR	No
	The contact phone number recorded for the program waiver.
8	WAIVER_EPISODE_ID	NUMERIC	No
	The unique ID of the care episode associated with the program waiver.
9	ITM_HX_START_LOCAL_DTTM	DATETIME (Local)	No
	The date and time when the values in this row became valid, in local time. Use this with ITM_HX_END_LOCAL_DTTM to find the period this row was in effect.
10	ITM_HX_START_UTC_DTTM	DATETIME (UTC)	No
	The date and time when the values in this row became valid, in UTC.
11	ITM_HX_END_LOCAL_DTTM	DATETIME (Local)	No
	The date and time when the values in this row stopped being valid, in local time. A null value indicates this row reflects the current values.
12	ITM_HX_END_UTC_DTTM	DATETIME (UTC)	No
	The date and time when the values in this row stopped being valid, in UTC. A null value indicates this row reflects the current values.
13	CVG_ITM_HX_REL_ACT_GUID	VARCHAR	No
	A unique identifier that links this history row to one or more related actions in the coverage action history. Use this column to join to the coverage action history table.