Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20240603101655’
emis_drug_guid	varchar	Unique identifier for the drug record	’123e4567-e89b-12d3-a456-426614174000’
exa_drug_guid	varchar	EXA unique identifier for the drug record	’987fcdeb-51a2-3c4d-e5f6-789012345678’
emis_registration_guid	varchar	Registration identifier	’a1b2c3d4-e5f6-7890-abcd-ef1234567890’
patient_id	bigint	Unique identifier for the patient	54321
emis_medication_organisation_guid	varchar	Organization identifier for the medication	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
emis_registration_organisation_guid	varchar	Organization identifier for the medication	’b2c3d4e5-f6a7-8901-bcde-f12345678901’
effective_date	timestamp	Date when the drug record became effective	’2026-01-01’
effective_date_precision	varchar	Precision of effective date	’YMDT’
entered_date	date	Date when the drug record was recorded	’2026-01-02’
entered_time	varchar	Time when the drug record 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_code_id	bigint	Code identifier for the drug record	953334100443112
emis_original_term	varchar	Original term for the drug record	’Painkiller’
dose	varchar	Dose of the medication	’500 mg’
quantity	double	Quantity of the medication	28
uom	varchar	Unit of measurement for the medication	’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)	Date of execution	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’
study_id	varchar	Study identifier	’study-12345’