This can be achieved by use of the exceptions query process.
- The first requirement is to write a HR Query based on the HR Record to identify all the employees you are interested in.
The only system requirement is that the query must output the employee number.
You should also output any other fields that you will require on the final query.
You should then define the selection criteria. (Note: suggested at a minimum, status <> ‘L’).
- The second requirement is to write a HR Query based on the Historical Pay Summary File, to identify the periods you are interested in.
The only field required to be output on the query is the employee number (Note: used to tie the two queries together). In the selection criteria, it is suggested to have two lines. One to say Net pay greater than zero, the other to say Period number greater than whatever is required, e.g. 201108, will show employee’s paid in 201109 onwards).
You will need to change this each period.
- To run the report, select Exceptions in HR Query.
In the first page of the wizard, select the query created in the stage above. In the second page, select the query created in the second stage above.
Click Finish and the query will run and output a line of the details specified in the first query for each employee who satisfies that query.
At the end of each line will be a column Qualify. Qualify will say Yes for each employee paid in the period in question, and No for any employee who has not yet been paid.
You can use Group By and Collapse to manipulate the data.