# Vlada benefit reading, allowance dollars like for like (edition v20261018b), same members base -> next year

`medicare_semantic.vw_benefit_reading_cells_sd` · Medicare Advantage, Part D, Medicaid · status live · 691,438 rows

Allowance dollars on paired members (book followed <-> next), like for like: level = sd_<k>_l0 / w and sd_<k>_l1 / w; sd_<k>_sw = members whose design changed form (a design change, never a raise or a cut). Pointer -> medicare_semantic.benefit_company_cells_sd_v20261018b. Owner: the Benefits lane.

**Grain.** One row per base_year x lvl x state x county_ssa x bucket x plan_type x parent.

| column | type | meaning |
|---|---|---|
| base_year | int |  |
| value_year | int |  |
| 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 |  |

Tools that read it: get_benefit_change

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