Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20251216112941’
emis_code_id	bigint	Unique identifier for the clinical code	7334778019
emis_term	varchar	Term associated with the clinical code	’Rubber double bag’
emis_old_code	varchar	Old format code associated with the clinical code	’C1234’
snomed_concept_id	bigint	SNOMED concept ID value	1277009
snomed_description_id	bigint	SNOMED description ID value	2177900
national_code	varchar	National code value	’G02’
national_code_category	varchar	National code category	’ACTIVITY LOCATION TYPE CODE’
national_description	varchar	National code description	’Nursing Home’
emis_code_category_description	varchar	EMIS Code ID category description	’Referral’
parent_emis_code_id	bigint	Parent EMIS code id value	14624461400406141
_execution_date	varchar(14)	Extraction execution date	’20260520042133’
organisation	varchar(4)	Organisation identifier	’EMIS’