Contents x
    [SO/URSA-PHU] Patient Timelines Master for URSA-PHU Concepts
    • 27 Jun 2025
    • 19 Minutes to read
    • Print
    • Dark
      Light
    Contents

    [SO/URSA-PHU] Patient Timelines Master for URSA-PHU Concepts

    • Updated on 27 Jun 2025
    • 19 Minutes to read
    • Print
    • Dark
      Light
    Article summary

    Object Description

    One record per patient-period for all living patients; including periods in which the patient is not a member of any plan, and not covered by data sources; includes information on patient's membership and data coverage status, including past and future status. This patient timeline includes fields specific to URSA-PHU used to characterize the patient's potentially preventable hospital utilization if present but includes patient-periods without any URSA-PHU related encounters.

    Metadata

    • Table Name: ursa.so_ursa_phu_pat_002
    • 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)
      • 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

    • Patient Fields

      • Is Any Current Plan Membership
      • Is Patient Alive
      • Is Hospice in Last 12 Months -- Evidence of CMS hospice status or evidence of hospice services in the last 12 months. Typically used as a denominator exclusion.
      • 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)
      • PCP Attribution Category
      • Primary Care Engagement Category
      • Count Primary Care Visits in Last 36 Months
      • Count Primary Care Visits Last 12 Months
      • Specialty Care Engagement Category
      • Count Specialty Care Office Visits in Last 36 Months
      • Primary or Specialty Care Engagement Category
      • Count Clinician Office Visits in Last 3 Years
      • Count Hospital Inpatient Admissions in Last 12 Months
      • Count ED Visits Without Inpatient Admissions in Last 12 Months

    • Date Fields

      • Period Start Date
      • Period End Date
      • Last Continuous Primary Payor Membership Episode Start Date -- The start date of the most recent prior completed Continuous Primary Payor Membership Episode as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Primary Payor Membership Episode)
      • Last Continuous Primary Payor Membership Episode End Date -- The end date of the most recent prior completed Continuous Primary Payor Membership Episode 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)
      • Next Continuous Primary Payor Membership Episode Start Date -- The start date of the next Continuous Primary Payor Membership Episode starting after the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Primary Payor Membership Episode)
      • Next Continuous Primary Payor Membership Episode End Date -- The end date of the next Continuous Primary Payor Membership Episode starting after 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 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 Non-Membership Episode Start Date -- The start date of the Non-Membership Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Non-Membership Episode)
      • Current Non-Membership Episode End Date -- The end date of the Non-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] Non-Membership Episode, [URSA-CORE] Period End Date)
      • 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)
      • Current Continuous Pharmacy Claim Data Coverage Episode Start Date -- The start date of the Continuous Pharmacy Claim Data Coverage Episode in effect as of the (potentially historical) period covered by the record. (See also [URSA-CORE] Continuous Pharmacy Claim Data Coverage Episode)
      • Current Continuous Pharmacy Claim Data Coverage Episode End Date -- The end date of the Continuous Pharmacy 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 Pharmacy Claim Data Coverage Episode)
      • Most Recent Prior Primary Care Visit Last 12 Months Encounter 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)

    • Provider Fields

      • Count Visits with Attributee Individual Primary Care Provider in Last 36 Months
      • Count Visits with Attributee Primary Care Provider Group in Last 36 Months

    • Insurance Fields

      • Primary Plan Financial Class Description
      • Count Active Plan Memberships
      • Is Any Plan Financial Class Commercial
      • Is Any Plan Financial Class Medicare FFS
      • Is Any Plan Financial Class Medicare Advantage
      • Is Any Plan Financial Class Medicaid
      • Is CMS ESRD Status -- Indicates the patient meets the Medicare ESRD eligibility criterion as of a particular date; can be derived from the CMS Medicare Beneficiary Status Code. (See also [URSA-CORE] CMS Medicare Beneficiary Status Code)
      • Is CMS Hospice Status -- Indicates the patient is considered to be Hospice status.

    • Diagnosis Fields

      • CCW Count Category
      • Count CCW Conditions -- The total of both Chronic Conditions and Potentially Disabling Events included in the CMS Chronic Condition Warehouse (CCW) library. (See also [URSA-CORE] CCW Comorbidity Category, [URSA-CORE] Count Potentially Disabling Events, [URSA-CORE] CMS Chronic Condition Warehouse (CCW), [URSA-CORE] Count Chronic Conditions)
      • Is CCW Acquired Hypothyroidism -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Acute Myocardial Infarction -- At least 1 inpatient claim with one or more of the DX codes from the corresponding CCW value set as the first or second diagnosis position in the prior 1 year.
      • Is CCW ADHD, Conduct Disorders, and Hyperkinetic Syndrome -- At least 1 inpatient claim OR 2 other non-drug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Alzheimers Disease -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 3 years.
      • Is CCW Alzheimers Disease and Related Disorders or Senile Dementia -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 3 years.
      • Is CCW Anemia -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Anxiety Disorders -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Asthma -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Atrial Fibrillation -- At least 1 inpatient OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set as the first or second diagnosis position in the prior 1 year.
      • Is CCW Autism Spectrum Disorder -- At least 1 inpatient claim OR 2 other non-drug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Benign Prostatic Hyperplasia -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year. Exclusion: If any of the qualifying claims also have an ICD-10 DX of D29.1, then it is excluded.
      • Is CCW Bipolar Disorder -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Blindness and Visual Impairment -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Breast Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in prior 1 year.
      • Is CCW Cataract -- At least 1 HOP or Carrier claim with one or more of the DX codes from the corresponding CCW value set as the principal diagnosis position in the prior 1 year.
      • Is CCW Cerebral Palsy -- At least 1 inpatient claim OR 2 other non-drug claims of any service type with DX codes over the last 2 years (See also [URSA-CORE] CMS Chronic Condition Warehouse (CCW))
      • Is CCW CKD -- Indicates that the patient meets the CMS Chronic Condition Warehouse criteria for chronic kidney disease; i.e., 2 or more qualifying outpatient or professional ICD codes in the prior 2 years, or 1 or more non-outpatient institutional claim ICD codes in the prior 2 years.
      • Is CCW Colorectal Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW COPD and Bronchiectasis -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Cystic Fibrosis and Other Metabolic Disorder -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Deafness and Hearing Impairment -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Depression -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Depressive Disorders -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Diabetes -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Endometrial Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Epilepsy -- At least 1 inpatient claim OR 2 other non-drug claims of any service type during the two-year period (See also [URSA-CORE] CMS Chronic Condition Warehouse (CCW))
      • Is CCW Fibromyalgia and Chronic Pain and Fatigue -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Glaucoma -- At least 1 Carrier claim with one or more of the DX codes from the corresponding CCW value set as the principal diagnosis position in the prior 1 year.
      • Is CCW Heart Failure -- At least 1 inpatient, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Hip or Pelvic Fracture -- At least 1 inpatient or SNF claim with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Hyperlipidemia -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Hypertension -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Intellectual Disability -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Ischemic Heart Disease -- At least 1 inpatient, SNF, HHA, HOP, or Carrier claim with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Learning Disability -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Leukemia -- At least 1 inpatient OR 2 non-inpatient claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Lung Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Migraine and Chronic Headache -- At least 1 inpatient claim OR 2 non-inpatient claims with DX codes within a 2 year period. (See also [URSA-CORE] CMS Chronic Condition Warehouse (CCW))
      • Is CCW Mobility Impairment -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Multiple Sclerosis -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Muscular Dystrophy -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Obesity -- At least 1 inpatient OR 2 non-inpatient claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Osteoporosis -- At least 1 inpatient, SNF, HHA OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW Other Developmental Delay -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Personality Disorder -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Pressure or Chronic Ulcer -- At least 1 inpatient OR 2 non-inpatient claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Prostate Cancer -- At least 1 inpatient, SNF OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
      • Is CCW PTSD -- At least 1 inpatient OR 2 other nondrug claims of any service type with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW PVD -- At least 1 inpatient OR 2 non-inpatient claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Rheumatoid Arthritis or Osteoarthritis -- At least 2 inpatient, SNF, HHA, HOP, or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Schizophrenia -- At least 1 inpatient claim OR 2 other non-drug claims of any service type with DX codes at least one day apart in the prior within the 2 year reference period. Qualifying codes can also be found as a subset of those in the CCW "Schizophrenia or Other Psychotic Disorders". (See also [URSA-CORE] Is CCW Schizophrenia or Other Psychotic Disorders)
      • Is CCW Schizophrenia or Other Psychotic Disorders -- At least 1 inpatient OR 2 other nondrug claims of any service type with one ore more of the DX codes from the corresponding CCW value set in the prior 2 years.
      • Is CCW Stroke or Transient Ischemic Attack -- At least 1 inpatient OR 2 HOP or Carrier claims with one or more of the DX codes from the corresponding CCW value set in the prior 1 year.
        EXCLUSIONS: If any of the qualifying claims have : 800 <= DX Code <=
        804.9, 850 <= DX Code <= 854.1 in any DX position OR DX V57xx as the principal DX Code, then the claim is excluded.
      • CCW Systems Category
      • Count CCW Systems -- The count of distinct systems of the body with one or more active CCW Condition. CCW Systems are as a parent category to the individual CCW Conditions grouping them based primarily on the human body system they impact such as; Behavioral Health, Cancers, Cardiovascular, Cerebrovascular, Endocrine, Genitourinary, Musculoskeletal, and Pulmonary. (See also [URSA-CORE] CMS Chronic Condition Warehouse (CCW))
      • Is CCW System Behavioral Health -- Indicates the patient has one or more of the following CCW conditions; ADHD, Conduct Disorders, and Hyperkinetic Syndrome, Anxiety Disorders, Autism Spectrum Disorder, Bipolar Disorder, Depression, Depressive Disorders, Personality Disorders, PTSD, Schizophrenia, or Schizophrenia and Other Psychotic Disorders.
      • Is CCW System Cardiovascular -- Indicates the patient has one or more of the following CCW conditions; Acute Myocardial Infarction (AMI), Atrial Fibrillation, Heart Failure, Hypertension, Ischemic Heart Disease, or Peripheral Vascular Disease (PVD).
      • Is CCW System Congenital -- Indicates the patient has one or more of the following CCW conditions; Cerebral Palsy, Cystic Fibrosis and Other Metabolic Disorder, Intellectual Disability, Learning Disability, Muscular Dystrophy, or Other Developmental Delays.
      • Is CCW System Endocrine/Metabolic -- Indicates the patient has one or more of the following CCW conditions; Diabetes, Acquired Hypothyroidism, Hyperlipidemia, or Obesity.
      • Is CCW System Genitourinary -- Indicates the patient has one or more of the following CCW conditions; Benign Prostatic Hyperplasia or Chronic Kidney Disease (CKD).
      • Is CCW System Hematologic -- Indicates the patient has one or more of the following CCW conditions; Anemia.
      • Is CCW System Musculoskeletal -- Indicates the patient has one or more of the following CCW conditions; Hip or Pelvic Fracture, Rheumatoid Arthritis or Osteoarthritis, or Osteoporosis.
      • Is CCW System Neurological -- Indicates the patient has one or more of the following CCW conditions; Alzheimer's Disease, Alzheimer's Disease and Related Disorders or Senile Dementia, Stroke or Transient Ischemic Attack, Epilepsy, Migraine and Chronic Headache, Mobility Impairment, Multiple Sclerosis, or Deafness and Hearing Impairment.
      • Is CCW System Oncologic -- Indicates the patient has one or more of the following CCW conditions; Breast Cancer, Colorectal Cancer, Endometrial Cancer, Lung Cancer, Prostate Cancer, or Leukemia.
      • Is CCW System Ophthalmologic -- Indicates the patient has one or more of the following CCW conditions; Cataract, Glaucoma, or Blindness and Visual Impairment.
      • Is CCW System Pulmonary -- Indicates the patient has one or more of the following CCW conditions; Asthma, or Chronic Obstructive Pulmonary Disease (COPD) and Bronchiectasis.
      • Is CCW System Other -- Indicates the patient has one or more of the following CCW conditions; Fibromyalgia and Chronic Pain and Fatigue, Pressure or Chronic Ulcer.

    • Metadata Fields

      • Random Integer 1 to 1000
      • Is Medical Claim Data Coverage -- Indicates data coverage for medical claims (i.e., institutional and professional claims) from at least one data source for the patient and time period specified on the record. (See also [URSA-CORE] Data Coverage)
      • Is Pharmacy Claim Data Coverage -- Indicates data coverage for pharmacy claims from at least one data source for the patient and time period specified on the record. (See also [URSA-CORE] Data Coverage)

    • Module Fields

      • Is ED High-Utilizer
      • Is New ED High-Utilizer
      • Count ED Visits in Last 3 Months
      • Count ED Visits in Last 12 Months
      • Count Potentially Preventable ED Visits in Last 12 Months
      • Count Potentially Preventable ED Visits Due to Preventable Condition in Last 12 Months
      • Count Potentially Preventable ED Visits Due to Inappropriate Setting in Last 12 Months
      • Count Ambulatory Care Sensitive Admissions in Last 12 Months
      • Count Admissions with Prior Related Encounter in Last 12 Months
      • Count Potentially Preventable ED Visits Without Admissions in Next 12 Months
      • Count Potentially Preventable Inpatient Admissions in Next 12 Months
      • Count Ambulatory Care Sensitive Admissions in Next 12 Months
      • Count Admissions with Prior Related Encounter in Next 12 Months
      • Total Paid Amount for Potentially Preventable Hospital Encounters in Next 12 Months

    Foreign Keys

    • empirical_attributee_primary_care_prov_group_prov_id → ursa.no_ursa_core_prov_001.prov_id
    • empirical_attributee_primary_care_individual_prov_id → ursa.no_ursa_core_prov_001.prov_id
    • pat_id → ursa.no_ursa_core_pat_001.pat_id
    • primary_plan_attributee_prov_id → ursa.no_ursa_core_prov_001.prov_id
    • primary_payor_id → ursa.no_ursa_core_struct_004.payor_id
    • primary_plan_id → ursa.no_ursa_core_struct_005.plan_id
    Was this article helpful?
    What's Next