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

Object Description

One row per patient-period for living patients with any data coverage.

Metadata

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

• Operations Support Fields

  • Patient Operational ID -- The user-facing value used by staff used to uniquely identify the Patient in their administrative systems and/or day-to-day operations. (See also [URSA-CORE] Patient)

• Patient Fields

  • Is Patient Alive
  • 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 Age Integer -- Patient age, expressed as an integer, as of a reference date or interval.
  • NCQA Race Code -- The code used to identify race in official NCQA measure submissions; e.g., 1 = White, 2 = Black or African American, 3 = American Indian and Alaska Native, 4 = Asian, etc.
  • NCQA Ethnicity Code -- The code used to identify ethnicity in official NCQA measure submissions; e.g., 1 = Hispanic or Latino, 2 = Not Hispanic or Latino, 3 = Unknown Ethnicity.
  • NCQA Gender Code -- The code used to identify gender in official NCQA measure submissions; e.g., M = male; F = female.
  • Is Patient Sex Female -- Indicates the patient's sex is female. 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 patient sex documented on that particular type of record in the source data.
  • Is Patient Sex Male -- Indicates the patient's sex is male. 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 patient sex documented on that particular type of record in the source data.
  • Is Patient with 2nd Birthday in Last 12 Months
  • Is Patient with 13th Birthday in Last 12 Months
  • Is Patient turned 15 months in Last 12 Months
  • Is Patient turned 30 months in Last 12 Months
  • Is Patient Age 3 Mo to 1 Yr
  • Is Patient with Non-Supplemental Outpatient Visit with PCP or OB in Last 12 Months
  • Patient State Abbreviation
  • Patient ZIP Code 5-Digit
  • 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
  • Is Patient Death in Last 12 Mo
  • Patient Age Integer Unbounded by Death
  • Is Patient with 19th Birthday in Last 12 Months
  • Is Patient Age 0-27 Mo
  • Is Patient Age 0-36 Mo
  • Is Patient Age 15-42 Mo
  • Is Patient Age 10-13 years
  • Is Patient Age 9-13 years
  • Patient Date of Death

• 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)
  • 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 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)
  • 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

  • Primary Plan Attributee Provider Description
  • Primary Plan Attributee Primary NUCC Provider Taxonomy Description
  • Empirical Attributee Primary Care Individual Provider Description
  • Empirical Attributee Primary Care Provider Group Provider Description
  • Empirical Attributee Primary Care Individual Primary NUCC Provider Taxonomy Description
  • Empirical Attributee Primary Care Provider Group Primary NUCC Provider Taxonomy Description

• Insurance Fields

  • Primary Payor Description
  • Primary Plan Description
  • Primary Plan Financial Class Description
  • 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 Membership
  • Is Any Plan MMP
  • Is Any Plan SNP
  • Is Any Plan I-SNP

• Diagnosis Fields

  • Is History of Narcolepsy

• 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 Advanced Illness -- Two or more instances of advanced illness on distinct dates in the last 24 months or one or more instance of dementia medications in last 24 months. Typically combined with age and/or frailty for denominator exclusion.
  • 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.
  • Is Palliative Care in Last 12 Months -- Evidence of at least one palliative care event in the last 12 months. Typically used as a denominator exclusion.
  • Is Institutionalized Status in Last 12 Months -- Evidence of enrollment in an I-SNP plan or evidence of living in a long-term institution at any point in the last 12 months. Typically combined with age as a denominator restriction.
  • Is Pregnancy in Last 12 Months -- Evidence of pregnancy in the last 12 months. Used as a denominator exclusion for some measures.
  • Is Frailty in Last 12 Months
  • Is Frailty in Last 18 Months
  • Is Palliative Care in Last 18 Months
  • Is Institutionalized Status in Last 18 Months
  • Is Diabetes in Last 24 Months -- 1) Two or more claims with evidence of diabetes on distinct dates in the last 24 months OR 2) One claim with evidence of diabetes and one insulin or hypoglycemic/antihyperglycemic medication fill in the last 24 months.
  • Is Diabetes in Last 24 Months Allowing Supplemental Data

• [No Field Group]

  • Is Schizophrenia or Bipolar Disorder in Last 12 Months
  • Is Diabetes Diagnosis
  • Is Diabetes Medication Document
  • Is History of Contraindication of Vaccine
  • Is History of Organ and Bone Marrow Transplant
  • Is Diabetes Diagnosis includes Supplemental Data
  • is Diabetes Medication Document with Supplemental Data

Foreign Keys

• primary_plan_id → ursa.no_ursa_core_struct_005.plan_id
• primary_payor_id → ursa.no_ursa_core_struct_004.payor_id
• last_continuous_primary_payor_membership_episode_payor_id → ursa.no_ursa_core_struct_004.payor_id
• next_continuous_primary_payor_membership_episode_payor_id → ursa.no_ursa_core_struct_004.payor_id
• primary_plan_attributee_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
• empirical_attributee_primary_care_prov_group_prov_id → ursa.no_ursa_core_prov_001.prov_id