|
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. |
|
|