Schema

Raw

Column Name	Data Type	Description	Example
_execution_date	varchar(14)	View execution timestamp	’20260521042151’
_ingest_time	varchar	Timestamp of data ingestion	’20251216112102’
_record_version	varchar	Internal record version identifier	’20251216105559’
snomed_concept_id	bigint	SNOMED concept identifier	10013511000001105
snomed_description_id	bigint	SNOMED description identifier	45471501000001116
drug_preparation_code_id	bigint	Drug preparation code identifier	5680841000033114
other_code_system	varchar(38)	Alternate code system	https://fhir.hl7.org.uk/Id/egton-codes
other_code	varchar	Alternate code for the concept	’999999’
other_display	varchar	Display name for the alternate code	’Example display’
_mkb_version	varchar	MKB coding system version	’MKB-229’
organisation	varchar(4)	Organisation identifier (source organisation)	‘EMIS’