COVERAGE_MEMBER_RIDERS

Description: |
This table stores member-level riders and their effective period. Members will only have riders in this table if there are riders with a selection mode of 4-Member-Specific (PLAN_GRP_RIDER.RIDER_SEL_MODE_C = 4) for the employer group on their coverage (COVERAGE.PLAN_GRP_ID) and the rider been assigned to the member.

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 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for the rider. This column is frequently used to link to the PATIENT table.
4 | BENEFIT_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
5 | EFF_DATE | DATETIME | No |
The date when the rider becomes effective for the patient. This date should never be NULL. The period of time between this date and the term date represents a period during which the specified patient is eligible for the specified rider. This date range will not overlap any other date range for the same rider and patient.
6 | TERM_DATE | DATETIME | No |
The date after which the rider is no longer effective for the patient. If this date is NULL, the rider is assumed to always be effective from the effective date onward.