member_coverage

Keeps track of each load of an enrolled member's coverage

Primary Key:

• member_coverage_id

Foreign Keys:

• coverage_group_or_plan_id => coverage_group_or_plan.coverage_group_or_plan_id
• coverage_id => coverage.coverage_id
• member_eligibility_id => member_eligibility.member_eligibility_id

Indexes:

• member_coverage_coverage_group_or_plan_id_idx - coverage_group_or_plan_id
• member_coverage_coverage_id_idx - coverage_id
• member_coverage_member_eligibility_id_idx - member_eligibility_id
• member_coverage_uq (Unique) - member_eligibility_id, coverage_id

Column	Data Type	Nullable	Indexed	Description
member_coverage_id	bigint	No	Yes	Snowflake ID of the member coverage record. Generated through expression:
member_eligibility_id	bigint	No	Yes	Links to the member eligibility record Generated through expression:
coverage_maintenance_type	maintenance_type	No	No	Identifies the change type for this record (From HD01) Generated through expression:
coverage_maintenance_effective_date	date	Yes	No	Maintenance effective date (From DTP 303) Generated through expression:
coverage_group_or_plan_id	bigint	No	Yes	Links to the group or plan (From HD and REF) Generated through expression:
coverage_id	bigint	No	Yes	Links to the unique coverage data for this record Generated through expression: