Reporting Views Overview

A reporting view is a collection of database fields that relate to a specific Accolade concept, such as users, projects, or resource pools, or that show the relationship between two objects, such as templates and deliverables. Insert the database field references in queries to create Accolade reports.

Accolade contains the following reporting view types:

• Project Reporting Views - Reporting views that contain database fields with project information begin with RVP_. Reports created with these views use respect the security set with access groups and security profiles. Users view a chart or report, or previewing a query, see only data that relates to projects in access groups to which they have access.

• Non-Project Reporting Views - Reporting views that contain only database fields that do not relate directly to project begin with RV_. The content in these reporting views is not affected by access group or security profile access.
• Custom Views - Custom reporting views begin with CRVP_ and CRV_.

To quickly view the list of all reporting views in Accolade, from the System > Content Sources > Queries menu, create and preview the following query: SELECT * from RV_ReportingViews. Substitute the RV_ReportingViews portion of the query with any reporting view name to see the list of all columns within that view.

See the following to get started:

• Non-Project Reporting Views (RV_) Reference
• Project Reporting Views (RVP_) Reference