# Vlada Plan Value (Method Lock 1.0 + PV-55, signed 2026-10-17; served build v19e) per plan-segment, 2026 and 2027, five legs, range ends, card bounds, D-SNP two columns

`medicare_semantic.vw_plan_value_plans` · Medicare Advantage, Part D, Medicaid · status live · 8,709 rows

Vlada Plan Value v16, the method Ben signed on 2026-10-08 (build plan_value_*_v16 on atoms benefit_engine_atoms_v20261007a, Edition 1.1 locked benefits; recommended variant fixcard3_design_on): value to the member, PMPM, modeled, for 2026 and 2027. Served build v19e = Method Lock 1.0 (v19d, signed by Ben 2026-10-15, final 2026-10-16) + PV-55 (the ER copay charged on every visit, CMS's convention), signed by Ben 2026-10-17 on docs/ma-value-engine/lock/v19/GATE-RECEIPT-v19e.json as the Plan Value for launch (docs/ma-value-engine/V19-2025-2027.md): the v16 method plus the v18c / v18d / v18e fixes, the SSBCI eligibility rule, U3, D3 and the extras read through one reader on benefit edition v20261015d; 2027 Part D FINAL on CMS's CY2027 formulary; CY2025 built (not in this view). The headline is all-in for every product type except D-SNP: medical cost-sharing value at the expected position in each filed range (theta) + extras (supplemental, the card valued by what the money buys: 0.645 grocery / utility / rent / SSBCI-type dollars, 0.30 OTC dollars) + Part D + Part B buydown - member premium, one column per leg. Beside it: the minimum-end and maximum-end values (the range rule), the card bounds (every card dollar at 0.30 / 0.72), the headline without Part D, and the filed design. D-SNP has two columns: the full-dual headline (extras + Part D against the Extra Help comparator, medical $0) and the filed design (for partial duals and design comparison), plus Medicaid's cost-sharing protection published beside, never in a total. Pinned name medicare_semantic.vw_plan_value_plans_v19e; previous builds v19d (ER waiver on admission refused) and v18 (interim 2027 Part D) stay queryable as vw_plan_value_plans_v19d / vw_plan_value_plans_v18. The August v1 views (vw_plan_value_national / vw_plan_value_county) stay queryable by name. Owner source: register w3 vlada_w3_benvat.

**Grain.** One row per plan-segment (plan_segment_key = '<contract>-<plan>-<segment>', unique; 8,709 rows over 8,080 contract-plans, measured 2026-10-16 in Athena on vw_plan_value_plans_v19d and 2026-10-17 on _v19e, as v18). Every CY2026 and CY2027 plan-segment is a row; 6,598 are valued in at least one year, 5,472 carry 2026 members in the locked atoms, 3,237 carry none (new in 2027 or memberless); unvalued years keep NULL values. contract_plan repeats across a plan's segments (327 plans file more than one segment, 289 of them with different values per segment).

| column | type | meaning |
|---|---|---|
| contract_plan | string |  |
| contract_id | string |  |
| plan_id | string |  |
| product_type | string |  |
| snp_type | varchar(5) |  |
| plan_type | string |  |
| parent_organization | string |  |
| members_sept_2026 | double |  |
| is_valued_2026 | boolean |  |
| is_valued_2027 | boolean |  |
| headline_definition | varchar(9) |  |
| plan_value_2026 | double |  |
| plan_value_2027 | double |  |
| plan_value_min_end_2026 | double |  |
| plan_value_max_end_2026 | double |  |
| plan_value_min_end_2027 | double |  |
| plan_value_max_end_2027 | double |  |
| plan_value_card_low_2026 | double |  |
| plan_value_card_high_2026 | double |  |
| plan_value_card_low_2027 | double |  |
| plan_value_card_high_2027 | double |  |
| medical_cost_sharing_value_2026 | double |  |
| extras_value_2026 | double |  |
| part_d_value_2026 | double |  |
| part_b_buydown_value_2026 | double |  |
| member_premium_2026 | double |  |
| medical_cost_sharing_value_2027 | double |  |
| extras_value_2027 | double |  |
| part_d_value_2027 | double |  |
| part_b_buydown_value_2027 | double |  |
| member_premium_2027 | double |  |
| medical_cost_sharing_value_min_end_2026 | double |  |
| medical_cost_sharing_value_max_end_2026 | double |  |
| medical_cost_sharing_value_min_end_2027 | double |  |
| medical_cost_sharing_value_max_end_2027 | double |  |
| plan_value_excl_part_d_2026 | double |  |
| plan_value_excl_part_d_2027 | double |  |
| filed_design_plan_value_2026 | double |  |
| filed_design_plan_value_2027 | double |  |
| filed_design_min_end_2026 | double |  |
| filed_design_max_end_2026 | double |  |
| filed_design_min_end_2027 | double |  |
| filed_design_max_end_2027 | double |  |
| filed_design_card_low_2026 | double |  |
| filed_design_card_high_2026 | double |  |
| filed_design_card_low_2027 | double |  |
| filed_design_card_high_2027 | double |  |
| filed_design_medical_value_2026 | double |  |
| filed_design_extras_value_2026 | double |  |
| filed_design_part_d_value_2026 | double |  |
| filed_design_part_b_buydown_value_2026 | double |  |
| filed_design_member_premium_2026 | double |  |
| filed_design_medical_value_2027 | double |  |
| filed_design_extras_value_2027 | double |  |
| filed_design_part_d_value_2027 | double |  |
| filed_design_part_b_buydown_value_2027 | double |  |
| filed_design_member_premium_2027 | double |  |
| dsnp_full_dual_plan_value_2026 | double |  |
| dsnp_full_dual_plan_value_2027 | double |  |
| dsnp_part_d_value_vs_extra_help_2026 | double |  |
| dsnp_part_d_value_vs_extra_help_2027 | double |  |
| medicaid_cost_sharing_protection_2026 | double |  |
| medicaid_cost_sharing_protection_2027 | double |  |
| dsnp_zero_dollar_cost_sharing_2026 | string |  |
| dsnp_zero_dollar_cost_sharing_2027 | string |  |
| part_d_2027_carried_from_2026 | boolean |  |
| part_d_2027_basis | string |  |
| range_basis | varchar(23) |  |
| card_rule | varchar(33) |  |
| build | varchar(14) |  |
| variant | varchar(18) |  |
| atoms | varchar(26) |  |
| value_label | varchar(7) |  |
| plan_segment_key | string |  |
| segment_id | string |  |
| product_type_2027 | string |  |
| parent_organization_2027 | string |  |
| grain | varchar(12) |  |
| product_type_2025 | string |  |
| snp_type_2025 | varchar(5) |  |
| parent_organization_2025 | string |  |
| members_sept_2025 | double |  |
| is_valued_2025 | boolean |  |
| plan_value_2025 | double |  |
| medical_cost_sharing_value_2025 | double |  |
| extras_value_2025 | double |  |
| part_d_value_2025 | double |  |
| part_b_buydown_value_2025 | double |  |
| member_premium_2025 | double |  |
| plan_value_excl_part_d_2025 | double |  |
| plan_value_card_low_2025 | double |  |
| plan_value_card_high_2025 | double |  |
| plan_value_2025_at_2026_drug_prices | double |  |
| filed_design_plan_value_2025 | double |  |
| filed_design_medical_value_2025 | double |  |
| filed_design_extras_value_2025 | double |  |
| filed_design_part_d_value_2025 | double |  |
| filed_design_part_b_buydown_value_2025 | double |  |
| filed_design_member_premium_2025 | double |  |
| filed_design_card_low_2025 | double |  |
| filed_design_card_high_2025 | double |  |
| dsnp_full_dual_plan_value_2025 | double |  |
| dsnp_part_d_value_vs_extra_help_2025 | double |  |
| medicaid_cost_sharing_protection_2025 | double |  |
| dsnp_zero_dollar_cost_sharing_2025 | string |  |
| part_d_2025_basis | string |  |

Tools that read it: get_plan_value

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