Create a specific Unit cohort for each participating unit:

optepro-salford
optepro-lister
optepro-kings

The units need to have 'visible to join' False and the opt-epro group feature assigned to it.

postgres=# \c patientview_staging
You are now connected to database "patientview_staging" as user "postgres".
patientview_staging=# select id, group_name, group_short_name, code  from pv_group where code like '%pro%';
    id    |           group_name           |  group_short_name  |        code
----------+--------------------------------+--------------------+--------------------
 61775323 | OPT EPro Project Kings Group   | OPTEPRO Kings      | optepro-kings
 61775292 | OPT EPro Project Lister Group  | OPTEPRO Lister     | optepro-lister
 61775257 | OPT EPRO Project Salford Group | OPTEPRO Salford    | optepro-salford
 59542083 | OPT EPRO                       | OPT_EPRO           | optepro
 67579758 | OPT EPro Manchester Group      | OPTEPRO Manchester | optepro-manchester
(5 rows)

patientview_staging=#

Configured Cohort for Saltford

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

Configuration on staging for three test sites

# Code for listing cohort ids
patientview_staging=# select id, group_name, group_short_name, code  from pv_group where code like '%pro%';
    id    |          group_name           | group_short_name |      code
----------+-------------------------------+------------------+-----------------
 61775323 | OPT EPro Project Kings Group  | OPTEPRO Kings    | optepro-kings
 61775292 | OPT EPro Project Lister Group | OPTEPRO Lister   | optepro-lister
 61775257 | OPT ERO Project Salford Group | OPTEPRO Salford  | optepro-salford
 59542083 | OPT EPRO                      | OPT_EPRO         | optepro
(4 rows)

# Code for listing groups (currently ids are same on live and staging)patientview_production2=# select id, group_name, group_short_name, code  from pv_group where id in (888,715,396);
 id  |                group_name                | group_short_name | code
-----+------------------------------------------+------------------+-------
 396 | Salford Royal (Hope Hospital) Manchester | Salford Royal    | RM301
 715 | Stevenage, Lister Hospital               | Stevenage-Lister | RAQ01
 888 | London - Kings College Hospital          | London -  Kings  | RJZ
(3 rows)

#Code to list final configuration for three test sites
patientview_staging=# select * from pv_survey_unit;
 id | unit_id | survey_group_id
----+---------+-----------------
  1 |      39 |        59542083
  2 |     396 |        61775257
  3 |     715 |        61775292
  4 |     888 |        61775323
(4 rows)