[DM/URSA-QUALITY] Patient Timeline of Asthma Concepts

Object Description

None

Metadata

• Table Name: ursa.so_ursa_quality_pat_008
• Layer: DATA_MART
• 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

• Patient Fields

  • Is Patient with ED or IP Visit with Asthma Principal DX in Last 12 Months
  • Is Patient with IP Stay with Asthma Principal DX in Last 12 Months
  • Is Patient with 4+ Qualifying Outpatient Visit with Asthma Diagnosis
  • Is Patient with Asthma DX in Any Setting in Last 12 Months

• Medication Fields

  • Is Asthma Controller Medication Including Supplemental
  • Is Asthma Controller NDC Including Supplemental
  • Is Asthma Reliever NDC Including Supplemental
  • Is Asthma Reliever Medication Non-Supplemental
  • NDC Medication Dispensing Events per Patient|Date|Drug Category|Route Includes Supplemental
  • NDC Units of Medication per Patient|Date|Drug Category|Route Includes Supplemental
  • NDC Controller Units of Medication per Patient|Date|Drug Category|Route Includes Supplemental
  • Medication Dispensing Events per Patient|Date|Drug Category|Route for Non-Supplemental Data
  • Units of Medication per Patient|Date|Drug Category|Route for Non-Supplemental

• Validation Only Fields

  • Count Asthma Controller and Relieve NDCs in Last 12 Mo
  • IP Discharge Date

• [No Field Group]

  • Sum of Non-Supplemental Medication Dispensing Events per Patient|Date|Drug Category Route
  • Sum of Non-Supplemental Leukotriene Modifier or Antibody Inhibitor Dispensing Events per Patient|Date|Drug Category|Route
  • Are all Medications Dispensed Leukutiene or Antibody Inhibitors
  • Is Patient with Persistent Asthma
  • Reason for Measure Eligibility in Year
  • Reason For Measure Eligibility in Year with Med Logic
  • Is Required Exclusion Non-Laboratory Respiratory Diseases with Different Treatment Approaches than Asthma in Last 12 Mo
  • 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)
  • Period Start Date
  • Period End Date