1.0 Jobs, Applications and Assessment
System Views
These views contain extra system details for that specialised report with very specific requirements. They can be used by themselves or joined to your custom view via a subquery in your report.
System views contain system fields only in a standardised format.
Any customisation of system fields or addition of custom fields will be done in your custom views.
By keeping these views as system fields only, we are able to make ongoing updates and additions that are available immediately for your use, rather than waiting for individual updates to your specific custom views. If we implement new system fields, or find a new way to calculate something, you get them straight away.
Of particular importance are the SYS 1.x series - they contain even more fields and calculations that might be relevant to your report requirements. If your are unable to get these from your custom view, explore the relevant system view.
A full data dictionary will be available on the Welcome dashboard > System Views subtab.
rstem views are:
|
System views can only be used by Corporate Report Writers.
Working with System Views
You can add fields from system views to a report built on your custom view. You will usually do this via an append subquery.
Join fields
You’ll need to join your custom view to the system view via a field contained in both. Custom view 1.0 contains a range of unique identifiers for this purpose. Choose one that matches the detail in your report and the data you need from the system view e.g. ApplicationID for additional application data. Hover over each field when building your report or refer to the data dictionary for full definitions.
System view filters
It is also best practice to filter the data matched in your system view in addition to the join to your custom view data. Doing this can significantly help your report’s performance. You can:
match filter fields from your custom view (where possible) e.g. Job Open Date
add filter fields from the system view to help narrow the data it is matching from
You can link a subquery filter to another filter (e.g. in the master) in the advanced filter settings.