wiki:DataIntegrations

Version 21 (modified by Richard Bramley, 9 years ago) ( diff )

--

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

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(DataIntegration) failed
'Environment' object has no attribute 'get_db_cnx'

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Note: See TracWiki for help on using the wiki.