Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
emis_drug_guid	varchar	Unique identifier for the drug record	’drug-12345’
exa_drug_guid	varchar	External unique identifier for the drug record	’ext-drug-67890’
emis_registration_guid	varchar	Registration identifier	’reg-98765’
patient_id	varchar	Unique identifier for the patient	’pat-54321’
emis_medication_organisation_guid	varchar	Organization identifier for the medication	’org-11223’
effective_date	date	Date when the drug record became effective	’2026-01-01’
entered_date	date	Date when the drug record was recorded	’2026-01-02’
entered_time	time	Time when the drug record was recorded	’12:34:56’
emis_code_id	varchar	Code identifier for the drug record	’code-67890’
emis_original_term	varchar	Original term for the drug record	’Painkiller’
dose	varchar	Dose of the medication	’500mg’
quantity	varchar	Quantity of the medication	’30 tablets’
uom	varchar	Unit of measurement for the medication	’mg’
execution_date	date	Date of execution	’2026-04-10’
study_id	varchar	Study identifier	’study-12345’