Reports/Queries/Data

Find out how to extract your data from People in various forma

Jason Sturman avatar Sheldon Walker avatar Sarah Mills avatar
44 articles in this collection
Written by Jason Sturman, Sheldon Walker, and Sarah Mills
The Query Builder

Queries - How to Create a Query

(Admin Only)
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Filters and Options

(Admin Only) An in-depth view of filters and options for creating queries
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Creating Charts

(Admin Only) Video and description detailing how to create charts within the query builder
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Login Audit Report

(Admin Only) Build a query that tells you when each employee has logged in to the system
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Queries - Holiday Entitlement Accrued To Date

(Admin Only) Build a report on how many days/hours entitlement pro rata.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Holidays

(Admin Only) Build a report on employee holidays
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - TOIL

(Admin Only) Build a report on TOIL
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Timesheets

(Admin Only) Build a report on your employee's clock in and out information
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Annual Leave Entitlement

Build a report on employee's yearly, remaining entitlement and carryover
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Assignments

(Admin Only) Build a report on Project Assignments
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Maternity/Paternity

(Admin Only) Build a report on Maternity/Paternity leave
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Build an Expense Report

Creating an expense report, exporting and printing.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Logbook

(Admin Only) Report on logbook information and/or logbook approval data.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Length of Service

Report on employee's length of service and LOS rules
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Thanks

(Admin Only) Build a report on thanks badges
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Deleted Holiday

Report on deleted holidays
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

People® Queries and Excel Power Bi

(Admin Only) Load Query Data Into Excel via Power Bi
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Goals

Can I print Goals?
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Late Report

(Admin Only) Build a report on who has been late over a specific time period
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Deleted documents

Build a report on deleted documents
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Other Events

(Admin Only) Build a report on other events
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Reports - Staff Turnover

Discover the true level (and cost) of your company's staff turnover rate.
Sheldon Walker avatar
Written by Sheldon Walker
Updated over a week ago

Queries - Documents

(Admin Only) Build a report on documents added, signed etc.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Edit Access Rights

Build a report on who had edit access rights
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Training

(Admin Only) Build a report on training records
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Performance

(Admin Only) Build a report on performance reviews
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Sickness

(Admin Only) Build a report on Sickness
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Leavers

(Admin Only) Build a report on leavers
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - ATS Reports

(Admin Only) Build a query on Applicant/Vacancy information
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Historical Salary Report

(Admin Only) Build a query on all salary changes
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Historical Changes Report

(Admin Only) Build a query on changes made to an employee's record
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Filter by a Specific Time Frame

Using the 'Greater than' and 'Less than' options to report on information within a chosen point in time.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Queries - Point in Time Head Count Report

Report on the employees in the company at a specific time
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Opening Query Builder Files in Excel

(Admin Only) Guidance on query building files imported to Microsoft Excel
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago