Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’20211001112217’
emis_location_guid	varchar	Unique identifier for the location	’E8105444-30C7-4DB9-B186-5A0F2648C0C8’
emis_location_id	bigint	Numeric location identifier	67890
location_type_description	varchar	Description of the location type	’School’
emis_parent_location_guid	varchar	Identifier for the parent location	’parent-loc-54321’
open_date	date	Date when the location was opened	’2026-01-01’
close_date	date	Date when the location was closed	’2026-12-31’
_execution_date	varchar(14)	Extract execution date	’20260521042151’
organisation	varchar	Organisation identifier	’CDB-0001’