# D-SNP integration status (FIDE / HIDE / CO / CO-P, AIP, zero-dollar cost sharing, dual categories) by plan segment and state, CY2023-2027

`medicare_silver.dsnp_integration_status_v1` · Medicare Advantage, Part D, Medicaid · status live · 4,795 rows

CMS integration level of every D-SNP from the MA Landscape (CY2023-2027), with the last SNP Comprehensive Report month of the year (status, AIP, partial-dual-only, enrollment), the CMS MMCO integration list (status incl. CO-P, integrated-care SEP, dual categories the plan may enroll, age and enrollment limits) and the PBP filing as cross-checks. Identifiers as CMS prints them (segment unpadded), the format of pbp_section_a and vw_benefit_vector.

**Grain.** One row per (plan_year, contract_id, plan_id, segment_id, state_code); a multi-state plan segment has one row per state (plan_segment_state_rank = 1 for plan counts). CY2027: 1,052 plan segments.

| column | type | meaning |
|---|---|---|
| plan_year | int |  |
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| state_code | string |  |
| state_name_raw | string |  |
| plan_name | string |  |
| org_name | string |  |
| parent_org_name | string |  |
| plan_type | string |  |
| integration_status | string |  |
| integration_status_raw | string |  |
| applicable_integrated_plan | boolean |  |
| aip_raw | string |  |
| zero_dollar_cost_sharing | boolean |  |
| zero_dollar_cost_sharing_raw | string |  |
| landscape_county_count | int |  |
| plan_segment_state_count | int |  |
| plan_segment_state_rank | int |  |
| snp_report_month | string |  |
| snp_report_integration_status | string |  |
| snp_report_aip | boolean |  |
| snp_report_partial_dual_only | boolean |  |
| snp_report_dsnp_only_contract | boolean |  |
| snp_report_plan_segment_enrollment | bigint |  |
| snp_report_status_agrees | boolean |  |
| cms_list_edition | string |  |
| cms_list_integration_status | string |  |
| cms_list_aip | boolean |  |
| cms_list_integrated_care_sep | boolean |  |
| cms_list_dual_categories_raw | string |  |
| cms_list_enrolls_full_benefit_duals | boolean |  |
| cms_list_enrolls_partial_duals | boolean |  |
| cms_list_age_eligibility_raw | string |  |
| cms_list_enrollment_limitations_raw | string |  |
| cms_list_medicaid_mco_organization_raw | string |  |
| cms_list_status_agrees | boolean |  |
| pbp_dsnp_filed | boolean |  |
| pbp_dsnp_zerodollar_code | string |  |
| pbp_zero_dollar_agrees | boolean |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| bronze_object_key | string |  |
| snp_report_source_url | string |  |
| snp_report_sha256_content_hash | string |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |

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