Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Timestamp of data ingestion	’20250221121533’
emis_organisation_guid	varchar	Unique identifier for the organisation	’123e4567-e89b-12d3-a456-426614174000’
emis_main_location_guid	varchar	Main location GUID for the organisation	’123e4567-e89b-12d3-a456-426614174001’
is_main_location_flag	boolean	Indicates this is the main location (always TRUE)	true
_execution_date	varchar(14)	Extract execution date	’20250221121533’
organisation	varchar	Organisation identifier	’CDB-0001’