[SO/URSA-HCC] Patient Timelines of Historical-Diagnoses CMS-HCC Results
  • 28 Jun 2025
  • 8 Minutes to read
  • Dark
    Light

[SO/URSA-HCC] Patient Timelines of Historical-Diagnoses CMS-HCC Results

  • Dark
    Light

Article summary

Object Description

One record per period in which the patient qualified for either the version 24 or version 28 CMS-HCC model, under the "Historical Diagnoses" scenario (in which earlier diagnoses are included in later years); the blended RAF score is generated using the appropriate blending ratio for the calendar year of the period.

Metadata

  • Table Name: ursa.so_ursa_hcc_pat_011
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Complex Timeline
  • Temporal Class: Interval (Timeline)
  • Case ID: Patient ID
  • Interval Start Date: Period Start Date
  • Interval End Date: Period End Date
  • Primary Key: Patient ID, Period Start Date, Period End Date

Published Fields

  • Data Model Keys

    • Patient ID -- The internal database identifier (used, e.g., for joins and primary keys) for the patient. This value is typically mastered, i.e., all records for the same patient, regardless of the source data system from which that record originated, should have the same Patient ID value. (Note that while the mastered Patient ID value might resemble a local identifier used in one of the upstream data sources, this does not indicate any special priority of that source system in determining the characteristics of the patient.) (See also [URSA-CORE] Patient)
  • Date Fields

    • Period Start Date
    • Period End Date
  • Validation Only Fields

    • CMS-HCC v24 Model Output 1 Summary
    • CMS-HCC v24 Model Output 2 Summary
    • CMS-HCC v24 Model Output 3 Summary
    • CMS-HCC v24 Model Output 4 Summary
    • CMS-HCC v24 Model Output 5 Summary
    • CMS-HCC v24 Model Output 6 Summary
    • CMS-HCC v24 Model Output 7 Summary
    • CMS-HCC v24 Model Output 8 Summary
    • CMS-HCC v24 Model Output 9 Summary
    • CMS-HCC v24 Model Output 10 Summary
    • CMS-HCC v24 Model Output 11 Summary
    • CMS-HCC v24 Model Output 12 Summary
    • CMS-HCC v24 Model Output 13 Summary
    • CMS-HCC v24 Model Output 14 Summary
    • CMS-HCC v24 Model Output 15 Summary
    • CMS-HCC v24 Model Output 16 Summary
    • CMS-HCC v24 Model Output 17 Summary
    • CMS-HCC v24 Model Output 18 Summary
    • CMS-HCC v24 Model Output 19 Summary
    • CMS-HCC v24 Model Output 20 Summary
    • CMS-HCC v28 Model Output 1 Summary
    • CMS-HCC v28 Model Output 2 Summary
    • CMS-HCC v28 Model Output 3 Summary
    • CMS-HCC v28 Model Output 4 Summary
    • CMS-HCC v28 Model Output 5 Summary
    • CMS-HCC v28 Model Output 6 Summary
    • CMS-HCC v28 Model Output 7 Summary
    • CMS-HCC v28 Model Output 8 Summary
    • CMS-HCC v28 Model Output 9 Summary
    • CMS-HCC v28 Model Output 10 Summary
    • CMS-HCC v28 Model Output 11 Summary
    • CMS-HCC v28 Model Output 12 Summary
    • CMS-HCC v28 Model Output 13 Summary
    • CMS-HCC v28 Model Output 14 Summary
    • CMS-HCC v28 Model Output 15 Summary
    • CMS-HCC v28 Model Output 16 Summary
    • CMS-HCC v28 Model Output 17 Summary
    • CMS-HCC v28 Model Output 18 Summary
    • CMS-HCC v28 Model Output 19 Summary
    • CMS-HCC v28 Model Output 20 Summary
  • Module Fields

    • CMS-HCC RAF Score
    • CMS-HCC Raw RAF Score
    • CMS-HCC Demographic Component RAF Score
    • CMS-HCC Disease Component RAF Score
    • CMS-HCC RAF Score Using 2024 Blend
    • CMS-HCC RAF Score Using 2025 Blend
    • CMS-HCC v24 RAF Score
    • CMS-HCC v24 Raw RAF Score
    • CMS-HCC v24 All Outputs Summary
    • CMS-HCC v28 RAF Score
    • CMS-HCC v28 Raw RAF Score
    • CMS-HCC v28 All Outputs Summary
    • CMS-HCC v24 Demographic Component Raw RAF Score
    • CMS-HCC v24 Demographic Component RAF Score
    • CMS-HCC v28 Demographic Component Raw RAF Score
    • CMS-HCC v28 Demographic Component RAF Score
    • CMS-HCC v24 Model Output 1 Code
    • CMS-HCC v24 Model Output 1 Description
    • CMS-HCC v24 Model Output 1 Raw RAF Score
    • CMS-HCC v24 Model Output 2 Code
    • CMS-HCC v24 Model Output 2 Description
    • CMS-HCC v24 Model Output 2 Raw RAF Score
    • CMS-HCC v24 Model Output 3 Code
    • CMS-HCC v24 Model Output 3 Description
    • CMS-HCC v24 Model Output 3 Raw RAF Score
    • CMS-HCC v24 Model Output 4 Code
    • CMS-HCC v24 Model Output 4 Description
    • CMS-HCC v24 Model Output 4 Raw RAF Score
    • CMS-HCC v24 Model Output 5 Code
    • CMS-HCC v24 Model Output 5 Description
    • CMS-HCC v24 Model Output 5 Raw RAF Score
    • CMS-HCC v24 Model Output 6 Code
    • CMS-HCC v24 Model Output 6 Description
    • CMS-HCC v24 Model Output 6 Raw RAF Score
    • CMS-HCC v24 Model Output 7 Code
    • CMS-HCC v24 Model Output 7 Description
    • CMS-HCC v24 Model Output 7 Raw RAF Score
    • CMS-HCC v24 Model Output 8 Code
    • CMS-HCC v24 Model Output 8 Description
    • CMS-HCC v24 Model Output 8 Raw RAF Score
    • CMS-HCC v24 Model Output 9 Code
    • CMS-HCC v24 Model Output 9 Description
    • CMS-HCC v24 Model Output 9 Raw RAF Score
    • CMS-HCC v24 Model Output 10 Code
    • CMS-HCC v24 Model Output 10 Description
    • CMS-HCC v24 Model Output 10 Raw RAF Score
    • CMS-HCC v24 Model Output 11 Code
    • CMS-HCC v24 Model Output 11 Description
    • CMS-HCC v24 Model Output 11 Raw RAF Score
    • CMS-HCC v24 Model Output 12 Code
    • CMS-HCC v24 Model Output 12 Description
    • CMS-HCC v24 Model Output 12 Raw RAF Score
    • CMS-HCC v24 Model Output 13 Code
    • CMS-HCC v24 Model Output 13 Description
    • CMS-HCC v24 Model Output 13 Raw RAF Score
    • CMS-HCC v24 Model Output 14 Code
    • CMS-HCC v24 Model Output 14 Description
    • CMS-HCC v24 Model Output 14 Raw RAF Score
    • CMS-HCC v24 Model Output 15 Code
    • CMS-HCC v24 Model Output 15 Description
    • CMS-HCC v24 Model Output 15 Raw RAF Score
    • CMS-HCC v24 Model Output 16 Code
    • CMS-HCC v24 Model Output 16 Description
    • CMS-HCC v24 Model Output 16 Raw RAF Score
    • CMS-HCC v24 Model Output 17 Code
    • CMS-HCC v24 Model Output 17 Description
    • CMS-HCC v24 Model Output 17 Raw RAF Score
    • CMS-HCC v24 Model Output 18 Code
    • CMS-HCC v24 Model Output 18 Description
    • CMS-HCC v24 Model Output 18 Raw RAF Score
    • CMS-HCC v24 Model Output 19 Code
    • CMS-HCC v24 Model Output 19 Description
    • CMS-HCC v24 Model Output 19 Raw RAF Score
    • CMS-HCC v24 Model Output 20 Code
    • CMS-HCC v24 Model Output 20 Description
    • CMS-HCC v24 Model Output 20 Raw RAF Score
    • CMS-HCC v28 Model Output 1 Code
    • CMS-HCC v28 Model Output 1 Description
    • CMS-HCC v28 Model Output 1 Raw RAF Score
    • CMS-HCC v28 Model Output 2 Code
    • CMS-HCC v28 Model Output 2 Description
    • CMS-HCC v28 Model Output 2 Raw RAF Score
    • CMS-HCC v28 Model Output 3 Code
    • CMS-HCC v28 Model Output 3 Description
    • CMS-HCC v28 Model Output 3 Raw RAF Score
    • CMS-HCC v28 Model Output 4 Code
    • CMS-HCC v28 Model Output 4 Description
    • CMS-HCC v28 Model Output 4 Raw RAF Score
    • CMS-HCC v28 Model Output 5 Code
    • CMS-HCC v28 Model Output 5 Description
    • CMS-HCC v28 Model Output 5 Raw RAF Score
    • CMS-HCC v28 Model Output 6 Code
    • CMS-HCC v28 Model Output 6 Description
    • CMS-HCC v28 Model Output 6 Raw RAF Score
    • CMS-HCC v28 Model Output 7 Code
    • CMS-HCC v28 Model Output 7 Description
    • CMS-HCC v28 Model Output 7 Raw RAF Score
    • CMS-HCC v28 Model Output 8 Code
    • CMS-HCC v28 Model Output 8 Description
    • CMS-HCC v28 Model Output 8 Raw RAF Score
    • CMS-HCC v28 Model Output 9 Code
    • CMS-HCC v28 Model Output 9 Description
    • CMS-HCC v28 Model Output 9 Raw RAF Score
    • CMS-HCC v28 Model Output 10 Code
    • CMS-HCC v28 Model Output 10 Description
    • CMS-HCC v28 Model Output 10 Raw RAF Score
    • CMS-HCC v28 Model Output 11 Code
    • CMS-HCC v28 Model Output 11 Description
    • CMS-HCC v28 Model Output 11 Raw RAF Score
    • CMS-HCC v28 Model Output 12 Code
    • CMS-HCC v28 Model Output 12 Description
    • CMS-HCC v28 Model Output 12 Raw RAF Score
    • CMS-HCC v28 Model Output 13 Code
    • CMS-HCC v28 Model Output 13 Description
    • CMS-HCC v28 Model Output 13 Raw RAF Score
    • CMS-HCC v28 Model Output 14 Code
    • CMS-HCC v28 Model Output 14 Description
    • CMS-HCC v28 Model Output 14 Raw RAF Score
    • CMS-HCC v28 Model Output 15 Code
    • CMS-HCC v28 Model Output 15 Description
    • CMS-HCC v28 Model Output 15 Raw RAF Score
    • CMS-HCC v28 Model Output 16 Code
    • CMS-HCC v28 Model Output 16 Description
    • CMS-HCC v28 Model Output 16 Raw RAF Score
    • CMS-HCC v28 Model Output 17 Code
    • CMS-HCC v28 Model Output 17 Description
    • CMS-HCC v28 Model Output 17 Raw RAF Score
    • CMS-HCC v28 Model Output 18 Code
    • CMS-HCC v28 Model Output 18 Description
    • CMS-HCC v28 Model Output 18 Raw RAF Score
    • CMS-HCC v28 Model Output 19 Code
    • CMS-HCC v28 Model Output 19 Description
    • CMS-HCC v28 Model Output 19 Raw RAF Score
    • CMS-HCC v28 Model Output 20 Code
    • CMS-HCC v28 Model Output 20 Description
    • CMS-HCC v28 Model Output 20 Raw RAF Score
    • v24 Disease Component 1 Raw RAF Score Text
    • v24 Disease Component 2 Raw RAF Score Text
    • Count CMS-HCC v24 HCCs
    • Count CMS-HCC v28 HCCs

