Schema

Raw

Column Name	Data Type	Description
model_updated_datetime	timestamp(6) with time zone	Datetime when the source record was last updated
is_deleted	boolean	Indicates whether the record is soft deleted
transform_datetime	timestamp(6) with time zone	Datetime when the record became available in the model after a relevant change
organisation	varchar	Source organisation identifier (GP practice context)
slot_id	varbinary	Pseudo-identifier for the appointment slot
patient_id	varbinary	Pseudo-identifier for the patient linked to the slot
slot_start_datetime	timestamp(6) with time zone	Scheduled start datetime of the appointment slot
slot_end_datetime	timestamp(6) with time zone	Scheduled end datetime of the appointment slot
booked_datetime	timestamp(6) with time zone	Datetime when the appointment was booked
arrived_datetime	timestamp(6) with time zone	Datetime when the patient arrived
sent_in_datetime	timestamp(6) with time zone	Datetime when the patient was sent in
left_datetime	timestamp(6) with time zone	Datetime when the patient left
call_started_datetime	timestamp(6) with time zone	Datetime when a call associated with the slot started
call_ended_datetime	timestamp(6) with time zone	Datetime when a call associated with the slot ended
current_status_id	bigint	Identifier for the slot’s current appointment status
current_status_datetime	timestamp(6) with time zone	Datetime when the current status was set
current_status_description	varchar	Human-readable description of the current status
current_status_type_description	varchar	Higher-level category describing the current status type
slot_type_id	bigint	Identifier for the slot type
slot_type_description	varchar	Human-readable description of the slot type