Reports/Queries/Data

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

Sheldon Walker avatar Sarah Mills avatar E
44 articles in this collection
Written by Sheldon Walker, Sarah Mills, and Edward Dixon
The Query Builder

Queries - Filters and Options

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

Queries - How to Create a Query

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

Queries - Creating Charts

(Admin Only) Video and description detailing how to create charts within the query builder
E
Written by Edward Dixon
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
E
Written by Edward Dixon
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
E
Written by Edward Dixon
Updated over a week ago

Opening Query Builder Files in Excel

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