Definition

Purpose

The sharing_organisation model exposes organisation-level sharing agreements and metadata from the anonymised extract. It represents data sharing relationships between organisations participating in the recruit study.

Information

This table documents data sharing agreements between organisations, tracking activation status and modifications. Access is restricted by the current user’s permissions within their organisation.

• agreement_guid (PK): The unique identifier for the sharing agreement
• emis_organisation_guid (FK): Links to the organisation involved in the agreement

Examples

Get all sharing agreements for the current user

SELECT *
FROM hive.explorer_recruit_anon.sharing_organisation
WHERE organisation = 'CDB-0001'
LIMIT 100;

Find active sharing agreements

SELECT
  agreement_guid,
  name,
  ods_code,
  is_activated_flag
FROM hive.explorer_recruit_anon.sharing_organisation
WHERE is_activated_flag = TRUE
LIMIT 100;

Find sharing agreements for a specific organisation

SELECT
  agreement_guid,
  name,
  emis_organisation_guid,
  ods_code,
  is_activated_flag
FROM hive.explorer_recruit_anon.sharing_organisation
WHERE emis_organisation_guid = 'ORG-GUID-123'
LIMIT 100;