| | 1 | you will need to update the Load_observation_''source'' Proc. \\ \\ |
| | 2 | If this is not yet created in the Programmability folder for you database then create one based on the Brave or Briccs one. |
| | 3 | \\ \\ |
| | 4 | within the Proc there are two CTE*s the first of which is the **!StudyData** CTE`* and the second **Facts** which is made up of some union joins, it's the **Facts** area you will need to update. |
| | 5 | \\^*CTE = Common Table Expression^ |
| | 6 | \\ \\ |
| | 7 | **!StudyData** get the create record observations (for Redcap you'll have two, one for Gelnfield, Redcap and another for external, Redcap ext) |
| | 8 | \\ |
| | 9 | NB: In the LOAD_Observations_RedCap you will see this listed as 'create record' however in the LOAD_Observations_CiviCRM it will done via a series of joins e.g the LOAD_ValidEnrollments view joined to \\ |
| | 10 | civicrm_contact joined to... \\ |
| | 11 | ... civicrm_value_genvasc_recruitment_data_5 |
| | 12 | The Second CTE is the **Facts** which have many many many union joins all for different types of data. including, but not limited to, the following: |
| | 13 | |
| | 14 | - **Date Fields** |
| | 15 | - **Exist if '1' Fields** |
| | 16 | - **Text and Enum Fields** |
| | 17 | - **Numeric Fields** |
| | 18 | - Recruitment Site |
| | 19 | - Age at Interview |
