Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added new site

...

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

Code Block
languagesql
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 

...