[SO/URSA-CORE] Patient Timelines for CCW Conditions

Object Description

One record per patient period in which the patient was alive and met the criteria for at least one CMS Chronic Condition Warehouse (CCW) condition.

Metadata

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

• Date Fields

  • Period Start Date
  • Period End Date

• Diagnosis Fields

  • Count CCW Conditions
  • Is CCW Acquired Hypothyroidism
  • Is CCW Acute Myocardial Infarction
  • Is CCW Alzheimers Disease
  • Is CCW Alzheimers Disease and Related Disorders or Senile Dementia
  • Is CCW Anemia
  • Is CCW Asthma
  • Is CCW Atrial Fibrillation
  • Is CCW Benign Prostatic Hyperplasia
  • Is CCW Breast Cancer
  • Is CCW Cataract
  • Is CCW CKD
  • Is CCW COPD and Bronchiectasis
  • Is CCW Colorectal Cancer
  • Is CCW Depression
  • Is CCW Diabetes
  • Is CCW Endometrial Cancer
  • Is CCW Glaucoma
  • Is CCW Heart Failure
  • Is CCW Hip or Pelvic Fracture
  • Is CCW Hyperlipidemia
  • Is CCW Hypertension
  • Is CCW Ischemic Heart Disease
  • Is CCW Lung Cancer
  • Is CCW Osteoporosis
  • Is CCW Prostate Cancer
  • Is CCW Stroke or Transient Ischemic Attack
  • Is CCW Anxiety Disorders
  • Is CCW Depressive Disorders
  • Is CCW Rheumatoid Arthritis or Osteoarthritis
  • Is CCW Schizophrenia or Other Psychotic Disorders
  • Is CCW Bipolar Disorder
  • Is CCW Epilepsy
  • Is CCW Cerebral Palsy
  • Is CCW Migraine and Chronic Headache
  • Is CCW Cystic Fibrosis and Other Metabolic Disorder
  • Is CCW Fibromyalgia and Chronic Pain and Fatigue
  • Is CCW ADHD, Conduct Disorders, and Hyperkinetic Syndrome
  • Is CCW Autism Spectrum Disorder
  • Is CCW Intellectual Disability
  • Is CCW Learning Disability
  • Is CCW Leukemia
  • Is CCW Mobility Impairment
  • Is CCW Multiple Sclerosis
  • Is CCW Muscular Dystrophy
  • Is CCW Obesity
  • Is CCW Other Developmental Delay
  • Is CCW PVD
  • Is CCW Personality Disorder
  • Is CCW PTSD
  • Is CCW Pressure or Chronic Ulcer
  • Is CCW Schizophrenia
  • Is CCW Blindness and Visual Impairment
  • Is CCW Deafness and Hearing Impairment
  • Count CCW Systems
  • Is CCW System Behavioral Health
  • Is CCW System Cardiovascular
  • Is CCW System Congenital
  • Is CCW System Endocrine/Metabolic
  • Is CCW System Genitourinary
  • Is CCW System Hematologic
  • Is CCW System Musculoskeletal
  • Is CCW System Neurological
  • Is CCW System Oncologic
  • Is CCW System Ophthalmologic
  • Is CCW System Pulmonary
  • Is CCW System Other

Terms

• CMS Chronic Condition Warehouse (CCW): The CMS Chronic Conditions Data Warehouse (CCW) provides researchers with Medicare and Medicaid beneficiary, claims, and assessment data linked by beneficiary across the continuum of care. The CCW includes common chronic conditions and other chronic or potentially disabling conditions, which identify additional chronic health, mental health, and substance abuse conditions. These reference only ICD-10 diagnosis codes and have modified look-back periods, qualifying claims, and codes. See more at: https://www2.ccwdata.org/

Dedicated Precursors

• [SO/URSA-CORE] Patient Timelines for CCW Conditions, Precursor 1 (Diagnosis Inputs): One record per [patient / date / claim type] triple; with flags for select CCW conditions