Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20240603101655’
emis_drug_guid	varchar	Medication identifier	’123e4567-e89b-12d3-a456-426614174000’
exa_drug_guid	varchar	EXA medication identifier	’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_medication_organisation_guid	varchar	Medication organisation GUID	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
emis_registration_organisation_guid	varchar	Registration organisation GUID	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
effective_date	date	Medication effective date	’2026-01-01’
effective_date_precision	varchar	Precision of effective date	’YMDT’
entered_date	date	Date recorded	’2026-01-02’
entered_time	varchar	Time 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_code_id	bigint	Code identifier	953334100443112
emis_original_term	varchar	Original term	’Medication term’
dose	varchar	Dose text	’500 mg’
quantity	double	Quantity	28
uom	varchar	Unit of measure	’tablet’
emis_prescription_type	varchar	Prescription type	’repeat’
drug_active_flag	boolean	Active flag	true
cancellation_date	date	Cancellation/stop date	’2026-02-01’
number_of_issues	bigint	Number of issues	3
number_authorised	bigint	Number authorised	3
confidential_flag	boolean	Confidentiality flag	false
_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’