Medicare Advantage, Part D, Medicaid

Vlada benefit vector v2 extension, 191 more benefit columns per plan-segment-year with a catalog status each

medicare_semantic.vw_benefit_vector_v2_ext·live·semantic_view

Rows

90,464

Columns

195

History

N/A

Card

nocolumns only

Typed tools

What it is

1The catalog v2 extension of the benefit vector (Benefits lane CI, 2026-09-29): every MA benefit the catalog names beyond the 63 vector metrics (core medical cost shares, Part D and the insulin caps, supplemental benefits, SSBCI, VBID, D-SNP facts, money anchors), each column with a catalog status in ops/sb_llm/benefit_catalog_v2.yaml (trusted / filed_only / held / not_in_filing) that says whether the number is served with a tie to the filing, filed but not yet tied, held elsewhere, or not in the filing at all.
2Doc docs/skills/pbp-semantics/BENEFIT-CATALOG-V2.md.

Grain

Key	Grain
N/A	1One row per contract_id x plan_id x segment_id x report_year, 90,464 rows, report_year 2015-2027, 1,582 contracts, 187 columns (measured 2026-09-29, Athena 7c1728a2); exactly one row per live vector key 2015-2026, plus S contracts and 2027 Landscape keys the vector excludes. 2The pointer follows the current version (v20260929co, a materialized Parquet table behind it, 195 columns with 8 SNF filed-coinsurance columns added; a contract-year probe answers in about 2 s).

Key

Grain

N/A

1One row per contract_id x plan_id x segment_id x report_year, 90,464 rows, report_year 2015-2027, 1,582 contracts, 187 columns (measured 2026-09-29, Athena 7c1728a2); exactly one row per live vector key 2015-2026, plus S contracts and 2027 Landscape keys the vector excludes.
2The pointer follows the current version (v20260929co, a materialized Parquet table behind it, 195 columns with 8 SNF filed-coinsurance columns added; a contract-year probe answers in about 2 s).

Columns (195)

