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


Ignore:
Timestamp:
09/04/13 10:54:34 (11 years ago)
Author:
Nick Holden
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • LEGACY - GRAPHIC2 Study

    v12 v13  
    5454
    5555Study: GRAPHIC2
    56 
    5756Standard activity timeline: Open Case. That's it. Nothing else.
    58 
    5957Recruitment activity timeline: Recruitment Interview. ABPM fitting. ABPM collection. Letter to GP.
    6058
    … …  
    6361Mapping of graphic participants source file to civicrm object model:
    6462
    65 ID Number => GRAPHIC2 / GRAPHIC ID (needs CiviCase entry, maybe import programmatically?) AND / OR 'External Identifier'
     63ID Number => GRAPHIC2 / GRAPHIC ID
    6664S Number DO NOT IMPORT
    6765Discovered S number => UHL S Number
    68 Lab Number => GRAPHIC2 / LAB ID (needs CiviCase entry, maybe import programmatically?)
    69 Family Number => GRAPHIC2 / FAMILY ID (needs CiviCase entry, maybe import programmatically?)
     66Lab Number => GRAPHIC2 / LAB ID
     67Family Number => GRAPHIC2 / FAMILY ID
    7068Date of Letter  DO NOT IMPORT
    71 Title => Prefix
     69Title => Prefix (needs editing in spreadsheet to match CiviCRM prefixes)
    7270Surname => Last Name
    7371Forename => First Name
    7472Middle Name => Middle Name
    75 Date of Birth => Date of Birth
     73Date of Birth => Date of Birth (needs editing in spreadsheet to match YYYY-MM-DD
    7674Address 1 => NEEDS EDTING - SHOULD MATCH 'Additional Address 1'
    7775Address 2 => NEEDS CLEANING - SHOULD MATCH 'Street address'
    … …  
    8987GP Address 3     DO NOT IMPORT
    9088GP Address 4     DO NOT IMPORT
     89NEW COLUMN surgery civicrm code => Relationship to GP surgery
    9190Height   DO NOT IMPORT
    9291Weight   DO NOT IMPORT
    … …  
    111110CHD risk         DO NOT IMPORT
    112111Stroke risk      DO NOT IMPORT
    113 Consent(1) for contact re further studies        DO NOT IMPORT
    114 Consent(1a) for blood to be stored       DO NOT IMPORT
     112Consent(1) for contact re further studies => GRAPHIC 2 / Consent for further studies
     113Consent(1a) for blood to be stored  => GRAPHIC 2 / G1 Blood Consent
    115114Consent(2) requested re further studies  DO NOT IMPORT
    116115Consent2 (nurse/interview?)      DO NOT IMPORT
    … …  
    122121EPC in CAD Study (Mother)        DO NOT IMPORT
    123122Position in family       DO NOT IMPORT
    124 GRAPHIC2 (Mother) letter         DO NOT IMPORT
    125 GRAPHIC2 response        DO NOT IMPORT
     123GRAPHIC2 (Mother) letter => ACTIVITY - GRAPHIC 2 Mother letter
     124GRAPHIC2 response => GRAPHIC 2 / Pre-consent to GRAPHIC 2
    126125GRAPHIC2 No of participants      DO NOT IMPORT
    127126Comments DO NOT IMPORT