COVERAGE_STATUS
Description:
This table stores information about the current coverage statuses of 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 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_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the coverage gained the coverage status.
6 RESOLUTION_UTC_DTTM DATETIME (UTC) No
The UTC date and time when the resolution had its state for this coverage status set.
7 CREATION_DTTM DATETIME (Local) No
The local date and time when the coverage gained the coverage status.
8 RESOLUTION_DTTM DATETIME (Local) No
The local date and time when the coverage had its resolution for this coverage status set.
9 COVERAGE_STATE_CHANGE_REASON_C_NAME VARCHAR No
The coverage status set reason category ID for the coverage record. This column's associated ZC table is ZC_CVG_STAT_CHNG_RSN.
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.