# Vlada benefit vector, every MA plan's filed benefit design, one row per plan-segment-year, 2015 to 2026

`medicare_semantic.vw_benefit_vector` · Medicare Advantage, Part D, Medicaid · status live · 72,414 rows

The one defined benefit set for analysis (Ben 2026-09-28; Benefits lane CH): the PBP filing of record read by the platform's own rule into 63 metrics from primary care to the OTC card, each with a status column (a NULL is never $0), the D-SNP design headline with <metric>__dual_effective on the Medicare A/B cost shares, the five clocks (benefit_design_year, rebate_payment_year, stars_rating_year_paid, enrollment_weight_month), product_type as one column, market and is_employer_group, plan_enrollment, prev_contract_plans from the crosswalk and yoy_break_metrics. Reproduces the platform's national series to the cent (10 of 33,488 fields differ; two 2024 plans where the vector is right per segment). Registry ops/sb_llm/benefit_vector_registry.yaml; doc docs/skills/pbp-semantics/BENEFIT-VECTOR.md.

**Grain.** One row per contract_id x plan_id x segment_id x report_year (2015-2026), 72,414 rows, 1,457 contracts, 243 columns (63 metrics each with <metric>__status; measured 2026-09-29, Athena ae557f34). The pointer follows the current version (v20260929g, promoted 13:53Z, a deterministic build with the pre-2019 fills; 2019-2026 identical to e); S (PDP) contracts excluded.

