MC_CVG_ELIG_VERIFICATION

Description: |
This table contains information about the eligibility verification status of coverage members.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
COVERAGE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COVERAGE_ID | NUMERIC | No |
The unique identifier (.1 item) 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 | MEMBER_PAT_ID | VARCHAR | No |
The unique ID of the member for this row.
4 | VERIFICATION_RECORD_ID | NUMERIC | No |
The unique ID of the member's eligibility verification record (VRX).
5 | GRACE_PERIOD_START_DATE | DATETIME | No |
This start date of the member's eligibility grace period.
6 | GRACE_PERIOD_END_DATE | DATETIME | No |
This end date of the member's eligibility grace period.
7 | MC_VERIFICATION_TYPE_C_NAME | VARCHAR | No |
The verification status type for the verification record on this line.
May contain organization-specific values: Yes