# HCC risk-model coefficients, current posting per payment year, package-labelled

`medicare_semantic.vw_hcc_coefficients_current_v2` · Medicare Advantage, Part D, Medicaid · status live · 52,463 rows

Every CMS-HCC / ESRD / RxHCC coefficient package of the current CMS model-software posting per payment year (midyear final or final when held, else the initial: 2027 is the initial posting until CMS posts its midyear final), each row joined to the 92-row package seed that cites the year's Rate Announcement page: package_calibration, package_applies_to (all / non-PACE / PACE / non-PACE;PACE / MA-PD;PACE / PDP), payment_use (CMS's blend weight for the year), announcement_url, announcement_pages, value_check. Same columns as medicare_silver.dim_hcc_coefficients_v2 otherwise, including xw_model_version and hcc_number for the join from medicare_semantic.vw_icd10_hcc_crosswalk_current_v1.

**Grain.** One row per (rate_year, software_package, segment, variable) for the one CMS posting chosen per payment year: 52,463 rows, 12 payment years 2016-2027, 66 packages, unique on that key (Athena 52d9f563-a9cf-4679-b35c-cac14d8bcbf1, 882c4101-b8f0-4c5b-9999-4db6d06ad7e2).

| 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 |  |
| package_calibration | varchar(81) |  |
| package_applies_to | varchar(13) |  |
| payment_use | varchar(101) |  |
| announcement_url | varchar(99) |  |
| announcement_pages | varchar(96) |  |
| value_check | varchar(185) |  |
| 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_semantic.vw_hcc_coefficients_current_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_hcc_coefficients_current_v2")` first.