Medicare Advantage, Part D, Medicaid

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

medicare_semantic.vw_plan_value_national·live·semantic_view

Rows

9,948,020

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Vlada 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.
2Modeled from the PBP, Landscape, ratebook and enrollment sources; never a CMS figure and never a paid claim.
3Adds `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`.
4Owner source: register w3 vlada_w3_benvat (door RAW, locked by Ben 2026-09-03).
5Supersedes medicare_semantic.benvat_v1_plan_county, whose 41 string columns read positionally out of CSV.

Grain

Key	Grain
N/A	1One 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; 2CY2023-CY2026). 3Real types (double / int / boolean / varchar); no cast is needed or wanted.

Columns (43)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract,plan,segment,county_ssa,benefit_design_year`
Join	`how_to_join(source_fqn="medicare_semantic.vw_plan_value_national")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_plan_value_national
Note	Name: Ben chose "Vlada Plan Value" on 2026-09-17. "BenVAT" survives in the source id, the code and the retired table names until a rename lane changes them.

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