Changes between Version 16 and Version 17 of Onyx to CiviCRM

Timestamp:

12/13/13 09:04:50 (10 years ago)

Author:

Richard Bramley

Comment:

--

Onyx to CiviCRM

@@ -36 +36 @@
 - [x] Gender (Participant.gender)
  - FEMALE or MALE
-- [ ] Participant NHS Number {participant_attribute_value.pat_nhsnumber}
+- [x] Participant NHS Number {participant_attribute_value.pat_nhsnumber}
 - [x] Participant UHL System Number {Participant.enrollmentId}
 - [x] Consent Values
@@ -44 +44 @@
  - Consents to possible further contact from BRU (question_answer.question_name="consent_q4")
  - Understands the rules for withdrawal (question_answer.question_name="consent_q5")
+- [x] Ethnicity
+- [x] GP
+- [x] Telephone
+- [x] Work Telephone
 
 == Additional Requirements
@@ -78 +82 @@
     , consent.q4 AS consent_furtherContact
     , consent.q5 AS consent_understandsWithdrawal
+    , pa.ethnicity
+    , pa.gp
+    , pa.telephone
+    , pa.workphone
 FROM participant p
 JOIN interview i ON i.participant_id = p.id