_ingest_time | varchar | Timestamp of data ingestion | ’20260304183451’ |
emis_session_guid | varchar | Unique identifier for the session | ’123e4567-e89b-12d3-a456-426614174000’ |
emis_location_guid | varchar | Location GUID for the session | ’123e4567-e89b-12d3-a456-426614174001’ |
session_id | bigint | Session identifier | 67890 |
session_type_description | varchar | Session type description | ’GP Surgery’ |
session_category_display_name | varchar | Display name for 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 | ’123e4567-e89b-12d3-a456-426614174001’ |
deleted | boolean | Soft-delete flag | false |
_execution_date | varchar(14) | Extract execution date | ’20260521042151’ |
organisation | varchar | Organisation identifier | ’CDB-0001’ |