Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’2026-04-10T12:00:00Z’
emis_observation_guid	varchar	Unique identifier for the problem record	’obs-12345’
exa_observation_guid	varchar	External identifier for the problem record	’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’
emis_parent_observation_guid	varchar	Parent problem/observation GUID	’obs-99999’
end_date	date	Date the problem ended	’2026-03-01’
end_date_precision	varchar	Precision of the end date	’day’
expected_duration_in_days	integer	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	’auth-45678’
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	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’
study_id	varchar	Study identifier from included patients view	’study-12345’