COVERAGE_STATUS

Description:

This table stores information about the current coverage statuses of a coverage record.

Primary Key

Column Name	Ordinal Position
COVERAGE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COVERAGE_ID	NUMERIC	No
	The unique identifier for the coverage 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	COVERAGE_STATUS_TYPE_C_NAME	VARCHAR	No
	The coverage status type category ID for the coverage record. May contain organization-specific values: No Category Entries: Binder Payment Enrollment Geographic Area Verification Geographic Area Investigation
4	COVERAGE_STATUS_RESOLUTION_C_NAME	VARCHAR	No
	The coverage status resolution category ID for the coverage record. This column's associated ZC table is ZC_CVD_STAT_OUTST_ACT_RES. May contain organization-specific values: Yes Category Entries: Not Resolved Approved Denied Canceled Paid Failed To Pay Geographic Area Verification Passed Subscriber Gained Coverage Resolved Under Investigation Temporary Address In Geographic Area Out of Geographic Area
5	CREATION_UTC_DTTM	DATETIME (UTC)	No
	The UTC date and time when the coverage gained the coverage status.
6	RESOLUTION_UTC_DTTM	DATETIME (UTC)	No
	The UTC date and time when the resolution had its state for this coverage status set.
7	CREATION_DTTM	DATETIME (Local)	No
	The local date and time when the coverage gained the coverage status.
8	RESOLUTION_DTTM	DATETIME (Local)	No
	The local date and time when the coverage had its resolution for this coverage status set.
9	COVERAGE_STATE_CHANGE_REASON_C_NAME	VARCHAR	No
	The coverage status set reason category ID for the coverage record. This column's associated ZC table is ZC_CVG_STAT_CHNG_RSN. May contain organization-specific values: Yes Category Entries: Geographic Area Verification Result DTRR TRC 154 Out of Area DTRR TRC 16 Enrollment Accepted, Out of Area DTRR TRC 138 Beneficiary Address Change to Outside the U.S.