Schema

Raw Schema

Column Name	Data Type	Description	Example
_execution_date	varchar	Extract execution date	’2026-04-10’
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10’
_record_version	varchar	Record version	’r1’
snomed_concept_id	bigint	SNOMED concept id	123456
snomed_description	varchar	SNOMED description	’Some desc’
emis_code_id	bigint	EMIS code identifier	12345
snomed_description_id	bigint	SNOMED description id	654321
_mkb_version	varchar	MKB version	’MKB-229’
organisation	varchar	Organisation identifier	’EMIS’