Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	varchar	The datetime that the record was ingested, format YYYYMMDDHHMMSS	’20230512143015’
is_deleted	boolean	Indicates if this record should be considered soft deleted	FALSE
slot_id	bigint	Internal identifier for the appointment slot, unique within a source database	12345
appointment_slot_guid	varchar	The EMIS globally unique identifier for the appointment slot	’a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
slot_uuid	varchar	Deterministic UUID5 generated from slot_id + organisation	’b2c3d4e5-f6a7-5b6c-0d1e-2f3a4b5c6d7e’
load_datetime	timestamp(6) with time zone	Formatted ingest time for filtering	’2023-05-12 14:30:15.000000 UTC’
session_id	bigint	Internal identifier for the appointment session this slot belongs to	67890
session_guid	varchar	The EMIS globally unique identifier for the session	’c3d4e5f6-a7b8-6c7d-1e2f-3a4b5c6d7e8f’
session_uuid	varchar	Deterministic UUID5 generated from session_id + organisation	’d4e5f6a7-b8c9-7d0e-2f3a-4b5c6d7e8f9a’
session_organisation_id	bigint	Internal identifier for the organisation that owns the session	54321
session_organisation_guid	varchar	The EMIS globally unique identifier for the session organisation	’e5f6a7b8-c9d0-8e1f-3a4b-5c6d7e8f9a0b’
session_organisation_uuid	varchar	Deterministic UUID5 generated from session_organisation_id + organisation	’f6a7b8c9-d0e1-9f2a-4b5c-6d7e8f9a0b1c’
patient_id	bigint	Internal identifier for the patient linked to this slot	11223
patient_guid	varchar	The EMIS globally unique identifier for the patient registration	’f6a7b8c9-d0e1-9f2a-4b5c-6d7e8f9a0b1c’
patient_uuid	varchar	Deterministic UUID5 generated from patient_id + organisation	’07b8c9d0-e1f2-0a3b-5c6d-7e8f9a0b1c2d’
patient_organisation_id	bigint	Internal identifier for the organisation where the patient is registered	22334
patient_organisation_guid	varchar	The EMIS globally unique identifier for the patient’s organisation	’18c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
patient_organisation_uuid	varchar	Deterministic UUID5 generated from patient_organisation_id + organisation	’29d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
external_patient_guid	varchar	GUID for a patient booked from an external organisation	’b8c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
external_patient_organisation_id	bigint	Internal identifier of the external patient’s organisation	99887
external_patient_organisation_guid	varchar	GUID of the organisation from which the external patient originates	’b8c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
external_patient_organisation_uuid	varchar	Deterministic UUID5 generated from external_patient_organisation_id + organisation	’3ae1f2a3-b4c5-3d6e-8f9a-0b1c2d3e4f5a’
slot_start_datetime	timestamp(6) with time zone	The date and time the slot is scheduled to start	’2023-09-01 09:00:00.000000 UTC’
slot_end_datetime	timestamp(6) with time zone	The date and time the slot is scheduled to end	’2023-09-01 09:10:00.000000 UTC’
booked_datetime	timestamp(6) with time zone	The date and time the slot was booked by the patient	’2023-08-20 14:30:00.000000 UTC’
arrived_datetime	timestamp(6) with time zone	The date and time the patient arrived for the appointment	’2023-09-01 08:58:00.000000 UTC’
sent_in_datetime	timestamp(6) with time zone	The date and time the patient was sent in to see the clinician	’2023-09-01 09:02:00.000000 UTC’
left_datetime	timestamp(6) with time zone	The date and time the patient left the appointment	’2023-09-01 09:12:00.000000 UTC’
call_started_datetime	timestamp(6) with time zone	The date and time a remote consultation call started	’2023-09-01 09:01:00.000000 UTC’
call_ended_datetime	timestamp(6) with time zone	The date and time a remote consultation call ended	’2023-09-01 09:11:00.000000 UTC’
planned_duration_in_minutes	bigint	The planned duration of the appointment slot in minutes	10
actual_duration_in_minutes	bigint	The actual duration of the appointment in minutes	12
waiting_time_in_minutes	bigint	The time the patient waited from arrival to being sent in, in minutes	2
appointment_delay_in_minutes	bigint	The number of minutes the appointment started after its scheduled time	5
appointment_lead_time_in_minutes	bigint	The number of minutes between booking and appointment start time	720
current_status_id	bigint	Internal identifier for the slot’s current status	3
current_status_datetime	timestamp(6) with time zone	The date and time the current status was recorded	’2023-09-01 09:02:00.000000 UTC’
current_status_type_id	bigint	Internal identifier for the delivery mode or status type of the slot	2
current_status_description	varchar	Human-readable description of the current slot status (e.g. arrived, dna, available)	‘arrived’
current_status_type_description	varchar	Description of the slot delivery mode (e.g. Face to Face, Telephone)	‘Face to Face’
current_status_last_set_by_global_user_in_role_id	bigint	Internal identifier for the current status last set by global user in role	12345
current_status_last_set_by_global_user_in_role_uuid	varchar	Deterministic UUID5 generated from current_status_last_set_by_global_user_in_role_id + organisation	’3ae1f2a3-b4c5-3d6e-8f9a-0b1c2d3e4f5a’
slot_type_id	bigint	Internal identifier for the type of the slot	5
slot_type_description	varchar	Human-readable description of the slot type (e.g. Bookable, Walk-in)	‘Bookable’
slot_type_national_category_name	varchar	National slot category name associated with the slot type	’General Practice’
slot_type_national_category_description	varchar	National slot category description associated with the slot type	’Standard GP consultation slot’
context_type	varchar	Operational context for the slot (for example routine or urgent care context)	‘Routine Care’
service_setting	varchar	Service setting in which the appointment is delivered	’Primary Care’
booking_method_id	bigint	Internal identifier for the booking method used	1
booking_method_description	varchar	Description of how the slot was booked (e.g. Practice Booked, Online)	‘Practice Booked’
booked_by_external_organisation_id	bigint	Internal identifier for the booked by external organisation	12345
booked_by_external_organisation_uuid	varchar	Deterministic UUID5 generated from booked_by_external_organisation_id + organisation	’3ae1f2a3-b4c5-3d6e-8f9a-0b1c2d3e4f5a’
is_booked	boolean	Indicates whether the slot has been booked by a patient	TRUE
is_blocked	boolean	Indicates whether the slot is blocked and unavailable for booking	FALSE
is_gp_connect_bookable	boolean	Indicates whether the slot can be booked via GP Connect	TRUE
is_internet_bookable	boolean	Indicates whether the slot is available for online booking	FALSE
is_urgent	boolean	Indicates whether the appointment slot is marked as urgent	FALSE
patient_age_at_appointment	bigint	The patient’s age at the time of the appointment in years	42
did_not_attend_reason_id	bigint	Internal identifier for the reason a patient did not attend (DNA)	NULL
embargo_type_id	bigint	Internal identifier for the embargo type applied to restrict early booking	NULL
embargo_days	bigint	Number of days before the slot start date at which the embargo lifts	NULL
embargo_minutes	bigint	Number of minutes before the slot start time at which a relative embargo lifts	NULL
embargo_time	varchar	The specific time of day at which a fixed embargo lifts	NULL
embargo_is_relative	boolean	Indicates whether the embargo timing is relative to the slot start time	NULL
organisation	varchar	An identifier for the source of data (an organisation) relating to a given GP practice	’CDB-12345’
extract_datetime	timestamp(6) with time zone	The datetime that the record was last extracted from the source database with a relevant change	’2023-05-12 14:30:15.000000 UTC’
transform_datetime	timestamp(6) with time zone	The datetime the data was made available in the model with a relevant change	’2023-09-01 10:30:15.000000 UTC’
_execution_date	varchar	Formatted transform datetime for versioning	’20230901103015’

