Data Export - Appointments
Appointment
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 scheduled appointment between a patient and a provider, with its status (booked, arrived, noshow, canceled and so on), start and end time and duration. An appointment may or may not turn into a measurement encounter. This is the export for scheduling, attendance and no-show analysis.
Example questions this export can answer
- Measure no-show and cancellation rates by provider, site or time period
- Analyze appointment volume and utilization over time
- Compare scheduled appointments against measurement encounters to see where measurement actually happened
| Property | Name | Field Type | Cardinality | Notes | |||||
|---|---|---|---|---|---|---|---|---|---|
| instituteid | Institute Id | identifier | 1..* | ||||||
| instituteShortcode | Institute Shortcode | String | 1..* | ||||||
| id | Id | identifier | 1..1 | ||||||
| status | Status | enum | 1..1 | proposed | pending | booked | arrived | fulfilled | canceled | noshow |
| startDate | Start Date | timestamp | 1..1 | ||||||
| endDate | End Date | timestamp | 0..1 | ||||||
| minutesDuration | Duration (minutes) | integer | 1..1 | ||||||
| encounterId | Encounter Id | identifier | 0..1 | Encounter | |||||
| practitionerId | Practitioner Id | identifier | 0..1 | Practitioner | |||||
| patientId | Patient Id | identifier | 1..1 | Patient | |||||
| treatmentServiceId | Treatment Service Id | identifier | 1..1 | Treatment Service |