# 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` · Medicare Advantage, Part D, Medicaid · status live · 4,795 rows

Joins 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.** Same as medicare_silver.dsnp_integration_status_v1.

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_dsnp_medicaid_wrap_v5 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_dsnp_medicaid_wrap_v5")` first.