Vanilla

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	slot_deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
session_uuid	varchar	✗	✓
emis_session_guid	varchar	✓	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓
session_organisation_guid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	varchar	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_start_date_time	timestamp(6) with time zone	✓	✓
slot_end_date_time	timestamp(6) with time zone	✓	✓
time_booked	timestamp(6) with time zone	✓	✓
arrived_datetime	timestamp(6) with time zone	✗	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
call_started_datetime	varchar	✗	✓
call_ended_datetime	varchar	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_minutes	varchar	✓	✓
appointment_delay_in_minutes	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
slot_current_status_emis_id	varchar	✓	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	varchar	✗	✓
slot_status_description	varchar	✓	✓
slot_delivery_mode	varchar	✓	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	varchar	✗	✓
slot_type_description	varchar	✓	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
booking_method_id	varchar	✗	✓
booking_method	varchar	✓	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
slot_booked_flag	boolean	✓	✓
slot_blocked_flag	boolean	✓	✓
slot_gpconnect_flag	boolean	✓	✓
slot_internet_flag	boolean	✓	✓
is_urgent	boolean	✗	✓
patient_age_at_appointment	bigint	✗	✓
did_not_attend_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
external_patient_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
did_not_attend_reason_id	varchar	✗	✓
embargo_type_id	varchar	✗	✓
slot_embargoed_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
slot_embargo_is_relative_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_encounter_guid	varchar	✓	✗
session_lead_hcp_type	varchar	✓	✗
non_regular_and_current_active	varchar	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
regular_and_current_active	varchar	✓	✗
regular_current_active_and_inactive	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
session_category_display_name	varchar	✓	✗
session_deleted	varchar	✓	✗
session_end_date_time	varchar	✓	✗
session_location	varchar	✓	✗
session_start_date_time	varchar	✓	✗
slot_release_date	varchar	✓	✗
slot_release_date_time	varchar	✓	✗
slot_release_time	varchar	✓	✗
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Apollo

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	slot_deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✗	✓
slot_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
session_id	varchar	✗	✓
session_guid	varchar	✗	✓
session_uuid	varchar	✗	✓
patient_organisation_id	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
emis_lead_session_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_start_date_time	timestamp(6) with time zone	✓	✓
slot_end_date_time	timestamp(6) with time zone	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✗	✓
waiting_time_in_minutes	varchar	✗	✓
appointment_delay_in_minutes	varchar	✗	✓
appointment_lead_time_in_minutes	varchar	✗	✓
patient_age_at_appointment	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
embargo_type_id	varchar	✗	✓
service_setting	varchar	✗	✓
context_type	varchar	✗	✓
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
external_patient_organisation_guid	varchar	✗	✓
external_patient_organisation_uuid	varchar	✗	✓
booked_datetime	timestamp(6) with time zone	✗	✓
arrived_datetime	timestamp(6) with time zone	✗	✓
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
current_status_id	bigint	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	bigint	✗	✓
current_status_description	varchar	✗	✓
current_status_type_description	varchar	✗	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	bigint	✗	✓
slot_type_description	varchar	✗	✓
booking_method_id	bigint	✗	✓
booking_method_description	varchar	✗	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
is_booked	boolean	✗	✓
is_blocked	boolean	✗	✓
is_gp_connect_bookable	boolean	✗	✓
is_internet_bookable	boolean	✗	✓
is_urgent	boolean	✗	✓
did_not_attend_reason_id	bigint	✗	✓
embargo_is_relative	boolean	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Artemis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	slot_deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
emis_session_guid	varchar	✓	✓
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	varchar	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
booking_method	varchar	✓	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
time_booked	varchar	✓	✓
slot_start_date_time	timestamp(6) with time zone	✓	✓
slot_end_date_time	timestamp(6) with time zone	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_minutes	varchar	✓	✓
appointment_delay_in_minutes	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
current_status_type_id	varchar	✗	✓
slot_current_status_emis_id	varchar	✓	✓
slot_status_description	varchar	✓	✓
slot_delivery_mode	varchar	✓	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	varchar	✗	✓
slot_type_description	varchar	✓	✓
patient_age_at_appointment	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	varchar	✗	✓
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
slot_booked_flag	boolean	✓	✓
slot_blocked_flag	boolean	✓	✓
slot_gpconnect_flag	boolean	✓	✓
slot_internet_flag	boolean	✓	✓
did_not_attend_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_embargoed_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_embargo_is_relative_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	varchar	✓	✗
emis_encounter_guid	varchar	✓	✗
exa_encounter_guid	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
session_lead_hcp_type	varchar	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
session_category_display_name	varchar	✓	✗
session_deleted	varchar	✓	✗
session_end_date_time	timestamp(6) with time zone	✓	✗
session_location	varchar	✓	✗
session_start_date_time	timestamp(6) with time zone	✓	✗
slot_release_date	date	✓	✗
slot_release_date_time	timestamp(6) with time zone	✓	✗
slot_release_time	time	✓	✗
booking_method_id	bigint	✗	✓
arrived_datetime	timestamp(6) with time zone	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
is_urgent	boolean	✗	✓
did_not_attend_reason_id	bigint	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Hestia

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	slot_deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
emis_session_guid	varchar	✓	✓
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	varchar	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
booking_method_id	varchar	✗	✓
booking_method	varchar	✓	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
time_booked	timestamp(6) with time zone	✓	✓
slot_start_date_time	timestamp(6) with time zone	✓	✓
slot_end_date_time	timestamp(6) with time zone	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_minutes	varchar	✓	✓
appointment_delay_in_minutes	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
slot_current_status_emis_id	varchar	✓	✓
slot_status_description	varchar	✓	✓
slot_delivery_mode	varchar	✓	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	varchar	✗	✓
slot_type_description	varchar	✓	✓
patient_age_at_appointment	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	varchar	✗	✓
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
slot_booked_flag	boolean	✓	✓
slot_blocked_flag	boolean	✓	✓
slot_gpconnect_flag	boolean	✓	✓
slot_internet_flag	boolean	✓	✓
did_not_attend_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
external_patient_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_embargoed_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_embargo_is_relative_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_encounter_guid	varchar	✓	✗
session_lead_hcp_type	varchar	✓	✗
non_regular_and_current_active	varchar	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
regular_and_current_active	varchar	✓	✗
regular_current_active_and_inactive	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
session_category_display_name	varchar	✓	✗
session_deleted	varchar	✓	✗
session_end_date_time	timestamp(6) with time zone	✓	✗
session_location	time	✓	✗
session_start_date_time	timestamp(6) with time zone	✓	✗
slot_release_date	date	✓	✗
slot_release_date_time	timestamp(6) with time zone	✓	✗
slot_release_time	time	✓	✗
arrived_datetime	timestamp(6) with time zone	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	bigint	✗	✓
is_urgent	boolean	✗	✓
did_not_attend_reason_id	bigint	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Olympus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
emis_appointment_slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
emis_session_guid	varchar	✓	✓
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
emis_session_organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
patient_organisation_id	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
slot_start_date	date	✓	✓
slot_start_time	time	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_minutes	varchar	✓	✓
appointment_delay_in_minutes	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
patient_age_at_appointment	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	varchar	✗	✓
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
did_not_attend_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
did_not_attend_reason_emis_code_id	decimal	✓	✓
processing_id	bigint	✓	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
external_patient_organisation_guid	varchar	✗	✓
external_patient_organisation_uuid	varchar	✗	✓
slot_end_datetime	timestamp(6) with time zone	✗	✓
booked_datetime	timestamp(6) with time zone	✗	✓
arrived_datetime	timestamp(6) with time zone	✗	✓
current_status_id	bigint	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	bigint	✗	✓
current_status_description	varchar	✗	✓
current_status_type_description	varchar	✗	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	bigint	✗	✓
slot_type_description	varchar	✗	✓
booking_method_id	bigint	✗	✓
booking_method_description	varchar	✗	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
is_booked	boolean	✗	✓
is_blocked	boolean	✗	✓
is_gp_connect_bookable	boolean	✗	✓
is_internet_bookable	boolean	✗	✓
is_urgent	boolean	✗	✓
embargo_is_relative	boolean	✗	✓
did_not_attend_reason_id	bigint	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Prometheus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
emis_appointment_slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
emis_session_guid	varchar	✓	✓
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
emis_session_organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
slot_start_date	date	✓	✓
slot_start_time	time	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_minutes	varchar	✓	✓
appointment_delay_in_minutes	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
patient_age_at_appointment	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	varchar	✗	✓
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
did_not_attend_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
did_not_attend_reason_emis_code_id	decimal	✓	✓
processing_id	bigint	✓	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
external_patient_organisation_guid	varchar	✗	✓
external_patient_organisation_uuid	varchar	✗	✓
slot_end_datetime	timestamp(6) with time zone	✗	✓
booked_datetime	timestamp(6) with time zone	✗	✓
arrived_datetime	timestamp(6) with time zone	✗	✓
current_status_id	bigint	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	bigint	✗	✓
current_status_description	varchar	✗	✓
current_status_type_description	varchar	✗	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	bigint	✗	✓
slot_type_description	varchar	✗	✓
booking_method_id	bigint	✗	✓
booking_method_description	varchar	✗	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
is_booked	boolean	✗	✓
is_blocked	boolean	✗	✓
is_gp_connect_bookable	boolean	✗	✓
is_internet_bookable	boolean	✗	✓
is_urgent	boolean	✗	✓
embargo_is_relative	boolean	✗	✓
did_not_attend_reason_id	bigint	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	execution_date	✓	Exists in v1 with a different name

