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
• subscriber_member_eligibility_id => member_eligibility.member_eligibility_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_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. Generated through expression:
trading_partner_submission_id	bigint	No	Yes	Links to trading partner submission. Generated through expression:
prior_id_number	text	No	No	Prior member identifier (From REF Q4) Generated through expression:
eligibility_maintenance_type	maintenance_type	No	No	Identifies the change type for this record (From INS03) Generated through expression:
eligibility_maintenance_reason	maintenance_reason_type	No	No	Reason for the change (From INS04) Generated through expression:
eligibility_maintenance_effective_date	date	Yes	No	Maintenance effective date (From DTP 303) Generated through expression:
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) Generated through expression:
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) Generated through expression:
subscriber_member_eligibility_id	bigint	No	Yes	Links to the member_eligibility_id of the subscriber. Links to itself if it is the subscriber. Generated through expression:
eligibility_id	bigint	No	Yes	Links to the eligibility data for this record. Generated through expression: