Skip to main content

Data Export - Episodes of Care

Episode of Care​

Generated by the Bulk Data Export system

The order of columns is subject to change. When parsing files, please ensure to use headers rather than positional parsing to ensure you are reading the data correctly.

What this export contains​

One row per episode of care, a span of active treatment and measurement for a patient under a managing organization. It carries the start and end dates, status and treatment service. Most clinical exports link back to an episode of care, so it is the natural unit for caseload and outcomes analysis.

Example questions this export can answer​

  • Measure length of treatment from episode start to end
  • Count active versus discharged episodes by site or program
  • Use episode id as the unit for outcomes and caseload reporting
PropertyNameField TypeCardinalityNotes
instituteidInstitute Ididentifier1..*
instituteShortcodeInstitute ShortcodeString1..*
idIdidentifier1..1
patientIdPatient Ididentifier1..1Patient
statusStatusenum1..1planned | waitlistactiveon_holdfinishedcanceled
managingOrganizationIdManaging Organization Ididentifier1..1
periodStartPeriod Starttimestamp1..1
periodEndPeriod Endtimestamp0..1
treatmentServiceIdTreatment Service Ididentifier1..1Treatment Service