Pseudo_Anon

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
session_guid	varchar	✓	✓
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
patient_guid	varchar	✓	✓
patient_id	bigint	✗	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	varchar	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
appointment_date	date	✓	✓
appointment_start_time	timestamp(6) with time zone	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_min	varchar	✓	✓
appointment_delay_in_min	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
patient_age_at_appointment	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	varchar	✗	✓
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
did_not_attend	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
dna_reason_code_id	decimal	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
external_patient_organisation_guid	varchar	✗	✓
external_patient_organisation_uuid	varchar	✗	✓
slot_end_datetime	timestamp(6) with time zone	✗	✓
booked_datetime	timestamp(6) with time zone	✗	✓
arrived_datetime	timestamp(6) with time zone	✗	✓
current_status_id	bigint	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	bigint	✗	✓
current_status_description	varchar	✗	✓
current_status_type_description	varchar	✗	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	bigint	✗	✓
slot_type_description	varchar	✗	✓
booking_method_id	bigint	✗	✓
booking_method_description	varchar	✗	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
is_booked	boolean	✗	✓
is_blocked	boolean	✗	✓
is_gp_connect_bookable	boolean	✗	✓
is_internet_bookable	boolean	✗	✓
is_urgent	boolean	✗	✓
embargo_is_relative	boolean	✗	✓
did_not_attend_reason_id	bigint	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	execution_date	✓	Exists in v1 with a different name

