member_eligibility

Keeps track of member eligibility information

Primary Key:

Foreign Keys:

Indexes:

member_eligibility_eligibility_id_idx - eligibility_id
member_eligibility_member_seen_id_idx - member_seen_id
member_eligibility_prior_incorrect_member_seen_id_idx - prior_incorrect_member_seen_id
member_eligibility_subscriber_member_eligibility_id_idx - subscriber_member_eligibility_id
member_eligibility_trading_partner_submission_id_idx - trading_partner_submission_id
member_eligibility_uq (Unique) - trading_partner_submission_id, eligibility_id, member_seen_id

Column	Data Type	Nullable	Indexed	Description
`member_eligibility_id`	`bigint`	No	Yes	Snowflake ID for member eligibility record.
`trading_partner_submission_id`	`bigint`	No	Yes	Links to trading partner submission.
`prior_id_number`	`text`	No	No	Prior member identifier (From REF Q4)
`eligibility_maintenance_type`	`maintenance_type`	Yes	No	Identifies the change type for this record (From INS03)
`eligibility_maintenance_reason`	`maintenance_reason_type`	Yes	No	Reason for the change (From INS04)
`eligibility_maintenance_effective_date`	`date`	Yes	No	Maintenance effective date (From DTP 303)
`member_seen_id`	`bigint`	No	Yes	Links to name, address and contact information for the member. (From NM1 IL or NM1 74 for a correction record)
`prior_incorrect_member_seen_id`	`bigint`	Yes	Yes	Links to a prior incorrect name, address and contact information for the member. Null if not a correction (From NM1 70)
`subscriber_member_eligibility_id`	`bigint`	No	Yes	Links to the member_eligibility_id of the subscriber. Links to itself if it is the subscriber.
`eligibility_id`	`bigint`	No	Yes	Links to the eligibility data for this record.
`sender_identifier`	`text`	No	No	Identifies the sender (From ISA06)