COVERAGE_STATUS_HX
Description:
The historical values of the COVERAGE_STATUS 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 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
Requested
Approved - Awaiting Payment
Awaiting Reinstatement
Approved - Expired
Reinstated
5 CREATION_DTTM DATETIME (Local) No
The local date and time when the coverage gained the coverage status.
6 CREATION_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the coverage gained the coverage status.
7 RESOLUTION_DTTM DATETIME (Local) No
The local date and time when the coverage had its resolution for this coverage status set.
8 RESOLUTION_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the resolution had its state for this coverage status set.
9 COVERAGE_STATE_CHANGE_REASON_C_NAME VARCHAR No
The Coverage Status - Change Reason category ID for the coverage record.
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.
10 ITM_HX_START_LOCAL_DTTM DATETIME (Local) No
The start instant of when the coverage/line combination is valid in local time.
11 ITM_HX_START_UTC_DTTM DATETIME (UTC) No
The start instant of when the coverage/line combination is valid in UTC.
12 ITM_HX_END_LOCAL_DTTM DATETIME (Local) No
The end instant of when the coverage/line combination is valid in local time.
13 ITM_HX_END_UTC_DTTM DATETIME (UTC) No
The end instant of when the coverage/line combination is valid in UTC.
14 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.