Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
locationguid	varchar	Unique identifier for the location. Part of the composite primary key.	{A1B2C3D4-E5F6-7890-ABCD-EF1234567890}	38	False
locationname	varchar	The human-readable name of the location.	Anytown Branch Surgery	100	False
locationtypedescription	varchar	Classifies the location type (e.g., Branch Surgery, Main Site).	Branch Surgery	50	False
parentlocationguid	varchar	References the parent location in a hierarchical site structure.	{B2C3D4E5-F6A7-8901-BCDE-F12345678901}	38	True
opendate	date	The date the location became operational.	2005-01-15	3	False
closedate	date	The date the location was closed. Null if still active.	2023-06-30	3	True
maincontactname	varchar	The primary contact person for this location.	Reception Manager	200	True
faxnumber	varchar	Fax contact number for the location.	01234 567890	100	True
emailaddress	varchar	Email address for the location.	reception@anytownsurgery.nhs.uk	100	True
phonenumber	varchar	Phone number for the location.	01234 567891	100	True
housenameflatnumber	varchar	House name or flat number component of the address.	The Old Mill	50	True
numberandstreet	varchar	Street number and name component of the address.	123 High Street	50	True
village	varchar	Village component of the address.	Little Anytown	50	True
town	varchar	Town component of the address.	Anytown	50	True
county	varchar	County component of the address.	Anyshire	50	True
postcode	varchar	Postal code for the location.	AN1 2BC	7	True
deleted	boolean	Indicates whether the record is deleted. Always false in this BulkView.	false	1	False