# CMS MMCO Integration Status for Contract Year D-SNPs, every edition CY2021-2027

`medicare_silver.cms_dsnp_integration_status_list_v1` · Medicare Advantage, Part D, Medicaid · status live · 6,783 rows

CMS's per-plan D-SNP integration list from its review of every State Medicaid Agency Contract: FIDE / HIDE / CO / CO-P, AIP, integrated-care SEP (CY2025+), Medicaid MCO organization (CY2025), dual-eligible categories the plan may enroll, age and enrollment limits (CY2027).

**Grain.** One row per edition (sha256_content_hash) x contract x plan x state; is_latest_edition marks the edition used per contract year.

| column | type | meaning |
|---|---|---|
| contract_year | int |  |
| edition | string |  |
| is_latest_edition | boolean |  |
| contract_id | string |  |
| plan_id | string |  |
| state_code | string |  |
| legal_entity_name | string |  |
| integration_status | string |  |
| integration_status_raw | string |  |
| applicable_integrated_plan | boolean |  |
| aip_raw | string |  |
| integrated_care_sep_eligible | boolean |  |
| dual_categories_raw | string |  |
| dual_categories_other_raw | string |  |
| enrolls_other_fbde | boolean |  |
| enrolls_qmb_only | boolean |  |
| enrolls_qmb_plus | boolean |  |
| enrolls_slmb_only | boolean |  |
| enrolls_slmb_plus | boolean |  |
| enrolls_qdwi | boolean |  |
| enrolls_qi | boolean |  |
| enrolls_full_benefit_duals | boolean |  |
| enrolls_partial_duals | boolean |  |
| age_eligibility_raw | string |  |
| enrollment_limitations_raw | string |  |
| medicaid_mco_organization_raw | string |  |
| footnote_marker | string |  |
| publisher_row_number | int |  |
| publisher_row_multiplicity | int |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| bronze_object_key | string |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.cms_dsnp_integration_status_list_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.cms_dsnp_integration_status_list_v1")` first.