Patient Timelines of Standard Final Action CMS-HCC Results

Object Description

One record per period in which the patient qualified for either the version 24 or version 28 CMS-HCC model; 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_003
• 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

Dedicated Precursors

• [SO/URSA-HCC] Patient Timelines of Standard Final Action 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. The Simple Timeline object is used to merge contiguous periods in the same calendar year together when the CMS-HCC demographic component values are identical, reducing the record volume sent to the model.
• [SO/URSA-HCC] Patient Timelines of Standard Final Action CMS-HCC Results, Precursor 2 (Model Inputs): One record per distinct patient-period (for patients with no acceptable qualifying diagnoses in the prior calendar year) or per patient-period-diagnosis (for the first instances of diagnosis code in the prior calendar year for that patient); 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 Standard Final Action CMS-HCC Results, Precursor 3 (Version 24 Model Output):
• [SO/URSA-HCC] Patient Timelines of Standard Final Action CMS-HCC Results, Precursor 4 (Version 28 Model Output):