DataIntegrations

Error: Macro BackLinks(DataIntegrationSource) failed

'Environment' object has no attribute 'get_db_cnx'

Error: Macro BackLinks(DataIntegrationDestination) failed

'Environment' object has no attribute 'get_db_cnx'

Error: Macro BackLinks(DataIntegrationCategory) failed

'Environment' object has no attribute 'get_db_cnx'

Error: Macro BackLinks(DataIntegrationStatus) failed

'Environment' object has no attribute 'get_db_cnx'

Error: Macro BackLinks(DataIntegrationJob) failed

'Environment' object has no attribute 'get_db_cnx'

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 ICE Messages to GENVASC CiviCRM

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

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'