VladaOmega
Sign inStart free
State programs

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

medicare_silver.medicaid_mcpar_puf_question_v1·live·reference
Rows
454
Columns
11
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1What 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

KeyGrain
N/A
  1. 1One row per (performance_year, question_id, question_number_raw);
  2. 2PY2023 215 + PY2024 239 = 454 rows (Athena 4d11ad5e, f9118535).

Columns (11)

ColumnTypeMeaning
performance_yearint
question_idstring
question_number_rawstring
puf_rowsint
puf_plan_rowsint
template_typestring
template_labelstring
template_hintstring
template_commitstring
template_urlstring
definition_basisstring

Query it

describe_data_source(source_fqn="medicare_silver.medicaid_mcpar_puf_question_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_mcpar_puf_question_v1 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keyperformance_year,question_id,question_number_raw
Joinhow_to_join(source_fqn="medicare_silver.medicaid_mcpar_puf_question_v1")
Raw doorAthena (read-only via query_substrate): medicare_silver.medicaid_mcpar_puf_question_v1
NoteRegistered 2026-10-06 with the view as a reference source; it explains the line table.

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