# MA pbp section b14 preventive

`medicare_silver.pbp_section_b14_preventive` · Medicare Advantage, Part D, Medicaid · status partial

Section B14: Preventive services. Widest single section (190 cols in 2026).

**Grain.** One row per Medicare Advantage plan-segment per CMS quarterly PBP release. The MINIMAL verified-unique key is contract_id × plan_id × segment_id × report_year × quarter = 193,488 distinct = 193,488 total rows (exact). report_year may be swapped for effective_period_start (they are 1:1). Dropping quarter collapses to 106,175 (a plan-year appears in up to 4 quarterly snapshots), so quarter is required. version, bid_id, pbp_a_plan_type and the ~95 maxplan/_d columns the profiler appended are NOT needed and must not be added to the key.

**How to use it.** To compare 2025 Medicare Advantage preventive cost-sharing across plans, pin a single snapshot and read the per-service copay/coins/cap columns: SELECT contract_id, plan_id, segment_id, pbp_a_plan_type, pbp_b14b_copay_amt_rpe_max AS routine_physical_copay, pbp_b14e_coins_pct_max_diab AS diabetes_screen_coins_pct, pbp_b14c_maxplan_amt_wig AS wig_annual_cap FROM medicare_silver.pbp_section_b14_preventive WHERE report_year=2025 AND quarter=1. This answers 'what does each MA plan charge an enrollee for a routine physical, a diabetes screening, and how much wig coverage it caps at' (observed: routine physical $0 median–$20 max; diabetes screening 20% median coins; wig cap $400 median–$1,000 max).

**Traps.**
- The profiler's reported 'grain' (~100 columns) is a massive SUPERSET — it just kept appending maxplan/_d columns until unique. The TRUE minimal grain is only 5 columns: contract_id, plan_id, segment_id, report_year, quarter.
- quarter is a SNAPSHOT/release dimension, not a benefit attribute. The same plan-year is re-published in multiple quarterly CMS files (most visible 2018-2024 with Q1-Q4); rows across quarters are near-identical re-releases. For 'the plan's 2025 benefits' filter to ONE quarter (e.g. quarter=1) or you will multi-count plans. There is NO is_current / is_latest flag — you must pick the snapshot yourself (latest quarter, or quarter=1).
- report_year, effective_period_start, effective_period_end and observed_period are all redundant: report_year = year(effective_period_start) for 100% of rows; start=Jan 1, end=Dec 31 of that year. asserted_at is the May-2026 ingestion/load date (NOT a benefit date) — never use it as the coverage period.
- The 800+ pbp_b14* columns are SPARSE and layout-shifts by year: most specific copay/coins columns are NULL for any given plan/year (e.g. the b14b_ame_* copay columns are entirely null in 2025; only ~102 of ~392 cost columns are populated in 2025 Q1). NULL means 'benefit/field not applicable to this plan', not zero — and $0 (a real value, e.g. $0 preventive copay) is distinct from NULL. Always COUNT() non-nulls before averaging a sub-benefit column.
- Codes use CMS PBP conventions, not booleans: yes/no fields (*_auth_yn, *_refer_yn) are 1=Yes, 2=No (NOT 1/0). orgtype and pbp_a_plan_type are 2-digit CMS plan-classification codes ('01'=HMO, '02'=local PPO, '04'=HMO-POS, '20'=PFFS, '31'=MSA...). bid_id is NULL and segment_id is '' for older years (pre-bid era / non-segmented plans) — both blanks are meaningful, not data errors. Years 2010 and 2011 are entirely absent from the table.
- Cost columns come in _min / _max pairs and per-service tags (mhc=mental-health counseling, rat=transportation, bsd=bundled, sc/sce=smoking cessation, wig; bar=bone density, diab, glauc, ekg, dre). *_copay_*_amt = dollars, *_coins_*_pct = percent, *_maxplan_amt_<tag> = annual plan-coverage dollar CAP (not a cost share). Don't mix amt vs pct vs maxplan when aggregating.

