Medicare Advantage, Part D, Medicaid

PBP combined supplemental limit (cleaned view)

medicare_semantic.vw_pbp_combined_supplemental·live·semantic_view

Rows

62,702

Columns

116

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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

Key	Grain
N/A	1One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category) cleaned row.

Columns (116)

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

Query it

describe_data_source(source_fqn="medicare_semantic.vw_pbp_combined_supplemental")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_pbp_combined_supplemental WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	get_pbp_benefit
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_pbp_combined_supplemental")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_pbp_combined_supplemental
Note	Cleaned PBP reasoning surface; register source cms_ma_pbp; raw is medicare_silver.pbp_section_d. Rows measured 2026-09-28 (Athena).

This page as markdown: /docs-md/data/medicare_semantic_vw_pbp_combined_supplemental.md · every page in one file: /llms-full.txt