Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’2026-04-10T09:00:00Z’
emis_observation_guid	varchar	EMIS observation GUID (alias id)	‘123e4567-e89b-12d3-a456-426614174000’
exa_observation_guid	varchar	EXA observation GUID (alias id_type5)	‘123e4567-e89b-12d3-a456-426614174001’
emis_registration_guid	varchar	Registration identifier	’123e4567-e89b-12d3-a456-426614174001’
patient_id	bigint	Unique identifier for the patient	54321
emis_registration_organisation_guid	varchar	Organisation registration GUID	’org-123’
effective_date	date	Date the observation is effective	’2026-03-01’
effective_date_precision	varchar	Precision of the effective date	’YMDT’
entered_date	date	Date the observation was recorded	’2026-03-01’
entered_time	varchar	Time the observation was recorded	’09:12:34’
emis_authorising_userinrole_guid	varchar	Authorising practitioner GUID	’user-123’
emis_enteredby_userinrole_guid	varchar	Entered-by userinrole GUID	’user-456’
emis_parent_observation_guid	varchar	Parent observation GUID	’parent-123’
emis_code_id	bigint	Source code identifier	1001
emis_problem_observation_guid	varchar	Problem observation GUID	’obs-123’
emis_consultation_guid	varchar	Consultation GUID	’cons-123’
exa_consultation_guid	varchar	EXA consultation GUID	’cons-456’
numericvalue	varchar	Numeric value of the observation	12.34
uom	varchar	Unit of measure	’mmHg’
observation_type	varchar	Observation type	’vital-sign’
range_lower	double	Lower bound of valid range	0.0
range_upper	double	Upper bound of valid range	100.0
document_guid	varchar	Document GUID	’doc-123’
confidential_flag	boolean	Confidentiality flag	false
_execution_date	varchar(14)	View execution timestamp	’2026-04-10’
organisation	varchar	Organisation identifier used in inclusion join	’CDB-0001’
study_id	varchar	Recruit study identifier	’study-12345’