plan_match

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

Primary Key:

• group_id
• match_order

Foreign Keys:

• coverage_group_or_plan_id => coverage_group_or_plan.coverage_group_or_plan_id
• group_id => group.group_id
• plan_id => plan.plan_id

Indexes:

• plan_match_coverage_group_or_plan_id_idx - coverage_group_or_plan_id
• plan_match_group_id_coverage_group_or_plan_id_idx (Unique) - group_id, coverage_group_or_plan_id
• plan_match_plan_id_idx - plan_id

Column	Data Type	Nullable	Indexed	Description
group_id	bigint	No	Yes	Links to the group 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_id	bigint	No	Yes	The plan which members are allocated to