Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
userinroleguid	varchar	Unique identifier for this user-in-role instance. Part of the composite primary key.	{G7H8I9J0-K1L2-3456-MNOP-567890123456}	38	False
organisationguid	varchar	References the practice this role is attached to.	{C3D4E5F6-A7B8-9012-CDEF-123456789012}	38	False
title	varchar	Title of the staff member (e.g., Dr, Mr, Mrs).	Dr	50	True
givenname	varchar	First given name of the staff member.	Sarah	108	True
surname	varchar	Family name of the staff member.	Jones	100	True
jobcategorycode	char	Coded value for the job category (e.g., R0050 for GP).	R0050	5	False
jobcategoryname	varchar	Human-readable label for the job category.	General Medical Practitioner	100	False
contractstartdate	date	The date the person started in this role at the organisation.	2015-08-01	3	False
contractenddate	date	The date the role ended. Null if still active.	2024-07-31	3	True
registrationnumber	varchar	Professional registration number (e.g., GMC number for GPs).	1234567	50	True