Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
appointmentsessionguid	varchar	Unique identifier for the appointment session. Part of the composite primary key.	{I9J0K1L2-M3N4-5678-OPQR-789012345678}	38	False
description	varchar	Free-text description of the session (e.g., ‘Morning GP Surgery’).	Morning GP Surgery	100	False
locationguid	varchar	References the physical site where the session takes place in Admin_Location.	{A1B2C3D4-E5F6-7890-ABCD-EF1234567890}	38	False
sessiontypedescription	varchar	Classifies the session type (e.g., Surgery, Clinic, Home Visit).	Surgery	50	False
sessioncategorydisplayname	varchar	Display category of the session (e.g., GP, Nurse, Admin).	GP	100	False
startdate	date	The date the session begins.	2025-03-15	3	False
starttime	time	The time the session begins.	11:00:00	5	False
enddate	date	The date the session ends.	2025-03-15	3	False
endtime	time	The time the session ends.	11:00:00	5	False
private	boolean	Indicates whether the session is a private (non-NHS) session.	false	1	False
organisationguid	varchar	References the practice responsible for the session in Admin_Organisation.	{C3D4E5F6-A7B8-9012-CDEF-123456789012}	38	False
deleted	boolean	Indicates whether the record is deleted. Always false in this BulkView.	false	1	False