Medicare Advantage, Part D, Medicaid

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

medicare_semantic.vw_icd10_hcc_crosswalk_current_v1·live·semantic_view

Rows

457,917

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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.
22027 serves the initial edition (the 2026 final code set) until CMS posts the 2027 midyear final, then switches with no code change.
3Same 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

Key	Grain
N/A	1One 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). 22025 = midyear final (54,440), 2026 = final (44,860), 2027 = initial (44,860).

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_semantic.vw_icd10_hcc_crosswalk_current_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_icd10_hcc_crosswalk_current_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,model_version,icd_code,hcc_category`
Join	`how_to_join(source_fqn="medicare_semantic.vw_icd10_hcc_crosswalk_current_v1")`
Raw door	Tools: get_risk_model, get_icd10_hcc_mapping; Athena: medicare_semantic.vw_icd10_hcc_crosswalk_current_v1 (pin rate_year and model_version)
Note	Read path for the ICD-10 -> HCC crosswalk from 2026-10-07 (get_risk_model 0.4.0, get_icd10_hcc_mapping 0.3.0). Every edition stays in medicare_silver.dim_icd10_hcc_crosswalk_v3.

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