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	NUMERIC	No
	The unique ID of the benefit plan record for the rider.
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.