member_eligibility

Keeps track of member eligibility information

Primary Key:

• member_eligibility_id

Foreign Keys:

• eligibility_id => eligibility.eligibility_id
• member_seen_id => member_seen.member_seen_id
• prior_incorrect_member_seen_id => member_seen.member_seen_id
• trading_partner_submission_id => trading_partner_submission.trading_partner_submission_id

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_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	-
trading_partner_submission_id	bigint	No	Yes	-
prior_id_number	text	No	No	Prior member identifier (From REF Q4)
eligibility_maintenance_type	maintenance_type	No	No	Identifies the change type for this record (From INS03)
eligibility_maintenance_reason	maintenance_reason_type	No	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	No	Links to the member_eligibility_id of the subscriber
eligibility_id	bigint	No	Yes	-