Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	timestamp	Timestamp of data ingestion	’2026-04-10’
emis_location_guid	varchar	Location GUID	’loc-12345’
emis_location_id	varchar	Numeric location id	’123’
location_type_description	varchar	Location type description	’GP surgery’
emis_parent_location_guid	varchar	Parent location GUID	’loc-54321’
open_date	date	Opening date	’2000-01-01’
close_date	date	Closing date	’2025-12-31’
_execution_date	varchar	Extract execution date	’2026-04-10’
organisation	varchar	Organisation identifier	’CDB-0001’