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:Foreign Keys:plan_sponsor_id=>plan_sponsor.plan_sponsor_id
group_external_group_id_idx(Unique) -external_group_idgroup_plan_sponsor_id_idx-plan_sponsor_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
group_id | bigint | No | Yes | - |
plan_sponsor_id | bigint | No | Yes | - |
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 |
external_group_id | text | Yes | Yes | Identifier that can be used to tie this group to an external CRM or other system of record for groups |