# Vlada locked 2027 allowance dollars like for like by company (v20261007a), same members 2026 vs 2027, dental / hearing / OTC / eyewear / flex card

`medicare_semantic.benefit_company_cells_sd_v20261007a` · Medicare Advantage, Part D, Medicaid · status live · 138,014 rows

Allowance dollars like for like (REPORT-FAMILY-PLAN.md section 0; rule in benefits_same_design.py): each 2026 continuing member (atoms kind = book, followed) paired 1:1 with their 2027 plan (kind = next, same county_ssa + base_key, same weight). For each allowance k in dental, hearing, OTC, eyewear and card: sd_<k>_l0 / sd_<k>_l1 = SUM(w x PMPM dollars) in 2026 / 2027 over the comparable pairs (same form both years, or offered without a stated amount both years), so the 2026 and 2027 levels are sd_<k>_l0 / w and sd_<k>_l1 / w and the like-for-like change is (sd_<k>_l1 - sd_<k>_l0) / w; sd_<k>_sw = members whose design changed form (a form switch is a design change, never a raise or a cut) and sd_<k>_kn = members with the design known both years. Tie-out: 7,250 values against same_design.json, 0 mismatches. Versioned, never replaced. Owner: the Benefits lane.

**Grain.** One row per lvl x state x county_ssa x bucket x plan_type x parent, the same keys and 'ALL' rollups as benefit_company_cells_v20261007a without per (every row is the paired 2026 -> 2027 members). 138,014 rows (county 133,094, state 4,035, national 885; CELLS-MANIFEST.md 2026-10-07).

| column | type | meaning |
|---|---|---|
| lvl | varchar(8) |  |
| state | string |  |
| county_ssa | string |  |
| county_name | string |  |
| bucket | string |  |
| plan_type | string |  |
| parent | string |  |
| w | double |  |
| sd_dental_l0 | double |  |
| sd_dental_l1 | double |  |
| sd_dental_sw | double |  |
| sd_dental_kn | double |  |
| sd_hearing_l0 | double |  |
| sd_hearing_l1 | double |  |
| sd_hearing_sw | double |  |
| sd_hearing_kn | double |  |
| sd_otc_l0 | double |  |
| sd_otc_l1 | double |  |
| sd_otc_sw | double |  |
| sd_otc_kn | double |  |
| sd_eyewear_l0 | double |  |
| sd_eyewear_l1 | double |  |
| sd_eyewear_sw | double |  |
| sd_eyewear_kn | double |  |
| sd_card_l0 | double |  |
| sd_card_l1 | double |  |
| sd_card_sw | double |  |
| sd_card_kn | double |  |

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