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
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.