group_match

Information used to match members received from a TPA, plan sponsor, or other trading partner to our definition of a group (in the group table).

Primary Key:

• plan_sponsor_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_sponsor_id => plan_sponsor.plan_sponsor_id

Indexes:

• group_match_coverage_group_or_plan_id_idx - coverage_group_or_plan_id
• group_match_group_id_idx - group_id
• group_match_plan_sponsor_id_coverage_group_or_plan_id_idx (Unique) - plan_sponsor_id, coverage_group_or_plan_id
• group_match_plan_sponsor_id_idx - plan_sponsor_id

Column	Data Type	Nullable	Indexed	Description
plan_sponsor_id	bigint	No	Yes	Links to the plan sponsor whose members will be split into one or more groups
match_order	smallint	No	Yes	Order in which rules will be run against plan sponsor members to determine which group they belong to
coverage_group_or_plan_id	bigint	Yes	Yes	Member group or plan filters
group_id	bigint	No	Yes	The group that matching members belong to