Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’20240603101655’
emis_observation_guid	varchar	Unique identifier for the problem record	’123e4567-e89b-12d3-a456-426614174000’
exa_observation_guid	varchar	EXA identifier for the problem record	’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’
emis_parent_observation_guid	varchar	Parent problem/observation GUID	’c3d4e5f6-a7b8-9012-cdef-123456789012’
end_date	date	Date the problem ended	’2026-03-01’
end_date_precision	varchar	Precision of the end date	’day’
expected_duration_in_days	bigint	Expected duration of the problem in days	90
last_review_date	date	Date the problem was last reviewed	’2026-01-15’
last_review_date_precision	varchar	Precision of the last review date	’day’
emis_last_review_userinrole_guid	varchar	User-in-role who last reviewed the problem	’d4e5f6a7-b8c9-0123-4567-890abcdef012’
parent_problem_relationship_description	varchar	Relationship to parent problem	’child’
problem_status_description	varchar	Status of the problem	’Active’
fhir_significance	varchar	FHIR problem significance description	’significant’
_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’