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 observation identifier	’obs-12345’
exa_observation_guid	varchar	External observation identifier	’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 immunisation was given	’2026-01-01’
effective_date_precision	varchar	Precision of effective date	’day’
entered_date	date	Date recorded	’2026-01-02’
entered_time	time	Time recorded	’12:34:56’
emis_authorising_userinrole_guid	varchar	Authorising practitioner identifier	’auth-45678’
emis_enteredby_userinrole_guid	varchar	Entered-by practitioner identifier	’auth-56789’
emis_consultation_guid	varchar	Consultation identifier	’cons-12345’
exa_consultation_guid	varchar	External consultation identifier	’ext-cons-67890’
emis_code_id	varchar	Code identifier	’code-67890’
emis_original_term	varchar	Original term	’Influenza vaccine’
readv2_code	varchar	Read v2 code	’A123’
other_code_system	varchar	Other code system	’ICD10’
other_code	varchar	Other code	’X123’
other_display	varchar	Other display	’Other term’
batch_number	varchar	Vaccine batch number	’BATCH123’
manufacturer	varchar	Vaccine manufacturer	’Pharma Ltd’
expiry_date	date	Batch expiry date	’2027-01-01’
snomed_concept_id	bigint	SNOMED concept id	123456
snomed_description_id	bigint	SNOMED description id	654321
confidential_flag	boolean	Confidentiality flag	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’