Column	Type	Meaning
`contract_id`	string
`plan_id`	string
`segment_id`	string
`report_year`	int
`air_ambulance_copay`	double
`ambulance_ground_coins`	double
`pulmonary_rehab_coins`	double
`cardiac_rehab_coins`	double
`setpad_copay`	double
`setpad_coins`	double
`radiation_copay`	double
`imaging_complex_coins`	double
`radiology_coins`	double
`lab_coins`	double
`diag_tests_coins`	double
`dental_medicare_copay`	double
`dental_comp_coins`	double
`dental_medicare_coins`	double
`dental_comp_offered`	int
`dental_prev_offered`	int
`dental_comp_copay`	double
`dental_preventive_coins`	double
`dental_exams_limit`	double
`dental_cleanings_limit`	double
`supplies_copay`	double
`shoes_coins`	double
`shoes_copay`	double
`routine_podiatry_copay`	double
`physical_therapy_coins`	double
`occupational_therapy_coins`	double
`mental_health_ind_coins`	double
`specialist_coins`	double
`primary_care_coins`	double
`podiatry_coins`	double
`mental_health_grp_coins`	double
`routine_podiatry_coins`	double
`routine_podiatry_limit`	double
`hearing_aid_limit`	double
`hearing_exam_limit`	double
`hearing_exam_medicare_coins`	double
`otc_hearing_aid_copay`	double
`hearing_fitting_copay`	double
`hearing_fitting_limit`	double
`hearing_aids_offered`	int
`hearing_exam_offered`	int
`inpatient_coins`	double
`inpatient_unlimited_days`	int
`psych_days`	double
`inpatient_psych_coins`	double
`meals_offered`	int
`optional_premium`	double
`optional_max`	double
`otc_offered`	int
`substance_use_copay`	double
`outpatient_hosp_coins`	double
`asc_coins`	double
`observation_coins`	double
`substance_use_coins`	double
`partb_insulin_coins`	double
`chemo_copay`	double
`partb_insulin_month_max`	double
`partb_drugs_copay`	double
`partd_insulin_copay`	double
`partd_tier3_coins`	double
`partd_insulin_coins`	double
`partd_tier3_copay`	double
`partd_tier4_copay`	double
`partd_tier5_copay`	double
`partd_tier6_copay`	double
`partd_tier2_offered`	int
`partd_tier5_offered`	int
`preventive_coins`	double
`transport_copay`	double
`transport_offered`	int
`transport_trips_limit`	double
`eye_exam_limit`	double
`eye_exam_medicare_coins`	double
`eyewear_medicare_coins`	double
`eyewear_copay`	double
`contacts_copay`	double
`eye_exam_allowance`	double
`eyewear_limit`	double
`contacts_limit`	double
`eyewear_offered`	int
`partd_tier1_retail_preferred_1m_copay`	double
`partd_tier1_retail_preferred_1m_coins`	double
`partd_tier1_retail_standard_3m_copay`	double
`partd_tier1_retail_standard_3m_coins`	double
`partd_tier1_retail_preferred_3m_copay`	double
`partd_tier1_retail_preferred_3m_coins`	double
`partd_tier1_mail_standard_3m_copay`	double
`partd_tier1_mail_standard_3m_coins`	double
`partd_tier1_mail_preferred_3m_copay`	double
`partd_tier1_mail_preferred_3m_coins`	double
`partd_tier2_retail_preferred_1m_copay`	double
`partd_tier2_retail_preferred_1m_coins`	double
`partd_tier2_retail_standard_3m_copay`	double
`partd_tier2_retail_standard_3m_coins`	double
`partd_tier2_retail_preferred_3m_copay`	double
`partd_tier2_retail_preferred_3m_coins`	double
`partd_tier2_mail_standard_3m_copay`	double
`partd_tier2_mail_standard_3m_coins`	double
`partd_tier2_mail_preferred_3m_copay`	double
`partd_tier2_mail_preferred_3m_coins`	double
`partd_tier3_retail_preferred_1m_copay`	double
`partd_tier3_retail_preferred_1m_coins`	double
`partd_tier3_retail_standard_3m_copay`	double
`partd_tier3_retail_standard_3m_coins`	double
`partd_tier3_retail_preferred_3m_copay`	double
`partd_tier3_retail_preferred_3m_coins`	double
`partd_tier3_mail_standard_3m_copay`	double
`partd_tier3_mail_standard_3m_coins`	double
`partd_tier3_mail_preferred_3m_copay`	double
`partd_tier3_mail_preferred_3m_coins`	double
`partd_tier4_retail_preferred_1m_copay`	double
`partd_tier4_retail_preferred_1m_coins`	double
`partd_tier4_retail_standard_3m_copay`	double
`partd_tier4_retail_standard_3m_coins`	double
`partd_tier4_retail_preferred_3m_copay`	double
`partd_tier4_retail_preferred_3m_coins`	double
`partd_tier4_mail_standard_3m_copay`	double
`partd_tier4_mail_standard_3m_coins`	double
`partd_tier4_mail_preferred_3m_copay`	double
`partd_tier4_mail_preferred_3m_coins`	double
`partd_tier5_retail_preferred_1m_copay`	double
`partd_tier5_retail_preferred_1m_coins`	double
`partd_tier5_retail_standard_3m_copay`	double
`partd_tier5_retail_standard_3m_coins`	double
`partd_tier5_retail_preferred_3m_copay`	double
`partd_tier5_retail_preferred_3m_coins`	double
`partd_tier5_mail_standard_3m_copay`	double
`partd_tier5_mail_standard_3m_coins`	double
`partd_tier5_mail_preferred_3m_coins`	double
`partd_tier6_retail_preferred_1m_copay`	double
`partd_tier6_retail_standard_3m_copay`	double
`partd_tier6_retail_standard_3m_coins`	double
`partd_tier6_retail_preferred_3m_copay`	double
`partd_tier6_mail_standard_3m_copay`	double
`partd_tier6_mail_standard_3m_coins`	double
`partd_tier6_mail_preferred_3m_copay`	double
`worldwide_er_copay`	double
`worldwide_urgent_copay`	double
`worldwide_transport_copay`	double
`worldwide_cap`	double
`worldwide_cap_period`	string
`fitness_offered`	int
`fitness_copay`	double
`fitness_copay_basis`	varchar(33)
`fitness_max_annualized`	double
`fitness_type_physical`	boolean
`fitness_type_memory`	boolean
`fitness_type_activity_tracker`	boolean
`premium_part_c`	double
`premium_part_d_basic`	double
`premium_part_d_supplemental`	double
`premium_full_lis`	double
`moop_combined`	double
`moop_oon`	double
`medical_deductible_in_network`	double
`medical_deductible_oon`	double
`dsnp_state_covers_cost_share`	string
`ssbci_offered`	boolean
`ssbci_food_own_dollar_annual`	double
`ssbci_general_supports_own_dollar_annual`	double
`ssbci_package_pot`	double
`ssbci_food_offered`	boolean
`ssbci_general_supports_offered`	boolean
`ssbci_transportation_offered`	boolean
`ssbci_pest_control_offered`	boolean
`ssbci_indoor_air_offered`	boolean
`ssbci_social_needs_offered`	boolean
`ssbci_meals_offered`	boolean
`ssbci_home_modifications_offered`	boolean
`flex_card_pot`	double
`flex_card_period`	varchar(18)
`flex_card_includes_otc`	boolean
`flex_card_includes_food_or_utilities`	boolean
`flex_card_includes_dental`	boolean
`b19a_reduced_cost_sharing_package`	boolean
`b19b_additional_benefits_package`	boolean
`acupuncture_copay`	double
`pers_offered`	boolean
`in_home_support_offered`	boolean
`bathroom_safety_offered`	boolean
`nurse_line_offered`	boolean
`chiropractic_routine_copay`	double
`vbid_participant`	int
`snf_coins_interval1_begin_day`	double
`snf_coins_interval1_end_day`	double
`snf_coins_interval1_pct`	double
`snf_coins_interval2_begin_day`	double
`snf_coins_interval2_end_day`	double
`snf_coins_interval2_pct`	double
`snf_coins_interval_count`	string
`snf_coins_per_stay_pct`	double

Query it

describe_data_source(source_fqn="medicare_semantic.vw_benefit_vector_v2_ext")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_benefit_vector_v2_ext 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_v2_ext")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_benefit_vector_v2_ext

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