Problem

In the past PROMs analytics was done primarily by one or two analysts. This group put together a large collection of queries which pull data about questionnaires in a format specific to each questionnaire. These queries are a great resource for analysts new to PROMs, but they have their limitations:

1. Analysts must refresh the tables created by these queries manually.
2. These queries write their data across multiple UserWork schemas or to temptables.
3. Documentation is unclear or nonexistent.
4. Access to these queries is limited to only a few analysts.

Proposed Resolution

By converting these Master Queries to views, we can resolve the prior shortcomings.

See the Tasks section below for a list of queries that require conversion.

Tasks