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	Unique identifier for the observation	’obs-12345’
exa_observation_guid	varchar	External identifier for the observation	’ext-obs-67890’
pseudo_registration_guid	varchar	Hashed registration identifier	’reg-98765’
pseudo_patient_id	varchar	Hashed patient identifier	’pat-54321’
emis_registration_organisation_guid	varchar	Organisation identifier	’org-11223’
effective_date	date	Date the observation was recorded as effective	’2026-01-15’
effective_date_precision	varchar	Precision of the effective date	’day’
entered_date	date	Date the observation was entered	’2026-01-15’
entered_time	varchar	Time the observation was entered	’10:30:00’
emis_authorising_userinrole_guid	varchar	Authorising practitioner identifier	’auth-45678’
emis_enteredby_userinrole_guid	varchar	User who entered the record	’user-11111’
emis_parent_observation_guid	varchar	Parent observation GUID	’obs-99999’
emis_code_id	varchar	Code identifier for the observation	’code-67890’
emis_problem_observation_guid	varchar	Linked problem observation GUID	’obs-55555’
emis_consultation_guid	varchar	Linked consultation identifier	’cons-12345’
exa_consultation_guid	varchar	External consultation identifier	’ext-cons-67890’
numericvalue	decimal	Numeric measurement value	120.5
uom	varchar	Unit of measure	’mmHg’
observation_type	varchar	Type of observation	’measurement’
range_lower	decimal	Lower reference range bound	90.0
range_upper	decimal	Upper reference range bound	140.0
document_guid	varchar	Linked document GUID	’doc-33333’
confidential_flag	boolean	Indicates confidentiality	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’