Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
emis_code_id	bigint	EMIS code identifier	12345
emis_term	varchar	Human-readable term	’Hypertension’
emis_old_code	varchar	Legacy/read code identifier	’H12..’
snomed_concept_id	bigint	SNOMED concept id	123456
snomed_description_id	bigint	SNOMED description id	654321
national_code	varchar	National cross-reference code	’N123’
national_code_category	varchar	National code category	’category’
national_description	varchar	National description	’desc’
emis_code_category_description	varchar	EMIS categorisation description	’category desc’
parent_emis_code_id	bigint	Parent EMIS code id	123
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’EMIS’