Schema

Raw Schema

Column Name	Data Type	Description	Example
_execution_date	varchar(14)	View execution timestamp	’20260521042151’
_ingest_time	varchar	Timestamp of data ingestion	’20251216113329’
_record_version	varchar	Internal record version identifier	’20251216111629’
snomed_concept_id	bigint	SNOMED concept identifier	55555000000555
snomed_description	varchar	SNOMED description text	’Ethnic category - 2001 census’
emis_code_id	bigint	EMIS code identifier (aliased from code_id)	141291000000111
snomed_description_id	bigint	SNOMED description identifier	141291000000111
_mkb_version	varchar	MKB coding system version	’MKB-229’
organisation	varchar(4)	Organisation identifier (source organisation)	‘EMIS’