Skip to main content

Build queries for Timesheet Report plugin

Queries for the Timesheet Report plugin.

J
Written by Joshua Shooter

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
Timesheet report showing incorrect information
Run Timesheet Exception Report tool
Run Payescape Payroll plugin
Run DPN Payroll plugin
Did this answer your question?