plan_sponsor
Information about the plan sponsor (usually employer) of a health plan.
Primary Key:Indexes:plan_sponsor_external_plan_sponsor_id_idx
(Unique) -external_plan_sponsor_id
Column | Data Type | Nullable | Indexed | Description |
---|---|---|---|---|
plan_sponsor_id | bigint | No | Yes | Identifier that can be used to tie this plan sponsor to an external CRM or other system of record for plan sponsors |
plan_sponsor_name | text | No | No | Name of the plan sponsor. This will periodically be overwritten by the external plan sponsor name if external_plan_sponsor_id is set |
external_plan_sponsor_id | text | Yes | Yes | Identifier that can be used to tie this plan sponsor to an external CRM or other system of record for plan sponsors |