_ingest_time | varchar | 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 | ’123e4567-e89b-12d3-a456-426614174000’ |
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’ |