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 identifier for the observation	’987fcdeb-51a2-3c4d-e5f6-789012345678’
pseudo_registration_guid	varchar	Hashed registration identifier	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
pseudo_patient_id	varchar	Hashed patient identifier	’f47ac10b-58cc-4372-a567-0e02b2c3d479’
emis_registration_organisation_guid	varchar	Organisation identifier	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
effective_date	date	Date the observation was recorded as effective	’2026-01-15’
effective_date_precision	varchar	Precision of the effective date	’YMDT’
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	’c3d4e5f6-a7b8-9012-cdef-123456789012’
emis_enteredby_userinrole_guid	varchar	User who entered the record	’d4e5f6a7-b8c9-0123-4567-890abcdef012’
emis_parent_observation_guid	varchar	Parent observation GUID	’e5f6a7b8-c9d0-1234-5678-90abcdef0123’
emis_code_id	bigint	Code identifier for the observation	7334778019
emis_problem_observation_guid	varchar	Linked problem observation GUID	’f6a7b8c9-d0e1-2345-6789-0abcdef01234’
emis_consultation_guid	varchar	Linked consultation identifier	’a7b8c9d0-e1f2-3456-7890-abcdef012345’
exa_consultation_guid	varchar	EXA consultation identifier	’b8c9d0e1-f2a3-4567-8901-bcdef0123456’
numericvalue	varchar	Numeric measurement value	120.5
uom	varchar	Unit of measure	’mmHg’
observation_type	varchar	Type of observation	’measurement’
range_lower	double	Lower reference range bound	90.0
range_upper	double	Upper reference range bound	140.0
document_guid	varchar	Linked document GUID	’c9d0e1f2-a3b4-5678-9012-cdef01234567’
confidential_flag	boolean	Indicates confidentiality	false
_execution_date	varchar(14)	Extract execution date	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’
study_id	varchar	Study identifier from included patients view	’study-12345’