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

  • Published on Aug 21, 2025
  • 6 minute(s) read
Prev Next

Object Description

One row per patient-period for living patients.

Metadata

  • Table Name: ursa.so_ursa_pqa_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 Plan Attributee Provider ID
    • Empirical Attributee Primary Care Individual Provider ID
    • Empirical Attributee Primary Care Provider Group Provider ID
    • 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

  • Patient Fields

    • Is Patient Alive
    • Patient Age Integer -- Patient age, expressed as an integer, as of a reference date or interval.
    • Patient Date of Death

  • Date Fields

    • Period Start Date
    • Period End Date
    • Earliest Diabetes Medication Fill in Last 12 months
    • Earliest Statin Diabetes Medication Fill in Last 12 months
    • Earliest Opioid Medication Fill in Last 12 months
    • Earliest Benzodiazepine Medication Fill in Last 12 months
    • Earliest Antihistamines Medication Fill in Last 12 months
    • Earliest Antiemetic Medication Fill in Last 12 months
    • Earliest Antimuscarinic Medication Fill in Last 12 months
    • Earliest Antiparkinsonian Medication Fill in Last 12 months
    • Earliest Antipsychotic Medication Fill in Last 12 months
    • Earliest Antispasmodic Medication Fill in Last 12 months
    • Earliest Skeletal Muscle Relaxant Medication Fill in Last 12 months
    • Earliest Antidepressant Medication Fill in Last 12 months
    • Earliest RASA Medication Fill in Last 12 months
    • Earliest Statin Medication Fill in Last 12 months
    • 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 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)
    • 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)
    • 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)

  • Encounter Fields

    • Is Ursa Encounter Type Hospital Inpatient Admission
    • Is Ursa Encounter Type SNF Encounter

  • Insurance Fields

    • Is Any Plan Membership
    • Is Any Plan Coverage Type Medical
    • Is Any Plan Coverage Type Pharmacy
    • 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 Any Plan MMP
    • Is Any Plan SNP
    • Is Any Plan I-SNP
    • 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.

  • Medication Fields

    • Count of Distinct Poly ACH Medication Groups
    • Count of Poly ACH Medication Groups with 2+ Fills
    • Count Distinct Diabetes Medication Fill Dates in Last 12 Months
    • Count Distinct Diabetes (Including Insulin) Medication Fill Dates in Last 12 Months
    • Count Distinct Benzodiazepine Medication Fill Dates in Last 12 Months
    • Count Distinct Antiemetic Medication Fill Dates in Last 12 Months
    • Count Distinct Antimuscarinic Medication Fill Dates in Last 12 Months
    • Count Distinct Antiparkinsonian Medication Fill Dates in Last 12 Months
    • Count Distinct Antipsychotic Medication Fill Dates in Last 12 Months
    • Count Distinct Antispasmodic Medication Fill Dates in Last 12 Months
    • Count Distinct Skeletal Muscle Relaxant Medication Fill Dates in Last 12 Months
    • Count Distinct Antidepressant Medication Fill Dates in Last 12 Months
    • Count Distinct Days of Statin Medication Fills in Last 12 Months
    • Count Distinct Opioid Medication Fills in Last 12 Months
    • Count Distinct Antihistamine Medication Fills in Last 12 Months
    • Count Distinct RASA Medication Fills in Last 12 Months
    • Cumulative Days of Anticholinergic Overlap in Measure Year
    • Cumulative Days of Opioid and Benzodiazepine Overlap in Measure Year
    • Is Period of Overlapping Opioid and Benzodiazepine Usage
    • Is Period of Overlapping Anticholinergic Usage

  • Metadata Fields

    • 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 Palliative Care in Last 12 Months
    • Is Pregnancy in Last 12 Months
    • Is Insulin Medication in Last 12 Months
    • Is ESRD in the Last 12 Months
    • Is PQA Hospice in the Last 12 Months
    • Is Lactation in Last 12 Months
    • Is Fertility Medication in Last 12 Months
    • Is PCOS in Last 12 Months
    • Is Cirrhosis in Last 12 Months
    • Is Rhabdomyolysis in Last 12 Months
    • Is Prediabetes in Last 12 Months
    • Is Cancer Diagnosis in Last 12 Months
    • Is Sickle Cell Diagnosis in Last 12 Months
    • Is Cancer Related Pain in Last 12 Months
    • Is Sacubitril Valsartan Medication in Last 12 Months
    • Count Hospital Inpatient Admissions in Last 12 Months
    • Count ED Visits Without Inpatient Admissions in Last 12 Months