Queries/Reporting

We currently use PHR for reporting on headcount and this includes reporting of the FTE for part-time workers. At the moment we use the salary area, but use the deduction tab to show they work part time. We have come into problems as we are integra...

A query that checks which employees have a sick leave / other event without supporting documents, that were uploaded through the "attach file" option of the event. That way we can monitor who needs to upload their documents and who doesn't.

At the moment the only query reports we can run for how many sickness days have been taken, is a report that lists all the sickness occurrence. Therefore to get total numbers for each employee we have to calculate manually. Even though the total d...

Adding a filtering field for Admins and Managers on 'Date Last Opened' alongside the existing Name, Description and Category will allow for easy tidying up of unused Queries.

You cannot currently build a query that shows if an assignment is part of an approved timesheet. We currently have staff that do assignments but dont send them for approval. The timesheet and assignment can still be approved but when reporting the...

Please could there be an option created to only bring back the most recent record on a logbook query. This would make it so much easier to report on something like someones pension record in the logbook section, only bringing back the most recent ...

I often have queries that I need to write, especially for Ripples, where I don't have the flexibility I need in the query builder. I need an IS NOT option i.e. the date was not yesterday or today, and I need a weekend option i.e. the date was not ...

Access Workspace is built around their Access Data Engine (ADE) allowing you to build Analytics within workspace to combine data from multiple Access and 3rd Party applications and present this consolidated data to selected individuals. It seems t...

We would like reports run to include the line manager/direct report's ID/employee number as a field, as well as the colleagues ID/employee number. At the moment, for a number of reports that include the manager, we are adding this manually.

I needed a list of employees based in each of our office locations as at a historic date. There's no way of doing this under the current query filter options so it would be great for this to be added.