[SO/URSA-CKD] Patient Timelines for CKD Stage

Object Description

One record per patient-period during which the patient met the criteria for CKD and stage could be determined.

Metadata

• Table Name: ursa.so_ursa_ckd_pat_004
• Layer: SYNTHETIC_OBJECT
• Object Type: Attribution 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

• Date Fields

  • Period Start Date
  • Period End Date

• Diagnosis Fields

  • Is CKD Stage 1
  • Is CKD Stage 2
  • Is CKD Stage 3
  • Is CKD Stage 4
  • Is CKD Stage 5
  • Is ESRD

• Validation Only Fields

  • Is 2+ Codes This Stage
  • Is Chronic Dialysis Patient
  • Is CMS ESRD Status Patient
  • Stage Token

Foreign Keys

• pat_id → ursa.no_ursa_core_pat_001.pat_id