Timesheet Pivot Table
| Access this page using Action>Timesheet Pivot Table. |
Use this page to view active time and expense entries filtered by work date time, work time, leave code, leave hours, or earnings code. The time and expense entries displayed in the system have not yet been processed by the HR Management module. Once processed in the HR Management module, the time and expense entries are no longer available for display in the Timesheet Pivot Table page.
Employees can see their sum of hours or percent of hours by cost center. It shows the time distribution for each pay period. This information can be exported to PDF, or a spreadsheet.
Fields
Sum of Hours/Percent of Hours: Select Sum of Hours to display the information in the table by hours, or select Percent of hours to display the information in the table by percentages.
Include History from, to: Enter the from and to dates to include historical information.
Work Date Time: Select specific work dates and time entries or accept the default of Show All. Items selected display in the table below with each day as a separate column.
Work Time: Select specific work times or accept the default of Show All. Items selected display in the table below, with each day as a separate column. If a work time is removed, it will be removed from the table below as well.
Leave Code: Select specific leave codes or accept the default of Show All. Items selected display in the table below, with each day as a separate column. If a leave code is removed, it will be removed from the table below as well.
Leave Hours: Select specific leave hours or accept the default of Show All. Items selected display in the table below, with each day as a separate column. If any leave hours is removed, it will be removed from the table below as well.
Earnings Code: Select specific earning codes or accept the default of Show All. Items selected display in the table below, with each day as a separate column. If an earning code is removed, it will be removed from the table below as well.
Work Hours: Click this button to sort the columns in ascending or descending order by work hours.
Work Date: Click this button to sort the columns in ascending or descending order by work date.
Cost Center: Click this button to sort the cost center column in ascending or descending order.
Grand Total: The system displays the sum of all columns per cost center.
Buttons
Export PDF: Use this button to save the file as a PDF. This process creates a file that can be e-mailed.
Export XLS: Use this button to export your active data to a spreadsheet.
Export XLSX: Use this button to export your active data to a spreadsheet.