Create a specific Unit cohort for each participating unit:
- eprooptepro-Salfordsalfordepro
- optepro-Listerlister
- eprooptepro-Kingskings
The units need to have 'visible to join' False and the opt-epro group feature assigned to it.
| Code Block | ||
|---|---|---|
| ||
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)
|
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.
| Code Block | ||||
|---|---|---|---|---|
| ||||
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 Block | ||
|---|---|---|
| ||
# 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) |