Contents x
    [DM/URSA-HCC] Data Mart for URSA-HCC Patient Timelines
    • 17 Jul 2025
    • 21 Minutes to read
    • Print
    • Dark
      Light
    Contents

    [DM/URSA-HCC] Data Mart for URSA-HCC Patient Timelines

    • Updated on 17 Jul 2025
    • 21 Minutes to read
    • Print
    • Dark
      Light
    Article summary

    Object Description

    One record per patient-period in which the patient had a calculated RAF score. (RAF scores are generated during calendar years in which the patient had an active membership at any time.)

    Metadata

    • Table Name: ursa.dm_ursa_hcc_001
    • Layer: DATA_MART
    • Object Type: Single Stack
    • 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)
      • Primary Payor ID -- The internal database identifier (used, e.g., for joins and primary keys) for the Primary Payor. (See also [URSA-CORE] Primary Payor)
      • Primary Plan ID
      • Primary Plan Attributee Provider ID
      • Empirical Attributee Primary Care Individual Provider ID
      • Empirical Attributee Primary Care Provider Group Provider ID

    • Date Fields

      • Period Start Date
      • Period End Date
      • Current Continuous Primary Payor Membership Episode Start Date -- The start date of the Continuous Primary Payor Membership Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Primary Payor Membership Episode)
      • Current Continuous Primary Payor Membership Episode End Date -- The end date of the Continuous Primary Payor Membership Episode in effect as of the (potentially historical) period covered by the record. Values follow the standard exclusive convention for Period End Dates. (See also [URSA-CORE] Continuous Primary Payor Membership Episode, [URSA-CORE] Period End Date)
      • Current Continuous Medical Claim Data Coverage Episode Start Date -- The start date of the Continuous Medical Claim Data Coverage Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Medical Claim Data Coverage Episode)
      • Current Continuous Medical Claim Data Coverage Episode End Date -- The end date of the Continuous Medical Claim Data Coverage Episode in effect as of the (potentially historical) period covered by the record. Values follow the standard exclusive convention for Period End Dates. (See also [URSA-CORE] Continuous Medical Claim Data Coverage Episode, [URSA-CORE] Period End Date)

    • Module Fields

      • CMS-HCC Patient Age -- For a given reference date or month, the patient age, expressed as an integer, evaluated as of February 1 of the calendar year containing the reference date or month; this is the method used to establish a patient's age for calculation of HCC/RAF score results.
      • CMS-HCC Age Category -- A categorical value describing the patient's age with respect to the age ranges used to group patients for the CMS-HCC RAF score calculation; uses the CMS-HCC Patient Age value. (See also [URSA-HCC] CMS-HCC Patient Age)
      • CMS-HCC Patient Sex Code -- Takes the value of "M" for male patients and "F" for female patients, which are the values expected by the CMS-HCC RAF score model. Because the model requires patient sex as an input, patients are assumed to be female if their sex is not known.
      • Is CMS-HCC Medicaid Patient -- The binary value used by the CMS-HCC model to identify Medicaid patients. Derived, when possible, from the CMS RAF Type Code (obtained either from an MMR record or a membership record). (See also [URSA-HCC] CMS RAF Type Code)
      • CMS-HCC Eligibility Code -- The coded value used by the CMS-HCC model to characterize the patient's community vs. long-term institutional residential status, full dual vs. partial dual vs. non-dual status, and aged vs. disabled Medicare eligibility status. Values are as follows: CFA = Community Full Benefit Dual Aged; CFD = Community Full Benefit Dual Disabled; CNA = Community Non-Dual Aged; CND = Community Non-Dual Disabled; CPA: Community Partial Benefit Dual Aged; CPD = Community Partial Benefit Dual Disabled; INS = Long Term Institutional; NE = New Enrollee; SNPNE = SNP NE. Derived, when possible, from the CMS RAF Type Code (obtained either from an MMR record or a membership record). Because the model requires this code as an input, patients are assumed to be CNA if their true status is not known. (See also [URSA-HCC] CMS RAF Type Code)
      • CMS-HCC Eligibility Code Description
      • CMS-HCC Original Reason for Entitlement Code -- The CMS Original Reason for Entitlement Code (OREC) for the patient used by the CMS-HCC model. Takes the same values as the standard CMS Original Reason for Entitlement Code field. This value is obtained from the MMR if available there, then from the membership record. Because the model requires this code as an input, patients are assumed to be OREC = Aged if their true status is not known. (See also [URSA-CORE] CMS Original Reason for Entitlement Code)
      • CMS-HCC Original Reason for Entitlement Code Description
      • Standard Final Action CMS-HCC RAF Score -- The normalized CMS-HCC RAF score calculated under the Standard Final Action scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC Raw RAF Score -- The raw (non-normalized) CMS-HCC RAF score calculated under the Standard Final Action scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC Demographic Component RAF Score -- The demographic component contribution to the normalized CMS-HCC RAF score, calculated under the Standard Final Action scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC Disease Component RAF Score -- The disease component contribution to the normalized CMS-HCC RAF score, calculated under the Standard Final Action scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC v24 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Standard Final Action scenario, using the CMS-HCC model v24. (See also [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC v28 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Standard Final Action scenario, using the CMS-HCC model v28. (See also [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC v24 to v28 Increase in RAF Score -- The increase in RAF score from the Standard Final Action CMS-HCC v24 RAF score to the CMS-HCC v28 RAF score; a positive number indicates the v28 score is higher than the v24 score. (See also [URSA-HCC] Standard Final Action CMS-HCC v24 RAF Score, [URSA-HCC] Standard Final Action CMS-HCC v28 RAF Score)
      • Standard Final Action CMS-HCC RAF Score Using 2024 Blend -- The CMS-HCC RAF score calculated using the 2024 blend under the Standard Final Action scenario. (See also [URSA-HCC] CMS-HCC RAF Score Using 2024 Blend, [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action CMS-HCC RAF Score Using 2025 Blend -- The CMS-HCC RAF score calculated using the 2025 blend under the Standard Final Action scenario. (See also [URSA-HCC] CMS-HCC RAF Score Using 2025 Blend, [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action 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 Standard Final Action scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Standard Final Action CMS-HCC Scenario)
      • Standard Final Action 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 Standard Final Action scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Standard Final Action 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)
      • Within-Year-Updated CMS-HCC Raw RAF Score -- The raw (non-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)
      • Within-Year-Updated CMS-HCC Demographic Component RAF Score -- The demographic 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)
      • 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)
      • Within-Year-Updated CMS-HCC v24 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Within-Year-Updated scenario, using the CMS-HCC model v24. (See also [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
      • Within-Year-Updated CMS-HCC v28 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Within-Year-Updated scenario, using the CMS-HCC model v28. (See also [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
      • Within-Year-Updated CMS-HCC RAF Score Using 2024 Blend -- The CMS-HCC RAF score calculated using the 2024 blend under the Within-Year-Updated scenario. (See also [URSA-HCC] CMS-HCC RAF Score Using 2024 Blend, [URSA-HCC] Within-Year-Updated CMS-HCC Scenario)
      • Within-Year-Updated CMS-HCC RAF Score Using 2025 Blend -- The CMS-HCC RAF score calculated using the 2025 blend under the Within-Year-Updated scenario. (See also [URSA-HCC] CMS-HCC RAF Score Using 2025 Blend, [URSA-HCC] Within-Year-Updated 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)
      • Within-Year-Updated Count CMS-HCC v24 HCCs
      • Within-Year-Updated Count CMS-HCC v28 HCCs
      • 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)
      • Historical-Diagnoses vs. Standard Final Action CMS-HCC RAF Score Gap -- The difference between the CMS-HCC RAF score calculated under the Historical-Diagnoses scenario and the Standard Final Action 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] Standard Final Action 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 Raw RAF Score -- The raw (non-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)
      • Historical-Diagnoses CMS-HCC Demographic Component RAF Score -- The demographic 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)
      • 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)
      • Historical-Diagnoses CMS-HCC v24 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Historical-Diagnoses scenario, using the CMS-HCC model v24. (See also [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
      • Historical-Diagnoses CMS-HCC v28 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Historical-Diagnoses scenario, using the CMS-HCC model v28. (See also [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
      • Historical-Diagnoses CMS-HCC RAF Score Using 2024 Blend -- The CMS-HCC RAF score calculated using the 2024 blend under the Historical-Diagnoses scenario. (See also [URSA-HCC] CMS-HCC RAF Score Using 2024 Blend, [URSA-HCC] Historical-Diagnoses CMS-HCC Scenario)
      • Historical-Diagnoses CMS-HCC RAF Score Using 2025 Blend -- The CMS-HCC RAF score calculated using the 2025 blend under the Historical-Diagnoses scenario. (See also [URSA-HCC] CMS-HCC RAF Score Using 2025 Blend, [URSA-HCC] Historical-Diagnoses 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)
      • Historical-Diagnoses Count CMS-HCC v24 HCCs
      • Historical-Diagnoses Count CMS-HCC v28 HCCs
      • 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)
      • Standard Initial Run CMS-HCC RAF Score -- The normalized CMS-HCC RAF score calculated under the Standard Initial Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC Raw RAF Score -- The raw (non-normalized) CMS-HCC RAF score calculated under the Standard Initial Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC Demographic Component RAF Score -- The demographic component contribution to the normalized CMS-HCC RAF score, calculated under the Standard Initial Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC Disease Component RAF Score -- The disease component contribution to the normalized CMS-HCC RAF score, calculated under the Standard Initial Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC RAF Score Using 2024 Blend -- The CMS-HCC RAF score calculated using the 2024 blend under the Standard Initial Run scenario. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC RAF Score Using 2025 Blend -- The CMS-HCC RAF score calculated using the 2025 blend under the Standard Initial Run scenario. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC v24 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Standard Initial Run scenario, using the CMS-HCC model v24. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run CMS-HCC v28 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Standard Initial Run scenario, using the CMS-HCC model v28. (See also [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run 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 Standard Initial Run scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Initial Run 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 Standard Initial Run scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Standard Initial Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC RAF Score -- The normalized CMS-HCC RAF score calculated under the Standard Midyear Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC Raw RAF Score -- The raw (non-normalized) CMS-HCC RAF score calculated under the Standard Midyear Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC Demographic Component RAF Score -- The demographic component contribution to the normalized CMS-HCC RAF score, calculated under the Standard Midyear Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC Disease Component RAF Score -- The disease component contribution to the normalized CMS-HCC RAF score, calculated under the Standard Midyear Run scenario, blending different versions of the model (v24 vs. v28) as appropriate. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC RAF Score Using 2024 Blend -- The CMS-HCC RAF score calculated using the 2024 blend under the Standard Midyear Run scenario. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC RAF Score Using 2025 Blend -- The CMS-HCC RAF score calculated using the 2025 blend under the Standard Midyear Run scenario. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC v24 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Standard Midyear Run scenario, using the CMS-HCC model v24. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run CMS-HCC v28 RAF Score -- The normalized CMS-HCC RAF score, calculated under the Standard Midyear Run scenario, using the CMS-HCC model v28. (See also [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run 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 Standard Midyear Run scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Standard Midyear Run 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 Standard Midyear Run scenario. (See also [URSA-HCC] CMS-HCC Model Outputs, [URSA-HCC] Standard Midyear Run CMS-HCC Scenario)
      • Is Patient With CMS-HCC Calculations Using MAO-004 Diagnoses -- Indicates the CMS-HCC model used at least one MAO-004 diagnosis record to calculate this patient's HCC/RAF score in at least one time period.
      • Is Patient With CMS-HCC Calculations Using Claim Diagnoses -- Indicates the CMS-HCC model used at least one qualifying claim diagnosis record to calculate this patient's HCC/RAF score in at least one time period.
      • Is Patient With CMS-HCC Calculations Using Bill Diagnoses -- Indicates the CMS-HCC model used at least one qualifying bill diagnosis record to calculate this patient's HCC/RAF score in at least one time period.

    • Patient Fields

      • Patient Age Integer -- Patient age, expressed as an integer, as of a reference date or interval.
      • Patient Age Category Tier 1 -- Non-overlapping ranges of the patient age in years into three categories; [01] Pediatrics < 19, [02] Adults 19 - 64, and [03] Older Adults >= 65. Coarser grain to the Patient Age Category Tier 2. (See also [URSA-CORE] Patient Age Category Tier 2)
      • Patient Age Category Tier 2 -- Non-overlapping ranges of the patient age in years representing finer grain categories than the Patient Age Category Tier 1. This field incorporates findings from publications on defining meaningful age groups in the context of disease. These ranges closely, but not exactly, align with standard age ranges such as those defined by the Medical Subject Headings (MeSH). See results of K-Means simple clustering method at: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3825015/ (See also [URSA-CORE] Patient Age Category Tier 1)
      • Patient First Name
      • Patient Last Name
      • Patient Date of Birth -- The patient's date of birth. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the date of birth found on that particular type of record in the source data.
      • Patient State Abbreviation
      • Patient ZIP Code 5-Digit
      • UW HIP Area Deprivation Index National Percentile -- A value between 1 and 100 representing the composite measure of socioeconomic deprivation from University of Wisconsin’s School of Medicine and Public Health. Scores are for Census Block Group geographic level, which generally contains between 600 and 3,000 people. Higher scores indicate more deprivation, so a score of 1 indicates the least deprivation while a score of 100 indicates the most deprivation. Percentiles are constructed by ranking the ADI from low to high for the nation and grouping the block groups into bins corresponding to each 1% range of the ADI. The 2019 ADI was constructed using the 2015-2019 5-year estimates from the US Census' American Community Survey and includes 17 component measures that span the domains of income, education, employment, and housing quality. It may be linked with the 9-digit ZIP code crosswalk, which was built to correspond directly to Census block groups. The 2019 ADI was released on 07/14/2021 and is the most recent version as of 02/02/22.
      • UW HIP ADI Quintile Category -- The UW HIP Area Deprivation Index National Percentile grouped into 5 levels, each spanning 20 percentile points (ADI 1 is percentile scores from 1 to 20 while ADI 5 is scores from 81 to 100). Higher scores indicate more deprivation, so ADI 1 is the least deprived while ADI 5 is the most deprived. Quintiles are frequently used in health research. They give larger sample sizes per group and are easier to plot and interpret. Quintiles also carry less information and group more dissimilar patients. Quintiles are good for descriptive analyses while the original percentile measure is preferable for predictive modeling. (See also [URSA-CORE] UW HIP Area Deprivation Index National Percentile)
      • UW HIP ADI Decile Category
      • CDC SVI Overall National Percentile -- Social Vulnerability Index is a composite score maintained by the Center for Disease Control and Prevention using data from the U.S. Census of Population and Housing. The score is a composite of 15 measures, with all directed so that higher values indicate more vulnerability. The composite finds the percentile ranking of each component value, sums the percentile rankings, and then finds the percentile ranking of the sums. Percentile ranks are found with the formula: Percentile Rank = (Rank-1) / (N-1). If any component is missing, then the composite is also recoded as missing. Measures are organized into the four themes of Socioeconomic Status, Household Composition & Disability, Minority Status & Language, and Housing Type & Transportation, and composites for these themes are constructed with the same methodology. SVI is reported at the Census Tract level. Tracts aim to include about 4000 people each. On average, there are about 4 Census Block groups for each Census Tract, so the SVI has less geographic resolution than the ADI. Ursa stores the 2018 version of the SVI, which was released on 01/31/2020 and is the most recent as of 02/02/22. (See also [URSA-CORE] CDC SVI Overall Quintile Category)
      • CDC SVI Overall Quintile Category -- The CDC SVI Overall National Percentile grouped into 5 levels, each spanning 20 percentile points (the first quintile is percentile scores from 1 to 20 while the fifth is scores from 81 to 100). Higher scores indicate more vulnerability, so the first quintile is the least vulnerable while the fifth is the most vulnerable. Quintiles are frequently used in health research. They give larger sample sizes per group and are easier to plot and interpret. Quintiles also carry less information and group more dissimilar patients. Quintiles are good for descriptive analyses while the original percentile measure is preferable for predictive modeling.

    • Insurance Fields

      • CMS RAF Type Code -- The standard 1- or 2-character CMS Part C Risk Adjustment Factor Type Code; e.g., E = New Enrollee, I = Institutional, D = Dialysis (ESRD), CF = Community Full Dual, CP = Community Partial Dual, CN = Community Non-Dual, etc.
      • Primary Payor Description
      • Primary Plan Description
      • Primary Plan CMS Contract Number
      • Primary Plan CMS PBP Number
      • Primary Plan Financial Class Description

    • Metadata Fields

      • Random Integer 1 to 1000
    Was this article helpful?
    What's Next