VladaOmega
Sign inStart free
State programs

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

medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1·live·reference
Rows
786
Columns
12
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1Maps 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;
  2. 2Athena 176d99d7) and basis.
  3. 3Names with no canonical plan are not in this table (they stay NULL in the view); refused rows carry no plan id.

Grain

KeyGrain
N/A
  1. 1One row per (performance_year, state_code, program_name_raw, plan_or_bss_raw);
  2. 2PY2023 404 + PY2024 382 = 786 rows, one row per plan-year (verifier xwalk_one_row_per_plan_year, Athena 4cb24947; counts Athena d68fa1cb).

Columns (12)

ColumnTypeMeaning
performance_yearint
state_codestring
program_name_rawstring
plan_or_bss_rawstring
medicaid_plan_idstring
plan_regionstring
plan_display_namestring
program_classstring
parent_namestring
match_methodstring
basisstring
puf_rowsint

Query it

describe_data_source(source_fqn="medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1 WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keyperformance_year,state_code,program_name_raw,plan_or_bss_raw
Joinhow_to_join(source_fqn="medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1")
Raw doorAthena (read-only via query_substrate): medicare_silver.medicaid_mcpar_puf_plan_xwalk_v1
Company namesparent_name resolve to a permanent Vlada ID: resolve_entity(text=<name>); the company pages hold owners and holdings
NoteRegistered 2026-10-06 with the view as a derived reference source; the view is the customer surface.

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