= 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 CiviCRM to i2b2 - Delete Withdrawn]]
- [[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]]
- [[DataIntegration BRICCS Glenfield REDCap to CiviCRM]]
- [[DataIntegration BRICCS Glenfield REDCap to i2b2]]
- [[DataIntegration BRICCS External REDCap to i2b2]]
- [[DataIntegration DREAM External REDCap to i2b2]]
- [[DataIntegration DREAM Glenfield REDCap to i2b2]]
- [[DataIntegration HSCIC GP and Practice to CiviCRM Core]]
- [[DataIntegration ICE Pathology Requests to GENVASC CiviCRM]]
- [[DataIntegration GENVASC CiviCRM to GENVASC i2b2]]
- [[DataIntegration GENVASC CiviCRM to GENVASC i2b2 - Delete Withdrawn]]
- [[DataIntegration GENVASC CiviCRM to GENVASC i2b2 - Delete Excluded]]
- [[DataIntegration GENVASC Primary Care Data to i2b2]]

=== [[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(DataIntegration)]]

[[BackLinks]]