Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10’
emis_referral_guid	uuid	Unique identifier for the referral	’123e4567-e89b-12d3-a456-426614174000’
emis_patient_guid	uuid	Unique identifier for the patient	’123e4567-e89b-12d3-a456-426614174001’
referral_date	date	Date of the referral	’2026-03-01’
referral_reason	string	Reason for the referral	’Specialist Consultation’
referral_status	string	Status of the referral	’Pending’
execution_date	date	Date of execution	’2026-04-10’