_ingest_time | varchar | Ingest timestamp | ’20240603101655’ |
emis_appointment_slot_guid | varchar | Slot GUID | ’123e4567-e89b-12d3-a456-426614174000’ |
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 | ’a1b2c3d4-e5f6-7890-abcd-ef1234567890’ |
pseudo_patient_id | varchar | Hashed patient identifier | ’f47ac10b-58cc-4372-a567-0e02b2c3d479’ |
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 | ’b2c3d4e5-f6a7-8901-bcde-f12345678901’ |
emis_session_guid | varchar | Session GUID | ’c3d4e5f6-a7b8-9012-cdef-123456789012’ |
deleted | boolean | Soft-delete flag | false |
_execution_date | varchar(14) | Extract execution date | ’20260521042151’ |
organisation | varchar | Organisation identifier | ’CDB-0001’ |
study_id | varchar | Study identifier from included patients view | ’study-12345’ |