Schema

Raw Schema

Column Name	Data Type	Description	Example
_ingest_time	varchar	Ingest timestamp	’20240603101655’
agreement_guid	varchar(36)	Sharing agreement GUID	’123e4567-e89b-12d3-a456-426614174000’
name	varchar	Friendly agreement name	’Practice A Share’
emis_organisation_guid	varchar	Organisation GUID	’123e4567-e89b-12d3-a456-426614174001’
ods_code	varchar	ODS code for the organisation	’A12345’
organisation_cdb	varchar	CDB identifier for the organisation	’cdb-99999’
is_activated_flag	boolean	Whether the sharing agreement is activated	true
deleted	boolean	Soft-delete flag	false
disabled	boolean	Whether the agreement is disabled	false
last_modified_date	date	Date the agreement was last modified	’2026-03-15’
organisation	varchar	Organisation identifier	’CDB-0001’
_execution_date	varchar(14)	Extract execution date	’20260521042151’