Skip to content
Partner Developer Portal

Schema

Column NameData TypeDescriptionExample
_ingest_timevarcharTimestamp of data ingestion’20260304183451’
emis_session_guidvarcharUnique identifier for the session’123e4567-e89b-12d3-a456-426614174000’
emis_location_guidvarcharLocation GUID for the session’123e4567-e89b-12d3-a456-426614174001’
session_idbigintSession identifier67890
session_type_descriptionvarcharSession type description’GP Surgery’
session_category_display_namevarcharDisplay name for session category’Routine’
session_start_datedateSession start date’2026-04-10’
session_start_timevarcharSession start time’09:00:00’
session_end_datedateSession end date’2026-04-10’
session_end_timevarcharSession end time’12:00:00’
private_flagbooleanWhether the session is privatefalse
emis_session_organisation_guidvarcharSession organisation GUID’123e4567-e89b-12d3-a456-426614174001’
deletedbooleanSoft-delete flagfalse
_execution_datevarchar(14)Extract execution date’20260521042151’
organisationvarcharOrganisation identifier’CDB-0001’