Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20251216111600’
emis_code_id	bigint	EMIS drug code identifier	953334100443112
emis_old_code	varchar	Legacy EMIS code	’ABCD931234EMIS’
emis_term	varchar	Term associated with the drug code	’Paracetamol’
dmd_product_code_id	bigint	DMD product code identifier	25385211444001103
_execution_date	varchar(14)	Date of query execution	’20260521042151’
organisation	varchar(4)	Organisation identifier	’EMIS’