# Vlada locked benefit engine atoms, version v20261006b (the table behind vw_benefit_engine_atoms)

`medicare_semantic.benefit_engine_atoms_v20261006b` · Medicare Advantage, Part D, Medicaid · status live · 802,687 rows

The versioned, immutable atom table of the locked benefit engine as locked on 2026-10-06 (rebuilt on benefit vector v20261006bb: the CY2025 in-network medical deductible read from the filing per plan segment; only the deductible columns of base 2025 book rows and base 2024 next rows differ from v20261005) (Parquet, one file per base year). Read the pointer view vw_benefit_engine_atoms unless a question must pin this exact version; the same rules apply (ratio of weighted sums, one bucket at a time, the 2027 level is the 2026 members followed). Superseded by benefit_engine_atoms_v20261006c; kept queryable by name. Owner: the Benefits lane.

**Grain.** Identical to medicare_semantic.vw_benefit_engine_atoms (the pointer view selects this version whole). 802,687 rows (measured 2026-10-05).

| column | type | meaning |
|---|---|---|
| kind | string |  |
| base_year | int |  |
| value_year | int |  |
| county_ssa | string |  |
| state | string |  |
| county_fips | string |  |
| county_name | string |  |
| bucket | string |  |
| parent | string |  |
| base_key | string |  |
| plan_segment_key | string |  |
| followed | boolean |  |
| weight | double |  |
| plan_type | string |  |
| product_type | string |  |
| successor | string |  |
| dental_pct_offered | double |  |
| dental_pct_max | double |  |
| dental_pct_no_max | double |  |
| dental_pct_card | double |  |
| dental_dollars_pmpm_if | double |  |
| dental_dollars_pmpm_all | double |  |
| dental_design_known | double |  |
| hearing_pct_offered | double |  |
| hearing_pct_allowance | double |  |
| hearing_pct_copay | double |  |
| hearing_pct_card | double |  |
| hearing_dollars_pmpm_if | double |  |
| hearing_dollars_pmpm_all | double |  |
| hearing_design_known | double |  |
| otc_pct_offered | double |  |
| otc_pct_own | double |  |
| otc_pct_card | double |  |
| otc_pct_no_amount | double |  |
| otc_dollars_pmpm_if | double |  |
| otc_dollars_pmpm_all | double |  |
| otc_design_known | double |  |
| eyewear_pct_offered | double |  |
| eyewear_pct_allowance | double |  |
| eyewear_pct_card | double |  |
| eyewear_pct_no_max | double |  |
| eyewear_dollars_pmpm_if | double |  |
| eyewear_dollars_pmpm_all | double |  |
| eyewear_design_known | double |  |
| hearing_copay_per_aid | double |  |
| otc_pct_filed_own_zero_card | double |  |
| card_pct_offered | double |  |
| card_dollars_pmpm_if | double |  |
| card_dollars_pmpm_all | double |  |
| allowance_total_pmpm_all | double |  |
| allowance_total_coverage | double |  |
| giveback_pct_offered | double |  |
| giveback_pmpm_if | double |  |
| premium_pct_zero | double |  |
| svc_transportation_pct_offered | double |  |
| svc_transportation_known | double |  |
| svc_fitness_pct_offered | double |  |
| svc_fitness_known | double |  |
| svc_meals_post_discharge_pct_offered | double |  |
| svc_meals_post_discharge_known | double |  |
| svc_meals_any_pct_offered | double |  |
| svc_meals_any_known | double |  |
| svc_podiatry_pct_offered | double |  |
| svc_podiatry_known | double |  |
| svc_transportation_trips | double |  |
| svc_transportation_pct_unlimited | double |  |
| svc_podiatry_visits | double |  |
| deductible_pct_none | double |  |
| deductible_pct_partb | double |  |
| deductible_pct_plan | double |  |
| deductible_plan_amount | double |  |
| deductible_design_known | double |  |
| deductible_pct_scope_oon | double |  |
| premium | double |  |
| premium_coverage | double |  |
| moop | double |  |
| moop_coverage | double |  |
| medical_deductible | double |  |
| medical_deductible_coverage | double |  |
| partd_deductible | double |  |
| partd_deductible_coverage | double |  |
| primary_care | double |  |
| primary_care_coverage | double |  |
| specialist | double |  |
| specialist_coverage | double |  |
| telehealth | double |  |
| telehealth_coverage | double |  |
| mental_health_ind | double |  |
| mental_health_ind_coverage | double |  |
| er | double |  |
| er_coverage | double |  |
| urgent | double |  |
| urgent_coverage | double |  |
| ambulance_ground | double |  |
| ambulance_ground_coverage | double |  |
| hosp_5day | double |  |
| hosp_5day_coverage | double |  |
| inpatient | double |  |
| inpatient_coverage | double |  |
| snf | double |  |
| snf_coverage | double |  |
| outpatient_hosp | double |  |
| outpatient_hosp_coverage | double |  |
| asc | double |  |
| asc_coverage | double |  |
| imaging_complex | double |  |
| imaging_complex_coverage | double |  |
| radiology | double |  |
| radiology_coverage | double |  |
| lab | double |  |
| lab_coverage | double |  |
| physical_therapy | double |  |
| physical_therapy_coverage | double |  |
| dme | double |  |
| dme_coverage | double |  |
| partb_drugs | double |  |
| partb_drugs_coverage | double |  |
| partb_insulin | double |  |
| partb_insulin_coverage | double |  |
| dialysis | double |  |
| dialysis_coverage | double |  |
| partd_tier1_copay | double |  |
| partd_tier1_copay_coverage | double |  |
| partd_tier2_copay | double |  |
| partd_tier2_copay_coverage | double |  |
| partd_tier4_coins | double |  |
| partd_tier4_coins_coverage | double |  |
| partd_tier5_coins | double |  |
| partd_tier5_coins_coverage | double |  |
| primary_care_pct_copay | double |  |
| primary_care_pct_coins | double |  |
| primary_care_coins | double |  |
| specialist_pct_copay | double |  |
| specialist_pct_coins | double |  |
| specialist_coins | double |  |
| telehealth_pct_copay | double |  |
| telehealth_pct_coins | double |  |
| telehealth_coins | double |  |
| mental_health_ind_pct_copay | double |  |
| mental_health_ind_pct_coins | double |  |
| mental_health_ind_coins | double |  |
| physical_therapy_pct_copay | double |  |
| physical_therapy_pct_coins | double |  |
| physical_therapy_coins | double |  |
| er_pct_copay | double |  |
| er_pct_coins | double |  |
| er_coins | double |  |
| urgent_pct_copay | double |  |
| urgent_pct_coins | double |  |
| urgent_coins | double |  |
| ambulance_ground_pct_copay | double |  |
| ambulance_ground_pct_coins | double |  |
| ambulance_ground_coins | double |  |
| outpatient_hosp_pct_copay | double |  |
| outpatient_hosp_pct_coins | double |  |
| outpatient_hosp_coins | double |  |
| imaging_complex_pct_copay | double |  |
| imaging_complex_pct_coins | double |  |
| imaging_complex_coins | double |  |
| radiology_pct_copay | double |  |
| radiology_pct_coins | double |  |
| radiology_coins | double |  |
| lab_pct_copay | double |  |
| lab_pct_coins | double |  |
| lab_coins | double |  |
| inpatient_pct_copay | double |  |
| inpatient_pct_coins | double |  |
| inpatient_coins | double |  |
| snf_pct_copay | double |  |
| snf_pct_coins | double |  |
| snf_coins | double |  |
| primary_care_ll_known | double |  |
| primary_care_llc_from | double |  |
| primary_care_llc_to | double |  |
| primary_care_lli_from | double |  |
| primary_care_lli_to | double |  |
| primary_care_sw_coins | double |  |
| primary_care_sw_copay | double |  |
| specialist_ll_known | double |  |
| specialist_llc_from | double |  |
| specialist_llc_to | double |  |
| specialist_lli_from | double |  |
| specialist_lli_to | double |  |
| specialist_sw_coins | double |  |
| specialist_sw_copay | double |  |
| telehealth_ll_known | double |  |
| telehealth_llc_from | double |  |
| telehealth_llc_to | double |  |
| telehealth_lli_from | double |  |
| telehealth_lli_to | double |  |
| telehealth_sw_coins | double |  |
| telehealth_sw_copay | double |  |
| mental_health_ind_ll_known | double |  |
| mental_health_ind_llc_from | double |  |
| mental_health_ind_llc_to | double |  |
| mental_health_ind_lli_from | double |  |
| mental_health_ind_lli_to | double |  |
| mental_health_ind_sw_coins | double |  |
| mental_health_ind_sw_copay | double |  |
| physical_therapy_ll_known | double |  |
| physical_therapy_llc_from | double |  |
| physical_therapy_llc_to | double |  |
| physical_therapy_lli_from | double |  |
| physical_therapy_lli_to | double |  |
| physical_therapy_sw_coins | double |  |
| physical_therapy_sw_copay | double |  |
| er_ll_known | double |  |
| er_llc_from | double |  |
| er_llc_to | double |  |
| er_lli_from | double |  |
| er_lli_to | double |  |
| er_sw_coins | double |  |
| er_sw_copay | double |  |
| urgent_ll_known | double |  |
| urgent_llc_from | double |  |
| urgent_llc_to | double |  |
| urgent_lli_from | double |  |
| urgent_lli_to | double |  |
| urgent_sw_coins | double |  |
| urgent_sw_copay | double |  |
| ambulance_ground_ll_known | double |  |
| ambulance_ground_llc_from | double |  |
| ambulance_ground_llc_to | double |  |
| ambulance_ground_lli_from | double |  |
| ambulance_ground_lli_to | double |  |
| ambulance_ground_sw_coins | double |  |
| ambulance_ground_sw_copay | double |  |
| outpatient_hosp_ll_known | double |  |
| outpatient_hosp_llc_from | double |  |
| outpatient_hosp_llc_to | double |  |
| outpatient_hosp_lli_from | double |  |
| outpatient_hosp_lli_to | double |  |
| outpatient_hosp_sw_coins | double |  |
| outpatient_hosp_sw_copay | double |  |
| imaging_complex_ll_known | double |  |
| imaging_complex_llc_from | double |  |
| imaging_complex_llc_to | double |  |
| imaging_complex_lli_from | double |  |
| imaging_complex_lli_to | double |  |
| imaging_complex_sw_coins | double |  |
| imaging_complex_sw_copay | double |  |
| radiology_ll_known | double |  |
| radiology_llc_from | double |  |
| radiology_llc_to | double |  |
| radiology_lli_from | double |  |
| radiology_lli_to | double |  |
| radiology_sw_coins | double |  |
| radiology_sw_copay | double |  |
| lab_ll_known | double |  |
| lab_llc_from | double |  |
| lab_llc_to | double |  |
| lab_lli_from | double |  |
| lab_lli_to | double |  |
| lab_sw_coins | double |  |
| lab_sw_copay | double |  |
| inpatient_ll_known | double |  |
| inpatient_llc_from | double |  |
| inpatient_llc_to | double |  |
| inpatient_lli_from | double |  |
| inpatient_lli_to | double |  |
| inpatient_sw_coins | double |  |
| inpatient_sw_copay | double |  |
| snf_ll_known | double |  |
| snf_llc_from | double |  |
| snf_llc_to | double |  |
| snf_lli_from | double |  |
| snf_lli_to | double |  |
| snf_sw_coins | double |  |
| snf_sw_copay | double |  |

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