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

What it is

1. 1Base-year members followed 1:1 into their next-year plan (book <-> next on county_ssa + base_key); not followed = to_design 'exit'.
2. 2Designs: allowances cap | cap_plus_card | no_max (copay_per_aid for hearing) | card | none | unknown; cost shares zero | copay | coinsurance | unknown; premium zero | paid;
3. 3MOOP 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).
4. 4The 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.
5. 5Pointer -> medicare_semantic.benefit_reading_transitions_v20261018b.
6. 6Owner: the Benefits lane.

Grain

Columns (30)

Query it

describe_data_source(source_fqn="medicare_semantic.vw_benefit_reading_transitions")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_benefit_reading_transitions WHERE <filter> LIMIT 100")