Schema

Core

The core schema represents the Appointment Slot/Current Appointment schema derived from EMIS source system.

Column Name	Data Type	Description	Example
load_datetime	timestamp(6) with time zone	The datetime that the record was last upserted into the EXA data lake from EMIS source system with a relevant change from source system.	‘2023-05-12 14:30:15.000000 UTC’
_ingest_time	varchar	The load_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility.	‘20230512143015’
is_deleted	boolean	Indicates whether the appointment slot record has been soft deleted.	FALSE
appointment_slot_id	bigint	The unique internal identifier for the appointment slot record within an organisation.	12345
appointment_slot_guid	varchar	The GUID for the appointment slot record within an organisation.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
appointment_slot_uuid	varchar	The UUID derived from appointment_slot_id and organisation, providing a stable unique identifier.	‘b2c3d4e5-f6a7-5b6c-0d1e-2f3a4b5c6d7e’
session_id	bigint	The unique internal identifier for the appointment session linked to this slot.	67890
session_guid	varchar	The GUID for the appointment session linked to this slot within an organisation.	‘c3d4e5f6-a7b8-6c7d-1e2f-3a4b5c6d7e8f’
session_uuid	varchar	The UUID derived from session_id and organisation, providing a stable unique identifier.	‘d4e5f6a7-b8c9-7d0e-2f3a-4b5c6d7e8f9a’
session_organisation_id	bigint	The unique internal identifier for the organisation where the session is recorded.	54321
session_organisation_guid	varchar	The GUID for the organisation where the session is recorded.	‘e5f6a7b8-c9d0-8e1f-3a4b-5c6d7e8f9a0b’
session_organisation_uuid	varchar	The UUID derived from session_organisation_id and organisation, providing a stable unique identifier.	‘f6a7b8c9-d0e1-9f2a-4b5c-6d7e8f9a0b1c’
patient_id	bigint	The unique internal identifier for the patient linked to the appointment slot.	11223
patient_guid	varchar	The GUID for the patient linked to the appointment slot within an organisation.	‘f6a7b8c9-d0e1-9f2a-4b5c-6d7e8f9a0b1c’
patient_uuid	varchar	The UUID derived from patient_id and organisation, providing a stable unique identifier.	‘07b8c9d0-e1f2-0a3b-5c6d-7e8f9a0b1c2d’
patient_organisation_id	bigint	The unique internal identifier for the organisation where the patient is registered.	22334
patient_organisation_guid	varchar	The GUID for the organisation where the patient is registered.	‘18c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
patient_organisation_uuid	varchar	The UUID derived from patient_organisation_id and organisation, providing a stable unique identifier.	‘29d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
external_patient_guid	varchar	The GUID for the patient booked from an external organisation.	‘b8c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
external_patient_organisation_id	bigint	The unique internal identifier for the external patient organisation.	99887
external_patient_organisation_guid	varchar	The GUID for the external patient organisation.	‘b8c9d0e1-f2a3-1b4c-6d7e-8f9a0b1c2d3e’
external_patient_organisation_uuid	varchar	The UUID derived from external_patient_organisation_id and organisation, providing a stable unique identifier.	‘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	decimal(10, 2)	The planned duration of the appointment slot in minutes.	30.00
actual_duration_in_minutes	decimal(10, 2)	The actual duration of the appointment in minutes.	25.53
waiting_time_in_minutes	decimal(10, 2)	The waiting time from patient arrival to being sent in, in minutes.	14.67
appointment_delay_in_minutes	decimal(10, 2)	The number of minutes the appointment started after the scheduled slot start time.	12.00
appointment_lead_time_in_minutes	decimal(10, 2)	The number of minutes between booking time and slot start time.	7142.47
current_status_id	bigint	The internal identifier for the current appointment slot 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_description	varchar	The display description of the current slot status (for example, arrived, DNA, or available).	‘arrived’
current_status_type_id	bigint	The internal identifier for the current slot status type or delivery mode.	2
current_status_type_description	varchar	The display description of the slot delivery mode (for example, Face to Face or Telephone).	‘Face to Face’
current_status_last_set_by_global_user_in_role_id	bigint	The internal identifier for the user in role that last set the current slot status.	12345
current_status_last_set_by_global_user_in_role_uuid	varchar	The UUID derived from current_status_last_set_by_global_user_in_role_id and organisation, providing a stable unique identifier.	‘3ae1f2a3-b4c5-3d6e-8f9a-0b1c2d3e4f5a’
slot_type_id	bigint	The internal identifier for the appointment slot type.	188
slot_type_description	varchar	The display description of the appointment slot type	‘Nurse F2F 30mins’
slot_type_national_category_name	varchar	National slot category name associated with the slot type	‘General Consultation Routine’
slot_type_national_category_description	varchar	National slot category description associated with the slot type	‘A planned consultation or routine follow u’
context_type	varchar	Operational context for the slot (for example routine or urgent care context)	‘Care Related Encounter’
service_setting	varchar	Service setting in which the appointment is delivered	‘General Practice’
booking_method_id	bigint	The internal identifier for the booking method used for the slot.	1
booking_method_description	varchar	The display description of how the slot was booked (for example, via Practice or Online).	‘Practice’
booked_by_external_organisation_id	bigint	The internal identifier for the external organisation that booked the slot.	12345
booked_by_external_organisation_uuid	varchar	The UUID derived from booked_by_external_organisation_id and organisation, providing a stable unique identifier.	‘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 age at the time of the appointment in years.	42
did_not_attend_reason_id	bigint	The internal identifier for the reason a patient did not attend (DNA).	405044018
embargo_type_id	bigint	The internal identifier for the embargo type applied to the slot.	23
embargo_days	bigint	Number of days before the slot start date at which the embargo lifts	7
embargo_minutes	bigint	Number of minutes before the slot start time at which a relative embargo lifts	0
embargo_time	timestamp(6) with time zone	The specific time of day at which a fixed embargo lifts	‘2021-12-31 00:00:00.000000 UTC’
embargo_is_relative	boolean	Indicates whether the embargo timing is relative to the slot start time	FALSE
organisation	varchar	An identifier for the source organisation (GP practice) associated with the slot record.	‘CDB-12345’
transform_datetime	timestamp(6) with time zone	The datetime when the record was last processed and updated in the data model.	‘2023-09-01 10:30:15.000000 UTC’
_execution_date	varchar	The transform_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility.	‘20230901103015’

