Medicare Advantage, Part D, Medicaid

Vlada benefit vector, every MA plan's filed benefit design, one row per plan-segment-year, 2015 to 2026

medicare_semantic.vw_benefit_vector·live·semantic_view

Rows

72,414

Columns

261

History

N/A

Card

nocolumns only

Typed tools

What it is

1The one defined benefit set for analysis (Ben 2026-09-28;
2Benefits lane CH): the PBP filing of record read by the platform's own rule into 63 metrics from primary care to the OTC card, each with a status column (a NULL is never $0), the D-SNP design headline with <metric>__dual_effective on the Medicare A/B cost shares, the five clocks (benefit_design_year, rebate_payment_year, stars_rating_year_paid, enrollment_weight_month), product_type as one column, market and is_employer_group, plan_enrollment, prev_contract_plans from the crosswalk and yoy_break_metrics.
3Reproduces the platform's national series to the cent (10 of 33,488 fields differ; two 2024 plans where the vector is right per segment).
4Registry ops/sb_llm/benefit_vector_registry.yaml; doc docs/skills/pbp-semantics/BENEFIT-VECTOR.md.

Grain

Key	Grain
N/A	1One row per contract_id x plan_id x segment_id x report_year (2015-2026), 72,414 rows, 1,457 contracts, 243 columns (63 metrics each with <metric>__status; measured 2026-09-29, Athena ae557f34). 2The pointer follows the current version (v20260929g, promoted 13:53Z, a deterministic build with the pre-2019 fills; 32019-2026 identical to e); 4S (PDP) contracts excluded.

