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

`medicare_silver.dim_icd10_hcc_crosswalk_v3` · Medicare Advantage, Part D, Medicaid · status live · 707,821 rows

The 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. Labels: CMS-HCC V22, V23 (2019), V24 (2020-2025), V28 (2024+); ESRD_V21 and ESRD_V24 for the ESRD models; RxHCC_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). Every row keeps the verbatim source column header, its payment-year flag, the CSV line and the ZIP and CSV hashes.

**Grain.** One 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). An ICD-10 code that maps to more than one HCC in a model has one row per HCC.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.dim_icd10_hcc_crosswalk_v3 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.dim_icd10_hcc_crosswalk_v3")` first.