Vanilla

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	✓	✓		Renamed from `slot_deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
session_uuid	varchar	✗	✓
emis_session_guid	varchar	✓	✓	session_guid
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓	external_patient_organisation_guid
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_start_date_time	timestamp(6) with time zone	✓	✓	slot_start_datetime
slot_end_date_time	timestamp(6) with time zone	✓	✓	slot_end_datetime
booked_datetime	timestamp(6) with time zone	✓	✓		Renamed from `time_booked` in V1
arrived_datetime	timestamp(6) with time zone	✗	✓
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in v1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in v1
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓		Renamed from `patient_wait_in_minutes` in V1
appointment_delay_in_minutes	decimal(10, 2)	✓	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
slot_current_status_emis_id	bigint	✓	✓	current_status_id
current_status_datetime	timestamp(6) with time zone	✗	✓
current_status_type_id	bigint	✗	✓
slot_status_description	varchar	✓	✓	current_status_description
slot_delivery_mode	varchar	✓	✓	current_status_type_description
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	✓	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
booking_method_id	bigint	✗	✓
booking_method	varchar	✓	✓	booking_method_description
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
slot_booked_flag	boolean	✓	✓	is_booked
slot_blocked_flag	boolean	✓	✓	is_blocked
slot_gpconnect_flag	boolean	✓	✓	is_gp_connect_bookable
slot_internet_flag	boolean	✓	✓	is_internet_bookable
is_urgent	boolean	✗	✓
patient_age_at_appointment	bigint	✗	✓
did_not_attend_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
external_patient_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
did_not_attend_reason_id	bigint	✗	✓
embargo_type_id	bigint	✗	✓
slot_embargoed_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
slot_embargo_is_relative_flag	boolean	✓	✓	embargo_is_relative
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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Apollo

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	✓	✓		Renamed from `slot_deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✗	✓
appointment_slot_uuid	varchar	✗	✓
patient_id	bigint	✗	✓
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
session_id	bigint	✗	✓
session_guid	varchar	✗	✓
session_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
emis_lead_session_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_start_date_time	timestamp(6) with time zone	✓	✓	slot_start_datetime
slot_end_date_time	timestamp(6) with time zone	✓	✓	slot_end_datetime
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✗	✓
waiting_time_in_minutes	decimal(10, 2)	✗	✓
appointment_delay_in_minutes	decimal(10, 2)	✗	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
patient_age_at_appointment	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
embargo_type_id	bigint	✗	✓
service_setting	varchar	✗	✓
context_type	varchar	✗	✓
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Artemis

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	✓	✓		Renamed from `slot_deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
emis_session_guid	varchar	✓	✓	session_guid
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓	external_patient_organisation_guid
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
booking_method	varchar	✓	✓	booking_method_description
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
booked_datetime	timestamp(6) with time zone	✓	✓		Renamed from `time_booked` in V1
slot_start_date_time	timestamp(6) with time zone	✓	✓	slot_start_datetime
slot_end_date_time	timestamp(6) with time zone	✓	✓	slot_end_datetime
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in V1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in V1
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓	Renamed from `patient_wait_in_minutes` in V1
appointment_delay_in_minutes	decimal(10, 2)	✓	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
current_status_type_id	bigint	✗	✓
slot_current_status_emis_id	bigint	✓	✓	current_status_id
slot_status_description	varchar	✓	✓	current_status_description
slot_delivery_mode	varchar	✓	✓	current_status_type_description
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	✓	✓
patient_age_at_appointment	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	bigint	✗	✓
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
slot_booked_flag	boolean	✓	✓	is_booked
slot_blocked_flag	boolean	✓	✓	is_blocked
slot_gpconnect_flag	boolean	✓	✓	is_gp_connect_bookable
slot_internet_flag	boolean	✓	✓	is_internet_bookable
did_not_attend_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_embargoed_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_embargo_is_relative_flag	boolean	✓	✓	embargo_is_relative
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 changes in v2 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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Hermes

The table below presents the flavour specific schema and maps columns between core and flavour (V2).

Column Name	Data Type	Core Mapping	Comments
is_deleted	boolean
pseudo_appointment_slot_uuid	varchar	appointment_slot_uuid	hashed
pseudo_session_organisation_uuid	varchar	session_organisation_uuid	hashed
pseudo_session_uuid	varchar	session_uuid	hashed
pseudo_patient_uuid	varchar	patient_uuid	hashed
pseudo_patient_organisation_uuid	varchar	patient_organisation_uuid	hashed
pseudo_external_patient_guid	varchar	external_patient_guid	hashed
pseudo_external_patient_organisation_uuid	varchar	external_patient_organisation_uuid	hashed
slot_start_datetime	timestamp(6) with time zone
slot_end_datetime	timestamp(6) with time zone
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
call_started_datetime	timestamp(6) with time zone
call_ended_datetime	timestamp(6) with time zone
planned_duration_in_minutes	decimal(10, 2)
actual_duration_in_minutes	decimal(10, 2)
waiting_time_in_minutes	decimal(10, 2)
appointment_delay_in_minutes	decimal(10, 2)
appointment_lead_time_in_minutes	decimal(10, 2)
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
slot_type_id	bigint
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	bigint
booking_method_description	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_type_id	bigint
embargo_days	bigint
embargo_minutes	bigint
embargo_time	timestamp(6) with time zone
embargo_is_relative	boolean
patient_age_at_appointment	bigint
organisation	varchar
transform_datetime	timestamp(6) with time zone

Hestia

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	✓	✓		Renamed from `slot_deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
emis_session_guid	varchar	✓	✓	session_guid
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓	external_patient_organisation_guid
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
booking_method_id	bigint	✗	✓
booking_method	varchar	✓	✓	booking_method_description
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
booked_datetime	timestamp(6) with time zone	✓	✓		Renamed from `time_booked` in V1
slot_start_date_time	timestamp(6) with time zone	✓	✓	slot_start_datetime
slot_end_date_time	timestamp(6) with time zone	✓	✓	slot_end_datetime
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in v1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in v1
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓		Renamed from `patient_wait_in_minutes` in V1
appointment_delay_in_minutes	decimal(10, 2)	✓	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
slot_current_status_emis_id	bigint	✓	✓	current_status_id
slot_status_description	varchar	✓	✓	current_status_description
slot_delivery_mode	varchar	✓	✓	current_status_type_description
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	✓	✓
patient_age_at_appointment	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	bigint	✗	✓
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
slot_booked_flag	boolean	✓	✓	is_booked
slot_blocked_flag	boolean	✓	✓	is_blocked
slot_gpconnect_flag	boolean	✓	✓	is_gp_connect_bookable
slot_internet_flag	boolean	✓	✓	is_internet_bookable
did_not_attend_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
external_patient_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_embargoed_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_embargo_is_relative_flag	boolean	✓	✓	embargo_is_relative
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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Olympus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from `deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
emis_appointment_slot_guid	varchar	✓	✓	appointment_slot_guid
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
emis_session_guid	varchar	✓	✓	session_guid
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
emis_session_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓	patient_guid	hashed
pseudo_patient_uuid	varchar	✗	✓	patient_uuid	hashed
slot_start_date	date	✓	✓
slot_start_time	time	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in v1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in v1
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓		Renamed from `patient_wait_in_minutes` in V1
appointment_delay_in_minutes	decimal(10, 2)	✓	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
patient_age_at_appointment	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	bigint	✗	✓
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
did_not_attend_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
did_not_attend_reason_emis_code_id	bigint	✓	✓
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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Prometheus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from `deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
emis_appointment_slot_guid	varchar	✓	✓	appointment_slot_guid
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
emis_session_guid	varchar	✓	✓	session_guid
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
emis_session_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓	patient_guid	hashed
pseudo_patient_uuid	varchar	✗	✓	patient_uuid	hashed
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_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	✗	✓
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in v1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in v1
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓		Renamed from `patient_wait_in_minutes` in V1
appointment_delay_in_minutes	decimal(10, 2)	✓	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
patient_age_at_appointment	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	bigint	✗	✓
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
did_not_attend_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
did_not_attend_reason_emis_code_id	bigint	✓	✓
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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓		Renamed from `execution_date` in v1 name

