Medicare Advantage, Part D, Medicaid

PBP optional supplemental packages (cleaned view)

medicare_semantic.vw_pbp_optional_package·live·semantic_view

Rows

51,694

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Optional supplemental packages (extra premium, opt-in) per plan and plan year from PBP section D-OPT, 2018 on; also reads the step 16/17b/18b worksheets where the package detail lives.

Grain

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

Columns (80)

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(14)
`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`	string
`benefit_amount_period_code`	string
`benefit_amount_period_label`	string
`benefit_amount_annualized`	double
`benefit_amount_pmpm`	double
`normalization_status`	varchar(41)
`normalization_basis`	varchar(20)
`aggregation_policy`	varchar(40)
`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)
`optional_base_benefit_code`	string
`optional_base_benefit_label`	string
`optional_base_category`	string
`optional_base_l2_id`	string
`optional_benefit_type_code`	string
`optional_benefit_type_label`	string
`optional_coinsurance_pct_max`	double
`optional_coinsurance_pct_min`	double
`optional_copay_amount_max`	double
`optional_copay_amount_min`	double
`optional_cost_share_basis`	string
`optional_cost_share_same_as_mandatory`	boolean
`optional_cost_share_tiers_code`	string
`optional_day_interval1_begin_day`	double
`optional_day_interval1_end_day`	double
`optional_day_interval_count`	double
`optional_limit_unlimited`	boolean
`optional_maxplan_in_oon_code`	string
`optional_oon_offered`	boolean
`optional_oon_same_as_in_network`	boolean
`optional_oon_type_id`	string
`optional_package_benefit_codes`	string
`optional_package_deductible_amount`	double
`optional_package_detail_level`	varchar(22)
`optional_package_id`	string
`optional_package_in_latest_roster`	boolean
`optional_package_includes_dental`	boolean
`optional_package_includes_hearing`	boolean
`optional_package_includes_vision`	boolean
`optional_package_name`	string
`optional_package_offered`	boolean
`optional_package_premium_monthly`	double
`optional_package_sub_benefit`	string
`optional_package_targeting`	varchar(28)
`optional_per_ear_code`	string
`optional_service_detail`	string
`optional_service_maxplan_amount`	double
`optional_service_maxplan_period_code`	string
`source_amount_column`	string
`source_pbp_section`	string
`source_silver_table`	string
`lmi_authorities`	string
`source_url`	string
`sha256_content_hash`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_pbp_optional_package")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_pbp_optional_package 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_optional_package")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_pbp_optional_package
Note	Cleaned PBP reasoning surface; register source cms_ma_pbp; raw is medicare_silver.pbp_section_d_opt. Rows measured 2026-09-28 (Athena).

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