Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20240603101655’
emis_observation_guid	varchar	Unique identifier for the observation	’123e4567-e89b-12d3-a456-426614174000’
exa_observation_guid	varchar	EXA unique identifier for the observation	’987fcdeb-51a2-3c4d-e5f6-789012345678’
emis_drug_guid	varchar	Unique identifier for the drug record	’a7b8c9d0-e1f2-3456-7890-abcdef012345’
exa_drug_guid	varchar	EXA unique identifier for the drug record	’b8c9d0e1-f2a3-4567-8901-bcdef0123456’
entered_date	date	Date when the link was recorded	’2026-01-02’
entered_time	varchar	Time when the link was recorded	’12:34:56’
emis_registration_guid	varchar	Registration identifier	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
patient_id	bigint	Unique identifier for the patient	54321
emis_registration_organisation_guid	varchar	Registration organisation GUID	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
intent	varchar	Intent of the link	’causal’
confidential_flag	boolean	Indicates if the data is confidential	true
_execution_date	varchar(14)	Date of execution	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’
study_id	varchar	Study identifier	’study-12345’