Medicare Advantage, Part D, Medicaid

PBP fitness benefit (cleaned view)

medicare_semantic.vw_pbp_fitness·live·semantic_view

Rows

171,479

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Fitness benefits per plan and plan year from PBP section B14c: offered status, the fitness types (activity tracker, physical fitness, memory fitness), mandatory or optional, copay and coinsurance, the benefit amount with its period and annualized value, with the raw filed fields kept.
2Built by the benefits lane (Lane CI, 2026-09-29) as a versioned view; the bare name is a pointer to the newest version.

Grain

Key	Grain
N/A	1One row per (contract_id, plan_id, segment_id, report_year, quarter, benefit_category, fitness_sub_benefit) cleaned row; 2171,479 rows, report_year 2012-2026, 1,594 contracts (measured 2026-09-29, Athena 24b0afde).

Columns (44)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`version`	double
`report_year`	double
`quarter`	double
`benefit_category`	string
`fitness_sub_benefit`	string
`fitness_offered`	boolean
`offered_status`	varchar(29)
`fitness_type_activity_tracker`	boolean
`fitness_type_physical_fitness`	boolean
`fitness_type_memory_fitness`	boolean
`fitness_mandatory_optional`	varchar(9)
`copay_amount_max`	double
`copay_amount`	double
`copay_basis`	varchar(33)
`coinsurance_pct`	double
`benefit_amount`	double
`benefit_amount_period_code`	string
`benefit_amount_period_label`	varchar(18)
`benefit_amount_annualized`	double
`source_pbp_section`	string
`source_silver_table`	string
`source_url`	string
`sha256_content_hash`	string
`offered_basis`	varchar(28)
`fitness_targeting`	string
`fitness_offered_any_members`	boolean
`fitness_package_targeting`	string
`fitness_package_ids`	string
`fitness_package_names`	string
`fitness_package_in_ssbci_list`	boolean
`fitness_package_copay_amount_filed`	double
`fitness_package_source_view`	string
`section_d_group_index`	int
`section_d_group_name`	string
`section_d_group_amount`	double
`section_d_group_period_code`	string
`section_d_group_period_label`	string
`section_d_group_amount_annualized`	double
`section_d_group_category_codes`	string
`section_d_group_count`	bigint
`section_d_group_link_basis`	string

Query it

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

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