Skip to Main Content
PeopleHR Ideas Portal
ADD A NEW IDEA

Queries/Reporting

Showing 137 of 1404

Query to extract in the order your sort it

Please can queries extract into excel/csv in the column order that you sort it on PeopleHR. It is really annoying when doing reports that you have to sort the columns in the order you need them outside the system. It would be so much easier to be ...
Hannah Dougherty 11 months ago in Queries/Reporting 0 Open for Voting

System to calculate Bradford Factor accurately, and not exclude days with other events on the planner

We have to manually check all Bradford Factor scores as People HR will only add in a sickness absence to the Bradford factor score if an employee has not other event on the same day. (i.e. if an employee booked a morning off as sick, was due to wo...
Guest 8 months ago in Queries/Reporting 1 Open for Voting

Length of service (LOS) report to show average LOS for company

In our annual report and other MI reporting, we are asked to report on the avg LOS. We currently have to run the report then manually work it out.
Kate Hewitt 11 months ago in Queries/Reporting 0 Open for Voting

absence calculation

in planer, the number of days absent is over 12 past 12 months from todays date, however percentages of days absent is from First of January. giving for example 550% absence! one cant be absent from work more than 100% of the time!! either both ca...
Barbara Czarnocka 6 months ago in Queries/Reporting 0 Open for Voting

Query report sent via ripple

It would be really handy if the results of a query at any given time could be exported to Excel automatically and that report then sent in an email via ripple.
Ben Clarke 6 months ago in Queries/Reporting 0

Full data back up

It would be great if there was a way to run a full regular data back up in one report to ensure no loss of data and to comply with ISO27001
Guest about 1 month ago in Queries/Reporting 0

Query prompts when too many fields or too much data is selected

Whilst trying to create a query for a backup of all our data, the end product was 0 record. The problem was too many fields were selected and the system froze, which I had to find out through your support team. Surely you could put in place a prom...
Guest about 1 month ago in Queries/Reporting 0

Public holiday pattern clashes when an employee is on sick

If an employee is sick during a public holiday (ie they are subscribed to a public holiday pattern) the sick report does not pull through accurately as it does not take into account the public holiday as it sees it as a non-working day. This is no...
Fran Deias over 1 year ago in Queries/Reporting 1 Open for Voting

Schedule Reports

Have the ability (like is already in place in most systems) to schedule reports to send out to managers/generic mailboxes. Hotsheets are great but long winded and having the ability to simply schedule reports would be great.
duncan alexander 7 months ago in Queries/Reporting 0 Open for Voting

As-at TODAY option for reports

We want to be able to report on current items without manually amending a specific date field each time. We want the business to be able to pull latest data (especially current salaries excluding post dated ones) on the hotsheets without having to...
Annette Attwell almost 2 years ago in Queries/Reporting 0 Open for Voting