Skip to main content

Build queries for Timesheet Report plugin

Queries for the Timesheet Report plugin.

J
Written by Joshua Shooter
Updated over a week ago

As a PeopleHR admin, you can run a timesheet report in Plugins. To run this tool, build the mandatory queries for this report with the details we describe in the table below.

📌Note: Ensure you name your queries the same way as we describe these.

Query name

Fields included

Filter

Include options

Payroll : Core Data

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Company

  • Department

  • Reports to

  • Salary Details (First column)

  • Salary Type

  • Employment Detail (First column)

  • Time & Attendance ID

  • Leavers (First column)

  • Final Day of Employment

Not applicable.

Select Include Leavers.

Payroll : Time Data

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Break Timesheets (First column)

  • Timesheet date

  • Time In 1

  • Time Out 1

  • Time In 2

  • Time Out 2

  • Time In 3

  • Time Out 3

    • Keep selecting Time in and Time Out until all available slots are included.

  • Total time worked per day

Not applicable.

Select Include Leavers.

Payroll : Holidays

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Holidays (First Column)

  • Holiday Start Date

  • Holiday End Date

  • Holiday Type

  • Holiday Duration Type

  • Part of the Day

  • Duration (Days)

  • Duration (Hours)

  • Holiday Status

For Holiday Status use Equals - Approved.

Select Include Leavers.

Payroll : Other Events

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Other Events (First column)

  • Other Events Duration Type

  • Other Events Reason

  • Other Events Start Date

  • Other Events End Date

  • Other Events Total Duration (Days)

  • Other Events Total Duration (Hrs)

  • Other Events Status

  • Deleted Other Event record (Yes/No)

For Other Events Status use Equals - Approved.
​
For Deleted Other Event Record (Y/N) use Equals - No.

Select Include Leavers.

Payroll : Work Pattern

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Company

  • Department

  • Salary (First column)

  • Salary type

  • Work Pattern (First column)

  • Work Pattern Effective Date

  • Working Hours

Not applicable.

Select Include Leavers.

Payroll : Sick

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Absences (First column)

  • Sick Start Date

  • Sick End Date

  • Sick Duration Type Sick (AM/PM)

  • Sick Duration (Days)

  • Sick Duration (Hrs)

  • Sick Reason

Not applicable.

Select Include Leavers.

Payroll : MatPat

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Maternity/Paternity (First column)

  • Mat/Pat Actual Start Date

  • Mat/Pat Actual End Date

Not applicable.

Select Include Leavers.

Query for logbooks

For example, if you want to run the Timesheet Report plugin for banked hours, lunch breaks or overtime, you need to create a logbook first and then create the query for it. We describe all the details you need for your logbook queries in the table below:

📌Note: Ensure you name your queries the same way as we describe these.

Logbook name

Logbook fields

Query name

Query selected fields

Include options

Banked Hours

  • Date

  • Rate Code (21,22,etc)

  • Hours (Must be HH:MM eg 03:03)

Payroll : Banked Hours

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Employment details (First column)

  • Time & Attendance ID

  • Banked hours (First column)

  • Date(Banked Hours)

  • Rate Code(Banked Hours)

  • Hours(Must be HH:MM eg 03:03) (Banked Hours)

Select Include Leavers.

Lunch Breaks

  • Date

  • Reason

Payroll : Lunch Breaks

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Lunch Breaks (First column)

  • Date(Lunch Breaks)

  • Reason(Lunch Breaks)

Select Include Leavers.

Lunch Breaks

  • Date Overtime Worked

  • Reason

  • Overtime Hours Worked

Payroll : Overtime

  • Employee details (First column)

  • Employee ID

  • First Name

  • Last Name

  • Overtime

  • Date Overtime Worked (Overtime)

  • Reason (Overtime)

  • Overtime Hours Worked (Overtime)

Select Include Leavers.

Now you're ready to run the Timesheet Report plugin.

Related Articles
Run the Timesheet Report plugin
Create a timesheet query
Create query on sickness
Run Payescape Payroll plugin
Run DPN Payroll plugin
Did this answer your question?