Use the Employee Timesheet Approval Report page to generate a detail or summary report of employee timesheet approval statuses for a selected pay period, department, supervisor, or pay run, filtering by approval status (Not Submitted, Pending Full Approval, Approved, Posted, or All Records), so you can review which employees have submitted, approved, or outstanding timesheets and the associated hours by pay code.
Menu path
From the Human Resources menu, select Reports. From the Employee Timesheets menu, select Timecard Status Report.
Security
The Timecard Status report requires the following security resource (package HRM, subpackage ETS):
Function 5109: MAY RUN ETS TIMECARD STATUS REPORT
Users with the SUPER USER FOR ETS (5100) or PACKAGE SUPERVISOR FOR ETS (5101) resources also have access by virtue of their elevated privilege levels.
Create file
-
On the Employee Timesheet Approval Report page, select Detail Report or Summary Report, and then select Accept.
-
Refer to the Field descriptions and enter or select the report criteria.
-
Select Accept.
-
Select the Report Sort Order and select Accept.
-
Select a Destination:
-
Select File to create the report in .rpt format. You can change the default file name. The default file names are:
-
Detail Report: ets_rptapp1d.rpt
-
Summary Report: ets_rptapp1s.rpt
-
-
Select Screen to download the report in .pdf format. The default file names are:
-
Detail Report: ets_rptapp1d_<#####>.pdf
-
Summary Report: ets_rptapp1s_<#####>.pdf
-
-
Select Excel to download the report in .xlsx format. Select the required Excel Options. The default file names are:
-
Detail Report: ets_rptapp1drpt<####_#####>.xlsx
-
Summary Report: ets_rptapp1srpt<####_#####>.xlsx
-
Select OK.
-
Download the .rpt file from the View Files page.
-
Save the .pdf or .xlsx file.
For more information about the Print option, refer to Print Reports.
-
-
-
-
Field descriptions
The following table describes the fields in the Selection Criteria section of the Employee Timesheet Approval Report page.
|
Field |
Description |
|---|---|
|
Employee Number |
Limits the report to a single employee. Select the Lookup icon to search for and select an employee number. Leave this field blank to include all employees. |
|
E/T Department |
Limits the report to a specific Employee Timesheets department. When a department is selected, any linked departments are also included. Leave this field blank to include all departments. |
|
Pay Period |
Limits the report to a specific pay period, displayed as a start date–end date range. Leave this field blank to include all pay periods. |
|
Approval Status |
Filters records by their current timesheet approval status:
|
|
Supervisor Employee # |
Limits the report to timesheets associated with a specific supervisor. Select the Lookup icon to search for and select a supervisor employee number. Leave this field blank to include all supervisors. |
|
Pay Run |
Limits the report to timesheets posted to a specific pay run. Leave this field blank to include all pay runs. |
|
Primary Group |
Limits the report to employees assigned to a specific primary pay group. Leave this field blank to include all groups. |