_ingest_time | varchar | Ingest timestamp | ’2026-04-10T12:00:00Z’ |
emis_session_guid | varchar | Unique identifier for the session | ’session-12345’ |
emis_location_guid | varchar | Location GUID for the session | ’loc-55555’ |
session_id | varchar | Session identifier | ’sid-99999’ |
session_type_description | varchar | Session type description | ’GP Surgery’ |
session_category_display_name | varchar | Display name for the session category | ’Routine’ |
session_start_date | date | Session start date | ’2026-04-10’ |
session_start_time | varchar | Session start time | ’09:00:00’ |
session_end_date | date | Session end date | ’2026-04-10’ |
session_end_time | varchar | Session end time | ’12:00:00’ |
private_flag | boolean | Whether the session is private | false |
emis_session_organisation_guid | varchar | Session organisation GUID | ’org-22222’ |
deleted | boolean | Soft-delete flag | false |
_execution_date | varchar | Extract execution date | ’2026-04-10’ |
organisation | varchar | Organisation identifier | ’CDB-0001’ |