# PBP fitness benefit (cleaned view)

`medicare_semantic.vw_pbp_fitness` · Medicare Advantage, Part D, Medicaid · status live · 171,479 rows

Fitness 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. Built by the benefits lane (Lane CI, 2026-09-29) as a versioned view; the bare name is a pointer to the newest version.

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

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_pbp_fitness WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_pbp_fitness")` first.
