| is_deleted | BOOLEAN | Flag indicating if the sharing agreement record has been deleted | FALSE |
| agreement_guid | VARCHAR | UUID identifier for the sharing agreement | D0AD76B9-200B-4D52-8199-8D8F485EB1D7 |
| requester_organisation_guid | VARCHAR | UUID identifier for the requester organisation | A1B2C3D4-1234-5678-9ABC-DEF012345678 |
| sharer_organisation_guid | VARCHAR | UUID identifier for the sharer organisation | E5F6G7H8-9012-3456-7890-ABCDEF123456 |
| can_process | BOOLEAN | Flag indicating if data can be processed under this agreement (NULL if deleted) | TRUE |
| requester_status | VARCHAR | Status of the requester organisation (NULL if deleted) | Activated |
| requester_cdb | BIGINT | Requester organisation CDB number (NULL if deleted) | 50001 |
| requester_name | VARCHAR | Requester organisation name (NULL if deleted) | Requester Health Trust |
| agreement_status | VARCHAR | Agreement enabled/disabled status (NULL if deleted) | Enabled |
| agreement_id | BIGINT | Agreement identifier (NULL if deleted) | 1001 |
| agreement_name | VARCHAR | Agreement name (NULL if deleted) | Regional Care Agreement |
| agreement_purpose | VARCHAR | Agreement purpose description (NULL if deleted) | To facilitate integrated care |
| sharer_status | VARCHAR | Status of the sharer organisation (NULL if deleted) | 02. Activated |
| org_type | VARCHAR | Organisation type classification (NULL if deleted) | GP Practice |
| sharer_ods | VARCHAR | Sharer organisation ODS code (NULL if deleted) | Y12345 |
| sharer_cdb | BIGINT | Sharer organisation CDB number (NULL if deleted) | 50002 |
| sharer_name | VARCHAR | Sharer organisation name (NULL if deleted) | Example GP Surgery |
| last_modified_datetime | TIMESTAMP | Timestamp when the agreement was last modified (NULL if deleted) | 2024-09-17 08:48:00 |
| organisation | VARCHAR | Organisation assignment for the record (‘EMIS’ for deleted records, otherwise sharer organisation) | CDB-50002 |
| transform_datetime | TIMESTAMP | Timestamp when the record was transformed in the data pipeline | 2024-09-17 08:48:00.123456 +00:00 |
