Changes between Version 5 and Version 6 of Onyx to CiviCRM

Timestamp:

12/09/13 15:32:18 (10 years ago)

Author:

Richard Bramley

Comment:

--

Onyx to CiviCRM

@@ -17 +17 @@
 The following data will be copied from the Onyx database to CiviCRM (the question name within Onyx is shown in brackets):
 
-- Date and Time of Interview {Interview: start_date}
-- Partiticant Number (Admin.Participant.barcode)
-- Interview Status (Admin.Interview.status) Values of
+- Date and Time of Interview {Interview.start_date}
+- Partiticant Number (Participant.barcode)
+- Interview Status (Interview.status) Values of
  - IN_PROGRESS
  - CLOSED
  - CANCELLED
  - COMPLETED
-- Title (Admin.Participant.pat_title)
-- First Name (Admin.Participant.firstName)
-- Surname (Admin.Participant.lastName)
+- Title (participant_attribute_value.pat_title)
+- First Name (Participant.firstName)
+- Surname (Participant.lastName)
 - Address
- - Admin.Participant.pat_address1
- - Admin.Participant.pat_address2
- - Admin.Participant.pat_address3
- - Admin.Participant.pat_address4
- - Admin.Participant.pat_postcode
-- Date of Birth (Admin.Participant.birthDate)
-- Gender (Admin.Participant.gender)
-- Participant NHS Number {Admin.Participant.pat_nhsnumber}
-- Participant UHL System Number {Admin.Participant.enrollmentId}
+ - participant_attribute_value.pat_address1
+ - participant_attribute_value.pat_address2
+ - participant_attribute_value.pat_address3
+ - participant_attribute_value.pat_address4
+ - participant_attribute_value.pat_postcode
+- Date of Birth (Participant.birthDate)
+- Gender (Participant.gender)
+ - FEMALE or MALE
+- Participant NHS Number {participant_attribute_value.pat_nhsnumber}
+- Participant UHL System Number {Participant.enrollmentId}
 - Consent Values
- - Understands the request for consent (consent_q1)
- - Consents to donate blood and urine (consent_q2)
- - Consents to entry in the BRICCS database (consent_q3)
- - Consents to possible further contact from BRU (consent_q4)
- - Understands the rules for withdrawal (consent_q5)
+ - Understands the request for consent (question_answer.question_name="consent_q1")
+ - Consents to donate blood and urine (question_answer.question_name="consent_q2")
+ - Consents to entry in the BRICCS database (question_answer.question_name="consent_q3")
+ - Consents to possible further contact from BRU (question_answer.question_name="consent_q4")
+ - Understands the rules for withdrawal (question_answer.question_name="consent_q5")
 
 == Additional Requirements
@@ -51 +52 @@
  - It is possible to have hidden custom fields within CiviCRM by [http://book.civicrm.org/user/current/organising-your-data/custom-fields/ marking the Custom Group as inactive].  This could be used to store a date last updated or a hash value to cut down the number of interviews that need to be processed every time.
 
+== Query
+
+{{{
+
+}}}