[SO/URSA-HCC] 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

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

• Module Fields

  • Is Model v24 Output
  • Is Model v28 Output
  • CMS-HCC Missing Output Code and Description
  • CMS-HCC Missing Output Raw RAF Score Contribution
  • Historical-Diagnoses CMS-HCC RAF Score -- The normalized CMS-HCC RAF score calculated under the Historical-Diagnoses scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
  • Within-Year-Updated CMS-HCC RAF Score -- The normalized CMS-HCC RAF score calculated under the Within-Year-Updated scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Historical-Diagnoses CMS-HCC Disease Component RAF Score -- The disease component contribution to the normalized CMS-HCC RAF score, calculated under the Historical-Diagnoses scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
  • Within-Year-Updated CMS-HCC Disease Component RAF Score -- The disease component contribution to the normalized CMS-HCC RAF score, calculated under the Within-Year-Updated scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Historical-Diagnoses vs. Within-Year-Updated CMS-HCC RAF Score Gap -- The difference between the CMS-HCC RAF score calculated under the Historical-Diagnoses scenario and the Within-Year-Updated scenario; represents a theoretical increase to RAF score if all qualifying historical diagnoses had been redocumented in the reference calendar year. (See also [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Historical-Diagnoses CMS-HCC v24 All Outputs Summary -- A semicolon-delimited list of the CMS-HCC model outputs, including both the code and natural language description for each, produced by the CMS-HCC v24 model run under the Historical-Diagnoses scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
  • Historical-Diagnoses CMS-HCC v28 All Outputs Summary -- A semicolon-delimited list of the CMS-HCC model outputs, including both the code and natural language description for each, produced by the CMS-HCC v28 model run under the Historical-Diagnoses scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
  • Within-Year-Updated CMS-HCC v24 All Outputs Summary -- A semicolon-delimited list of the CMS-HCC model outputs, including both the code and natural language description for each, produced by the CMS-HCC v24 model run under the Within-Year-Updated scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Within-Year-Updated CMS-HCC v28 All Outputs Summary -- A semicolon-delimited list of the CMS-HCC model outputs, including both the code and natural language description for each, produced by the CMS-HCC v28 model run under the Within-Year-Updated scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Count Historical-Diagnoses CMS-HCC v24 Outputs Missing from Within-Year-Updated Outputs -- A count of all distinct outputs produced by the CMS-HCC v24 model run under the Historical-Diagnoses scenario that are not produced by the same model run under the Within-Year-Updated scenario. In effect, this is the count of model outputs (HCCs, primarily) that are, as of the reference date, "missing" from the patient's RAF score because some diagnoses have not been documented at that point in the reference year. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Count Historical-Diagnoses CMS-HCC v28 Outputs Missing from Within-Year-Updated Outputs -- A count of all distinct outputs produced by the CMS-HCC v28 model run under the Historical-Diagnoses scenario that are not produced by the same model run under the Within-Year-Updated scenario. In effect, this is the count of model outputs (HCCs, primarily) that are, as of the reference date, "missing" from the patient's RAF score because some diagnoses have not been documented at that point in the reference year. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Historical-Diagnoses CMS-HCC v24 Outputs Missing from Within-Year-Updated Outputs Summary -- A semicolon-delimited list of the CMS-HCC model outputs, including both the code and natural language description for each, produced by the CMS-HCC v24 model run under the Historical-Diagnoses scenario that are not produced by the same model run under the Within-Year-Updated scenario. In effect, this is the list of model outputs (HCCs, primarily) that are, as of the reference date, "missing" from the patient's RAF score because some diagnoses have not been documented at that point in the reference year. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • Historical-Diagnoses CMS-HCC v28 Outputs Missing from Within-Year-Updated Outputs Summary -- A semicolon-delimited list of the CMS-HCC model outputs, including both the code and natural language description for each, produced by the CMS-HCC v28 model run under the Historical-Diagnoses scenario that are not produced by the same model run under the Within-Year-Updated scenario. In effect, this is the list of model outputs (HCCs, primarily) that are, as of the reference date, "missing" from the patient's RAF score because some diagnoses have not been documented at that point in the reference year. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
  • CMS-HCC Missing Output Code
  • Ursa HCC Chronic vs. Not Chronic Type Category
  • Is Ursa Chronic vs. Not Chronic Type Primarily Chronic
  • Is Ursa Chronic vs. Not Chronic Type Primarily Not Chronic
  • Is Ursa Chronic vs. Not Chronic Type Mixed Chronic and Not Chronic

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.