# HCC risk-model coefficients, every CMS posting and package 2016-2027 (v2)

`medicare_silver.dim_hcc_coefficients_v2` · Medicare Advantage, Part D, Medicaid · status live · 75,521 rows

Every CMS-HCC, ESRD and RxHCC coefficient (relative factor) CMS published in its risk-adjustment model software for payment years 2016-2027, decoded from the SAS PROC CPORT coefficient libraries inside each posting (the only machine-readable form before 2026). One row per package x segment x variable: model_family (CMS-HCC / ESRD / RxHCC), model_version (the coefficient name: V21, V22, V23, V24, V28, RxHCC_V05, RxHCC_V08), xw_model_version (the ICD-10 crosswalk label: ESRD_V21 / ESRD_V24 for ESRD and the 2016-2019 CMS-HCC V21 PACE model), software_package (e.g. V2826.115.T1), segment (CMS's 2026 Python CSV headers for every year), variable (CMS's SAS name), hcc_number, coefficient_value (double), label, plus the library, ZIP and content SHA-256 for each row.

**Grain.** One row per (rate_year, software_edition, software_package, segment, variable): 75,521 rows, 16 CMS model-software postings (initial, midyear_final, final) for payment years 2016-2027, 92 package postings, 29 distinct coefficient libraries (Athena efce68d2-a999-40ab-a009-ee0f00fde64c; 0 duplicate keys, 0 null lineage, Athena 56fcd67c).

| column | type | meaning |
|---|---|---|
| rate_year | int |  |
| software_edition | string |  |
| model_family | string |  |
| model_version | string |  |
| xw_model_version | string |  |
| software_package | string |  |
| package_variant | string |  |
| package_description | string |  |
| segment | string |  |
| segment_code | string |  |
| variable | string |  |
| hcc_number | int |  |
| coefficient_value | double |  |
| label | string |  |
| sas_variable | string |  |
| source_member | string |  |
| coefficient_file_sha256 | string |  |
| 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_hcc_coefficients_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.dim_hcc_coefficients_v2")` first.