| slotguid | varchar | Unique identifier for the appointment slot. Part of the composite primary key. | {J0K1L2M3-N4O5-6789-PQRS-890123456789} | 38 | False |
| appointmentdate | date | The date the appointment is scheduled. | 2007-11-02 | 3 | False |
| appointmentstarttime | time | The scheduled start time of the appointment. | 11:00:00 | 5 | False |
| planneddurationinminutes | smallint | The intended duration of the appointment in minutes. | 40 | 2 | False |
| patientguid | varchar | References the booked patient in Admin_Patient. | {F6A7B8C9-D0E1-2345-FABC-456789012345} | 38 | False |
| sendintime | time | The time the patient was called in to see the clinician. | 11:00:00 | 5 | True |
| lefttime | time | The time the patient left after the appointment. | 11:00:00 | 5 | True |
| didnotattend | boolean | Indicates whether the patient did not attend (DNA). | false | 1 | True |
| patientwaitinmin | integer | Time the patient waited before being seen, in minutes. | 8 | 4 | True |
| appointmentdelayinmin | integer | Delay relative to scheduled start time, in minutes. | 8 | 4 | True |
| actualdurationinminutes | integer | The actual duration of the appointment in minutes. | 10 | 4 | True |
| organisationguid | varchar | References the practice in Admin_Organisation. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | False |
| sessionguid | varchar | References the parent session in Appointment_Session. | {I9J0K1L2-M3N4-5678-OPQR-789012345678} | 38 | False |
| dnareasoncodeid | bigint | References the clinical code for the Did Not Attend reason, if applicable. | 405044018 | 8 | True |
| bookeddate | date | The date the appointment was booked. | 2007-11-02 | 3 | True |
| bookedtime | time | The time the appointment was booked. | 14:30:00 | 5 | True |
| slotstatus | varchar | Current status of the slot (e.g., Booked, Free, Blocked). | Booked | 20 | True |
| slottype | varchar | Classifies the slot type (e.g., Telephone, Face to Face, Home Visit). | Saturday Nurse Appointments | 100 | True |
| isbookableonline | boolean | Indicates whether the slot is available for online booking. | true | 1 | False |
| bookingmethod | varchar | How the appointment was booked (e.g., Reception, Online, Telephone). | Practice | 25 | True |
| externalpatientguid | varchar | GUID for the patient from an external system, if applicable. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | True |
| externalpatientorganisation | varchar | The external organisation GUID for cross-organisation booking, if applicable. | {C3D4E5F6-A7B8-9012-CDEF-123456789012} | 38 | True |
| modeofcontact | varchar | Mode of contact for the appointment (e.g., In Person, Video, Telephone). | Telephone | 200 | True |
| isblocked | boolean | Indicates whether the appointment slot is blocked. | false | 1 | False |
| contexttype | varchar | The national category context type. | Care related Encounter | 200 | True |
| servicesetting | varchar | The national category service setting. | GP Practice | 200 | True |
| nationalslotcategoryname | varchar | The national slot category name as defined by NHS England. | General Consultation Acute | 200 | True |
| nationalslotcategorydescription | varchar | Description of the national slot category. | An urgent or acute appointment | 900 | True |
| deleted | boolean | Indicates whether the record is deleted. Always false in this BulkView. | false | 1 | False |