CVG_MEM_STAT_OUTST_ACT_HX
Description:
The historical values of the CVG_MEMBER_STAT_OUTST_ACT table over time.

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 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 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 this 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 this 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_STATUS_OUTST_ACT_LOC_DTTM DATETIME (Local) No
The instant the action was added to the coverage in the local time zone.
9 CVD_STATUS_OUTST_ACTION_DTTM DATETIME (UTC) No
The date and time when the action was added to the coverage in UTC time.
10 CVD_STAT_OUT_ACT_RES_LOC_DTTM DATETIME (Local) No
The instant the resolution was last changed in the local time zone.
11 CVD_STATUS_OUTST_ACT_RES_DTTM DATETIME (UTC) No
The instant the resolution was last changed in UTC.
12 CVD_STAT_OUT_ACT_DENIAL_RSN_C_NAME VARCHAR No
The covered status outstanding action denial reason on the coverage.
May contain organization-specific values: Yes
No Entries Defined
13 ITM_HX_START_LOCAL_DTTM DATETIME (Local) No
The start instant of when the coverage/line combination is valid in local time.
14 ITM_HX_START_UTC_DTTM DATETIME (UTC) No
The start instant of when the coverage/line combination is valid in UTC.
15 ITM_HX_END_LOCAL_DTTM DATETIME (Local) No
The end instant of when the coverage/line combination is valid in local time.
16 ITM_HX_END_UTC_DTTM DATETIME (UTC) No
The end instant of when the coverage/line combination is valid in UTC.
17 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.