...
The units need to have 'visible to join' False and the opt-epro group feature assigned to it.
Code Block | ||
---|---|---|
| ||
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 EROEPRO Project Salford Group | OPTEPRO Salford | optepro-salford 59542083 | OPT EPRO | OPT_EPRO | optepro 67579758 | OPT EPro Manchester Group | OPTEPRO Manchester | optepro-manchester (45 rows) patientview_staging=# |
Configured Cohort for Saltford
...