# PBP combined supplemental limit (cleaned view)

`medicare_semantic.vw_pbp_combined_supplemental` · Medicare Advantage, Part D, Medicaid · status live · 62,702 rows

The combined (pooled) supplemental benefit limit per plan and plan year from PBP section D, 2021 on: which benefits share one allowance and its periodicity.

**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 |  |
| benefit_category | string |  |
| cost_share_string | string |  |
| copay_amount | double |  |
| coinsurance_pct | double |  |
| limit_text | string |  |
| auth_required | boolean |  |
| referral_required | boolean |  |
| network_type | varchar(43) |  |
| max_oop_applies | boolean |  |
| limit_quantity | double |  |
| limit_unit | string |  |
| limit_period_code | string |  |
| limit_period_label | string |  |
| limit_quantity_per_year | double |  |
| benefit_amount | double |  |
| benefit_amount_kind | varchar(49) |  |
| benefit_amount_period_code | string |  |
| benefit_amount_period_label | varchar(18) |  |
| benefit_amount_annualized | double |  |
| benefit_amount_pmpm | double |  |
| normalization_status | varchar(29) |  |
| normalization_basis | varchar(47) |  |
| aggregation_policy | varchar(70) |  |
| offered_status | varchar(15) |  |
| numeric_amount_observability | varchar(31) |  |
| null_amount_reason | varchar(30) |  |
| annualization_policy | varchar(17) |  |
| combined_limit_policy | varchar(29) |  |
| consumer_document_reconciliation_status | varchar(11) |  |
| confidence_tier | varchar(23) |  |
| benefit_category_codes_undecoded | string |  |
| combined_group_index | int |  |
| combined_group_kind | string |  |
| combined_group_label | string |  |
| combined_group_name | string |  |
| combined_supplemental_offered | boolean |  |
| combined_supplemental_sub_benefit | string |  |
| delivery_mode_code | string |  |
| delivery_mode_description | string |  |
| delivery_mode_label | string |  |
| enrollee_must_preselect_benefits | boolean |  |
| enrollee_must_preselect_benefits_code | string |  |
| filed_group_count_code | string |  |
| food_or_utilities_inclusion_status | string |  |
| included_benefit_category_codes | string |  |
| included_benefit_category_labels | string |  |
| included_benefit_families | string |  |
| includes_b19_or_ssbci_additional_benefits | boolean |  |
| includes_dental | boolean |  |
| includes_fitness | boolean |  |
| includes_food_or_utilities | boolean |  |
| includes_hearing | boolean |  |
| includes_meals | boolean |  |
| includes_otc | boolean |  |
| includes_transportation | boolean |  |
| includes_vision | boolean |  |
| maximum_amount_period_code | string |  |
| maximum_amount_period_description | string |  |
| maximum_amount_period_label | string |  |
| plan_combined_supplemental_offered_code | string |  |
| reductions_in_cost_sharing_offered | boolean |  |
| rics_applies_to_deductible | boolean |  |
| rics_applies_to_deductible_code | string |  |
| rics_applies_to_medicare_covered | boolean |  |
| rics_applies_to_non_medicare_covered | boolean |  |
| rics_category_codes_undecoded | string |  |
| rics_category_scope_code | string |  |
| rics_delivery_mode_code | string |  |
| rics_delivery_mode_description | string |  |
| rics_delivery_mode_label | string |  |
| rics_eligibility | string |  |
| rics_eligibility_basis | string |  |
| rics_group_count_code | string |  |
| rics_group_index | int |  |
| rics_group_label | string |  |
| rics_group_name | string |  |
| rics_group_name_status | string |  |
| rics_maximum_amount | double |  |
| rics_maximum_period_code | string |  |
| rics_maximum_period_label | string |  |
| rics_maximum_period_months | int |  |
| rics_medicare_covered_category_codes | string |  |
| rics_medicare_covered_category_labels | string |  |
| rics_non_medicare_covered_category_codes | string |  |
| rics_non_medicare_covered_category_labels | string |  |
| rics_non_medicare_covered_families | string |  |
| rics_offered_code | string |  |
| rics_shared_combined_group_index | bigint |  |
| rics_shared_combined_package_name | string |  |
| rics_shared_package_status | string |  |
| rics_shared_with_combined_package | boolean |  |
| rics_shared_with_combined_package_code | string |  |
| shared_maximum_plan_benefit_amount | double |  |
| shared_maximum_plan_benefit_offered | boolean |  |
| shared_maximum_plan_benefit_offered_code | string |  |
| shared_visit_count | double |  |
| shared_visit_limit_offered | boolean |  |
| shared_visit_limit_offered_code | string |  |
| shared_visit_period_code | string |  |
| shared_visit_period_label | string |  |
| ssbci_benefit_category_codes | string |  |
| ssbci_benefit_category_codes_raw | string |  |
| ssbci_benefit_category_labels | string |  |
| ssbci_families_source | string |  |
| ssbci_package_names | string |  |
| source_pbp_section | varchar(1) |  |
| source_silver_table | varchar(29) |  |
| lmi_authorities | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |

Tools that read it: get_pbp_benefit

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