CVG_MEMBER_STAT_OUTST_ACT

Description:

This table stores the outstanding actions for the covered status of a member on 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	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	CVD_STAT_OUTST_ACTION_C_NAME	VARCHAR	No
	The covered status outstanding action category ID for this member on the coverage record. May contain organization-specific values: Yes Category Entries: Special Enrollment Period Verification Binder Payment Enrollment Geographic Area Verification Non-Covered Subscriber Arbitration for Re-enrollment of Coverage Good Cause Reinstatement
5	CVD_STAT_OUTST_ACT_RES_C_NAME	VARCHAR	No
	The covered status outstanding action resolution category ID for member on the coverage record. 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 Requested Approved - Awaiting Payment Awaiting Reinstatement Approved - Expired Reinstated
6	APN_QUAL_EVNT_C_NAME	VARCHAR	No
	The covered status outstanding action qualifying event category ID for the member on the coverage record. May contain organization-specific values: Yes
7	QUALIFYING_EVENT_DATE	DATETIME	No
	The qualifying event date for this outstanding action for the member on the coverage record.
8	CVD_STAT_OUT_ACT_DENIAL_RSN_C_NAME	VARCHAR	No
	The covered status outstanding action denial reason on the coverage. This is extracted as the category title. May contain organization-specific values: Yes No Entries Defined