Medicare Advantage, Part D, Medicaid

ICD-10 to HCC / RxHCC crosswalk, every CMS edition (v3)

medicare_silver.dim_icd10_hcc_crosswalk_v3·live·silver

Rows

707,821

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The CMS ICD-10-CM to HCC / RxHCC mapping files, every edition CMS lists on its risk-adjustment year pages, read from the publisher's own headers.
2Labels: CMS-HCC V22, V23 (2019), V24 (2020-2025), V28 (2024+);
3ESRD_V21 and ESRD_V24 for the ESRD models;
4RxHCC_V05 (2016-2024) and RxHCC_V08 (2023+) for Part D, with categories spelled RXHCC<n>. coefficient_model_version carries the dim_hcc_coefficients model name (ESRD_V21 -> V21, ESRD_V24 -> V24).
5Every row keeps the verbatim source column header, its payment-year flag, the CSV line and the ZIP and CSV hashes.

Grain

Key	Grain
N/A	1One row per (rate_year, mapping_edition, model_version, icd_code, hcc_category): 707,821 rows, 12 payment years 2016-2027, 17 CMS editions (initial, midyear_final, final), 8 model labels (Athena 8d7dff41). 2An ICD-10 code that maps to more than one HCC in a model has one row per HCC.

Columns (20)

Column	Type	Meaning
`rate_year`	int
`mapping_edition`	string
`model_family`	string
`model_version`	string
`coefficient_model_version`	string
`icd_code`	string
`hcc_category`	string
`hcc_number`	int
`icd_description`	string
`payment_year_flag`	string
`source_column`	string
`payment_year_flag_column`	string
`source_member`	string
`source_row_number`	int
`source_zip_sha256`	string
`source_url`	string
`sha256_content_hash`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`parser_artifact_hash`	string

Query it

describe_data_source(source_fqn="medicare_silver.dim_icd10_hcc_crosswalk_v3")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.dim_icd10_hcc_crosswalk_v3 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,mapping_edition,model_version,icd_code,hcc_category`
Join	`how_to_join(source_fqn="medicare_silver.dim_icd10_hcc_crosswalk_v3")`
Raw door	Athena (read-only via query_substrate): medicare_silver.dim_icd10_hcc_crosswalk_v3 (pin rate_year AND mapping_edition, or read medicare_semantic.vw_icd10_hcc_crosswalk_current_v1)
Note	Restated by Data Tracker 2026-10-07 (#3237). Supersedes medicare_silver.dim_icd10_hcc_crosswalk (frozen rollback). medicare_silver.dim_icd10_hcc_crosswalk_v2 (one edition per year, wrong edition for 2024/2025) is not served. Release rule: load the 2027 midyear final as a new partition when CMS posts it; the current view switches automatically.

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