Medicare Advantage, Part D, Medicaid

PBP optional supplemental premium and MOOP (cleaned view)

medicare_semantic.vw_pbp_optional_supplemental·live·semantic_view

Rows

40,968

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Premium and MOOP of each optional supplemental package per plan and plan year from PBP section D-OPT, 2018 on.

Grain

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

Columns (24)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`version`	double
`report_year`	double
`quarter`	double
`optional_package_identifier`	string
`package_name`	string
`monthly_premium`	double
`covered_benefit_codes`	string
`offers_dental`	boolean
`offers_vision`	boolean
`offers_hearing`	boolean
`offers_point_of_service`	boolean
`covered_categories`	string
`package_max_benefit_amount`	double
`package_max_period_label`	string
`package_deductible_amount`	double
`package_applies_to_moop`	boolean
`offered_status`	varchar(29)
`source_pbp_section`	varchar(5)
`source_silver_table`	varchar(33)
`source_url`	string
`sha256_content_hash`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_pbp_optional_supplemental")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_pbp_optional_supplemental
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_supplemental.md · every page in one file: /llms-full.txt