Database Dictionary

Reporting overview

Any database view that starts with the “rpt” prefix is designed as a reporting view, and intended to be consumed by a reporting tool such as Crystal Reports, SSRS (SQL Server Reporting Services), PowerBI, Excel, Cognos or any other reporting tool.

View design considerations

The views are designed around an “inheritance” pattern - that is, views reference other views.  This allows for ease of use and construction of reporting views and report design, but is generally not considered best practice.  Views that reference other views can become bloated with unnessesary database fields, and this can in turn affect performance and network traffic. 

Optimizing report views

Client Reports

rptClient_Basic

A basic view that display client information.  Contains the Primary Site only

rptClient_Site

Extends rptClient_Basic by including additional site details, including the site hierarchy for the client’s primary site

Job Reports

rptJob

Job

rptJob_Actions

rptJob_Basic

rptJob_Client

rptJob_Client_Actions

rptJob_Client_Asset