[SO/URSA-CKD] Chronic Dialysis Episodes

Object Description

One record per chronic dialysis episode; episodes must have at least one home or dialysis facility dialysis encounter to qualify as chronic.

Metadata

• Table Name: ursa.so_ursa_ckd_episode_001
• Layer: SYNTHETIC_OBJECT
• Object Type: Single Stack
• Temporal Class: Interval
• Case ID: Episode ID
• Interval Start Date: Episode Start Date
• Interval End Date: Episode End Date
• Primary Key: Episode ID

Published Fields

• Data Model Keys

  • Episode ID
  • 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)
  • First Encounter ID

• Date Fields

  • Episode Start Date
  • Episode End Date

• Encounter Fields

  • First Encounter Setting Category
  • Is First Encounter Setting Home or Outpatient Dialysis Facility
  • Is First Encounter Setting Home
  • Is First Encounter Setting Outpatient Dialysis Facility
  • Is First Encounter Setting Inpatient
  • Is First Encounter Setting Outpatient Non-Dialysis Facility
  • First Encounter Qualifying Document HCPCS Code
  • First Encounter Qualifying Document CMS Revenue Center Code
  • Is First Encounter Hospital Inpatient Admission Encounter
  • Is First Encounter Emergency Department Visit Parent Encounter
  • Is First Encounter Observation Stay Parent Encounter
  • Count Hospital Inpatient Admission Encounters with Dialysis
  • Count Emergency Department Visit Parent Encounters with Dialysis
  • Count Home Dialysis Encounters
  • Count Inpatient Dialysis Encounters
  • Count Outpatient Dialysis Facility Dialysis Encounters
  • Count Outpatient Non-Dialysis Facility Dialysis Encounters

• Episode Fields

  • Episode Length Days
  • Episode Count of Dialysis Encounters

• Clinical Services Fields

  • First Encounter Dialysis Modality Category
  • Is First Encounter Dialysis Modality Hemodialysis
  • Is First Encounter Dialysis Modality Peritoneal Dialysis
  • Count Documented Hemodialysis Encounters
  • Count Documented Peritoneal Dialysis Encounters
  • Last Encounter Date with Documented Hemodialysis
  • Last Encounter Date with Documented Peritoneal Dialysis
  • First Encounter Vascular Access Type Category
  • Is First Encounter Vascular Access Type Any Catheter
  • Is First Encounter Vascular Access Type Graft Without Catheter
  • Is First Encounter Vascular Access Type Fistula Only

Foreign Keys

• pat_id → ursa.no_ursa_core_pat_001.pat_id
• first_enc_id → ursa.so_ursa_ckd_enc_002.enc_id

Dedicated Precursors

• [SO/URSA-CKD] Chronic Dialysis Episodes, Precursor 1 (Dialysis Encounters with Episode Metadata): One record per encounter with performed dialysis; with metadata on the dialysis episode containing that encounter.