Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
patientguid	varchar	Unique identifier for the patient. Part of the composite primary key.	{F6A7B8C9-D0E1-2345-FABC-456789012345}	38	False
organisationguid	varchar	References the registered practice in Admin_Organisation.	{C3D4E5F6-A7B8-9012-CDEF-123456789012}	38	False
usualgpuserinroleguid	varchar	References the patient’s usual GP in Admin_UserInRole.	{G7H8I9J0-K1L2-3456-MNOP-567890123456}	38	True
sex	char	Biological sex as recorded in EMIS Web (M/F).	M	1	False
dateofbirth	date	The patient’s date of birth.	1975-06-14	3	False
dateofdeath	date	Date of death, if recorded. Null if patient is alive.	2023-11-02	3	True
title	varchar	Patient title (e.g., Mr, Mrs, Dr).	Mrs	50	False
givenname	varchar	Patient’s first given name.	Jane	40	False
middlenames	varchar	Patient’s middle name(s), if recorded.	Marie	256	False
surname	varchar	Patient’s family name.	Smith	100	False
dateofregistration	date	Date the patient registered with this practice.	2010-03-22	3	True
nhsnumber	char	The patient’s NHS number — the national patient identifier.	9434765919	10	True
patientnumber	integer	The practice-assigned patient number, also known as the EMIS Number.	1	4	True
patienttypedescription	varchar	Classifies the registration type (e.g., Regular, Temporary, Dummy).	Regular	30	True
dummytype	boolean	Classifies dummy patient records used for administrative purposes.	false	1	True
housenameflatnumber	varchar	House name or flat number component of the patient’s address.	Flat 2	50	True
numberandstreet	varchar	Street number and name component of the patient’s address.	45 Oak Road	50	True
village	varchar	Village component of the patient’s address.	Little Anytown	50	True
town	varchar	Town component of the patient’s address.	Anytown	50	True
county	varchar	County component of the patient’s address.	Anyshire	50	True
postcode	varchar	Patient’s postal code. Used for geographical analysis and deprivation scoring.	AN2 3CD	7	True
residentialinstitutecode	char	Code identifying a residential institution (e.g., care home), if applicable.	23	2	True
nhsnumberstatus	char	Verification status of the NHS number. This column is always null in the IM1 extract.	V1	2	True
carername	varchar	Name of the patient’s registered carer, if applicable.	John Smith	452	True
carerrelation	varchar	Relationship of the carer to the patient (e.g., Spouse, Parent).	Spouse	100	True
personguid	varchar	EMIS person-level GUID, which may link across multiple registrations.	{H8I9J0K1-L2M3-4567-NOPQ-678901234567}	38	False
dateofdeactivation	date	Date the patient’s registration was deactivated. Null if still registered.	2024-01-15	3	True
deleted	boolean	Indicates whether the record is deleted. Always false in this BulkView.	false	1	False
spinesensitive	boolean	Indicates whether the patient’s record is flagged as spine-sensitive.	false	1	False
isconfidential	boolean	Indicates whether the patient’s record is marked as confidential.	false	1	True
emailaddress	varchar	Patient’s email address, if recorded.	jane.smith@example.com	100	True
homephone	varchar	Patient’s home phone number.	01234 567890	100	True
mobilephone	varchar	Patient’s mobile phone number.	07700 900123	100	True
externalusualgpguid	varchar	GUID identifying the patient’s usual GP at an external organisation. Where that GP is registered in EMIS Web at another practice, this value may join to Admin_UserInRole.UserInRoleGuid.	{E5F6A7B8-C9D0-1234-EFAB-345678901234}	38	True
externalusualgp	varchar	Name of the patient’s usual GP at an external organisation, if applicable.	Dr. Jane Smith	263	True
externalusualgporganisation	varchar	GUID of the external organisation where the patient’s usual GP is registered.	{D77C65E1-E100-4272-9386-F4FC383D8759}	38	True
contactcomments	varchar	Free-text comments relating to patient contact preferences.	Prefers morning appointments	200	True