Columns (261)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`report_year`	int
`plan_segment_key`	string
`benefit_design_year`	int
`rebate_payment_year`	int
`stars_rating_year_paid`	int
`stars_release_month_paid`	string
`stars_overall_paid`	double
`enrollment_weight_month`	string
`plan_name`	string
`org_name`	string
`org_marketing_name`	string
`parent_org`	string
`parent_org_labels`	bigint
`plan_type`	string
`filing_plan_type`	string
`snp_class`	varchar(6)
`snp_class_source`	varchar(16)
`snp_type`	string
`filing_snp_type`	string
`dsnp_integration_status`	string
`dsnp_zero_dollar_filed`	boolean
`product_type`	string
`product_type_source`	varchar(21)
`part_d`	varchar(4)
`market`	varchar(7)
`is_employer_group`	boolean
`is_ma_type`	boolean
`states`	array<string>
`plan_enrollment`	bigint
`plan_enrollment_september`	bigint
`segments_in_plan`	bigint
`prev_contract_plans`	array<string>
`crosswalk_status`	string
`lineage_id`	string
`yoy_break_metrics`	array<string>
`primary_care`	double
`primary_care__status`	varchar(18)
`specialist`	double
`specialist__status`	varchar(18)
`telehealth`	double
`telehealth__status`	varchar(18)
`mental_health_ind`	double
`mental_health_ind__status`	varchar(18)
`mental_health_grp`	double
`mental_health_grp__status`	varchar(18)
`podiatry`	double
`podiatry__status`	varchar(18)
`preventive`	double
`preventive__status`	varchar(18)
`physical_exam`	double
`physical_exam__status`	varchar(18)
`inpatient`	double
`inpatient__status`	varchar(18)
`inpatient_stay`	double
`inpatient_stay__status`	varchar(18)
`inpatient_stay_share`	double
`inpatient_stay_share__status`	varchar(17)
`inpatient_psych`	double
`inpatient_psych__status`	varchar(18)
`inpatient_psych_stay`	double
`inpatient_psych_stay__status`	varchar(18)
`inpatient_psych_stay_share`	double
`inpatient_psych_stay_share__status`	varchar(17)
`snf`	double
`snf__status`	varchar(18)
`outpatient_hosp`	double
`outpatient_hosp__status`	varchar(18)
`observation`	double
`observation__status`	varchar(18)
`observation_stay`	double
`observation_stay__status`	varchar(18)
`observation_stay_share`	double
`observation_stay_share__status`	varchar(17)
`partial_hosp`	double
`partial_hosp__status`	varchar(18)
`er`	double
`er__status`	varchar(18)
`urgent`	double
`urgent__status`	varchar(18)
`ambulance_ground`	double
`ambulance_ground__status`	varchar(18)
`ambulance_air`	double
`ambulance_air__status`	varchar(18)
`lab`	double
`lab__status`	varchar(18)
`radiology`	double
`radiology__status`	varchar(18)
`imaging_complex`	double
`imaging_complex__status`	varchar(18)
`radiation`	double
`radiation__status`	varchar(18)
`physical_therapy`	double
`physical_therapy__status`	varchar(18)
`occupational_therapy`	double
`occupational_therapy__status`	varchar(18)
`cardiac_rehab`	double
`cardiac_rehab__status`	varchar(18)
`pulmonary_rehab`	double
`pulmonary_rehab__status`	varchar(18)
`dme`	double
`dme__status`	varchar(18)
`prosthetics`	double
`prosthetics__status`	varchar(18)
`medical_supplies`	double
`medical_supplies__status`	varchar(17)
`home_health`	double
`home_health__status`	varchar(18)
`dialysis`	double
`dialysis__status`	varchar(18)
`partb_drugs`	double
`partb_drugs__status`	varchar(18)
`dental_comprehensive`	double
`dental_comprehensive__status`	varchar(18)
`dental_comprehensive__pooled_card_year`	double
`dental_comprehensive__item_copay`	double
`vision_eyewear`	double
`vision_eyewear__status`	varchar(18)
`vision_eyewear__pooled_card_year`	double
`vision_eyewear__item_copay`	double
`hearing_aids`	double
`hearing_aids__status`	varchar(18)
`hearing_aids__pooled_card_year`	double
`hearing_aids__item_copay`	double
`otc`	double
`otc__status`	varchar(18)
`otc__pooled_card_year`	double
`otc__item_copay`	double
`dental_comprehensive__filed_amount`	double
`dental_comprehensive__filed_period_code`	string
`vision_eyewear__filed_amount`	double
`vision_eyewear__filed_period_code`	string
`hearing_aids__filed_amount`	double
`hearing_aids__filed_period_code`	string
`otc__filed_amount`	double
`otc__filed_period_code`	string
`asc`	double
`asc__status`	varchar(17)
`asc__rows`	bigint
`eye_exam_medicare`	double
`eye_exam_medicare__status`	varchar(17)
`eye_exam_medicare__rows`	bigint
`hearing_exam_medicare`	double
`hearing_exam_medicare__status`	varchar(17)
`hearing_exam_medicare__rows`	bigint
`partd_tier1_copay`	double
`partd_tier1_copay__status`	varchar(17)
`partd_tier1_copay__rows`	bigint
`eye_exam_routine`	double
`eye_exam_routine__status`	varchar(17)
`eye_exam_routine__rows`	bigint
`hearing_exam_routine`	double
`hearing_exam_routine__status`	varchar(17)
`hearing_exam_routine__rows`	bigint
`partd_tier2_copay`	double
`partd_tier2_copay__status`	varchar(17)
`partd_tier2_copay__rows`	bigint
`partd_tier5_coins`	double
`partd_tier5_coins__status`	varchar(17)
`partd_tier5_coins__rows`	bigint
`partb_insulin`	double
`partb_insulin__status`	varchar(17)
`partb_insulin__rows`	bigint
`dental_preventive`	double
`dental_preventive__status`	varchar(17)
`dental_preventive__rows`	bigint
`partd_tier4_coins`	double
`partd_tier4_coins__status`	varchar(17)
`partd_tier4_coins__rows`	bigint
`chemo`	double
`chemo__status`	varchar(17)
`chemo__rows`	bigint
`eyewear_medicare`	double
`eyewear_medicare__status`	varchar(17)
`eyewear_medicare__rows`	bigint
`diag_tests`	double
`diag_tests__status`	varchar(17)
`diag_tests__rows`	bigint
`meals`	double
`meals__status`	varchar(17)
`meals__rows`	bigint
`premium`	double
`premium__status`	varchar(16)
`medical_deductible`	double
`medical_deductible__status`	varchar(16)
`medical_deductible__basis`	string
`medical_deductible_filed`	double
`medical_deductible_filed__status`	varchar(17)
`moop`	double
`moop__status`	varchar(16)
`partd_deductible`	double
`partd_deductible__status`	varchar(16)
`partb_giveback`	double
`partb_giveback__status`	varchar(17)
`dsnp_zero_dollar_view`	int
`primary_care__dual_effective`	double
`specialist__dual_effective`	double
`telehealth__dual_effective`	double
`mental_health_ind__dual_effective`	double
`mental_health_grp__dual_effective`	double
`podiatry__dual_effective`	double
`preventive__dual_effective`	double
`physical_exam__dual_effective`	double
`inpatient__dual_effective`	double
`inpatient_stay__dual_effective`	double
`inpatient_psych__dual_effective`	double
`inpatient_psych_stay__dual_effective`	double
`snf__dual_effective`	double
`outpatient_hosp__dual_effective`	double
`observation__dual_effective`	double
`observation_stay__dual_effective`	double
`partial_hosp__dual_effective`	double
`er__dual_effective`	double
`urgent__dual_effective`	double
`ambulance_ground__dual_effective`	double
`ambulance_air__dual_effective`	double
`lab__dual_effective`	double
`radiology__dual_effective`	double
`imaging_complex__dual_effective`	double
`radiation__dual_effective`	double
`physical_therapy__dual_effective`	double
`occupational_therapy__dual_effective`	double
`cardiac_rehab__dual_effective`	double
`pulmonary_rehab__dual_effective`	double
`dme__dual_effective`	double
`prosthetics__dual_effective`	double
`medical_supplies__dual_effective`	double
`home_health__dual_effective`	double
`dialysis__dual_effective`	double
`partb_drugs__dual_effective`	double
`asc__dual_effective`	double
`eye_exam_medicare__dual_effective`	double
`hearing_exam_medicare__dual_effective`	double
`partb_insulin__dual_effective`	double
`chemo__dual_effective`	double
`eyewear_medicare__dual_effective`	double
`diag_tests__dual_effective`	double
`moop__dual_effective`	double
`medical_deductible__dual_effective`	double
`medical_deductible_filed__dual_effective`	double
`vector_version`	varchar(10)
`premium__basis`	string
`moop__basis`	varchar(11)
`inpatient__medicare_defined_basis`	string
`inpatient_psych__medicare_defined_basis`	string
`snf__medicare_defined_basis`	string
`otc__pooled_group_amount`	double
`otc__pooled_group_period_code`	string
`vision_eyewear__pooled_group_amount`	double
`vision_eyewear__pooled_group_period_code`	string
`hearing_aids__pooled_group_amount`	double
`hearing_aids__pooled_group_period_code`	string
`vision_eyewear__tier_class`	string
`vision_eyewear__standard_annual`	double
`vision_eyewear__preferred_annual`	double
`vision_eyewear__preferred_vendor`	string
`vision_eyewear__filed_tier`	varchar(14)
`vision_eyewear__headline`	double
`vision_eyewear__headline_basis`	varchar(27)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,segment_id,report_year`
Join	`how_to_join(source_fqn="medicare_semantic.vw_benefit_vector")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_benefit_vector
Company names	`org_marketing_name` `org_name` `parent_org` `parent_org_labels` 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_benefit_vector.md · every page in one file: /llms-full.txt