Medicare Advantage, Part D, Medicaid

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

medicare_silver.cms_dsnp_integration_status_list_v1·live·silver

Rows

6,783

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS'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

Key	Grain
N/A	1One row per edition (sha256_content_hash) x contract x plan x state; is_latest_edition marks the edition used per contract year.

Columns (34)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_year,sha256_content_hash,contract_id,plan_id,state_code`
Join	`how_to_join(source_fqn="medicare_silver.cms_dsnp_integration_status_list_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.cms_dsnp_integration_status_list_v1
Company names	`medicaid_mco_organization_raw` 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 cms_dsnp_integration_status_list (W3; Ben's yes, switch-on stage 1.2). Serving takes effect with the next MCP bridge release.

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