= DataIntegrations


[[BackLinks(DataIntegrationSource)]]

[[BackLinks(DataIntegrationDestination)]]

[[BackLinks(DataIntegrationCategory)]]

[[BackLinks(DataIntegrationStatus)]]

[[BackLinks(DataIntegrationJob)]]

== A List of them all

- [[DataIntegration BRICCS Glenfield Onyx to i2b2]]
- [[DataIntegration BRICCS Glenfield Onyx to CiviCRM]]
- [[DataIntegration BRICCS CiviCRM to i2b2]]
- [[DataIntegration BRICCS Northampton Onyx to i2b2]]
- [[DataIntegration Test Onyx to i2b2]]
- [[DataIntegration Test Onyx to i2b2 Amended Ontology]]
- [[DataIntegration SCAD Public REDCap to i2b2]]
- [[DataIntegration SCAD Public REDCap to CiviCRM]]

== Onyx

== REDCap


=== [[BRICCS Study]] Leicester (hospital internal server)

==== Data Collection: Ongoing

==== CiviCRM Extract

- **Status**: Required
- **Improvements Required**:
- **Source**: REDCap
- **Destination**: CiviCRM
- **Technology**: Drupal cron job
- **Description**: Load status of REDCap questionnaire into CiviCRM [[BRICCS Study]] enrolment.

==== i2b2 Extract

- **Status**: Completed
- **Improvements Required**:
 - Add more fields as needs arise
 - No interview date, so no start date for observations
- **Source**: REDCap
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Load questionnaire data into i2b2.

=== [[BRICCS Study]] External Sites (hospital N3 server)

==== Sites

- Kettering: recruiting
- Doncaster: recruiting
- Sheffield: recruiting
- Lincoln: recruiting
- Grantham: recruiting
- Chesterfield: recruiting
- Northampton: planned
- Royal Free Hospital: planned (might be [[DREAM Study]])

==== CiviCRM Extract

- **Status**: Not Required

==== i2b2 Extract

- **Status**: Completed
- **Improvements Required**:
 - Add more fields as needs arise
 - No interview date, so no start date for observations
- **Source**: REDCap
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Load questionnaire data into i2b2.

== CiviCRM

=== Common

==== HSCIC Practice Import

- **Status**: Working
- **Improvements Required**: None
- **Source**: HSCIC practice details files
- **Destination**: CiviCRM practice details
- **Technology**: Drupal cron job

=== [[GENVASC Study]]

==== Data Collection: Ongoing

Recruitment ongoing.  Will need to be able to continue amending participants records after recruitment is complete to track withdrawals.

==== ICE Message Import

- **Status**: Working
- **Improvements Required**: Amend the processing of ICE messages to require fewer manual amendments by the administrators.
- **Source**: Server: UHLSQLPRIME01\UHLBRICCSDB Database: genvasc-ice
- **Destination**: CiviCRM
- **Technology**: PHP MS SQL Server connection

==== i2b2 Extract Available Patients

- **Status**: Working
- **Improvements Required**: None
- **Source**: CiviCRM
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Load participant and consent information.

==== i2b2 Delete Withdrawn Patients

- **Status**: Working
- **Improvements Required**: None
- **Source**: CiviCRM
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Delete participants who have withdrawn.

===== Improvements Required

Check that it also deletes excluded participants.

=== [[BRICCS Study]]

==== Data Collection: Ongoing

Recruitment ongoing.  Will need to be able to continue amending participants records after recruitment is complete to track withdrawals.

==== i2b2 Delete Withdrawn Patients

- **Status**: Required
- **Improvements Required**: None
- **Source**: CiviCRM
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Delete participants who have withdrawn.

=== NIHR Bio-Resource

==== Data Collection: Ongoing

Recruitment ongoing.  Will need to be able to continue amending participants records after recruitment is complete to track withdrawals.

==== i2b2 Extract Available Patients

- **Status**: Working
- **Improvements Required**: None
- **Source**: CiviCRM
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Load participant and consent information.

==== i2b2 Delete Withdrawn Patients

- **Status**: Required
- **Improvements Required**: None
- **Source**: CiviCRM
- **Destination**: i2b2
- **Technology**: [[i2b2 Mapped Importer]]
- **Description**: Delete participants who have withdrawn.

== CaTissue

=== [[GENVASC Study]]

==== Data Collection: Ongoing

==== Participant Reconciliation

- **Status**: Required
- **Improvements Required**: None
- **Source**: CiviCRM & CaTissue
- **Destination**: Report
- **Technology**: Drupal cron job?
- **Description**: Reconcile the GPt numbers in CaTissue with those in CiviCRM to check that all samples have enrolments and all enrolments have samples.

=== [[BRICCS Study]]

==== Data Collection: Ongoing

==== Participant Reconciliation

- **Status**: Required
- **Improvements Required**: None
- **Source**: CiviCRM & CaTissue
- **Destination**: Report
- **Technology**: Drupal cron job?
- **Description**: Reconcile the BPt numbers in CaTissue with those in CiviCRM to check that all samples have enrolments and all enrolments have samples.

== i2b2

=== [[GENVASC Study]]

==== Data Collection: Ongoing

==== GEM Primary Care Data

- **Status**: Particially Written
- **Improvements Required**: Need meeting with GEM
- **Source**: GEM SystemOne and EMIS data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import primary care data from GEM

==== PATS Data

- **Status**: Working
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital audit data

==== PMI Data

- **Status**: Working
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital PMI data

==== Hospital HES Data

- **Status**: Partially Written
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital HES data

==== Hospital Discharge Letters Data

- **Status**: Partially Written
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital discharge data

==== National HES Data

- **Status**: Required
- **Improvements Required**: None
- **Source**: HSCIC DARS
- **Destination**: i2b2
- **Technology**: ?
- **Description**: Import national HES data

==== National ONS Cause of Death Data

- **Status**: Required
- **Improvements Required**: None
- **Source**: HSCIC DARS
- **Destination**: i2b2
- **Technology**: ?
- **Description**: Import national ONS Cause of Death data

=== [[BRICCS Study]]

==== Data Collection: Ongoing

==== PATS Data

- **Status**: Working
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital audit data

==== PMI Data

- **Status**: Working
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital PMI data

==== Hospital HES Data

- **Status**: Partially Written
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital HES data

==== Hospital Discharge Letters Data

- **Status**: Partially Written
- **Improvements Required**: None
- **Source**: UHL data warehouses
- **Destination**: i2b2
- **Technology**: SSIS
- **Description**: Import hospital discharge data

[[BackLinks]]