Changes between Version 8 and Version 9 of LEGACY - GRAPHIC2 Study

Timestamp:

08/30/13 14:34:53 (12 years ago)

Author:

Nick Holden

Comment:

--

LEGACY - GRAPHIC2 Study

@@ -57 +57 @@
 Activity timeline: Recruitment Interview. ABPM fitting.
 
+Mapping of graphic participants source file to civicrm object model:
+
+ID Number => GRAPHIC2 / GRAPHIC ID (needs CiviCase entry, maybe import programmatically?) AND / OR 'External Identifier'
+S Number DO NOT IMPORT
+Discovered S number => UHL S Number
+Lab Number => GRAPHIC2 / LAB ID (needs CiviCase entry, maybe import programmatically?)
+Family Number => GRAPHIC2 / FAMILY ID (needs CiviCase entry, maybe import programmatically?)
+Date of Letter  DO NOT IMPORT
+Title => Prefix
+Surname => Last Name
+Forename => First Name
+Middle Name => Middle Name
+Date of Birth => Date of Birth
+Address 1 => NEEDS EDTING - SHOULD MATCH 'Additional Address 1'
+Address 2 => NEEDS CLEANING - SHOULD MATCH 'Street address'
+Address 3 => NEEDS CLEANING - SHOULD MATCH 'Additional Address 2'
+Address 4 => NEEDS CLEANING - SHOULD MATCH 'City'
+NEW COLUMN 'COUNTY' => COUNTY
+Post Code => Postal code
+Phone Number => Phone (HOME)
+Alternative contact no DO NOT IMPORT
+GP Title DO NOT IMPORT
+GP Surname DO NOT IMPORT
+GP Forename DO NOT IMPORT
+GP Address 1 DO NOT IMPORT
+GP Address 2     DO NOT IMPORT
+GP Address 3     DO NOT IMPORT
+GP Address 4     DO NOT IMPORT
+Height   DO NOT IMPORT
+Weight   DO NOT IMPORT
+BMI      DO NOT IMPORT
+Mean 24hr BP     DO NOT IMPORT
+Mean Day Time BP         DO NOT IMPORT
+Mean Night Time BP       DO NOT IMPORT
+Sodium   DO NOT IMPORT
+Potassium        DO NOT IMPORT
+Urea     DO NOT IMPORT
+Creatinine       DO NOT IMPORT
+Glucose  DO NOT IMPORT
+Urate    DO NOT IMPORT
+Albumin  DO NOT IMPORT
+Adjusted Calcium         DO NOT IMPORT
+Total Cholesterol        DO NOT IMPORT
+HDL Cholesterol  DO NOT IMPORT
+Current Smoker   DO NOT IMPORT
+Advised to stop smoking  DO NOT IMPORT
+Known Diabetic   DO NOT IMPORT
+Known Hypertensive       DO NOT IMPORT
+CHD risk         DO NOT IMPORT
+Stroke risk      DO NOT IMPORT
+Consent(1) for contact re further studies        DO NOT IMPORT
+Consent(1a) for blood to be stored       DO NOT IMPORT
+Consent(2) requested re further studies  DO NOT IMPORT
+Consent2 (nurse/interview?)      DO NOT IMPORT
+Response to consent(2) request   DO NOT IMPORT
+Reminder letter (Sub Study)      DO NOT IMPORT
+Sub Study letter to be sent      DO NOT IMPORT
+Qualitative Study        DO NOT IMPORT
+Flap Gene Study  DO NOT IMPORT
+EPC in CAD Study (Mother)        DO NOT IMPORT
+Position in family       DO NOT IMPORT
+GRAPHIC2 (Mother) letter         DO NOT IMPORT
+GRAPHIC2 response        DO NOT IMPORT
+GRAPHIC2 No of participants      DO NOT IMPORT
+Comments DO NOT IMPORT
+
 == Device driver installations ==