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 | Snowflake ID of the plan sponsor record Generated through expression: |
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 Generated through expression: |
external_plan_sponsor_id | text | No | Yes | Identifier that can be used to tie this plan sponsor to an external CRM or other system of record for plan sponsors Generated through expression: |