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 drug code identifier	12345
emis_old_code	varchar	Legacy EMIS code	’D12..’
emis_term	varchar	Human-readable drug term	’Paracetamol’
dmd_product_code_id	bigint	DMD product code id	98765
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’