There are many views already created in AssignmentPro for you to use.
Below are examples of a base table highlighted in yellow where a "view" has been created:
What is a view and why would I need one?
There may be times when significant time could be saved by having a group of frequently accessed tables joined together in a view, especially where it is not possible to create a particular grouping of data/tables through the use of a report type. When this occurs, a "view" can be created as a base table.
A view gives us the ability to join data from several tables in a pre-coded way and thus provides data from several tables in a single view. When selecting a view in AssignmentPro for a User Report Type, look for "vwEQ_" or "vw_" at the beginning of the data source or "(view)" or "(View)" at the end of the data source.
For example: You may to want to create a report to back up a calculation which uses Compensation Worksheets, Cost Estimates, Payroll Systems and information that is stored in a User Page. A view could be created to join these 4 tables together to use all the data in the same report. This new view/table can then be used in the User Report by adding the table in the User Report Type. A view can be used to derive information from the system e.g. calculating the age of an employee based on today's date.
What are the limitations of using a view?
Views are commonly created to fulfill a specific function, but they do have their limitations.
A view table cannot always be joined or linked to other tables. This is normally due to a lack of vision as to what the view could be used for in the future. If you cannot connect a view to a table then an update to the view logic is required by an Equus developer. Any changes to a view would need to be performed by an Equus developer.
Things to consider before requesting a view to be created
Try using prerequisite report(s) in conjunction with your user report
Review existing views in the system. For a list of commonly used views, click here
Only Equus developers can change views. This is typically a time consuming process and requires raising a development ticket
I need a view, how do I get one?
Views can only be created by Equus developers and in general client specific views are not always provided. However, talk to your Equus representative to see whether your view has use for the wider Equus community and if it can be added into the product for everyone to use.