| Column Name | Description | Example |
|---|
| is_deleted | Flag indicating if the sharing agreement record has been deleted | FALSE |
| agreement_guid | The EMIS globally unique identifier for the sharing agreement | D0AD76B9-200B-4D52-8199-8D8F485EB1D7 |
| requester_organisation_guid | The EMIS globally unique identifier for the requester organisation | A1B2C3D4-1234-5678-9ABC-DEF012345678 |
| sharer_organisation_guid | The EMIS globally unique identifier for the sharer organisation | E5F60718-9012-3456-7890-ABCDEF123456 |
| emis_index_schema_id | Internal identifier for the emis index schema | 1 |
| user_id | User ID assigned to the agreement | 12345 |
| can_process | Flag indicating if data can be processed under this agreement (NULL if deleted) | TRUE |
| requester_status | Status of the requester organisation (NULL if deleted) | Activated |
| requester_cdb | Requester organisation CDB number (NULL if deleted) | 50001 |
| requester_name | Requester organisation name (NULL if deleted) | Requester Health Trust |
| agreement_status | Agreement enabled/disabled status (NULL if deleted) | Enabled |
| agreement_type_id | Agreement type identifier (NULL if deleted) | 5 |
| agreement_type_description | Agreement type description (NULL if deleted) | Standard Data Sharing |
| agreement_id | Agreement identifier (NULL if deleted) | 1001 |
| agreement_name | Agreement name (NULL if deleted) | Regional Care Agreement |
| agreement_purpose | Agreement purpose description (NULL if deleted) | To facilitate integrated care |
| sharer_status | Status of the sharer organisation (NULL if deleted) | 02. Activated |
| org_type | Organisation type classification (NULL if deleted) | GP Practice |
| sharer_ods | Sharer organisation ODS code (NULL if deleted) | Y12345 |
| sharer_cdb | Sharer organisation CDB number (NULL if deleted) | 50002 |
| sharer_name | Sharer organisation name (NULL if deleted) | Example GP Surgery |
| sharer_close_datetime | Datetime when the sharer organisation closed (NULL if deleted or not closed) | 2024-12-31 00:00:00 |
| patient_count | Total patient count for the sharer organisation (NULL if deleted) | 8500 |
| active_patient_count | Active patient count for the sharer organisation (NULL if deleted) | 7800 |
| active_user_count | Active user count for the sharer organisation (NULL if deleted) | 25 |
| sharer_environment_id | Internal identifier for the sharer environment | 12345 |
| sharer_environment | Environment description for the sharer organisation (NULL if deleted) | Production |
| last_modified_datetime | Timestamp when the agreement was last modified (NULL if deleted) | 2024-09-17 08:48:00 |
| last_modified_date | Date when the agreement was last modified (NULL if deleted) | 2024-09-17 |
| extract_date | Date of data extract (NULL if deleted) | 2024-09-17 |
| cognito_username | Cognito username for the user assigned to the agreement (NULL if deleted) | john.smith |
| organisation | Organisation assignment for the record (‘EMIS’ for deleted records, otherwise sharer organisation) | CDB-50002 |
| transform_datetime | Timestamp when the record was transformed in the data pipeline | 2024-09-17 08:48:00.123456 +00:00 |
| _execution_date | ETL execution date in format yyyyMMddHHmmss | 20240917084800 |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| name | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| name | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar(14) | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| name | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| name | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| name | varchar | ✓ | ✗ | Removed in v2 |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| name | varchar | ✓ | ✗ | Removed in v2 |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| name | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| _ingest_time | varchar | ✓ | ✗ | No longer available/required in v2 for this model |
| is_deleted | boolean | deleted | ✓ | Exists in v1 with a different name |
| agreement_guid | varchar | ✓ | ✓ | |
| emis_organisation_guid | varchar | ✓ | ✗ | Removed in v2 |
| name | varchar | ✓ | ✗ | Removed in v2 |
| ods_code | varchar | ✓ | ✗ | Removed in v2 |
| organisation_cdb | varchar | ✓ | ✗ | Removed in v2 |
| is_activated_flag | boolean | ✓ | ✗ | Removed in v2 |
| disabled | boolean | ✓ | ✗ | Removed in v2 |
| last_modified_date | date | ✓ | ✗ | Removed in v2, replaced by last_modified_datetime |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
Refer to the definition / universal-improvements page for detailed
differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|
| is_deleted | boolean | ✗ | ✓ | |
| agreement_guid | varchar | ✗ | ✓ | |
| requester_organisation_guid | varchar | ✗ | ✓ | |
| sharer_organisation_guid | varchar | ✗ | ✓ | |
| can_process | boolean | ✗ | ✓ | |
| requester_status | varchar | ✗ | ✓ | |
| requester_cdb | varchar | ✗ | ✓ | |
| requester_name | varchar | ✗ | ✓ | |
| agreement_status | varchar | ✗ | ✓ | |
| agreement_id | varchar | ✗ | ✓ | |
| agreement_name | varchar | ✗ | ✓ | |
| agreement_purpose | varchar | ✗ | ✓ | |
| sharer_status | varchar | ✗ | ✓ | |
| org_type | varchar | ✗ | ✓ | |
| sharer_ods | varchar | ✗ | ✓ | |
| sharer_cdb | varchar | ✗ | ✓ | |
| sharer_name | varchar | ✗ | ✓ | |
| sharer_close_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| active_patient_count | bigint | ✗ | ✓ | |
| active_user_count | bigint | ✗ | ✓ | |
| sharer_environment_id | bigint | ✗ | ✓ | |
| sharer_environment | varchar | ✗ | ✓ | |
| last_modified_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| organisation | varchar | ✗ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✗ | ✓ | |