group

Information about a group of employees for a plan sponsor of a health plan (e.g. Intel California). For a small employer, this will usually match the company name. Note that this is our group definition, and may not match with the group definition of a TPA or other trading partner.

Primary Key:

• group_id

Foreign Keys:

• plan_sponsor_id => plan_sponsor.plan_sponsor_id

Indexes:

• group_external_group_id_idx (Unique) - external_group_id
• group_plan_sponsor_id_idx - plan_sponsor_id

Column	Data Type	Nullable	Indexed	Description
group_id	bigint	No	Yes	Snowflake ID for group. Generated through expression:
plan_sponsor_id	bigint	No	Yes	Link to the plan sponsor record. Generated through expression:
group_name	text	No	No	Name of the group. This will periodically be overwritten by the external group name if external_group_id is set Generated through expression:
external_group_id	text	No	Yes	Identifier that can be used to tie this group to an external CRM or other system of record for groups Generated through expression: