Schema

Raw

Column Name	Data Type	Description	Example
_execution_date	date	View execution timestamp	’2026-04-10’
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10T09:00:00Z’
_record_version	integer	Internal record version identifier	1
snomed_concept_id	string	SNOMED concept identifier	’123456’
snomed_description_id	string	SNOMED description identifier	’654321’
drug_preparation_code_id	string	Drug preparation code identifier	’DMD12345’
other_code_system	string	Alternate code system	’SNOMED’
other_code	string	Alternate code for the concept	’999999’
other_display	string	Display name for the alternate code	’Example display’
_mkb_version	string	MKB coding system version	’MKB-229’
organisation	string	Organisation identifier (source organisation)	‘EMIS’