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

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 - 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 - TOIL

(Admin Only) Build a report on TOIL
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

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 - Goals

Can I print Goals?
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 - 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

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 - Thanks

(Admin Only) Build a report on thanks badges
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 - Performance

(Admin Only) Build a report on performance reviews
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

Report on who hasn't opened their Performance Review.

Use V Lookup in Excel to see who has not yet started their Performance Review
Sarah Mills avatar
Written by Sarah Mills
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

Reports - Top Facts About Our Company

Check out what the overall picture of your company looks like right now
Sheldon Walker avatar
Written by Sheldon Walker
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 - Assignments

(Admin Only) Build a report on Project Assignments
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

Queries - Sickness

(Admin Only) Build a report on Sickness
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

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 - 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 - 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 - ATS Reports

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

Google Hotsheets

Sync up to 10 queries on GoogleSheets and share externally
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

Reports

Reports overview, viewing access etc.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Report Designer - Charts/Graphs

(Admin Only) Adding charts and graphs to your customised report.
Sarah Mills avatar
Written by Sarah Mills
Updated over a week ago

Report Designer - How to Create a Custom Report

(Admin Only) Create your own bright report with images and data chosen specifically by you.
Sarah Mills avatar
Written by Sarah Mills
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 - 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 - 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

Create a Consolidated Timesheet Report in Excel

Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago

Printing Reports from Safari or Google Chrome

Details how to print a report opened in your safari or chrome browser
Jason Sturman avatar
Written by Jason Sturman
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

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 - 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

Indirect Reports

Jason Sturman avatar
Written by Jason Sturman
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

Printing Individual Holiday and Absence Reports

How to print reports based on an employees holiday or absence
Jason Sturman avatar
Written by Jason Sturman
Updated over a week ago