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 identifier for the observation	’obs-12345’
exa_observation_guid	varchar	External unique identifier for the observation	’ext-obs-67890’
emis_registration_guid	varchar	Registration identifier	’reg-98765’
patient_id	varchar	Unique identifier for the patient	’pat-54321’
emis_registration_organisation_guid	varchar	Organization identifier	’org-11223’
effective_date	date	Date when the immunisation became effective	’2026-01-01’
entered_date	date	Date when the immunisation was recorded	’2026-01-02’
entered_time	time	Time when the immunisation was recorded	’12:34:56’
emis_authorising_userinrole_guid	varchar	Authorizing practitioner identifier	’auth-45678’
emis_consultation_guid	varchar	Consultation identifier	’cons-12345’
emis_code_id	varchar	Code identifier for the immunisation	’code-67890’
emis_original_term	varchar	Original term for the immunisation	’Flu Vaccine’
batch_number	varchar	Batch number of the immunisation	’batch-11223’
manufacturer	varchar	Manufacturer of the immunisation	’Pharma Inc.‘
expiry_date	date	Expiry date of the immunisation	’2026-12-31’
confidential_flag	boolean	Indicates if the data is confidential	true
execution_date	date	Date of execution	’2026-04-10’
study_id	varchar	Study identifier	’study-12345’