Schema

Raw

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