# Medicaid MCPAR question dictionary (CMS MCPAR form template label, hint and type per question and edition)

`medicare_silver.medicaid_mcpar_puf_question_v1` · State programs · status live · 454 rows

What each MCPAR question asked: template_label, template_hint and template_type from CMS's MCPAR form template (github.com/Enterprise-CMCS/macpro-mdct-mcr, pinned commits per form era, template_commit and template_url), with puf_rows and puf_plan_rows counting the lines in the PUF and definition_basis saying how the definition was matched (template label at the PUF number, number differs, derived, undocumented).

**Grain.** One row per (performance_year, question_id, question_number_raw); PY2023 215 + PY2024 239 = 454 rows (Athena 4d11ad5e, f9118535).

| column | type | meaning |
|---|---|---|
| performance_year | int |  |
| question_id | string |  |
| question_number_raw | string |  |
| puf_rows | int |  |
| puf_plan_rows | int |  |
| template_type | string |  |
| template_label | string |  |
| template_hint | string |  |
| template_commit | string |  |
| template_url | string |  |
| definition_basis | string |  |

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