Changes between Version 13 and Version 14 of LEGACY - GRAPHIC2 Study


Ignore:
Timestamp:
09/05/13 08:44:58 (11 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - GRAPHIC2 Study

    v13 v14  
    4646FBC samples will be processed in the LCB lab, but this will need a specific data acquisition process which Richard is working on. Other blood results will come from pathology system, using the same DWH approach into i2b2 that we use for BRICCS and GENVASC.
    4747
    48 GRAPHIC 2 commits us to send a summary to the patient's GP containing their blood results and ABPM data. The blood results will go directly from the pathology department. A pro forma can be sent by the nurse, using CiviCRM, commenting that the GP should already have received the results, so there is no need to transcribe them.
     48GRAPHIC 2 commits us to send a summary to the patient's GP containing their blood results and ABPM data. The blood results will go directly from the pathology department. A pro forma can be sent by the nurse, using CiviCRM, commenting that the GP should already have received the results, so there is no need to transcribe them. But hard copies need to be sent to the patient.
    4949
    5050Implications for the CiviCRM object model:
    5151
    52 Custom group: GRAPHIC2
    53 Custom fields: GRAPHIC2/GRAPHIC ID, GRAPHIC2/LAB ID, GRAPHIC2/FAMILY ID, GRAPHIC2/CONSENT FOR FURTHER STUDIES, GRAPHIC2/G1 BLOOD CONSENT, GRAPHIC2/ PRE CONSENT TO GRAPHIC 2
     52* Group for contacts: GRAPHIC2 - all imported contacts are placed in this group
    5453
    55 Study: GRAPHIC2
    56 Standard activity timeline: Open Case. That's it. Nothing else.
    57 Recruitment activity timeline: Recruitment Interview. ABPM fitting. ABPM collection. Letter to GP.
     54* Custom group: GRAPHIC2
     55  * Custom fields: GRAPHIC2/GRAPHIC ID, GRAPHIC2/LAB ID, GRAPHIC2/FAMILY ID, GRAPHIC2/CONSENT FOR FURTHER STUDIES, GRAPHIC2/G1 BLOOD CONSENT, GRAPHIC2/ PRE CONSENT TO GRAPHIC 2
     56
     57* Study: GRAPHIC2
     58  * Standard activity timeline: Open Case. That's it. Nothing else.
     59  * Recruitment activity timeline: Recruitment Interview. ABPM fitting. ABPM collection. Letter to GP.
    5860
    5961The study definition xml file will be attached to this page once completed.
    … …  
    6163Mapping of graphic participants source file to civicrm object model:
    6264
    63 ID Number => GRAPHIC2 / GRAPHIC ID
    64 S Number DO NOT IMPORT
    65 Discovered S number => UHL S Number
    66 Lab Number => GRAPHIC2 / LAB ID
    67 Family Number => GRAPHIC2 / FAMILY ID
    68 Date of Letter  DO NOT IMPORT
    69 Title => Prefix (needs editing in spreadsheet to match CiviCRM prefixes)
    70 Surname => Last Name
    71 Forename => First Name
    72 Middle Name => Middle Name
    73 Date of Birth => Date of Birth (needs editing in spreadsheet to match YYYY-MM-DD
    74 Address 1 => NEEDS EDTING - SHOULD MATCH 'Additional Address 1'
    75 Address 2 => NEEDS CLEANING - SHOULD MATCH 'Street address'
    76 Address 3 => NEEDS CLEANING - SHOULD MATCH 'Additional Address 2'
    77 Address 4 => NEEDS CLEANING - SHOULD MATCH 'City'
    78 NEW COLUMN 'COUNTY' => COUNTY
    79 Post Code => Postal code
    80 Phone Number => Phone (HOME)
    81 Alternative contact no DO NOT IMPORT
    82 GP Title DO NOT IMPORT
    83 GP Surname DO NOT IMPORT
    84 GP Forename DO NOT IMPORT
    85 GP Address 1 DO NOT IMPORT
    86 GP Address 2     DO NOT IMPORT
    87 GP Address 3     DO NOT IMPORT
    88 GP Address 4     DO NOT IMPORT
    89 NEW COLUMN surgery civicrm code => Relationship to GP surgery
    90 Height   DO NOT IMPORT
    91 Weight   DO NOT IMPORT
    92 BMI      DO NOT IMPORT
    93 Mean 24hr BP     DO NOT IMPORT
    94 Mean Day Time BP         DO NOT IMPORT
    95 Mean Night Time BP       DO NOT IMPORT
    96 Sodium   DO NOT IMPORT
    97 Potassium        DO NOT IMPORT
    98 Urea     DO NOT IMPORT
    99 Creatinine       DO NOT IMPORT
    100 Glucose  DO NOT IMPORT
    101 Urate    DO NOT IMPORT
    102 Albumin  DO NOT IMPORT
    103 Adjusted Calcium         DO NOT IMPORT
    104 Total Cholesterol        DO NOT IMPORT
    105 HDL Cholesterol  DO NOT IMPORT
    106 Current Smoker   DO NOT IMPORT
    107 Advised to stop smoking  DO NOT IMPORT
    108 Known Diabetic   DO NOT IMPORT
    109 Known Hypertensive       DO NOT IMPORT
    110 CHD risk         DO NOT IMPORT
    111 Stroke risk      DO NOT IMPORT
    112 Consent(1) for contact re further studies => GRAPHIC 2 / Consent for further studies
    113 Consent(1a) for blood to be stored  => GRAPHIC 2 / G1 Blood Consent
    114 Consent(2) requested re further studies  DO NOT IMPORT
    115 Consent2 (nurse/interview?)      DO NOT IMPORT
    116 Response to consent(2) request   DO NOT IMPORT
    117 Reminder letter (Sub Study)      DO NOT IMPORT
    118 Sub Study letter to be sent      DO NOT IMPORT
    119 Qualitative Study        DO NOT IMPORT
    120 Flap Gene Study  DO NOT IMPORT
    121 EPC in CAD Study (Mother)        DO NOT IMPORT
    122 Position in family       DO NOT IMPORT
    123 GRAPHIC2 (Mother) letter => ACTIVITY - GRAPHIC 2 Mother letter
    124 GRAPHIC2 response => GRAPHIC 2 / Pre-consent to GRAPHIC 2
    125 GRAPHIC2 No of participants      DO NOT IMPORT
    126 Comments DO NOT IMPORT
     65* ID Number => GRAPHIC2 / GRAPHIC ID
     66* S Number DO NOT IMPORT
     67* Discovered S number => UHL S Number
     68* Lab Number => GRAPHIC2 / LAB ID
     69* Family Number => GRAPHIC2 / FAMILY ID
     70* Date of Letter        DO NOT IMPORT
     71* Title => Prefix (needs editing in spreadsheet to match CiviCRM prefixes)
     72* Surname => Last Name
     73* Forename => First Name
     74* Middle Name => Middle Name
     75* Date of Birth => Date of Birth (needs editing in spreadsheet to match YYYY-MM-DD
     76* Address 1 => NEEDS EDTING - SHOULD MATCH 'Additional Address 1'
     77* Address 2 => NEEDS CLEANING - SHOULD MATCH 'Street address'
     78* Address 3 => NEEDS CLEANING - SHOULD MATCH 'Additional Address 2'
     79* Address 4 => NEEDS CLEANING - SHOULD MATCH 'City'
     80* NEW COLUMN 'COUNTY' => COUNTY
     81* Post Code => Postal code
     82* Phone Number => Phone (HOME)
     83* Alternative contact no DO NOT IMPORT
     84* GP Title DO NOT IMPORT
     85* GP Surname DO NOT IMPORT
     86* GP Forename DO NOT IMPORT
     87* GP Address 1 DO NOT IMPORT
     88* GP Address 2   DO NOT IMPORT
     89* GP Address 3   DO NOT IMPORT
     90* GP Address 4   DO NOT IMPORT
     91* NEW COLUMN surgery civicrm code => Relationship to GP surgery
     92* Height         DO NOT IMPORT
     93* Weight         DO NOT IMPORT
     94* BMI    DO NOT IMPORT
     95* Mean 24hr BP   DO NOT IMPORT
     96* Mean Day Time BP       DO NOT IMPORT
     97* Mean Night Time BP     DO NOT IMPORT
     98* Sodium         DO NOT IMPORT
     99* Potassium      DO NOT IMPORT
     100* Urea   DO NOT IMPORT
     101* Creatinine     DO NOT IMPORT
     102* Glucose        DO NOT IMPORT
     103* Urate  DO NOT IMPORT
     104* Albumin        DO NOT IMPORT
     105* Adjusted Calcium       DO NOT IMPORT
     106* Total Cholesterol      DO NOT IMPORT
     107* HDL Cholesterol        DO NOT IMPORT
     108* Current Smoker         DO NOT IMPORT
     109* Advised to stop smoking        DO NOT IMPORT
     110* Known Diabetic         DO NOT IMPORT
     111* Known Hypertensive     DO NOT IMPORT
     112* CHD risk       DO NOT IMPORT
     113* Stroke risk    DO NOT IMPORT
     114* Consent(1) for contact re further studies => GRAPHIC 2 / Consent for further studies
     115* Consent(1a) for blood to be stored  => GRAPHIC 2 / G1 Blood Consent
     116* Consent(2) requested re further studies        DO NOT IMPORT
     117* Consent2 (nurse/interview?)    DO NOT IMPORT
     118* Response to consent(2) request         DO NOT IMPORT
     119* Reminder letter (Sub Study)    DO NOT IMPORT
     120* Sub Study letter to be sent    DO NOT IMPORT
     121* Qualitative Study      DO NOT IMPORT
     122* Flap Gene Study        DO NOT IMPORT
     123* EPC in CAD Study (Mother)      DO NOT IMPORT
     124* Position in family     DO NOT IMPORT
     125* GRAPHIC2 (Mother) letter => ACTIVITY - GRAPHIC 2 Mother letter
     126* GRAPHIC2 response => GRAPHIC 2 / Pre-consent to GRAPHIC 2
     127* GRAPHIC2 No of participants    DO NOT IMPORT
     128* Comments DO NOT IMPORT
    127129
    128130== Device driver installations ==