Dedicated Precursors

  • [SO/URSA-HCC] Patient Timelines of Historical-Diagnoses CMS-HCC Results, Precursor 1 (Demographic Model Input Periods): One record per patient-period during which the patient had an active membership in any plan (note: not just a Medicare plan) or was covered by an MMR record; this object additionally partitions periods of identical demographic inputs if a new acceptable qualifying diagnosis is documented (meaning there is some possibility of an update to the CMS-HCC model results).
  • [SO/URSA-HCC] Patient Timelines of Historical-Diagnoses CMS-HCC Results, Precursor 2 (Model Inputs): One record per distinct patient-period (for patients with no acceptable qualifying diagnoses in the current or prior two calendar years) or per patient-period-diagnosis (for patients with acceptable qualifying diagnoses); this unusual grain size is the required format for inputs sent to the CMS-HCC model. Patients with a qualifying membership but without any acceptable qualifying diagnosis codes will have a single record for that period, with a diagnosis code value of NULL.
  • [SO/URSA-HCC] Patient Timelines of Historical-Diagnoses CMS-HCC Results, Precursor 3 (Version 24 Model Output): One record per patient-period during which the patient was eligible to generate HCC/RAF results, under the "Historical Diagnoses" scenario (in which diagnoses from prior years are automatically included in later years); using model version 24.
  • [SO/URSA-HCC] Patient Timelines of Historical-Diagnoses CMS-HCC Results, Precursor 4 (Version 28 Model Output): One record per patient-period during which the patient was eligible to generate HCC/RAF results, under the "Historical Diagnoses" scenario (in which diagnoses from prior years are automatically included in later years); using model version 28.

Was this article helpful?