Pseudo_Anon

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from `deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
slot_guid	varchar	✓	✓	appointment_slot_guid
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
session_guid	varchar	✓	✓
session_uuid	varchar	✗	✓
session_organisation_id	bigint	✗	✓
session_organisation_guid	varchar	✓	✓		Renamed from `organisation_guid` in v1
session_organisation_uuid	varchar	✗	✓
patient_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
appointment_date	date	✓	✓
appointment_start_time	varchar	✓	✓
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in v1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in v1
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓		Renamed from `patient_wait_in_min` in V1
appointment_delay_in_min	decimal(10, 2)	✓	✓	appointment_delay_in_minutes
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
patient_age_at_appointment	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	bigint	✗	✓
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
did_not_attend	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
dna_reason_code_id	decimal	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓		Renamed from `execution_date` in v1

Themis

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
_record_version	varchar	✓	✗
is_deleted	boolean	✓	✓		Renamed from `slot_deleted` in V1
load_datetime	timestamp(6) with time zone	✗	✓
appointment_slot_id	bigint	✗	✓
appointment_slot_guid	varchar	✓	✓
appointment_slot_uuid	varchar	✗	✓
session_id	bigint	✗	✓
session_uuid	varchar	✗	✓
emis_session_guid	varchar	✓	✓	session_guid
session_organisation_id	bigint	✗	✓
session_emis_organisation_guid	varchar	✓	✓	session_organisation_guid
session_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
external_patient_guid	varchar	✗	✓
external_patient_organisation_id	bigint	✗	✓
patient_external_emis_organisation_guid	varchar	✓	✓	external_patient_organisation_guid
external_patient_organisation_uuid	varchar	✗	✓
emis_bookingsource_organisation_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_consultation_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_lead_session_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
slot_start_date_time	timestamp(6) with time zone	✓	✓	slot_start_datetime
slot_end_date_time	timestamp(6) with time zone	✓	✓	slot_end_datetime
call_started_datetime	timestamp(6) with time zone	✗	✓
call_ended_datetime	timestamp(6) with time zone	✗	✓
booked_datetime	timestamp(6) with time zone	✓	✓		Renamed from `time_booked` in V1
sent_in_datetime	timestamp(6) with time zone	✓	✓		Renamed from `sendin_time` in v1
left_datetime	timestamp(6) with time zone	✓	✓		Renamed from `left_time` in v1
planned_duration_in_minutes	decimal(10, 2)	✓	✓
actual_duration_in_minutes	decimal(10, 2)	✓	✓
waiting_time_in_minutes	decimal(10, 2)	✓	✓		Renamed from `patient_wait_in_minutes` in V1
appointment_delay_in_minutes	decimal(10, 2)	✓	✓
appointment_lead_time_in_minutes	decimal(10, 2)	✗	✓
patient_age_at_appointment	bigint	✗	✓
slot_current_status_emis_id	bigint	✓	✓	current_status_id
current_status_type_id	bigint	✗	✓
slot_status_description	varchar	✓	✓	current_status_description
slot_delivery_mode	varchar	✓	✓	current_status_type_description
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	varchar	✓	✓	booking_method_description
booked_by_external_organisation_id	bigint	✗	✓
booked_by_external_organisation_uuid	varchar	✗	✓
slot_booked_flag	boolean	✓	✓	is_booked
slot_blocked_flag	boolean	✓	✓	is_blocked
slot_gpconnect_flag	boolean	✓	✓	is_gp_connect_bookable
slot_internet_flag	boolean	✓	✓	is_internet_bookable
did_not_attend_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
external_patient_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
did_not_attend_reason_id	bigint	✗	✓
slot_type_national_category_name	varchar	✗	✓
slot_type_national_category_description	varchar	✗	✓
context_type	varchar	✗	✓
service_setting	varchar	✗	✓
embargo_type_id	bigint	✗	✓
slot_embargoed_flag	boolean	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
embargo_days	bigint	✗	✓
embargo_minutes	bigint	✗	✓
embargo_time	timestamp(6) with time zone	✗	✓
slot_embargo_is_relative_flag	boolean	✓	✓	embargo_is_relative
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	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Zeus

Not used in this schema