Timesheet Search

As an Administrator, you are able to search for timesheets in the system by accessing the Timesheet Search function.

Quick Overview

To access the Timesheet Query screen:

Expand Utilities.
Click Timesheet Search.
Filter your search results with the following criteria to the right in Advanced Search. If you do not wish to filter against certain criteria, leave it blank. You must make at least one selection.

Field	Description
Reporting Type	Filter results by Reporting Type
Employee ID	Retrieve only the timesheets of the selected employee
Employee First Name	Filter results by First Names
Employee Last Name	Filter results by Last Names
Start Date	Filter results so only timesheets with ending dates after the selected date are retrieved
End Date	Filter results so only timesheets with ending dates before the selected date are retrieved
Employee Type	Filter results so only timsheets of employees of the selected employee type are retrieved
Status	Retrieve only timesheets with a particular status
Previous Status	Retrieve only timesheets with a particular previous status
Company	Filter results by Company
Department	Retrieve timesheets of employees in the selected operating unit/department combination
Location	Retrieve timesheets of employees in the selected location
Process Status	Retrieve only timesheets that have/have not been extracted
My Group	Retrieve reports for your selected group
Posted To	Retrieve only timesheets extracted to the selected Accounting/Billing system
Not Posted To	Retrieve only timesheets not extracted to the selected Accounting/Billing system
Exception	Retrieve only timesheets with certain exceptions
Reporting Type	Retrieves only timesheets with selected reporting type
Level1 Code	Retrieves only timesheets with selected level 1
Level2 Code	Retrieves only timesheets with selected level 2
Approver	Retrieves only timesheets where the selected approver approved or approves for
Batch No	Retrieve only timesheets from the selected batch (Available in version 5.5 and up)

Click the Apply button.

From this window, you may print timesheets, delete timesheets, change the status, send an e-mail to the owner of the timesheet, route timesheets to another approver.

View/Print a Timesheet

You may view/print timesheets that you have access to in the database.

Select the timesheet to be printed (you may only view/print one report at a time).
Click on the Report button to view the different reports.
Click on the kind you want.
A pop up will appear with the selected report.
You can choose to print or save the pdf.

Deleting a Timesheet

You may delete a timesheet in the database, as long as it has not been approved or posted. If a timesheet is deleted, it will be replaced with a new timesheet.

Select the timesheet(s) you wish to delete.
Click on the Action button.
Click on the Delete button.
Confirm the selection by clicking the OK button.

Sending E-Mails

You may e-mail the owner of a timesheet to make an inquiry about it.

Select the timesheet owned by the user you wish to e-mail
Click on the E-Mail button.
Enter the e-mail message in the pop up box.
Click the Send button.

Validating Timesheets

Validating a timesheet allows you to view any errors or warnings attached to a timesheet.

Select the timesheet(s) to validate
Click on the Validate button.
Click on the link in the Validation Status column to view any messages.

Change Status

You may change the status of a report that you have access to. This can be useful for force approving timesheets, changing the status from opened so an approver can access the timesheet or re-releasing a timesheet. Under certain circumstances, the application will prevent you from changing the status of a timesheet. These include timesheets with validation warnings/errors, incomplete timesheets, or timesheets that are currently being accessed.

Select the timesheet(s) you wish to change the status for
Click on the Change Status button.
Select the new Status
Click the Apply button
View the Change Status Report to see if the status was changed for the timesheet(s). If the status was not changed, the report will inform you why.

Routing Timesheets

Timesheets can be routed to another approver to be viewed and approved. Only timesheets that are Released, Rejected or approved may be routed.

Select the timesheet(s) to route.
Click the Route button
- Route to: Enter the ID of the approver to route to
- Rights: Select the approval rights
  - Modify and Approve: allows the approver to make modifications to the timesheet as well as approve.
  - Approve Only: allows the approver to only approve the timesheet and not make any modifications.
  - Review Only: Only allow the approver to view the timesheet.
- Replace Original Approvers: If selected, the entire approval structure will be replaced and the approver being routed to will have the final approval
- Send e-mail: Choose whether or not to e-mail the new approver.
- Subject: Enter the subject of the e-mail
- Message: Enter the body of the e-mail
Click the Route button.

Refresh Approval Structure

Refresh Approval Structure is used when timesheet(s) are already in the approval process and a change is made to the approval structure. By refreshing the approval structure of timesheet(s) the approver(s) will be added/removed without resetting the current approval queue.

Example:

Approval structure: Released timesheets go to Manager A > then Manger B

Step 1: A user submits a timsheet and Manager A is now ready for approval

Step 2: Manager A approvers timesheet

Step 3: Manager B is ready for approval.

Step 4: Administration wants to add Manager C to the approval structure. To add Manage C without resetting the Manager A's approval the "Refresh Approval Structure" would be used.

Select the timesheet(s) that need a refresh of approval structure.
Select Action
Select Refresh Approval Structure

Summary Report

To view a summary report of all returned timesheets, click on the Print button.