You will need to create the following view and Procs from another Database (Dream would do), you can do this quickly by right clicking on the proc and selecting \\ ''Script Stored Procedure > 
create to > new query editor window.''\\
=== Views
1. LOAD_ValidEnrollments -- which you'll need to edit a lot
=== Procs
1. LOAD_CreateParticipants -- which you'll need to edit a lot
2. LOAD_PatientMapping -- which you'll need to edit a little
3. LOAD_All -- which you'll need to edit a little

4. LOAD_Observations_RedCap -- Lots of amendment
5. LOAD_Observations_CiviCRM -- little amendment
6. LOAD_Observations_Onyx -- DB dependent

[[BackLinks]]