Medicare Advantage, Part D, Medicaid

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·live·silver

Rows

4,795

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS 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.
2CO-P, integrated-care SEP, dual categories the plan may enroll, age and enrollment limits) and the PBP filing as cross-checks.
3Identifiers as CMS prints them (segment unpadded), the format of pbp_section_a and vw_benefit_vector.

Grain

Key	Grain
N/A	1One 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). 2CY2027: 1,052 plan segments.

Columns (47)

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

describe_data_source(source_fqn="medicare_silver.dsnp_integration_status_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.dsnp_integration_status_v1 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_silver.dsnp_integration_status_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.dsnp_integration_status_v1
Company names	`cms_list_medicaid_mco_organization_raw` `org_name` `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 cms_dsnp_integration_status (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_dsnp_integration_status_v1.md · every page in one file: /llms-full.txt