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