plan_sponsor_match

Information needed to match eligibility/enrollment and claims data to a plan sponsor

Primary Key:

• trading_partner_id
• match_order

Foreign Keys:

• coverage_group_or_plan_id => coverage_group_or_plan.coverage_group_or_plan_id
• plan_sponsor_id => plan_sponsor.plan_sponsor_id
• trading_partner_id => trading_partner.trading_partner_id

Indexes:

• plan_sponsor_match_coverage_group_or_plan_id_idx - coverage_group_or_plan_id
• plan_sponsor_match_plan_sponsor_id_idx - plan_sponsor_id
• plan_sponsor_match_trading_partner_id_coverage_group_or_pla_idx (Unique) - trading_partner_id, coverage_group_or_plan_id

Column	Data Type	Nullable	Indexed	Description
trading_partner_id	bigint	No	Yes	Links to the trading partner whose members will be split into one or more plans
match_order	smallint	No	Yes	The order in which rules are run
coverage_group_or_plan_id	bigint	Yes	Yes	Member group or plan filters
plan_sponsor_id	bigint	No	Yes	The plan which members are allocated to