Medicare Advantage, Part D, Medicaid

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

medicare_silver.dim_hcc_coefficients_v2·live·silver

Rows

75,521

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every 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).
2One 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.
3V2826.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

Key	Grain
N/A	1One 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; 20 duplicate keys, 0 null lineage, Athena 56fcd67c).

Columns (23)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,software_edition,software_package,segment,variable`
Join	`how_to_join(source_fqn="medicare_silver.dim_hcc_coefficients_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.dim_hcc_coefficients_v2 (pin rate_year AND software_edition AND software_package, or read medicare_semantic.vw_hcc_coefficients_current_v2)
Note	Restated by Data Tracker 2026-10-07 (#3246). Supersedes medicare_silver.dim_hcc_coefficients (2026-2027 only, RxHCC packages overwritten; frozen rollback). Release rule: load the 2027 midyear final software as a new partition when CMS posts it; the current view switches automatically.

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