Medicare Advantage, Part D, Medicaid

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

medicare_semantic.vw_hcc_coefficients_current_v2·live·semantic_view

Rows

52,463

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every 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.
2Same 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

Key	Grain
N/A	1One 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).

Columns (29)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,software_package,segment,variable`
Join	`how_to_join(source_fqn="medicare_semantic.vw_hcc_coefficients_current_v2")`
Raw door	Tools: get_risk_model, get_hcc_coefficient; Athena: medicare_semantic.vw_hcc_coefficients_current_v2 (pin rate_year, model_family and the population via package_applies_to)
Note	Read path for HCC coefficients from 2026-10-07 (get_risk_model 0.4.0, get_hcc_coefficient 0.2.0). Every posting stays in medicare_silver.dim_hcc_coefficients_v2. medicare_semantic.vw_hcc_coefficients_current_v1 (same rows, no package labels) exists in Glue but is not registered: it cannot tell the packages apart.

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