Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
emis_observation_guid	varchar	Problem observation identifier	’obs-12345’
exa_observation_guid	varchar	External problem observation identifier	’ext-obs-67890’
emis_drug_guid	varchar	Medication identifier	’med-54321’
exa_drug_guid	varchar	External medication identifier	’ext-med-98765’
entered_date	date	Date recorded	’2026-01-02’
entered_time	time	Time recorded	’12:34:56’
pseudo_registration_guid	varchar	Hashed registration identifier	’reg-98765’
pseudo_patient_id	varchar	Hashed patient identifier	’pat-54321’
emis_registration_organisation_guid	varchar	Registration organisation GUID	’org-11223’
intent	varchar	Intent of the link	’causal’
confidential_flag	boolean	Confidentiality flag	false
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’
study_id	varchar	Study identifier from included patients view	’study-12345’