# ICD-10 to HCC / RxHCC crosswalk, current edition per payment year

`medicare_semantic.vw_icd10_hcc_crosswalk_current_v1` · Medicare Advantage, Part D, Medicaid · status live · 457,917 rows

The CMS ICD-10-CM to HCC / RxHCC mapping with one edition per payment year: the midyear final or final when CMS has posted it, else the initial. 2027 serves the initial edition (the 2026 final code set) until CMS posts the 2027 midyear final, then switches with no code change. Same columns as medicare_silver.dim_icd10_hcc_crosswalk_v3, including model_version + hcc_number for the join to medicare_semantic.vw_hcc_coefficients_current_v2.

**Grain.** One row per (rate_year, model_version, icd_code, hcc_category) for the one CMS edition chosen per payment year: 457,917 rows, 12 payment years 2016-2027, 12 editions (Athena 5ca177af). 2025 = midyear final (54,440), 2026 = final (44,860), 2027 = initial (44,860).

| 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_semantic.vw_icd10_hcc_crosswalk_current_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_icd10_hcc_crosswalk_current_v1")` first.