# Vlada Plan Value, national basis (formerly BenVAT) per contract x plan x segment x county x benefit year

`medicare_semantic.vw_plan_value_national` · Medicare Advantage, Part D, Medicaid · status live · 9,948,020 rows

Vlada Plan Value v1, national basis (run d06cf1bf7, signed 2026-08-27; typed rebuild 2026-09-17 verified cell-for-cell against the signed CSVs): total plan value PMPM with _low/_high bounds and grade, medical value beyond Medicare, supplemental expected plan expense, Part B giveback and Part C/D premiums, the net totals, and the D-SNP split. Modeled from the PBP, Landscape, ratebook and enrollment sources; never a CMS figure and never a paid claim. Adds `snp_type` in the county view's labels (none / i_snp / d_snp / c_snp; the CMS code kept as `snp_type_cms_code`) and `is_valued`. Owner source: register w3 vlada_w3_benvat (door RAW, locked by Ben 2026-09-03). Supersedes medicare_semantic.benvat_v1_plan_county, whose 41 string columns read positionally out of CSV.

**Grain.** One row per benefit_design_year x contract x plan x segment x county_ssa (measured 2026-09-17 in Athena, 9,948,020 rows = 9,948,020 distinct keys, Athena e9083b2e; CY2023-CY2026). Real types (double / int / boolean / varchar); no cast is needed or wanted.

| column | type | meaning |
|---|---|---|
| contract | string |  |
| plan | string |  |
| segment | string |  |
| county_ssa | string |  |
| county_name | string |  |
| state | string |  |
| partial_county | string |  |
| eghp | string |  |
| benefit_design_year | int |  |
| organization | string |  |
| plan_name | string |  |
| plan_type | string |  |
| v1_total_plan_value_pmpm | double |  |
| v1_total_plan_value_pmpm_low | double |  |
| v1_total_plan_value_pmpm_high | double |  |
| v1_total_grade | string |  |
| medical_value_beyond_medicare_pmpm | double |  |
| supplemental_expected_plan_expense_pmpm | double |  |
| supplemental_expected_plan_expense_pmpm_low | double |  |
| supplemental_expected_plan_expense_pmpm_high | double |  |
| supplemental_total_is_partial_by_pmpm | double |  |
| supplemental_grade | string |  |
| medical_status | string |  |
| part_b_premium_giveback_pmpm | double |  |
| part_c_premium_pmpm | double |  |
| part_d_premium_pmpm | double |  |
| v1_total_net_of_part_c_premium_plus_giveback_pmpm | double |  |
| part_d_member_financial_value_pmpm | double |  |
| v1_total_incl_part_d_net_of_all_premiums_pmpm | double |  |
| v1_total_incl_part_d_net_of_all_premiums_pmpm_low | double |  |
| v1_total_incl_part_d_net_of_all_premiums_pmpm_high | double |  |
| part_b_giveback_recipient | string |  |
| dsnp_zero_dollar_cost_sharing | string |  |
| part_d_member_financial_value_at_lis_pmpm | double |  |
| dsnp_beneficiary_value_pmpm | double |  |
| dsnp_beneficiary_value_pmpm_low | double |  |
| dsnp_beneficiary_value_pmpm_high | double |  |
| dsnp_plan_liability_pmpm | double |  |
| dsnp_state_transfer_pmpm | double |  |
| dsnp_state_transfer_pmpm_low | double |  |
| snp_type_cms_code | string |  |
| snp_type | varchar(5) |  |
| is_valued | boolean |  |

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