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 is restricted to 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.
System views are:
Some system data only refreshes daily. This includes job alert, interview scheduler and global question data. |  |  |
Working with System Views
You can use system views by themselves or add fields from system views to a report built on your custom view. You will usually do the latter via an append subquery.
If joining custom to system views (or vice versa), you need to use:
join fields to match data between views
filters (like a date range) to focus the scope of data being matched data in the sub-query. This is a new, best-practice approach.
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.