| column | type | meaning |
|---|---|---|
| contract_id | string | CMS Medicare Advantage / Part C contract number (e.g. 'H0150'). Part of the natural plan key. 1,966 distinct across history; 1,966 is NOT row-unique. Letter prefix encodes contract type (H=local MA, R=regional PPO, etc.). |
| plan_id | string | 3-char plan number within the contract (e.g. '001','004'). Combined with contract_id+segment_id identifies a Plan Benefit Package. 656 distinct codes (reused across contracts, so not unique alone). |
| segment_id | string | Plan segment (service-area split). Empty string '' for non-segmented plans (5,074 rows in full table) — blank is a real value meaning 'no segment', not missing. Part of the plan key. |
| version | double | CMS within-cycle PBP submission/revision counter (double). Up to ~21-22 distinct values per report_year. NOT needed for grain uniqueness — the table is already deduped to one effective row per plan per quarterly release, so do not add version to the key. |
| report_year | double | PBP contract/benefit year (double, 2001-2026). 100% equal to year(effective_period_start) — fully redundant with it. The primary time dimension. Note gaps: 2010 and 2011 are absent from the data. |
| quarter | double | CMS quarterly RELEASE/snapshot number (1-4) within report_year. THIS is the snapshot disambiguator that makes the row unique: same plan-year reappears in multiple quarterly CMS re-releases. Most years have only Q1; 2018-2024 carry Q1-Q4. Plan counts barely change across quarters (re-publications, not new benefits). |
| bid_id | string | CMS bid identifier (string). NULL for 8,316 older rows (pre-bid_id era, e.g. 2003). Supplemental provenance id, not part of the minimal grain. |
| orgtype | string | CMS organization type code carried from PBP Section A (string, 9 distinct: '01'=local CCP/HMO dominant ~7,004/yr, '08','11','06','05','04','02'...). Classifies the contracting org. Descriptive filter dimension. |
| pbp_a_ben_cov | string | Benefit-coverage indicator from Section A (string). '1'=Part C medical (Parts A+B benefits) — ~98% of rows; '2'=other; NULL for a few. Descriptive. |
| pbp_a_plan_type | string | CMS plan-type code from Section A (string, 33 distinct: '01'=HMO, '02'=local PPO, '04'=HMO-POS/regional, '20'=PFFS, '31'=MSA, '18','48','09','07'...). Was appended to the profiler's bloated key but is functionally dependent on the plan, not a real grain component. |
| pbp_b14a_auth | string |  |
| pbp_b14a_auth_yn | string |  |
| pbp_b14a_mc_prevent_attest | string |  |
| pbp_b14a_refer_yn | string |  |
| pbp_b14b_ace_coins_max_pct | double |  |
| pbp_b14b_ace_coins_min_pct | double |  |
| pbp_b14b_ame_coins_pct | double |  |
| pbp_b14b_ame_copay_amt | double |  |
| pbp_b14b_ape_coins_pct | double |  |
| pbp_b14b_ape_copay_amt | double |  |
| pbp_b14b_auth | string |  |
| pbp_b14b_auth_yn | string |  |
| pbp_b14b_bendesc_ace_amo | string |  |
| pbp_b14b_bendesc_ace_per | string |  |
| pbp_b14b_bendesc_ame_amo | string |  |
| pbp_b14b_bendesc_ame_per | string |  |
| pbp_b14b_bendesc_amo_pe | string |  |
| pbp_b14b_bendesc_amo_ps | string |  |
| pbp_b14b_bendesc_apr_amo | string |  |
| pbp_b14b_bendesc_apr_per | string |  |
| pbp_b14b_bendesc_ehc | string |  |
| pbp_b14b_bendesc_lim_ace_yn | string |  |
| pbp_b14b_bendesc_lim_ame_yn | string |  |
| pbp_b14b_bendesc_lim_apr_yn | string |  |
| pbp_b14b_bendesc_lim_pe_yn | string |  |
| pbp_b14b_bendesc_lim_ps_yn | string |  |
| pbp_b14b_bendesc_numace | double |  |
| pbp_b14b_bendesc_numame | double |  |
| pbp_b14b_bendesc_numapr | double |  |
| pbp_b14b_bendesc_numpe | double |  |
| pbp_b14b_bendesc_numps | double |  |
| pbp_b14b_bendesc_oi_amo | string |  |
| pbp_b14b_bendesc_pe_per | string |  |
| pbp_b14b_bendesc_ps_per | string |  |
| pbp_b14b_bendesc_rpe_amo | string |  |
| pbp_b14b_bendesc_rpe_lim_yn | string |  |
| pbp_b14b_bendesc_rpe_numv | double |  |
| pbp_b14b_bendesc_rpe_per | string |  |
| pbp_b14b_bendesc_yn | string |  |
| pbp_b14b_coins_ehc | string |  |
| pbp_b14b_coins_pct_maxoi | double |  |
| pbp_b14b_coins_pct_minoi | double |  |
| pbp_b14b_coins_pct_pap | double |  |
| pbp_b14b_coins_pct_pe | double |  |
| pbp_b14b_coins_pct_rpe | double |  |
| pbp_b14b_coins_pct_rpe_max | double |  |
| pbp_b14b_coins_pct_rpe_min | double |  |
| pbp_b14b_coins_yn | string |  |
| pbp_b14b_copay_ace_max_amt | double |  |
| pbp_b14b_copay_ace_min_amt | double |  |
| pbp_b14b_copay_amt_pap | double |  |
| pbp_b14b_copay_amt_pe | double |  |
| pbp_b14b_copay_amt_rpe | double |  |
| pbp_b14b_copay_amt_rpe_max | double |  |
| pbp_b14b_copay_amt_rpe_min | double |  |
| pbp_b14b_copay_ehc | string |  |
| pbp_b14b_copay_oi_max_amt | double |  |
| pbp_b14b_copay_oi_min_amt | double |  |
| pbp_b14b_copay_yn | string |  |
| pbp_b14b_cstshr_coins_ace_max | double |  |
| pbp_b14b_cstshr_coins_ace_min | double |  |
| pbp_b14b_cstshr_coins_ace_yn | string |  |
| pbp_b14b_cstshr_coins_ame_max | double |  |
| pbp_b14b_cstshr_coins_ame_min | double |  |
| pbp_b14b_cstshr_coins_ame_yn | string |  |
| pbp_b14b_cstshr_copay_ace_max | double |  |
| pbp_b14b_cstshr_copay_ace_min | double |  |
| pbp_b14b_cstshr_copay_ace_yn | string |  |
| pbp_b14b_cstshr_copay_ame_max | double |  |
| pbp_b14b_cstshr_copay_ame_min | double |  |
| pbp_b14b_cstshr_copay_ame_yn | string |  |
| pbp_b14b_cstshr_yn | string |  |
| pbp_b14b_ded_amt | double |  |
| pbp_b14b_ded_yn | string |  |
| pbp_b14b_maxenr_amt | double |  |
| pbp_b14b_maxenr_per | string |  |
| pbp_b14b_maxenr_yn | string |  |
| pbp_b14b_maxplan_amt | double |  |
| pbp_b14b_maxplan_per | string |  |
| pbp_b14b_maxplan_yn | string |  |
| pbp_b14b_refer_yn | string |  |
| pbp_b14c_at_visits | double |  |
| pbp_b14c_auth | string |  |
| pbp_b14c_auth_yn | string |  |
| pbp_b14c_bendesc_adcs | string |  |
| pbp_b14c_bendesc_amo_at | string |  |
| pbp_b14c_bendesc_amo_bsd | string |  |
| pbp_b14c_bendesc_amo_cs | string |  |
| pbp_b14c_bendesc_amo_edm | string |  |
| pbp_b14c_bendesc_amo_hec | string |  |
| pbp_b14c_bendesc_amo_imr | string |  |
| pbp_b14c_bendesc_amo_isa | string |  |
| pbp_b14c_bendesc_amo_mhc | string |  |
| pbp_b14c_bendesc_amo_mnt | string |  |
| pbp_b14c_bendesc_amo_nhl | string |  |
| pbp_b14c_bendesc_amo_ntb | string |  |
| pbp_b14c_bendesc_amo_prs | string |  |
| pbp_b14c_bendesc_amo_rat | string |  |
| pbp_b14c_bendesc_amo_rp | string |  |
| pbp_b14c_bendesc_amo_sc | string |  |
| pbp_b14c_bendesc_amo_tm | string |  |
| pbp_b14c_bendesc_amo_wig | string |  |
| pbp_b14c_bendesc_amo_wm | string |  |
| pbp_b14c_bendesc_amo_wpt | string |  |
| pbp_b14c_bendesc_dur_cs | string |  |
| pbp_b14c_bendesc_dur_ntb | string |  |
| pbp_b14c_bendesc_dur_num_cs | double |  |
| pbp_b14c_bendesc_ehc | string |  |
| pbp_b14c_bendesc_hbpc | string |  |
| pbp_b14c_bendesc_ihss | string |  |
| pbp_b14c_bendesc_lim_at | string |  |
| pbp_b14c_bendesc_lim_cs | string |  |
| pbp_b14c_bendesc_lim_ntb | string |  |
| pbp_b14c_bendesc_num_cs | double |  |
| pbp_b14c_bendesc_num_ntb | double |  |
| pbp_b14c_bendesc_sce | string |  |
| pbp_b14c_bendesc_thp_msg | string |  |
| pbp_b14c_bendesc_typ_mhc | string |  |
| pbp_b14c_bendesc_visit_num_sc | double |  |
| pbp_b14c_bendesc_yn | string |  |
| pbp_b14c_coins_ehc | string |  |
| pbp_b14c_coins_pct_edm | double |  |
| pbp_b14c_coins_pct_max_adcs | double |  |
| pbp_b14c_coins_pct_max_at | double |  |
| pbp_b14c_coins_pct_max_bsd | double |  |
| pbp_b14c_coins_pct_max_cs | double |  |
| pbp_b14c_coins_pct_max_edm | double |  |
| pbp_b14c_coins_pct_max_hbpc | double |  |
| pbp_b14c_coins_pct_max_hec | double |  |
| pbp_b14c_coins_pct_max_ihss | double |  |
| pbp_b14c_coins_pct_max_imr | double |  |
| pbp_b14c_coins_pct_max_isa | double |  |
| pbp_b14c_coins_pct_max_mhc | double |  |
| pbp_b14c_coins_pct_max_mnt | double |  |
| pbp_b14c_coins_pct_max_ntb | double |  |
| pbp_b14c_coins_pct_max_prs | double |  |
| pbp_b14c_coins_pct_max_rat | double |  |
| pbp_b14c_coins_pct_max_rat_nh | double |  |
| pbp_b14c_coins_pct_max_rat_wp | double |  |
| pbp_b14c_coins_pct_max_rp | double |  |
| pbp_b14c_coins_pct_max_sc | double |  |
| pbp_b14c_coins_pct_max_sce | double |  |
| pbp_b14c_coins_pct_max_thmg | double |  |
| pbp_b14c_coins_pct_max_tm | double |  |
| pbp_b14c_coins_pct_max_wig | double |  |
| pbp_b14c_coins_pct_max_wm | double |  |
| pbp_b14c_coins_pct_min_adcs | double |  |
| pbp_b14c_coins_pct_min_at | double |  |
| pbp_b14c_coins_pct_min_bsd | double |  |
| pbp_b14c_coins_pct_min_cs | double |  |
| pbp_b14c_coins_pct_min_edm | double |  |
| pbp_b14c_coins_pct_min_hbpc | double |  |
| pbp_b14c_coins_pct_min_hec | double |  |
| pbp_b14c_coins_pct_min_ihss | double |  |
| pbp_b14c_coins_pct_min_imr | double |  |
| pbp_b14c_coins_pct_min_isa | double |  |
| pbp_b14c_coins_pct_min_mhc | double |  |
| pbp_b14c_coins_pct_min_mnt | double |  |
| pbp_b14c_coins_pct_min_ntb | double |  |
| pbp_b14c_coins_pct_min_prs | double |  |
| pbp_b14c_coins_pct_min_rat | double |  |
| pbp_b14c_coins_pct_min_rat_nh | double |  |
| pbp_b14c_coins_pct_min_rat_wp | double |  |
| pbp_b14c_coins_pct_min_rp | double |  |
| pbp_b14c_coins_pct_min_sc | double |  |
| pbp_b14c_coins_pct_min_sce | double |  |
| pbp_b14c_coins_pct_min_thmg | double |  |
| pbp_b14c_coins_pct_min_tm | double |  |
| pbp_b14c_coins_pct_min_wig | double |  |
| pbp_b14c_coins_pct_min_wm | double |  |
| pbp_b14c_coins_pct_nhl | double |  |
| pbp_b14c_coins_pct_ntb | double |  |
| pbp_b14c_coins_pct_sc | double |  |
| pbp_b14c_coins_pct_tm | double |  |
| pbp_b14c_coins_pct_wpt | double |  |
| pbp_b14c_coins_yn | string |  |
| pbp_b14c_combined_ben | string |  |
| pbp_b14c_copay_at_max_amt | double |  |
| pbp_b14c_copay_at_min_amt | double |  |
| pbp_b14c_copay_bsd_max_amt | double |  |
| pbp_b14c_copay_bsd_min_amt | double |  |
| pbp_b14c_copay_cs_max_amt | double |  |
| pbp_b14c_copay_cs_min_amt | double |  |
| pbp_b14c_copay_edm_amt | double |  |
| pbp_b14c_copay_edm_max_amt | double |  |
| pbp_b14c_copay_edm_min_amt | double |  |
| pbp_b14c_copay_ehc | string |  |
| pbp_b14c_copay_hec_amt | double |  |
| pbp_b14c_copay_hec_max_amt | double |  |
| pbp_b14c_copay_hec_min_amt | double |  |
| pbp_b14c_copay_imr_max_amt | double |  |
| pbp_b14c_copay_imr_min_amt | double |  |
| pbp_b14c_copay_isa_max_amt | double |  |
| pbp_b14c_copay_isa_min_amt | double |  |
| pbp_b14c_copay_max_amt_adcs | double |  |
| pbp_b14c_copay_max_amt_hbpc | double |  |
| pbp_b14c_copay_max_amt_ihss | double |  |
| pbp_b14c_copay_max_amt_sce | double |  |
| pbp_b14c_copay_max_amt_thmg | double |  |
| pbp_b14c_copay_mhc_max_amt | double |  |
| pbp_b14c_copay_mhc_min_amt | double |  |
| pbp_b14c_copay_min_amt_adcs | double |  |
| pbp_b14c_copay_min_amt_hbpc | double |  |
| pbp_b14c_copay_min_amt_ihss | double |  |
| pbp_b14c_copay_min_amt_sce | double |  |
| pbp_b14c_copay_min_amt_thmg | double |  |
| pbp_b14c_copay_mnt_max_amt | double |  |
| pbp_b14c_copay_mnt_min_amt | double |  |
| pbp_b14c_copay_nhl_amt | double |  |
| pbp_b14c_copay_ntb_amt | double |  |
| pbp_b14c_copay_ntb_max_amt | double |  |
| pbp_b14c_copay_ntb_min_amt | double |  |
| pbp_b14c_copay_prs_max_amt | double |  |
| pbp_b14c_copay_prs_min_amt | double |  |
| pbp_b14c_copay_rat_max_amt | double |  |
| pbp_b14c_copay_rat_min_amt | double |  |
| pbp_b14c_copay_rat_nh_max_amt | double |  |
| pbp_b14c_copay_rat_nh_min_amt | double |  |
| pbp_b14c_copay_rat_wp_max_amt | double |  |
| pbp_b14c_copay_rat_wp_min_amt | double |  |
| pbp_b14c_copay_rp_max_amt | double |  |
| pbp_b14c_copay_rp_min_amt | double |  |
| pbp_b14c_copay_sc_amt | double |  |
| pbp_b14c_copay_sc_max_amt | double |  |
| pbp_b14c_copay_sc_min_amt | double |  |
| pbp_b14c_copay_tm_amt | double |  |
| pbp_b14c_copay_tm_max_amt | double |  |
| pbp_b14c_copay_tm_min_amt | double |  |
| pbp_b14c_copay_wig_max_amt | double |  |
| pbp_b14c_copay_wig_min_amt | double |  |
| pbp_b14c_copay_wm_max_amt | double |  |
| pbp_b14c_copay_wm_min_amt | double |  |
| pbp_b14c_copay_wpt_amt | double |  |
| pbp_b14c_copay_yn | string |  |
| pbp_b14c_ded_amt | double |  |
| pbp_b14c_ded_yn | string |  |
| pbp_b14c_maxenr_amt | double |  |
| pbp_b14c_maxenr_amt_adcs | double |  |
| pbp_b14c_maxenr_amt_at | double |  |
| pbp_b14c_maxenr_amt_bsd | double |  |
| pbp_b14c_maxenr_amt_cs | double |  |
| pbp_b14c_maxenr_amt_edm | double |  |
| pbp_b14c_maxenr_amt_hbpc | double |  |
| pbp_b14c_maxenr_amt_hec | double |  |
| pbp_b14c_maxenr_amt_ihss | double |  |
| pbp_b14c_maxenr_amt_imr | double |  |
| pbp_b14c_maxenr_amt_isa | double |  |
| pbp_b14c_maxenr_amt_mhc | double |  |
| pbp_b14c_maxenr_amt_mnt | double |  |
| pbp_b14c_maxenr_amt_ntb | double |  |
| pbp_b14c_maxenr_amt_prs | double |  |
| pbp_b14c_maxenr_amt_rat | double |  |
| pbp_b14c_maxenr_amt_rp | double |  |
| pbp_b14c_maxenr_amt_sc | double |  |
| pbp_b14c_maxenr_amt_sce | double |  |
| pbp_b14c_maxenr_amt_thmg | double |  |
| pbp_b14c_maxenr_amt_tm | double |  |
| pbp_b14c_maxenr_amt_wig | double |  |
| pbp_b14c_maxenr_amt_wm | double |  |
| pbp_b14c_maxenr_ehc | string |  |
| pbp_b14c_maxenr_per | string |  |
| pbp_b14c_maxenr_per_adcs | string |  |
| pbp_b14c_maxenr_per_adcs_d | string |  |
| pbp_b14c_maxenr_per_at | string |  |
| pbp_b14c_maxenr_per_at_d | string |  |
| pbp_b14c_maxenr_per_bsd | string |  |
| pbp_b14c_maxenr_per_bsd_d | string |  |
| pbp_b14c_maxenr_per_cs | string |  |
| pbp_b14c_maxenr_per_cs_d | string |  |
| pbp_b14c_maxenr_per_edm | string |  |
| pbp_b14c_maxenr_per_edm_d | string |  |
| pbp_b14c_maxenr_per_hbpc | string |  |
| pbp_b14c_maxenr_per_hbpc_d | string |  |
| pbp_b14c_maxenr_per_hec | string |  |
| pbp_b14c_maxenr_per_hec_d | string |  |
| pbp_b14c_maxenr_per_ihss | string |  |
| pbp_b14c_maxenr_per_ihss_d | string |  |
| pbp_b14c_maxenr_per_imr | string |  |
| pbp_b14c_maxenr_per_imr_d | string |  |
| pbp_b14c_maxenr_per_isa | string |  |
| pbp_b14c_maxenr_per_isa_d | string |  |
| pbp_b14c_maxenr_per_mhc | string |  |
| pbp_b14c_maxenr_per_mhc_d | string |  |
| pbp_b14c_maxenr_per_mnt | string |  |
| pbp_b14c_maxenr_per_mnt_d | string |  |
| pbp_b14c_maxenr_per_ntb | string |  |
| pbp_b14c_maxenr_per_ntb_d | string |  |
| pbp_b14c_maxenr_per_prs | string |  |
| pbp_b14c_maxenr_per_prs_d | string |  |
| pbp_b14c_maxenr_per_rat | string |  |
| pbp_b14c_maxenr_per_rat_d | string |  |
| pbp_b14c_maxenr_per_rp | string |  |
| pbp_b14c_maxenr_per_rp_d | string |  |
| pbp_b14c_maxenr_per_sc | string |  |
| pbp_b14c_maxenr_per_sc_d | string |  |
| pbp_b14c_maxenr_per_sce | string |  |
| pbp_b14c_maxenr_per_sce_d | string |  |
| pbp_b14c_maxenr_per_thmg | string |  |
| pbp_b14c_maxenr_per_thmg_d | string |  |
| pbp_b14c_maxenr_per_tm | string |  |
| pbp_b14c_maxenr_per_tm_d | string |  |
| pbp_b14c_maxenr_per_wig | string |  |
| pbp_b14c_maxenr_per_wig_d | string |  |
| pbp_b14c_maxenr_per_wm | string |  |
| pbp_b14c_maxenr_per_wm_d | string |  |
| pbp_b14c_maxenr_yn | string |  |
| pbp_b14c_maxplan_amt | double |  |
| pbp_b14c_maxplan_amt_adcs | double |  |
| pbp_b14c_maxplan_amt_at | double |  |
| pbp_b14c_maxplan_amt_bsd | double |  |
| pbp_b14c_maxplan_amt_cs | double |  |
| pbp_b14c_maxplan_amt_edm | double |  |
| pbp_b14c_maxplan_amt_hbpc | double |  |
| pbp_b14c_maxplan_amt_hec | double |  |
| pbp_b14c_maxplan_amt_ihss | double |  |
| pbp_b14c_maxplan_amt_imr | double |  |
| pbp_b14c_maxplan_amt_isa | double |  |
| pbp_b14c_maxplan_amt_mhc | double |  |
| pbp_b14c_maxplan_amt_mnt | double |  |
| pbp_b14c_maxplan_amt_ntb | double |  |
| pbp_b14c_maxplan_amt_prs | double |  |
| pbp_b14c_maxplan_amt_rat | double |  |
| pbp_b14c_maxplan_amt_rp | double |  |
| pbp_b14c_maxplan_amt_sc | double |  |
| pbp_b14c_maxplan_amt_sce | double |  |
| pbp_b14c_maxplan_amt_thms | double |  |
| pbp_b14c_maxplan_amt_tm | double |  |
| pbp_b14c_maxplan_amt_wig | double |  |
| pbp_b14c_maxplan_amt_wm | double |  |
| pbp_b14c_maxplan_ehc | string |  |
| pbp_b14c_maxplan_per | string |  |
| pbp_b14c_maxplan_per_adcs | string |  |
| pbp_b14c_maxplan_per_adcs_d | string |  |
| pbp_b14c_maxplan_per_at | string |  |
| pbp_b14c_maxplan_per_at_d | string |  |
| pbp_b14c_maxplan_per_bsd | string |  |
| pbp_b14c_maxplan_per_bsd_d | string |  |
| pbp_b14c_maxplan_per_cs | string |  |
| pbp_b14c_maxplan_per_cs_d | string |  |
| pbp_b14c_maxplan_per_edm | string |  |
| pbp_b14c_maxplan_per_edm_d | string |  |
| pbp_b14c_maxplan_per_hbpc | string |  |
| pbp_b14c_maxplan_per_hbpc_d | string |  |
| pbp_b14c_maxplan_per_hec | string |  |
| pbp_b14c_maxplan_per_hec_d | string |  |
| pbp_b14c_maxplan_per_ihss | string |  |
| pbp_b14c_maxplan_per_ihss_d | string |  |
| pbp_b14c_maxplan_per_imr | string |  |
| pbp_b14c_maxplan_per_imr_d | string |  |
| pbp_b14c_maxplan_per_isa | string |  |
| pbp_b14c_maxplan_per_isa_d | string |  |
| pbp_b14c_maxplan_per_mhc | string |  |
| pbp_b14c_maxplan_per_mhc_d | string |  |
| pbp_b14c_maxplan_per_mnt | string |  |
| pbp_b14c_maxplan_per_mnt_d | string |  |
| pbp_b14c_maxplan_per_ntb | string |  |
| pbp_b14c_maxplan_per_ntb_d | string |  |
| pbp_b14c_maxplan_per_prs | string |  |
| pbp_b14c_maxplan_per_prs_d | string |  |
| pbp_b14c_maxplan_per_rat | string |  |
| pbp_b14c_maxplan_per_rat_d | string |  |
| pbp_b14c_maxplan_per_rp | string |  |
| pbp_b14c_maxplan_per_rp_d | string |  |
| pbp_b14c_maxplan_per_sc | string |  |
| pbp_b14c_maxplan_per_sc_d | string |  |
| pbp_b14c_maxplan_per_sce | string |  |
| pbp_b14c_maxplan_per_sce_d | string |  |
| pbp_b14c_maxplan_per_thms | string |  |
| pbp_b14c_maxplan_per_thms_d | string |  |
| pbp_b14c_maxplan_per_tm | string |  |
| pbp_b14c_maxplan_per_tm_d | string |  |
| pbp_b14c_maxplan_per_wig | string |  |
| pbp_b14c_maxplan_per_wig_d | string |  |
| pbp_b14c_maxplan_per_wm | string |  |
| pbp_b14c_maxplan_per_wm_d | string |  |
| pbp_b14c_maxplan_yn | string |  |
| pbp_b14c_mnt_mcd_num | string |  |
| pbp_b14c_mnt_mcd_unit | string |  |
| pbp_b14c_mnt_mcd_unit_d | string |  |
| pbp_b14c_mnt_mcd_yn | string |  |
| pbp_b14c_mnt_nmcd_num | string |  |
| pbp_b14c_mnt_nmcd_unit | string |  |
| pbp_b14c_mnt_nmcd_yn | string |  |
| pbp_b14c_rat_bendesc_ehc | string |  |
| pbp_b14c_refer_yn | string |  |
| pbp_b14c_rp_bendesc_ehc | string |  |
| pbp_b14c_rp_bendesc_other | string |  |
| pbp_b14c_rp_days | double |  |
| pbp_b14c_rp_max_meals | double |  |
| pbp_b14c_rp_other_yn | string |  |
| pbp_b14c_sce_note | string |  |
| pbp_b14c_sce_type_chk | string |  |
| pbp_b14c_thp_msg_num_amt | double |  |
| pbp_b14c_thp_msg_period | string |  |
| pbp_b14c_thp_msg_period_d | string |  |
| pbp_b14c_thp_msg_unlimited | string |  |
| pbp_b14d_auth | string |  |
| pbp_b14d_auth_yn | string |  |
| pbp_b14d_coins_mc_max_pct | double |  |
| pbp_b14d_coins_mc_min_pct | double |  |
| pbp_b14d_coins_yn | string |  |
| pbp_b14d_copay_mc_max_amt | double |  |
| pbp_b14d_copay_mc_min_amt | double |  |
| pbp_b14d_copay_yn | string |  |
| pbp_b14d_ded_amt | double |  |
| pbp_b14d_ded_yn | string |  |
| pbp_b14d_maxenr_amt | double |  |
| pbp_b14d_maxenr_per | string |  |
| pbp_b14d_maxenr_per_d | string |  |
| pbp_b14d_maxenr_yn | string |  |
| pbp_b14d_refer_yn | string |  |
| pbp_b14e_auth | string |  |
| pbp_b14e_auth_diab | string |  |
| pbp_b14e_auth_glauc | string |  |
| pbp_b14e_auth_other1 | string |  |
| pbp_b14e_auth_other2 | string |  |
| pbp_b14e_auth_other3 | string |  |
| pbp_b14e_auth_other4 | string |  |
| pbp_b14e_auth_other5 | string |  |
| pbp_b14e_auth_yn_bar | string |  |
| pbp_b14e_auth_yn_diab | string |  |
| pbp_b14e_auth_yn_dre | string |  |
| pbp_b14e_auth_yn_ekg | string |  |
| pbp_b14e_auth_yn_glauc | string |  |
| pbp_b14e_auth_yn_other | string |  |
| pbp_b14e_coins_ehc | string |  |
| pbp_b14e_coins_max_pct | double |  |
| pbp_b14e_coins_pct | double |  |
| pbp_b14e_coins_pct_max_bar | double |  |
| pbp_b14e_coins_pct_max_diab | double |  |
| pbp_b14e_coins_pct_max_dre | double |  |
| pbp_b14e_coins_pct_max_ekg | double |  |
| pbp_b14e_coins_pct_max_glauc | double |  |
| pbp_b14e_coins_pct_max_other | double |  |
| pbp_b14e_coins_pct_max_other1 | double |  |
| pbp_b14e_coins_pct_max_other2 | double |  |
| pbp_b14e_coins_pct_max_other3 | double |  |
| pbp_b14e_coins_pct_max_other4 | double |  |
| pbp_b14e_coins_pct_max_other5 | double |  |
| pbp_b14e_coins_pct_min_bar | double |  |
| pbp_b14e_coins_pct_min_diab | double |  |
| pbp_b14e_coins_pct_min_dre | double |  |
| pbp_b14e_coins_pct_min_ekg | double |  |
| pbp_b14e_coins_pct_min_glauc | double |  |
| pbp_b14e_coins_pct_min_other | double |  |
| pbp_b14e_coins_pct_min_other1 | double |  |
| pbp_b14e_coins_pct_min_other2 | double |  |
| pbp_b14e_coins_pct_min_other3 | double |  |
| pbp_b14e_coins_pct_min_other4 | double |  |
| pbp_b14e_coins_pct_min_other5 | double |  |
| pbp_b14e_coins_yn | string |  |
| pbp_b14e_copay_amt_max_bar | double |  |
| pbp_b14e_copay_amt_max_diab | double |  |
| pbp_b14e_copay_amt_max_dre | double |  |
| pbp_b14e_copay_amt_max_ekg | double |  |
| pbp_b14e_copay_amt_max_glauc | double |  |
| pbp_b14e_copay_amt_max_other | double |  |
| pbp_b14e_copay_amt_max_other1 | double |  |
| pbp_b14e_copay_amt_max_other2 | double |  |
| pbp_b14e_copay_amt_max_other3 | double |  |
| pbp_b14e_copay_amt_max_other4 | double |  |
| pbp_b14e_copay_amt_max_other5 | double |  |
| pbp_b14e_copay_amt_min_bar | double |  |
| pbp_b14e_copay_amt_min_diab | double |  |
| pbp_b14e_copay_amt_min_dre | double |  |
| pbp_b14e_copay_amt_min_ekg | double |  |
| pbp_b14e_copay_amt_min_glauc | double |  |
| pbp_b14e_copay_amt_min_other | double |  |
| pbp_b14e_copay_amt_min_other1 | double |  |
| pbp_b14e_copay_amt_min_other2 | double |  |
| pbp_b14e_copay_amt_min_other3 | double |  |
| pbp_b14e_copay_amt_min_other4 | double |  |
| pbp_b14e_copay_amt_min_other5 | double |  |
| pbp_b14e_copay_ehc | string |  |
| pbp_b14e_copay_mc_max_amt | double |  |
| pbp_b14e_copay_mc_min_amt | double |  |
| pbp_b14e_copay_yn | string |  |
| pbp_b14e_cost_share | string |  |
| pbp_b14e_cost_share_coins_max | double |  |
| pbp_b14e_cost_share_coins_min | double |  |
| pbp_b14e_cost_share_coins_yn | string |  |
| pbp_b14e_cost_share_copay_max | double |  |
| pbp_b14e_cost_share_copay_min | double |  |
| pbp_b14e_cost_share_copay_yn | string |  |
| pbp_b14e_ded_amt | double |  |
| pbp_b14e_ded_amt_bar | double |  |
| pbp_b14e_ded_amt_diab | double |  |
| pbp_b14e_ded_amt_dre | double |  |
| pbp_b14e_ded_amt_ekg | double |  |
| pbp_b14e_ded_amt_glauc | double |  |
| pbp_b14e_ded_amt_other | double |  |
| pbp_b14e_ded_amt_other1 | double |  |
| pbp_b14e_ded_amt_other2 | double |  |
| pbp_b14e_ded_amt_other3 | double |  |
| pbp_b14e_ded_amt_other4 | double |  |
| pbp_b14e_ded_amt_other5 | double |  |
| pbp_b14e_ded_ehc | string |  |
| pbp_b14e_ded_yn | string |  |
| pbp_b14e_maxenr_amt | double |  |
| pbp_b14e_maxenr_amt_bar | double |  |
| pbp_b14e_maxenr_amt_diab | double |  |
| pbp_b14e_maxenr_amt_dre | double |  |
| pbp_b14e_maxenr_amt_ekg | double |  |
| pbp_b14e_maxenr_amt_glauc | double |  |
| pbp_b14e_maxenr_amt_other | double |  |
| pbp_b14e_maxenr_amt_other1 | double |  |
| pbp_b14e_maxenr_amt_other2 | double |  |
| pbp_b14e_maxenr_amt_other3 | double |  |
| pbp_b14e_maxenr_amt_other4 | double |  |
| pbp_b14e_maxenr_amt_other5 | double |  |
| pbp_b14e_maxenr_ehc | string |  |
| pbp_b14e_maxenr_per | string |  |
| pbp_b14e_maxenr_per_bar | string |  |
| pbp_b14e_maxenr_per_bar_d | string |  |
| pbp_b14e_maxenr_per_diab | string |  |
| pbp_b14e_maxenr_per_diab_d | string |  |
| pbp_b14e_maxenr_per_dre | string |  |
| pbp_b14e_maxenr_per_dre_d | string |  |
| pbp_b14e_maxenr_per_ekg | string |  |
| pbp_b14e_maxenr_per_ekg_d | string |  |
| pbp_b14e_maxenr_per_glauc | string |  |
| pbp_b14e_maxenr_per_glauc_d | string |  |
| pbp_b14e_maxenr_per_other | string |  |
| pbp_b14e_maxenr_per_other1 | string |  |
| pbp_b14e_maxenr_per_other2 | string |  |
| pbp_b14e_maxenr_per_other3 | string |  |
| pbp_b14e_maxenr_per_other4 | string |  |
| pbp_b14e_maxenr_per_other5 | string |  |
| pbp_b14e_maxenr_yn | string |  |
| pbp_b14e_other1_name | string |  |
| pbp_b14e_other2_name | string |  |
| pbp_b14e_other3_name | string |  |
| pbp_b14e_other4_name | string |  |
| pbp_b14e_other5_name | string |  |
| pbp_b14e_other_yn | string |  |
| pbp_b14e_others_ehc | string |  |
| pbp_b14e_refer_ehc | string |  |
| pbp_b14e_refer_yn | string |  |
| observed_period | date | Date = Jan 1 of report_year (the benefit-year start as observed). Redundant with effective_period_start in practice. |
| asserted_at | date | Date Vlada ingested/asserted this snapshot (May 2026 batch). Q1 rows asserted 2026-05-16; Q2/Q3/Q4 rows asserted 2026-05-20. It is the load date, NOT a benefit date — do not confuse with effective period. |
| effective_period_start | date | Date the benefit year begins = Jan 1 of report_year (profiler's chosen time_column; earliest 2001-01-01, latest 2026-01-01). 1:1 with report_year. |
| effective_period_end | date | Date the benefit year ends = Dec 31 of report_year. Together with start gives the annual coverage window. |
| cms_vintage_sequence | int | Internal ingestion ordering int (1-4). Loosely tracks quarter but NOT clean 1:1 (Q1 carries vintages 1, 2 and 4). Do not use as the snapshot key — use quarter. Used with cps+effstart it yields 186,188 (<total), so it is also not a clean grain component. |
| parse_revision | int | Parser code revision (int, values 1-2). Provenance only. Older Q1 bulk = rev 1; later batches = rev 2. |
| parser_artifact_hash | string | Hash of the parser artifact that produced the row (string). 38 distinct = exactly one per (report_year, quarter) source file. Provenance. |
| source_url | string | URL of the CMS PBP source file the row was parsed from. 38 distinct = one per (year, quarter) snapshot. Provenance / lineage. |
| sha256_content_hash | string | SHA-256 of the source file content (string). 38 distinct, 1:1 with source_url and parser_artifact_hash — confirms each (year,quarter) is a single source file/snapshot. Provenance/dedup anchor. |
| pbp_b14a_auth_pos | string |  |
| pbp_b14a_bendec_ehc | string |  |
| pbp_b14a_bendec_yesno | string |  |
| pbp_b14a_bendesc_amo_amp | string |  |
| pbp_b14a_bendesc_amo_chp | string |  |
| pbp_b14a_bendesc_amo_dsm | string |  |
| pbp_b14a_bendesc_amo_hec | string |  |
| pbp_b14a_bendesc_amo_mhc | string |  |
| pbp_b14a_bendesc_amo_nhl | string |  |
| pbp_b14a_bendesc_amo_nl | string |  |
| pbp_b14a_bendesc_amo_ntb | string |  |
| pbp_b14a_bendesc_amo_ntv | string |  |
| pbp_b14a_bendesc_amo_oth | string |  |
| pbp_b14a_bendesc_amo_sc | string |  |
| pbp_b14a_bendesc_ehc | string |  |
| pbp_b14a_bendesc_yn | string |  |
| pbp_b14a_coins_cov__pos | string |  |
| pbp_b14a_coins_cov_amp | string |  |
| pbp_b14a_coins_cov_chp | string |  |
| pbp_b14a_coins_cov_dsm | string |  |
| pbp_b14a_coins_cov_hec | string |  |
| pbp_b14a_coins_cov_mhc | string |  |
| pbp_b14a_coins_cov_nhl | string |  |
| pbp_b14a_coins_cov_nl | string |  |
| pbp_b14a_coins_cov_ntb | string |  |
| pbp_b14a_coins_cov_ntv | string |  |
| pbp_b14a_coins_cov_oth | string |  |
| pbp_b14a_coins_cov_sc | string |  |
| pbp_b14a_coins_cov_sc_mdcr | string |  |
| pbp_b14a_coins_yesno | string |  |
| pbp_b14a_coins_yesno_pos | string |  |
| pbp_b14a_coins_yn | string |  |
| pbp_b14a_copay_yesno | string |  |
| pbp_b14a_copay_yesno_pos | string |  |
| pbp_b14a_copay_yn | string |  |
| pbp_b14a_ded_yesno | string |  |
| pbp_b14a_ded_yesno_pos | string |  |
| pbp_b14a_ded_yn | string |  |
| pbp_b14a_maxenr_per | string |  |
| pbp_b14a_maxenr_yesno | string |  |
| pbp_b14a_maxenr_yn | string |  |
| pbp_b14a_maxenr_yn_pos | string |  |
| pbp_b14a_maxplan_covb | string |  |
| pbp_b14a_maxplan_per | string |  |
| pbp_b14a_maxplan_yesno | string |  |
| pbp_b14a_maxplan_yesno_pos | string |  |
| pbp_b14a_maxplan_yn | string |  |
| pbp_b14a_maxpln_cov_pos | string |  |
| pbp_b14a_maxpln_per_pos | string |  |
| pbp_b14b_auth_pos | string |  |
| pbp_b14b_bendesc | string |  |
| pbp_b14b_bendesc_amo | string |  |
| pbp_b14b_bendesc_yesno | string |  |
| pbp_b14b_coins_cov__pos | string |  |
| pbp_b14b_coins_cov_mc | string |  |
| pbp_b14b_coins_cov_oi | string |  |
| pbp_b14b_coins_yesno | string |  |
| pbp_b14b_coins_yesno_pos | string |  |
| pbp_b14b_copay_yesno | string |  |
| pbp_b14b_copay_yesno_pos | string |  |
| pbp_b14b_cost_share | string |  |
| pbp_b14b_ded_yesno | string |  |
| pbp_b14b_ded_yesno_pos | string |  |
| pbp_b14b_maxenr_type | string |  |
| pbp_b14b_maxenr_type_pos | string |  |
| pbp_b14b_maxenr_yesno | string |  |
| pbp_b14b_maxenr_yesno_pos | string |  |
| pbp_b14b_maxplan_type_pos | string |  |
| pbp_b14b_maxplan_yesno_pos | string |  |
| pbp_b14b_maxpln_cov_pos | string |  |
| pbp_b14b_maxpln_per_pos | string |  |
| pbp_b14c_auth_pos | string |  |
| pbp_b14c_bendesc_amo | string |  |
| pbp_b14c_bendesc_enhan | string |  |
| pbp_b14c_bendesc_lim | string |  |
| pbp_b14c_bendesc_per | string |  |
| pbp_b14c_bendesc_yesno | string |  |
| pbp_b14c_coins_cov | string |  |
| pbp_b14c_coins_cov__pos | string |  |
| pbp_b14c_coins_yesno | string |  |
| pbp_b14c_coins_yesno_pos | string |  |
| pbp_b14c_copay_yesno | string |  |
| pbp_b14c_copay_yesno_pos | string |  |
| pbp_b14c_cost_share | string |  |
| pbp_b14c_ded_yesno | string |  |
| pbp_b14c_ded_yesno_pos | string |  |
| pbp_b14c_maxenr_type | string |  |
| pbp_b14c_maxenr_type_pos | string |  |
| pbp_b14c_maxenr_yesno | string |  |
| pbp_b14c_maxenr_yesno_pos | string |  |
| pbp_b14c_maxplan_cov | string |  |
| pbp_b14c_maxplan_type | string |  |
| pbp_b14c_maxplan_type_pos | string |  |
| pbp_b14c_maxplan_yesno | string |  |
| pbp_b14c_maxplan_yesno_pos | string |  |
| pbp_b14c_maxpln_cov_pos | string |  |
| pbp_b14c_maxpln_per_pos | string |  |
| pbp_b14d_auth_pos | string |  |
| pbp_b14d_bendesc_amo_pe | string |  |
| pbp_b14d_bendesc_amo_ps | string |  |
| pbp_b14d_bendesc_enhan | string |  |
| pbp_b14d_bendesc_lim_ape_yn | string |  |
| pbp_b14d_bendesc_lim_aps_yn | string |  |
| pbp_b14d_bendesc_pe_per | string |  |
| pbp_b14d_bendesc_ps_per | string |  |
| pbp_b14d_bendesc_yesno | string |  |
| pbp_b14d_bendesc_yn | string |  |
| pbp_b14d_coins_cov__pos | string |  |
| pbp_b14d_coins_cov_mcpap | string |  |
| pbp_b14d_coins_cov_mcpe | string |  |
| pbp_b14d_coins_cov_pap | string |  |
| pbp_b14d_coins_cov_pe | string |  |
| pbp_b14d_coins_yesno | string |  |
| pbp_b14d_coins_yesno_pos | string |  |
| pbp_b14d_copay_yesno | string |  |
| pbp_b14d_copay_yesno_pos | string |  |
| pbp_b14d_cost_share | string |  |
| pbp_b14d_ded_yesno | string |  |
| pbp_b14d_ded_yesno_pos | string |  |
| pbp_b14d_maxenr_type | string |  |
| pbp_b14d_maxenr_type_pos | string |  |
| pbp_b14d_maxenr_yesno | string |  |
| pbp_b14d_maxenr_yesno_pos | string |  |
| pbp_b14d_maxplan_cov | string |  |
| pbp_b14d_maxplan_per | string |  |
| pbp_b14d_maxplan_type | string |  |
| pbp_b14d_maxplan_type_pos | string |  |
| pbp_b14d_maxplan_yesno | string |  |
| pbp_b14d_maxplan_yesno_pos | string |  |
| pbp_b14d_maxplan_yn | string |  |
| pbp_b14d_maxpln_cov_pos | string |  |
| pbp_b14d_maxpln_per_pos | string |  |
| pbp_b14d_sep_cost_yn | string |  |
| pbp_b14a_coins_amp_pct | double |  |
| pbp_b14a_coins_chp_pct | double |  |
| pbp_b14a_coins_dsm_pct | double |  |
| pbp_b14a_coins_hec_pct | double |  |
| pbp_b14a_coins_mhc_pct | double |  |
| pbp_b14a_coins_nhl_pct | double |  |
| pbp_b14a_coins_nl_pct | double |  |
| pbp_b14a_coins_ntb_pct | double |  |
| pbp_b14a_coins_ntv_pct | double |  |
| pbp_b14a_coins_oth_pct | double |  |
| pbp_b14a_coins_pct_amp | double |  |
| pbp_b14a_coins_pct_chp | double |  |
| pbp_b14a_coins_pct_dsm | double |  |
| pbp_b14a_coins_pct_hec | double |  |
| pbp_b14a_coins_pct_max_amp | double |  |
| pbp_b14a_coins_pct_max_dsm | double |  |
| pbp_b14a_coins_pct_max_hec | double |  |
| pbp_b14a_coins_pct_max_mhc | double |  |
| pbp_b14a_coins_pct_max_oth | double |  |
| pbp_b14a_coins_pct_mhc | double |  |
| pbp_b14a_coins_pct_nhl | double |  |
| pbp_b14a_coins_pct_nl | double |  |
| pbp_b14a_coins_pct_ntb | double |  |
| pbp_b14a_coins_pct_ntv | double |  |
| pbp_b14a_coins_pct_oth | double |  |
| pbp_b14a_coins_pct_pos | double |  |
| pbp_b14a_coins_pct_prpdisc_pos | double |  |
| pbp_b14a_coins_pct_sc | double |  |
| pbp_b14a_coins_pctmax_amp | double |  |
| pbp_b14a_coins_pctmax_dsm | double |  |
| pbp_b14a_coins_pctmax_hec | double |  |
| pbp_b14a_coins_pctmax_mhc | double |  |
| pbp_b14a_coins_pctmax_oth | double |  |
| pbp_b14a_coins_pctmax_pos | double |  |
| pbp_b14a_coins_sc_mdcr_pct | double |  |
| pbp_b14a_coins_sc_mdcr_pct_max | double |  |
| pbp_b14a_coins_sc_mdcr_pct_min | double |  |
| pbp_b14a_coins_sc_pct | double |  |
| pbp_b14a_copay_amp_amt | double |  |
| pbp_b14a_copay_amp_amtmax | double |  |
| pbp_b14a_copay_amp_max_amt | double |  |
| pbp_b14a_copay_amt_pos | double |  |
| pbp_b14a_copay_amtmax_pos | double |  |
| pbp_b14a_copay_chp_amt | double |  |
| pbp_b14a_copay_dsm_amt | double |  |
| pbp_b14a_copay_dsm_amtmax | double |  |
| pbp_b14a_copay_dsm_max_amt | double |  |
| pbp_b14a_copay_hec_amt | double |  |
| pbp_b14a_copay_hec_max_amt | double |  |
| pbp_b14a_copay_mhc_amt | double |  |
| pbp_b14a_copay_mhc_amtmax | double |  |
| pbp_b14a_copay_mhc_max_amt | double |  |
| pbp_b14a_copay_nhl_amt | double |  |
| pbp_b14a_copay_nl_amt | double |  |
| pbp_b14a_copay_ntb_amt | double |  |
| pbp_b14a_copay_ntv_amt | double |  |
| pbp_b14a_copay_oth_amt | double |  |
| pbp_b14a_copay_oth_max_amt | double |  |
| pbp_b14a_copay_oth_maxamt | double |  |
| pbp_b14a_copay_sc_amt | double |  |
| pbp_b14a_copay_sc_mdcr_amt_max | double |  |
| pbp_b14a_copay_sc_mdcr_amt_min | double |  |
| pbp_b14a_ded_amt | double |  |
| pbp_b14a_ded_amt_pos | double |  |
| pbp_b14a_maxenr_amt | double |  |
| pbp_b14a_maxenr_amt_pos | double |  |
| pbp_b14a_maxplan_amt | double |  |
| pbp_b14a_maxplan_pct | double |  |
| pbp_b14a_maxpln_amt_pos | double |  |
| pbp_b14a_maxpln_pct_prpdis_pos | double |  |
| pbp_b14b_coins_pct_mc | double |  |
| pbp_b14b_coins_pct_oi | double |  |
| pbp_b14b_coins_pct_pos | double |  |
| pbp_b14b_coins_pctmax_pos | double |  |
| pbp_b14b_copay_amt_pos | double |  |
| pbp_b14b_copay_amtmax_pos | double |  |
| pbp_b14b_copay_mc_amt | double |  |
| pbp_b14b_copay_oi_amt | double |  |
| pbp_b14b_copay_oi_maxamt | double |  |
| pbp_b14b_cost_share_coins_max | double |  |
| pbp_b14b_cost_share_coins_min | double |  |
| pbp_b14b_cost_share_coins_yn | string |  |
| pbp_b14b_cost_share_copay_max | double |  |
| pbp_b14b_cost_share_copay_min | double |  |
| pbp_b14b_cost_share_copay_yn | string |  |
| pbp_b14b_ded_amt_pos | double |  |
| pbp_b14b_maxenr_amt_pos | double |  |
| pbp_b14b_maxpln_amt_pos | double |  |
| pbp_b14c_bendesc_numv | double |  |
| pbp_b14c_coins_pct | double |  |
| pbp_b14c_coins_pct_pos | double |  |
| pbp_b14c_copay_amt | double |  |
| pbp_b14c_copay_amt_pos | double |  |
| pbp_b14c_cost_share_coins_max | double |  |
| pbp_b14c_cost_share_coins_min | double |  |
| pbp_b14c_cost_share_coins_yn | string |  |
| pbp_b14c_cost_share_copay_max | double |  |
| pbp_b14c_cost_share_copay_min | double |  |
| pbp_b14c_cost_share_copay_yn | string |  |
| pbp_b14c_ded_amt_pos | double |  |
| pbp_b14c_maxenr_amt_pos | double |  |
| pbp_b14c_maxpln_amt_pos | double |  |
| pbp_b14c_mc_coins_pct | double |  |
| pbp_b14c_mc_copay_amt | double |  |
| pbp_b14d_bendesc_numpe | double |  |
| pbp_b14d_bendesc_numps | double |  |
| pbp_b14d_coins_pct_mcpap | double |  |
| pbp_b14d_coins_pct_mcpe | double |  |
| pbp_b14d_coins_pct_pap | double |  |
| pbp_b14d_coins_pct_pe | double |  |
| pbp_b14d_coins_pct_pos | double |  |
| pbp_b14d_coins_pctmax_pos | double |  |
| pbp_b14d_copay_amt_mcpap | double |  |
| pbp_b14d_copay_amt_mcpe | double |  |
| pbp_b14d_copay_amt_pap | double |  |
| pbp_b14d_copay_amt_pe | double |  |
| pbp_b14d_copay_amt_pos | double |  |
| pbp_b14d_copay_amtmax_pos | double |  |
| pbp_b14d_cost_share_coins_max | double |  |
| pbp_b14d_cost_share_coins_min | double |  |
| pbp_b14d_cost_share_coins_yn | string |  |
| pbp_b14d_cost_share_copay_max | double |  |
| pbp_b14d_cost_share_copay_min | double |  |
| pbp_b14d_cost_share_copay_yn | string |  |
| pbp_b14d_cost_share_yn | string |  |
| pbp_b14d_ded_amt_pos | double |  |
| pbp_b14d_maxenr_amt_pos | double |  |
| pbp_b14d_maxplan_amt | double |  |
| pbp_b14d_maxplan_pct | double |  |
| pbp_b14d_maxpln_amt_pos | double |  |
| pbp_b14a_* (123 cols) |  | Subsection B-14a = Medicare-covered preventive services that the plan must offer at $0 enrollee cost share. Holds attestation + authorization/referral flags. pbp_b14a_mc_prevent_attest='1' means plan attests zero-cost-share preventive coverage; pbp_b14a_auth_yn / refer_yn use 1=Yes,2=No (most plans=2, no auth/referral). Largely flags, minimal dollar data. |
| pbp_b14b_* (117 cols) |  | Subsection B-14b = routine/supplemental preventive exams (e.g. routine physical exam 'rpe', annual physical 'ape'/'ame'). Cost-sharing columns: *_copay_amt (dollars), *_coins_pct (percent), with _min/_max range variants (e.g. pbp_b14b_copay_amt_rpe_min/max). Observed routine-physical copay $0 median up to $20. |
| pbp_b14c_* (357 cols, largest) |  | Subsection B-14c = supplemental (non-Medicare) health & wellness services. Each service has a ~3-letter tag: mhc=mental-health counseling, rat=routine transportation, bsd=bundled supplemental, hec=health education, sc=smoking cessation, wig=wig, sce, etc. Columns: copay_<tag>_min/max_amt ($), coins pct, and maxplan_amt_<tag> = annual plan-coverage dollar cap (e.g. wig cap $400 median, $1,000 max; mental-health counseling copay $0-$250). Periodicity/yes-no/type sub-fields per service. |
| pbp_b14d_* (77 cols) |  | Subsection B-14d = Medicare-covered ('mc') preventive cost sharing where the plan DOES apply cost share. pbp_b14d_coins_mc_min/max_pct (percent) and pbp_b14d_copay_mc_min/max_amt (dollars). ~2,500-2,650 plans populate it in 2025. |
| pbp_b14e_* (127 cols) |  | Subsection B-14e = specific Medicare-covered preventive screenings with per-service cost share: tags bar=bone-mass/bone-density, diab=diabetes, glauc=glaucoma, ekg=EKG, dre=digital-rectal-exam. copay_amt_min/max_<tag> ($) and coins_pct_min/max_<tag> (%). E.g. diabetes screening $0 copay median, 20% coinsurance median (up to 35%). |

Tools that read it: get_pbp_benefit

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.pbp_section_b14_preventive WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.pbp_section_b14_preventive")` first.