_ingest_time | varchar | Ingest timestamp | ’2026-04-10T12:00:00Z’ |
emis_appointment_slot_guid | varchar | Slot GUID | ’slot-12345’ |
slot_start_date | date | Slot start date | ’2026-04-10’ |
slot_start_time | varchar | Slot start time | ’09:30:00’ |
planned_duration_in_minutes | integer | Planned duration in minutes | 15 |
pseudo_registration_guid | varchar | Hashed registration identifier | ’reg-98765’ |
pseudo_patient_id | varchar | Hashed patient identifier | ’pat-54321’ |
sendin_time | varchar | Time patient was sent in | ’09:10:00’ |
left_time | varchar | Time patient left | ’09:45:00’ |
did_not_attend_flag | boolean | Did-not-attend flag | false |
patient_wait_in_minutes | integer | Patient wait time (minutes) | 10 |
appointment_delay_in_minutes | integer | Appointment delay in minutes | 5 |
actual_duration_in_minutes | integer | Actual duration in minutes | 20 |
emis_session_organisation_guid | varchar | Session organisation GUID | ’org-22222’ |
emis_session_guid | varchar | Session GUID | ’session-12345’ |
deleted | boolean | Soft-delete flag | false |
_execution_date | varchar | Extract execution date | ’2026-04-10’ |
organisation | varchar | Organisation identifier | ’CDB-0001’ |
study_id | varchar | Study identifier from included patients view | ’study-12345’ |