In this topic you will learn how to run Time & Labor Queries.
Select the Query you desire to run from the Query drop the list.
Each Query name begins with a BI or WK:
Queries that begin with WK displays information for one week at a time. Queries that begin with BI displays information for a two week pay period.
Date: Click the Calendar button to choose date or enter desired date (mm/dd/yy).
The system will automatically adjust the beginning and ending pay period dates.
NOTE: The system always defaults to the current pay period.
Click the desired Group ID.
Click the Get Data button to run the query and display results.
The Query results can be sorted by clicking on the column headings.
You may export the results to Excel by clicking the download button.
The Query results will display on the screen. If your query has more than 25 rows use the page navigation options to view the additional results.
Notice your results display in an Excel file.
The following queries are currently available using these steps:
BI TL EMPLOYEE NO PAYABLE TIME
Identifies all employees where the sum of the base (regular) hours is zero for the pay period specified.
BI TL EMPLOYEES < 80 HRS
Identifies all employees where the sum of the base (regular) hours is less than 80 for the pay period specified.
BI TL EMPLOYEES < FTE
Identifies all employees where the sum of the base (regular) hours is less than the employees FTE for the pay period specified. The FTE used on the Job record is as of the Pay Period End Date.
BI TL EMPLOYEES > 80 HRS
Identifies all employees where the sum of the base (regular) hours is greater than 80 for the pay period specified.
BI TL EMPLOYEES > FTE
Identifies all employees where the sum of the base (regular) hours is greater than the employees FTE for the pay period specified. The FTE used on the Job record is as of the Pay Period End Date.
BI TL EXCEPTIONS
Identifies all employees with exceptions for the pay period specified.
BI TL GENERAL TRC QUERY
Identifies all employees that have the selected TRC for the pay period specified.
BI TL LONG SHIFT PUNCH
Identifies all employees with a punch in and out of 23 hours or more for the pay period specified.
BI TL PUNCH WITH COMMENT
Identifies all employees with a comment for the pay period specified.
WK TL EMPLOYEES < 40 HRS
Identifies all employees where the sum of the base(regular) hours is less than 40 for the week specified.
This completes Time & Labor Queries.