Medicare Advantage, Part D, Medicaid

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·live·semantic_view

Rows

8,709

Columns

106

History

N/A

Card

nocolumns only

Typed tools

What it is

1Vlada 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.
2Served 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;
32027 Part D FINAL on CMS's CY2027 formulary;
4CY2025 built (not in this view).
5The 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.
6Beside 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.
7D-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.
8Pinned 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.
9The August v1 views (vw_plan_value_national / vw_plan_value_county) stay queryable by name.
10Owner source: register w3 vlada_w3_benvat.

Grain

Key	Grain
N/A	1One row per plan-segment (plan_segment_key = '<contract>-<plan>-<segment>', unique; 28,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). 3Every CY2026 and CY2027 plan-segment is a row; 46,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).

Key

Grain

N/A

1One row per plan-segment (plan_segment_key = '<contract>-<plan>-<segment>', unique;
28,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).
3Every CY2026 and CY2027 plan-segment is a row;
46,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).

Columns (106)

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

Query it

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

Item	Value
Typed tools that read it	get_plan_value
Identity key	`plan_segment_key,contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_plan_value_plans")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_plan_value_plans
Company names	`parent_organization` `parent_organization_2025` `parent_organization_2027` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

This page as markdown: /docs-md/data/medicare_semantic_vw_plan_value_plans.md · every page in one file: /llms-full.txt