Schema

Raw

Column Name	Data Type	Description	Example
_execution_date	varchar(14)	View execution timestamp	’20260521042151’
_ingest_time	varchar	Timestamp of data ingestion	’20251216105757’
_record_version	varchar	Internal record version identifier	’20251216105021’
emis_code_id	bigint	EMIS code identifier (aliased from code_id)	1706521000006111
snomed_concept_id	bigint	SNOMED concept identifier	1706521000006111
data_dictionary_national_code	varchar	National data dictionary code	’q2’
attribute_type	varchar(15)	Attribute type for the mapping	’Language’
_mkb_version	varchar	MKB coding system version	’MKB-229’
organisation	varchar(4)	Organisation identifier for the source record	’EMIS’