Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
consultationguid	varchar	Unique identifier for the consultation. Part of the composite primary key.	{L2M3N4O5-P6Q7-8901-RSTU-012345678901}	38	False
patientguid	varchar	References the patient in Admin_Patient.	{F6A7B8C9-D0E1-2345-FABC-456789012345}	38	False
organisationguid	varchar	References the practice in Admin_Organisation.	{C3D4E5F6-A7B8-9012-CDEF-123456789012}	38	False
effectivedate	date	The clinical date of the consultation (when it took place).	2025-02-14	3	True
effectivedateprecision	varchar	The precision of the effective date (e.g., YMD = Year/Month/Day).	YMD	100	True
entereddate	date	The date the consultation record was entered into EMIS Web.	2025-02-14	3	True
enteredtime	time	The time the consultation record was entered into EMIS Web.	11:00:00	5	True
clinicianuserinroleguid	varchar	References the clinician who led the consultation in Admin_UserInRole.	{G7H8I9J0-K1L2-3456-MNOP-567890123456}	38	True
enteredbyuserinroleguid	varchar	References the staff member who entered the record, if different from the consulting clinician.	{G7H8I9J0-K1L2-3456-MNOP-567890123456}	38	True
appointmentslotguid	varchar	References the appointment slot this consultation is linked to in Appointment_Slot.	{J0K1L2M3-N4O5-6789-PQRS-890123456789}	38	True
consultationsourceterm	varchar	The display term for the source of the consultation.	Main Surgery	200	True
consultationsourcecodeid	bigint	References the coded source of the consultation in Coding_ClinicalCode.	1776011000006110	8	True
complete	boolean	Indicates whether the consultation record is complete.	true	1	True
consultationtype	varchar	The type of consultation (e.g., Administration, Telephone, Home Visit).	Minor Surgery	200	True
deleted	boolean	Indicates whether the record is deleted. Always false in this BulkView.	false	1	False
isconfidential	boolean	Indicates whether the consultation is marked as confidential.	false	1	True