When you create a query on salaries, this will automatically bring up the employee's current salary. This article will explain how to build a query on previous salary information.
To learn more about creating queries in general, please take a look at the below articles:
To create this query, first you will need to click on the Queries tab and select the plus icon. From here:
1. Click the 'Salary Details' option in the first column
2. In the next three columns, scroll down to the salary information.
3. Select all information you wish to include in this query - as you will be including history later on, we advise to ensure that 'Salary Effective Date' and 'Salary Amount' is ticked.
4. Click Next - you are now in the 'Filters and Options' page
5. If you skip this page, the query will retrieve all active employee's and their salary information. You may wish to use this area to filter by name, effective date, salary amount etc.
6. Once you have chosen your filters (if any), click Next.
7. Name your query (you can also select a category and/or write a description of this query.
8. Click Next and you will be provided with a list of employee's and their current salary.
9. From here, click on the 'Options' button:
10. You then have the option to include leavers in this query, or show history (in this case, salary history.)
11. Click Save!
Customer Services Team.