| column | type | meaning |
|---|---|---|
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| report_year | int |  |
| plan_segment_key | string |  |
| benefit_design_year | int |  |
| rebate_payment_year | int |  |
| stars_rating_year_paid | int |  |
| stars_release_month_paid | string |  |
| stars_overall_paid | double |  |
| enrollment_weight_month | string |  |
| plan_name | string |  |
| org_name | string |  |
| org_marketing_name | string |  |
| parent_org | string |  |
| parent_org_labels | bigint |  |
| plan_type | string |  |
| filing_plan_type | string |  |
| snp_class | varchar(6) |  |
| snp_class_source | varchar(16) |  |
| snp_type | string |  |
| filing_snp_type | string |  |
| dsnp_integration_status | string |  |
| dsnp_zero_dollar_filed | boolean |  |
| product_type | string |  |
| product_type_source | varchar(21) |  |
| part_d | varchar(4) |  |
| market | varchar(7) |  |
| is_employer_group | boolean |  |
| is_ma_type | boolean |  |
| states | array<string> |  |
| plan_enrollment | bigint |  |
| plan_enrollment_september | bigint |  |
| segments_in_plan | bigint |  |
| prev_contract_plans | array<string> |  |
| crosswalk_status | string |  |
| lineage_id | string |  |
| yoy_break_metrics | array<string> |  |
| primary_care | double |  |
| primary_care__status | varchar(18) |  |
| specialist | double |  |
| specialist__status | varchar(18) |  |
| telehealth | double |  |
| telehealth__status | varchar(18) |  |
| mental_health_ind | double |  |
| mental_health_ind__status | varchar(18) |  |
| mental_health_grp | double |  |
| mental_health_grp__status | varchar(18) |  |
| podiatry | double |  |
| podiatry__status | varchar(18) |  |
| preventive | double |  |
| preventive__status | varchar(18) |  |
| physical_exam | double |  |
| physical_exam__status | varchar(18) |  |
| inpatient | double |  |
| inpatient__status | varchar(18) |  |
| inpatient_stay | double |  |
| inpatient_stay__status | varchar(18) |  |
| inpatient_stay_share | double |  |
| inpatient_stay_share__status | varchar(17) |  |
| inpatient_psych | double |  |
| inpatient_psych__status | varchar(18) |  |
| inpatient_psych_stay | double |  |
| inpatient_psych_stay__status | varchar(18) |  |
| inpatient_psych_stay_share | double |  |
| inpatient_psych_stay_share__status | varchar(17) |  |
| snf | double |  |
| snf__status | varchar(18) |  |
| outpatient_hosp | double |  |
| outpatient_hosp__status | varchar(18) |  |
| observation | double |  |
| observation__status | varchar(18) |  |
| observation_stay | double |  |
| observation_stay__status | varchar(18) |  |
| observation_stay_share | double |  |
| observation_stay_share__status | varchar(17) |  |
| partial_hosp | double |  |
| partial_hosp__status | varchar(18) |  |
| er | double |  |
| er__status | varchar(18) |  |
| urgent | double |  |
| urgent__status | varchar(18) |  |
| ambulance_ground | double |  |
| ambulance_ground__status | varchar(18) |  |
| ambulance_air | double |  |
| ambulance_air__status | varchar(18) |  |
| lab | double |  |
| lab__status | varchar(18) |  |
| radiology | double |  |
| radiology__status | varchar(18) |  |
| imaging_complex | double |  |
| imaging_complex__status | varchar(18) |  |
| radiation | double |  |
| radiation__status | varchar(18) |  |
| physical_therapy | double |  |
| physical_therapy__status | varchar(18) |  |
| occupational_therapy | double |  |
| occupational_therapy__status | varchar(18) |  |
| cardiac_rehab | double |  |
| cardiac_rehab__status | varchar(18) |  |
| pulmonary_rehab | double |  |
| pulmonary_rehab__status | varchar(18) |  |
| dme | double |  |
| dme__status | varchar(18) |  |
| prosthetics | double |  |
| prosthetics__status | varchar(18) |  |
| medical_supplies | double |  |
| medical_supplies__status | varchar(17) |  |
| home_health | double |  |
| home_health__status | varchar(18) |  |
| dialysis | double |  |
| dialysis__status | varchar(18) |  |
| partb_drugs | double |  |
| partb_drugs__status | varchar(18) |  |
| dental_comprehensive | double |  |
| dental_comprehensive__status | varchar(18) |  |
| dental_comprehensive__pooled_card_year | double |  |
| dental_comprehensive__item_copay | double |  |
| vision_eyewear | double |  |
| vision_eyewear__status | varchar(18) |  |
| vision_eyewear__pooled_card_year | double |  |
| vision_eyewear__item_copay | double |  |
| hearing_aids | double |  |
| hearing_aids__status | varchar(18) |  |
| hearing_aids__pooled_card_year | double |  |
| hearing_aids__item_copay | double |  |
| otc | double |  |
| otc__status | varchar(18) |  |
| otc__pooled_card_year | double |  |
| otc__item_copay | double |  |
| dental_comprehensive__filed_amount | double |  |
| dental_comprehensive__filed_period_code | string |  |
| vision_eyewear__filed_amount | double |  |
| vision_eyewear__filed_period_code | string |  |
| hearing_aids__filed_amount | double |  |
| hearing_aids__filed_period_code | string |  |
| otc__filed_amount | double |  |
| otc__filed_period_code | string |  |
| asc | double |  |
| asc__status | varchar(17) |  |
| asc__rows | bigint |  |
| eye_exam_medicare | double |  |
| eye_exam_medicare__status | varchar(17) |  |
| eye_exam_medicare__rows | bigint |  |
| hearing_exam_medicare | double |  |
| hearing_exam_medicare__status | varchar(17) |  |
| hearing_exam_medicare__rows | bigint |  |
| partd_tier1_copay | double |  |
| partd_tier1_copay__status | varchar(17) |  |
| partd_tier1_copay__rows | bigint |  |
| eye_exam_routine | double |  |
| eye_exam_routine__status | varchar(17) |  |
| eye_exam_routine__rows | bigint |  |
| hearing_exam_routine | double |  |
| hearing_exam_routine__status | varchar(17) |  |
| hearing_exam_routine__rows | bigint |  |
| partd_tier2_copay | double |  |
| partd_tier2_copay__status | varchar(17) |  |
| partd_tier2_copay__rows | bigint |  |
| partd_tier5_coins | double |  |
| partd_tier5_coins__status | varchar(17) |  |
| partd_tier5_coins__rows | bigint |  |
| partb_insulin | double |  |
| partb_insulin__status | varchar(17) |  |
| partb_insulin__rows | bigint |  |
| dental_preventive | double |  |
| dental_preventive__status | varchar(17) |  |
| dental_preventive__rows | bigint |  |
| partd_tier4_coins | double |  |
| partd_tier4_coins__status | varchar(17) |  |
| partd_tier4_coins__rows | bigint |  |
| chemo | double |  |
| chemo__status | varchar(17) |  |
| chemo__rows | bigint |  |
| eyewear_medicare | double |  |
| eyewear_medicare__status | varchar(17) |  |
| eyewear_medicare__rows | bigint |  |
| diag_tests | double |  |
| diag_tests__status | varchar(17) |  |
| diag_tests__rows | bigint |  |
| meals | double |  |
| meals__status | varchar(17) |  |
| meals__rows | bigint |  |
| premium | double |  |
| premium__status | varchar(16) |  |
| medical_deductible | double |  |
| medical_deductible__status | varchar(16) |  |
| medical_deductible__basis | string |  |
| medical_deductible_filed | double |  |
| medical_deductible_filed__status | varchar(17) |  |
| moop | double |  |
| moop__status | varchar(16) |  |
| partd_deductible | double |  |
| partd_deductible__status | varchar(16) |  |
| partb_giveback | double |  |
| partb_giveback__status | varchar(17) |  |
| dsnp_zero_dollar_view | int |  |
| primary_care__dual_effective | double |  |
| specialist__dual_effective | double |  |
| telehealth__dual_effective | double |  |
| mental_health_ind__dual_effective | double |  |
| mental_health_grp__dual_effective | double |  |
| podiatry__dual_effective | double |  |
| preventive__dual_effective | double |  |
| physical_exam__dual_effective | double |  |
| inpatient__dual_effective | double |  |
| inpatient_stay__dual_effective | double |  |
| inpatient_psych__dual_effective | double |  |
| inpatient_psych_stay__dual_effective | double |  |
| snf__dual_effective | double |  |
| outpatient_hosp__dual_effective | double |  |
| observation__dual_effective | double |  |
| observation_stay__dual_effective | double |  |
| partial_hosp__dual_effective | double |  |
| er__dual_effective | double |  |
| urgent__dual_effective | double |  |
| ambulance_ground__dual_effective | double |  |
| ambulance_air__dual_effective | double |  |
| lab__dual_effective | double |  |
| radiology__dual_effective | double |  |
| imaging_complex__dual_effective | double |  |
| radiation__dual_effective | double |  |
| physical_therapy__dual_effective | double |  |
| occupational_therapy__dual_effective | double |  |
| cardiac_rehab__dual_effective | double |  |
| pulmonary_rehab__dual_effective | double |  |
| dme__dual_effective | double |  |
| prosthetics__dual_effective | double |  |
| medical_supplies__dual_effective | double |  |
| home_health__dual_effective | double |  |
| dialysis__dual_effective | double |  |
| partb_drugs__dual_effective | double |  |
| asc__dual_effective | double |  |
| eye_exam_medicare__dual_effective | double |  |
| hearing_exam_medicare__dual_effective | double |  |
| partb_insulin__dual_effective | double |  |
| chemo__dual_effective | double |  |
| eyewear_medicare__dual_effective | double |  |
| diag_tests__dual_effective | double |  |
| moop__dual_effective | double |  |
| medical_deductible__dual_effective | double |  |
| medical_deductible_filed__dual_effective | double |  |
| vector_version | varchar(10) |  |
| premium__basis | string |  |
| moop__basis | varchar(11) |  |
| inpatient__medicare_defined_basis | string |  |
| inpatient_psych__medicare_defined_basis | string |  |
| snf__medicare_defined_basis | string |  |
| otc__pooled_group_amount | double |  |
| otc__pooled_group_period_code | string |  |
| vision_eyewear__pooled_group_amount | double |  |
| vision_eyewear__pooled_group_period_code | string |  |
| hearing_aids__pooled_group_amount | double |  |
| hearing_aids__pooled_group_period_code | string |  |
| vision_eyewear__tier_class | string |  |
| vision_eyewear__standard_annual | double |  |
| vision_eyewear__preferred_annual | double |  |
| vision_eyewear__preferred_vendor | string |  |
| vision_eyewear__filed_tier | varchar(14) |  |
| vision_eyewear__headline | double |  |
| vision_eyewear__headline_basis | varchar(27) |  |

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