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.