Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10 12:00:00’
emis_issue_guid	varchar	Unique identifier for the issue record	’issue-12345’
exa_issue_guid	varchar	External unique identifier for the issue record	’ext-issue-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 issue record became effective	’2026-01-01’
entered_date	date	Date when the issue record was recorded	’2026-01-02’
entered_time	time	Time when the issue record was recorded	’12:34:56’
emis_code_id	varchar	Code identifier for the issue record	’code-67890’
emis_original_term	varchar	Original term for the issue 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’
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’