Schema

Column Name	Data Type	Description	Example	Max Length	Is Null
codeid	bigint	Unique EMIS internal identifier for this clinical code. Used as the join key in all clinical tables.	1777541000006110	8	False
term	varchar	The display term for the code as shown in EMIS Web.	Activity location: Patient’s home	255	False
readtermid	varchar	The Read v2 term identifier (alphanumeric code).	C10F.	200	True
snomedctconceptid	bigint	The SNOMED CT concept identifier for international interoperability.	1777541000006100	8	False
snomedctdescriptionid	bigint	The SNOMED CT description identifier.	1777541000006110	8	False
nationalcode	varchar	The national code value, if assigned.	A01	50	True
nationalcodecategory	varchar	The category of the national code.	ACTIVITY LOCATION TYPE CODE	100	True
nationaldescription	varchar	The description associated with the national code.	Patients home	255	True
emiscodecategorydescription	varchar	The EMIS-specific category for the code (e.g., Allergy, Immunisation, Referral).	Biochemistry	64	False
parentcodeid	bigint	References the parent code in the EMIS code hierarchy.	506031000006117	8	True