Themis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of the model.

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	slot_deleted	✓	Exists in v1 with a different name
load_datetime	timestamp(6) with time zone	✗	✓
slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
slot_uuid	varchar	✗	✓
session_id	varchar	✗	✓
session_uuid	varchar	✗	✓
emis_session_guid	varchar	✓	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓
session_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	varchar	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
slot_start_date_time	timestamp(6) with time zone	✓	✓
slot_end_date_time	timestamp(6) with time zone	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
time_booked	timestamp(6) with time zone	✓	✓
sendin_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
left_time	time	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
sent_in_datetime	timestamp(6) with time zone	✗	✓
left_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	varchar	✓	✓
actual_duration_in_minutes	varchar	✓	✓
patient_wait_in_minutes	varchar	✓	✓
appointment_delay_in_minutes	varchar	✓	✓
appointment_lead_time_in_minutes	varchar	✗	✓
patient_age_at_appointment	varchar	✗	✓
slot_current_status_emis_id	varchar	✓	✓
current_status_type_id	varchar	✗	✓
slot_status_description	varchar	✓	✓
slot_delivery_mode	varchar	✓	✓
current_status_last_set_by_global_user_in_role_id	bigint	✗	✓
current_status_last_set_by_global_user_in_role_uuid	varchar	✗	✓
slot_type_id	varchar	✗	✓
slot_type_description	varchar	✓	✓
booking_method_id	varchar	✗	✓
booking_method	varchar	✓	✓
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
slot_booked_flag	boolean	✓	✓
slot_blocked_flag	boolean	✓	✓
slot_gpconnect_flag	boolean	✓	✓
slot_internet_flag	boolean	✓	✓
did_not_attend_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
external_patient_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
did_not_attend_reason_id	varchar	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	varchar	✗	✓
slot_embargoed_flag	boolean	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
embargo_days	varchar	✗	✓
embargo_minutes	varchar	✗	✓
embargo_time	varchar	✗	✓
slot_embargo_is_relative_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_encounter_guid	varchar	✓	✗
session_lead_hcp_type	varchar	✓	✗
non_regular_and_current_active	varchar	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
regular_and_current_active	varchar	✓	✗
regular_current_active_and_inactive	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
session_category_display_name	varchar	✓	✗
session_deleted	varchar	✓	✗
session_end_date_time	varchar	✓	✗
session_location	varchar	✓	✗
session_start_date_time	timestamp(6) with time zone	✓	✗
slot_release_date	date	✓	✗
slot_release_date_time	timestamp(6) with time zone	✓	✗
slot_release_time	time	✓	✗
arrived_datetime	timestamp(6) with time zone	✗	✓
current_status_datetime	timestamp(6) with time zone	✗	✓
is_urgent	boolean	✗	✓
organisation	varchar	✓	✓
extract_datetime	timestamp(6) with time zone	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Zeus

Not used in this schema