Definition

The Agreement_SharingOrganisation extract records the organisations that participate in a data-sharing agreement under the IM1 scheme. It captures the activation status and modification history of each organisation’s participation, providing a control layer for understanding which practices are actively sharing data under a given agreement.

Information

The Agreement_SharingOrganisation extract is the access-control reference for IM1 data feeds. Each row represents one organisation’s participation in one agreement. The isactivated and disabled flags govern whether data for that organisation should be considered live or suspended.

Each record is uniquely identified by the combination of organisationguid and agreementid.

Key Identifiers

• organisationguid: References the participating organisation in Admin_Organisation.
• agreementid: The data-sharing agreement identifier under which the organisation’s data is shared.

Status Fields

• isactivated: Indicates whether the organisation’s participation in the agreement has been activated.
• disabled: Indicates whether the organisation has been temporarily or permanently suspended from the agreement.
• lastmodifieddate: The date when the agreement participation record was last updated.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Sharing Agreement ID"]
    n2["Organisation Details"]
    n3["Agreement Date Range"]
  end

  n17["Organisation A"] --> container
  n18["Organisation B"] --> container

  container --> n16["Gather sharing agreements"]
  n16 --> n14["ETL"]
  n14 --> n15["Agreement_SharingOrganisation Model"]