Medicare Advantage, Part D, Medicaid

Each D-SNP plan segment x state with its integration status and the state's Medicaid wrap (dental, eyeglasses, hearing, NEMT, overriding SMAC rules)

medicare_semantic.vw_dsnp_medicaid_wrap_v5·live·semantic_view

Rows

4,795

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Joins dsnp_integration_status_v1 to the state duals KB v5: per plan_year, state and benefit the KB row in effect that year for a full-benefit dual (latest effective_from, ties exact > rule > judged); dental, eyeglasses, hearing aids, NEMT, eye exam, personal care, adult day, home services, home modifications and MCO value-added fitness, plus the SMAC rules that override plan filings in the plan year.

Grain

Key	Grain
N/A	1Same as medicare_silver.dsnp_integration_status_v1.

Columns (37)

Column	Type	Meaning
`plan_year`	int
`contract_id`	string
`plan_id`	string
`segment_id`	string
`state_code`	string
`plan_name`	string
`parent_org_name`	string
`plan_type`	string
`integration_status`	string
`cms_list_integration_status`	string
`applicable_integrated_plan`	boolean
`zero_dollar_cost_sharing`	boolean
`cms_list_dual_categories_raw`	string
`cms_list_enrolls_full_benefit_duals`	boolean
`cms_list_enrolls_partial_duals`	boolean
`snp_report_partial_dual_only`	boolean
`snp_report_plan_segment_enrollment`	bigint
`plan_segment_state_rank`	int
`medicaid_wrap_delivery`	varchar(48)
`medicaid_adult_dental_level`	string
`medicaid_adult_dental_as_of`	string
`medicaid_adult_dental_source_id`	string
`medicaid_eyeglasses`	string
`medicaid_eyeglasses_as_of`	string
`medicaid_hearing_aids`	string
`medicaid_hearing_aids_as_of`	string
`medicaid_nemt`	string
`state_rules_overriding_plan_filing`	string
`state_rules_overriding_plan_filing_n`	bigint
`integration_source_url`	string
`integration_sha256_content_hash`	string
`medicaid_eye_exam`	string
`medicaid_personal_care`	string
`medicaid_adult_day`	string
`medicaid_home_services`	string
`medicaid_home_modifications`	string
`medicaid_mco_value_added_fitness`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,contract_id,plan_id,segment_id,state_code`
Join	`how_to_join(source_fqn="medicare_semantic.vw_dsnp_medicaid_wrap_v5")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_dsnp_medicaid_wrap_v5
Company names	`parent_org_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-10-12 under register source state_duals_kb (W8) as the successor of the v4 object (same facts under neutral ids). Serving takes effect with the next MCP bridge release.

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