# Vlada benefit reading, design transitions (edition v20261018b): members by base-year design x next-year design per benefit, same members

`medicare_semantic.vw_benefit_reading_transitions` · Medicare Advantage, Part D, Medicaid · status live · 17,670,144 rows

Base-year members followed 1:1 into their next-year plan (book <-> next on county_ssa + base_key); not followed = to_design 'exit'. Designs: allowances cap | cap_plus_card | no_max (copay_per_aid for hearing) | card | none | unknown; cost shares zero | copay | coinsurance | unknown; premium zero | paid; MOOP in_network | not_in_network; deductible none | plan | partb | none_in_network; giveback none | token | giveback; services offered | optional_only | none. v0__s / v1__s over pair_w = the like-for-like value both sides (allowances dollars a year; cost shares the copay pair, q = the coinsurance pair). The successor mix (same / other segment, crosswalk consolidated / renumbered, left county, plan not filed) and to_contract_changed / to_parent_changed (next contract's parent in the base parent's name space) / to_type_changed ride beside. Pointer -> medicare_semantic.benefit_reading_transitions_v20261018b. Owner: the Benefits lane.

**Grain.** One row per base_year x lvl x state x county_ssa x bucket ('ALL') x parent ('ALL') x benefit x from_design x to_design.

| column | type | meaning |
|---|---|---|
| base_year | int |  |
| value_year | int |  |
| lvl | varchar(8) |  |
| state | string |  |
| county_ssa | string |  |
| county_name | string |  |
| bucket | string |  |
| parent | string |  |
| benefit | string |  |
| from_design | string |  |
| to_design | string |  |
| members | double |  |
| plans_from | bigint |  |
| plans_to | bigint |  |
| pair_w | double |  |
| v0__s | double |  |
| v1__s | double |  |
| coins_w | double |  |
| q0__s | double |  |
| q1__s | double |  |
| succ_same_segment | double |  |
| succ_other_segment | double |  |
| succ_crosswalk_consolidated | double |  |
| succ_crosswalk_renumbered | double |  |
| succ_left_county | double |  |
| succ_plan_not_filed | double |  |
| to_contract_changed | double |  |
| to_parent_changed | double |  |
| to_parent_unknown | double |  |
| to_type_changed | double |  |

Tools that read it: get_benefit_change

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