Patient-Output Timelines of Missing Model Outputs

Object Description

One record per patient-year-output triple where the patient had the CMS-HCC model output found in the historical-diagnoses scenario but not in the within-year-updated scenario for that year.

Metadata

• Table Name: ursa.so_ursa_hcc_cond_003
• Layer: SYNTHETIC_OBJECT
• Object Type: Single Stack
• Temporal Class: Interval (Timeline)
• Case ID: Patient ID, CMS-HCC Missing Output Code and Description, Is Model v24 Output, Is Model v28 Output
• Interval Start Date: Period Start Date
• Interval End Date: Period End Date
• Primary Key: Patient ID, CMS-HCC Missing Output Code and Description, Is Model v24 Output, Is Model v28 Output, Period Start Date, Period End Date

Dedicated Precursors

• [SO/URSA-HCC] Patient-Output Timelines of Missing Model Outputs, Precursor 1 (Patient Timelines with Wide-Form Missing Outputs): One record per patient timeline period with at least one "missing" CMS-HCC model outputs; missing model outputs are stored in separate wide-form blocks for v24 and v28.