Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Create a specific Unit cohort for each participating unit:

  • epro-Salford
  • epro-Lister
  • epro-Kings

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

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



  • No labels