Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20240603101655’
emis_observation_guid	varchar	EMIS observation GUID	’123e4567-e89b-12d3-a456-426614174000’
exa_observation_guid	varchar	EXA observation GUID	’987fcdeb-51a2-3c4d-e5f6-789012345678’
patient_id	bigint	Internal patient identifier	54321
emis_registration_guid	varchar	EMIS registration GUID	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
emis_registration_organisation_guid	varchar	Registration organisation GUID	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
effective_date	timestamp	Date and time when the allergy became effective	’2026-01-01 00:00:00’
effective_date_precision	varchar	Precision of the effective date value	’YMDT’
entered_date	date	Date when the allergy was recorded	’2026-01-02’
entered_time	varchar	Time when the allergy was recorded	’12:34:56’
emis_authorising_userinrole_guid	varchar	Authorising user-in-role GUID	’c3d4e5f6-a7b8-9012-cdef-123456789012’
emis_enteredby_userinrole_guid	varchar	Entered-by user-in-role GUID	’d4e5f6a7-b8c9-0123-4567-890abcdef012’
emis_consultation_guid	varchar	EMIS consultation GUID	’e5f6a7b8-c9d0-1234-5678-90abcdef0123’
exa_consultation_guid	varchar	EXA consultation GUID	’f6a7b8c9-d0e1-2345-6789-0abcdef01234’
emis_code_id	bigint	EMIS clinical code identifier	7334778019
emis_original_term	varchar	Original clinical term for the allergy	’Peanut allergy’
readv2_code	varchar	Read v2 code for the recorded concept	’H17..00’
other_code_system	varchar	Alternate coding system	’https://fhir.hl7.org.uk/Id/egton-codes’
other_code	varchar	Alternate code value	’91936005’
other_display	varchar	Alternate code display text	’Allergy to peanuts’
snomed_concept_id	varchar	SNOMED concept identifier	’91936005’
snomed_description_id	varchar	SNOMED description identifier	’2603730011’
fhir_category	varchar	FHIR allergy category	’food’
fhir_status	varchar	FHIR allergy status	’active’
confidential_flag	boolean	Indicates whether the record is confidential	true
execution_date	date	Pipeline execution date	’2026-04-10’
organisation	varchar	Source organisation code	’CDB-0001’
study_id	varchar	Recruit study identifier	’study-12345’