Create a specific Unit cohort for each participating unit:
- epro-Salford
- epro-Lister
- epro-Kings
Assign these the correct unit code using the PV Table pv_survey_unit this mapping ensures the sending facility for the group is correctly sent in the survey otherwise it will use the configured group code.
Example for Leeds
patientview_staging=> select * from pv_survey_unit; id | unit_id | survey_group_id ----+---------+----------------- 1 | 39 | 59542083 patientview_staging=> select * from pv_group where id in (39, 59542083); -[ RECORD 1 ]----+---------------------------- id | 39 group_name | Leeds - St James's Hospital group_short_name | Leeds- St James's code | RQR00 ... -[ RECORD 2 ]----+---------------------------- id | 59542083 group_name | OPT EPRO group_short_name | OPT_EPRO code | optepro