| 24 | | |
| 25 | | == Onyx |
| 26 | | |
| 27 | | == REDCap |
| 28 | | |
| 29 | | |
| 30 | | === [[BRICCS Study]] Leicester (hospital internal server) |
| 31 | | |
| 32 | | ==== Data Collection: Ongoing |
| 33 | | |
| 34 | | ==== CiviCRM Extract |
| 35 | | |
| 36 | | - **Status**: Required |
| 37 | | - **Improvements Required**: |
| 38 | | - **Source**: REDCap |
| 39 | | - **Destination**: CiviCRM |
| 40 | | - **Technology**: Drupal cron job |
| 41 | | - **Description**: Load status of REDCap questionnaire into CiviCRM [[BRICCS Study]] enrolment. |
| 42 | | |
| 43 | | ==== i2b2 Extract |
| 44 | | |
| 45 | | - **Status**: Completed |
| 46 | | - **Improvements Required**: |
| 47 | | - Add more fields as needs arise |
| 48 | | - No interview date, so no start date for observations |
| 49 | | - **Source**: REDCap |
| 50 | | - **Destination**: i2b2 |
| 51 | | - **Technology**: [[i2b2 Mapped Importer]] |
| 52 | | - **Description**: Load questionnaire data into i2b2. |
| 53 | | |
| 54 | | === [[BRICCS Study]] External Sites (hospital N3 server) |
| 55 | | |
| 56 | | ==== Sites |
| 57 | | |
| 58 | | - Kettering: recruiting |
| 59 | | - Doncaster: recruiting |
| 60 | | - Sheffield: recruiting |
| 61 | | - Lincoln: recruiting |
| 62 | | - Grantham: recruiting |
| 63 | | - Chesterfield: recruiting |
| 64 | | - Northampton: planned |
| 65 | | - Royal Free Hospital: planned (might be [[DREAM Study]]) |
| 66 | | |
| 67 | | ==== CiviCRM Extract |
| 68 | | |
| 69 | | - **Status**: Not Required |
| 70 | | |
| 71 | | ==== i2b2 Extract |
| 72 | | |
| 73 | | - **Status**: Completed |
| 74 | | - **Improvements Required**: |
| 75 | | - Add more fields as needs arise |
| 76 | | - No interview date, so no start date for observations |
| 77 | | - **Source**: REDCap |
| 78 | | - **Destination**: i2b2 |
| 79 | | - **Technology**: [[i2b2 Mapped Importer]] |
| 80 | | - **Description**: Load questionnaire data into i2b2. |
| 81 | | |
| 82 | | == CiviCRM |
| 83 | | |
| 84 | | === Common |
| 85 | | |
| 86 | | ==== HSCIC Practice Import |
| 87 | | |
| 88 | | - **Status**: Working |
| 89 | | - **Improvements Required**: None |
| 90 | | - **Source**: HSCIC practice details files |
| 91 | | - **Destination**: CiviCRM practice details |
| 92 | | - **Technology**: Drupal cron job |
| 93 | | |
| 94 | | === [[GENVASC Study]] |
| 95 | | |
| 96 | | ==== Data Collection: Ongoing |
| 97 | | |
| 98 | | Recruitment ongoing. Will need to be able to continue amending participants records after recruitment is complete to track withdrawals. |
| 99 | | |
| 100 | | ==== ICE Message Import |
| 101 | | |
| 102 | | - **Status**: Working |
| 103 | | - **Improvements Required**: Amend the processing of ICE messages to require fewer manual amendments by the administrators. |
| 104 | | - **Source**: Server: UHLSQLPRIME01\UHLBRICCSDB Database: genvasc-ice |
| 105 | | - **Destination**: CiviCRM |
| 106 | | - **Technology**: PHP MS SQL Server connection |
| 107 | | |
| 108 | | ==== i2b2 Extract Available Patients |
| 109 | | |
| 110 | | - **Status**: Working |
| 111 | | - **Improvements Required**: None |
| 112 | | - **Source**: CiviCRM |
| 113 | | - **Destination**: i2b2 |
| 114 | | - **Technology**: [[i2b2 Mapped Importer]] |
| 115 | | - **Description**: Load participant and consent information. |
| 116 | | |
| 117 | | ==== i2b2 Delete Withdrawn Patients |
| 118 | | |
| 119 | | - **Status**: Working |
| 120 | | - **Improvements Required**: None |
| 121 | | - **Source**: CiviCRM |
| 122 | | - **Destination**: i2b2 |
| 123 | | - **Technology**: [[i2b2 Mapped Importer]] |
| 124 | | - **Description**: Delete participants who have withdrawn. |
| 125 | | |
| 126 | | ===== Improvements Required |
| 127 | | |
| 128 | | Check that it also deletes excluded participants. |
| | 25 | - [[DataIntegration BRICCS Glenfield REDCap to CiviCRM]] |
| | 26 | - [[DataIntegration BRICCS Glenfield REDCap to i2b2]] |
| | 27 | - [[DataIntegration BRICCS External REDCap to i2b2]] |
| | 28 | - [[DataIntegration DREAM External REDCap to i2b2]] |
| | 29 | - [[DataIntegration DREAM Glenfield REDCap to i2b2]] |
| | 30 | - [[DataIntegration HSCIC GP and Practice to CiviCRM Core]] |
| | 31 | - [[DataIntegration ICE Pathology Requests to GENVASC CiviCRM]] |
| | 32 | - [[DataIntegration GENVASC CiviCRM to GENVASC i2b2]] |
| | 33 | - [[DataIntegration GENVASC CiviCRM to GENVASC i2b2 - Delete Withdrawn]] |