# Medicaid MCPAR plan-ID crosswalk v1 (PUF plan name to canonical Medicaid plan id)

`medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1` · State programs · status live · 786 rows

Maps each plan name as the PUF prints it, per program and performance year, to the canonical medicaid_plan_id (mcd:<ST>:<slug>) with plan_region (Pennsylvania zones), plan_display_name, program_class, parent_name, match_method (Q1_exact 710, Q2_reviewed_region 56, Q2_reviewed 1, refused_statewide_placeholder 15, refused_reviewed 4; Athena 176d99d7) and basis. Names with no canonical plan are not in this table (they stay NULL in the view); refused rows carry no plan id.

**Grain.** One row per (performance_year, state_code, program_name_raw, plan_or_bss_raw); PY2023 404 + PY2024 382 = 786 rows, one row per plan-year (verifier xwalk_one_row_per_plan_year, Athena 4cb24947; counts Athena d68fa1cb).

| column | type | meaning |
|---|---|---|
| performance_year | int |  |
| state_code | string |  |
| program_name_raw | string |  |
| plan_or_bss_raw | string |  |
| medicaid_plan_id | string |  |
| plan_region | string |  |
| plan_display_name | string |  |
| program_class | string |  |
| parent_name | string |  |
| match_method | string |  |
| basis | string |  |
| puf_rows | int |  |

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