# PBP combined benefit groups (cleaned view)

`medicare_semantic.vw_pbp_combined_benefits_group` · Medicare Advantage, Part D, Medicaid · status live · 62,626 rows

The benefit groups pooled under one combined allowance per plan and plan year, from PBP section D, 2021 on.

**Grain.** One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category) cleaned row.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| version | double |  |
| report_year | double |  |
| quarter | double |  |
| group_index | int |  |
| group_name | string |  |
| shared_max_amount | double |  |
| max_amount_period_code | string |  |
| shared_visit_count | double |  |
| delivery_mode | string |  |
| enrollee_limited | boolean |  |
| member_categories_raw | string |  |
| member_families | string |  |
| member_family_count | bigint |  |
| is_cross_benefit | boolean |  |
| source_silver_table | varchar(29) |  |
| source_pbp_section | varchar(1) |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_pbp_combined_benefits_group WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_pbp_combined_benefits_group")` first.