# Vlada benefit vector v2 extension, 191 more benefit columns per plan-segment-year with a catalog status each

`medicare_semantic.vw_benefit_vector_v2_ext` · Medicare Advantage, Part D, Medicaid · status live · 90,464 rows

The catalog v2 extension of the benefit vector (Benefits lane CI, 2026-09-29): every MA benefit the catalog names beyond the 63 vector metrics (core medical cost shares, Part D and the insulin caps, supplemental benefits, SSBCI, VBID, D-SNP facts, money anchors), each column with a catalog status in ops/sb_llm/benefit_catalog_v2.yaml (trusted / filed_only / held / not_in_filing) that says whether the number is served with a tie to the filing, filed but not yet tied, held elsewhere, or not in the filing at all. Doc docs/skills/pbp-semantics/BENEFIT-CATALOG-V2.md.

**Grain.** One row per contract_id x plan_id x segment_id x report_year, 90,464 rows, report_year 2015-2027, 1,582 contracts, 187 columns (measured 2026-09-29, Athena 7c1728a2); exactly one row per live vector key 2015-2026, plus S contracts and 2027 Landscape keys the vector excludes. The pointer follows the current version (v20260929co, a materialized Parquet table behind it, 195 columns with 8 SNF filed-coinsurance columns added; a contract-year probe answers in about 2 s).

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| report_year | int |  |
| air_ambulance_copay | double |  |
| ambulance_ground_coins | double |  |
| pulmonary_rehab_coins | double |  |
| cardiac_rehab_coins | double |  |
| setpad_copay | double |  |
| setpad_coins | double |  |
| radiation_copay | double |  |
| imaging_complex_coins | double |  |
| radiology_coins | double |  |
| lab_coins | double |  |
| diag_tests_coins | double |  |
| dental_medicare_copay | double |  |
| dental_comp_coins | double |  |
| dental_medicare_coins | double |  |
| dental_comp_offered | int |  |
| dental_prev_offered | int |  |
| dental_comp_copay | double |  |
| dental_preventive_coins | double |  |
| dental_exams_limit | double |  |
| dental_cleanings_limit | double |  |
| supplies_copay | double |  |
| shoes_coins | double |  |
| shoes_copay | double |  |
| routine_podiatry_copay | double |  |
| physical_therapy_coins | double |  |
| occupational_therapy_coins | double |  |
| mental_health_ind_coins | double |  |
| specialist_coins | double |  |
| primary_care_coins | double |  |
| podiatry_coins | double |  |
| mental_health_grp_coins | double |  |
| routine_podiatry_coins | double |  |
| routine_podiatry_limit | double |  |
| hearing_aid_limit | double |  |
| hearing_exam_limit | double |  |
| hearing_exam_medicare_coins | double |  |
| otc_hearing_aid_copay | double |  |
| hearing_fitting_copay | double |  |
| hearing_fitting_limit | double |  |
| hearing_aids_offered | int |  |
| hearing_exam_offered | int |  |
| inpatient_coins | double |  |
| inpatient_unlimited_days | int |  |
| psych_days | double |  |
| inpatient_psych_coins | double |  |
| meals_offered | int |  |
| optional_premium | double |  |
| optional_max | double |  |
| otc_offered | int |  |
| substance_use_copay | double |  |
| outpatient_hosp_coins | double |  |
| asc_coins | double |  |
| observation_coins | double |  |
| substance_use_coins | double |  |
| partb_insulin_coins | double |  |
| chemo_copay | double |  |
| partb_insulin_month_max | double |  |
| partb_drugs_copay | double |  |
| partd_insulin_copay | double |  |
| partd_tier3_coins | double |  |
| partd_insulin_coins | double |  |
| partd_tier3_copay | double |  |
| partd_tier4_copay | double |  |
| partd_tier5_copay | double |  |
| partd_tier6_copay | double |  |
| partd_tier2_offered | int |  |
| partd_tier5_offered | int |  |
| preventive_coins | double |  |
| transport_copay | double |  |
| transport_offered | int |  |
| transport_trips_limit | double |  |
| eye_exam_limit | double |  |
| eye_exam_medicare_coins | double |  |
| eyewear_medicare_coins | double |  |
| eyewear_copay | double |  |
| contacts_copay | double |  |
| eye_exam_allowance | double |  |
| eyewear_limit | double |  |
| contacts_limit | double |  |
| eyewear_offered | int |  |
| partd_tier1_retail_preferred_1m_copay | double |  |
| partd_tier1_retail_preferred_1m_coins | double |  |
| partd_tier1_retail_standard_3m_copay | double |  |
| partd_tier1_retail_standard_3m_coins | double |  |
| partd_tier1_retail_preferred_3m_copay | double |  |
| partd_tier1_retail_preferred_3m_coins | double |  |
| partd_tier1_mail_standard_3m_copay | double |  |
| partd_tier1_mail_standard_3m_coins | double |  |
| partd_tier1_mail_preferred_3m_copay | double |  |
| partd_tier1_mail_preferred_3m_coins | double |  |
| partd_tier2_retail_preferred_1m_copay | double |  |
| partd_tier2_retail_preferred_1m_coins | double |  |
| partd_tier2_retail_standard_3m_copay | double |  |
| partd_tier2_retail_standard_3m_coins | double |  |
| partd_tier2_retail_preferred_3m_copay | double |  |
| partd_tier2_retail_preferred_3m_coins | double |  |
| partd_tier2_mail_standard_3m_copay | double |  |
| partd_tier2_mail_standard_3m_coins | double |  |
| partd_tier2_mail_preferred_3m_copay | double |  |
| partd_tier2_mail_preferred_3m_coins | double |  |
| partd_tier3_retail_preferred_1m_copay | double |  |
| partd_tier3_retail_preferred_1m_coins | double |  |
| partd_tier3_retail_standard_3m_copay | double |  |
| partd_tier3_retail_standard_3m_coins | double |  |
| partd_tier3_retail_preferred_3m_copay | double |  |
| partd_tier3_retail_preferred_3m_coins | double |  |
| partd_tier3_mail_standard_3m_copay | double |  |
| partd_tier3_mail_standard_3m_coins | double |  |
| partd_tier3_mail_preferred_3m_copay | double |  |
| partd_tier3_mail_preferred_3m_coins | double |  |
| partd_tier4_retail_preferred_1m_copay | double |  |
| partd_tier4_retail_preferred_1m_coins | double |  |
| partd_tier4_retail_standard_3m_copay | double |  |
| partd_tier4_retail_standard_3m_coins | double |  |
| partd_tier4_retail_preferred_3m_copay | double |  |
| partd_tier4_retail_preferred_3m_coins | double |  |
| partd_tier4_mail_standard_3m_copay | double |  |
| partd_tier4_mail_standard_3m_coins | double |  |
| partd_tier4_mail_preferred_3m_copay | double |  |
| partd_tier4_mail_preferred_3m_coins | double |  |
| partd_tier5_retail_preferred_1m_copay | double |  |
| partd_tier5_retail_preferred_1m_coins | double |  |
| partd_tier5_retail_standard_3m_copay | double |  |
| partd_tier5_retail_standard_3m_coins | double |  |
| partd_tier5_retail_preferred_3m_copay | double |  |
| partd_tier5_retail_preferred_3m_coins | double |  |
| partd_tier5_mail_standard_3m_copay | double |  |
| partd_tier5_mail_standard_3m_coins | double |  |
| partd_tier5_mail_preferred_3m_coins | double |  |
| partd_tier6_retail_preferred_1m_copay | double |  |
| partd_tier6_retail_standard_3m_copay | double |  |
| partd_tier6_retail_standard_3m_coins | double |  |
| partd_tier6_retail_preferred_3m_copay | double |  |
| partd_tier6_mail_standard_3m_copay | double |  |
| partd_tier6_mail_standard_3m_coins | double |  |
| partd_tier6_mail_preferred_3m_copay | double |  |
| worldwide_er_copay | double |  |
| worldwide_urgent_copay | double |  |
| worldwide_transport_copay | double |  |
| worldwide_cap | double |  |
| worldwide_cap_period | string |  |
| fitness_offered | int |  |
| fitness_copay | double |  |
| fitness_copay_basis | varchar(33) |  |
| fitness_max_annualized | double |  |
| fitness_type_physical | boolean |  |
| fitness_type_memory | boolean |  |
| fitness_type_activity_tracker | boolean |  |
| premium_part_c | double |  |
| premium_part_d_basic | double |  |
| premium_part_d_supplemental | double |  |
| premium_full_lis | double |  |
| moop_combined | double |  |
| moop_oon | double |  |
| medical_deductible_in_network | double |  |
| medical_deductible_oon | double |  |
| dsnp_state_covers_cost_share | string |  |
| ssbci_offered | boolean |  |
| ssbci_food_own_dollar_annual | double |  |
| ssbci_general_supports_own_dollar_annual | double |  |
| ssbci_package_pot | double |  |
| ssbci_food_offered | boolean |  |
| ssbci_general_supports_offered | boolean |  |
| ssbci_transportation_offered | boolean |  |
| ssbci_pest_control_offered | boolean |  |
| ssbci_indoor_air_offered | boolean |  |
| ssbci_social_needs_offered | boolean |  |
| ssbci_meals_offered | boolean |  |
| ssbci_home_modifications_offered | boolean |  |
| flex_card_pot | double |  |
| flex_card_period | varchar(18) |  |
| flex_card_includes_otc | boolean |  |
| flex_card_includes_food_or_utilities | boolean |  |
| flex_card_includes_dental | boolean |  |
| b19a_reduced_cost_sharing_package | boolean |  |
| b19b_additional_benefits_package | boolean |  |
| acupuncture_copay | double |  |
| pers_offered | boolean |  |
| in_home_support_offered | boolean |  |
| bathroom_safety_offered | boolean |  |
| nurse_line_offered | boolean |  |
| chiropractic_routine_copay | double |  |
| vbid_participant | int |  |
| snf_coins_interval1_begin_day | double |  |
| snf_coins_interval1_end_day | double |  |
| snf_coins_interval1_pct | double |  |
| snf_coins_interval2_begin_day | double |  |
| snf_coins_interval2_end_day | double |  |
| snf_coins_interval2_pct | double |  |
| snf_coins_interval_count | string |  |
| snf_coins_per_stay_pct | double |  |

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