TL - Elapsed Hourly Integrated Timesheet
This document will explain how an employee and/or manager enters time and absence into the elapsed hourly integrated timesheet. This timesheet is generally assigned to employees that record a quantity of hours for each shift and may or may not have a prepopulated schedule assignment.
The timesheet for University Staff-Exempt employees has been enhanced to offer new and improved features effective 2/3/2018.
- "Exception" time reporters are generally assigned a default schedule which will automatically be processed by time administration to payable time without needing to click the Submit button on the timesheet.
- "Positive" time reporters generally do not have a schedule assignment. A default schedule may be assigned at the Employee level but this type of timesheet will require physical submission in order for scheduled hours to be processed for approval.
- Both Exception and Positive leave eligible elapsed time reporters will use their elapsed hourly integrated timesheet to record worked hours and absence takes.
2. Select the correct time period. If the employee does not have a default schedule assignment, scheduled hours will reflect "0.00". If the employee does have a default schedule assignment, the total scheduled hours for the period being viewed will display.
3. Enter the quantity of hours that the employee worked in the Quantity field on the appropriate day(s).
4. Click Submit.
5. The timesheet has now been submitted and the Submitted icons appear in the Status column.
After Time Administration runs, the hours will be available for approval.
1. Click the delete (-) button on the row you wish to delete. You may also check the "Select for Delete" box(es)
for the row(s) you need to remove and then click "Delete
Selected Rows". This function can be used to delete a single row or multiple rows at once.
- If using the (-) button to delete:
- If using "Select for Delete"
2. If this completes your timesheet adjustments, click Submit
1. If multiple rows are needed for a single day (i.e. Multiple TRCs are necessary, partial day absences) add a row to that day in the timesheet by clicking the (+) button on the appropriate row.
2. A blank row is inserted for the day.
3. You may now enter additional Time/Absence codes as necessary.
- Multiple TRCs: In the example below, the employee worked their scheduled hours and was then on standby for 4 additional hours.
Employees with Default Schedules:
1. If the employee has a default schedule assignment, upon accessing the timesheet, the Scheduled Hours total be reflective of the schedule assignment. The quantity of hours will also be pre-populated in the quantity and the "Sched Hrs" column will display the total scheduled hours each day.
2. Exception time reporters with a default schedule assignment only need their timesheet updated/submitted if they deviate from their scheduled hours.
Positive time reporters must physically click submit each pay period for their scheduled hours to be processed by time admin.
Overriding Default Scheduled HoursIf the employee did not work a scheduled day, it is necessary to clear the hours from that day in the timesheet. To clear the hours from a scheduled day:
1. Click the delete (-) button on the row for which you need to remove the scheduled hours. You may also check the "Select for Delete" box(es) for the row(s) you need to remove scheduled hours and then click "Delete Selected Rows".
2. To override the scheduled hours, enter a "0" in the quantity column. Click Submit.
Adding a Full Day Absence Take:
Whether the employee has a schedule or not, an absence take can be entered from the timesheet by selecting the appropriate take from the Time/Absence Code dropdown on the row associated with the date of the absence.
1. Select the appropriate Time/Absence Code from the dropdown on the row associated with the date of the absence.
2. If the employee has a default schedule, the quantity will automatically populate with the number of scheduled hours. If the employee does not have a default schedule, enter the number of hours to be associated with the absence take.
3. Click Submit.
Adding a Partial Day Absence Take:
1. Add a row to the day associated with the partial-day absence by clicking the (+) button.
2. On the new row select the type of absence take from the Time/Absence Code drop down.
3. Enter the appropriate number of hours associated with the absence take in the quantity field.
4. If the employee had already submitted time or has a default schedule assignment, update the quantity of hours worked.
5. Click Submit.
Deleting an Absence from the Timesheet:
You may remove a previously requested/approved absence take by following the procedure to delete the row associated with the absence from the timesheet. The changes will flow into the UWS Absence and Absence Event pages accordingly.
1. To delete an absence delete the row with the absence from the timesheet using either the (-) button or Select for Delete/Delete Select Rows function.
2. Enter a quantity of hours if necessary or 0.00 if the employee did not report to work that day.
3. Click Submit.
Earning Comp Time for FLSA Exempt Employees:
Note: Not all FLSA Exempt staff are eligible for overtime or compensatory time because of the total job concept. Overtime and compensatory time earnings are granted at the discretion of the employing department.
If a FLSA exempt employee's work week is more than 40 hours and the employee's employing unit has deemed them eligible for overtime, the employee may prefer to accrue comp time instead of overtime payment. Compensatory time earnings are granted at the discretion of the employer. Splitting of overtime and compensatory time during the same week will no longer be permitted. Comp time earnings will be based on the earnings per week, not by the total time period; thus it will be necessary to designate Comp Time for each eligible week.
1. Add a row to the day on which comp time earnings are applicable by clicking the '+' button.
2. Enter the quantity of hours to be designated as comp time earnings and select the appropriate comp time earnings code from the Time/Absence Code drop-down. (ECT10 = Straight Rate Comp Time Earnings, ECT15 = Time and one half Rate Comp Time Earnings).
3. Click Submit.
Using Comp Time:
An employee's comp time balance can be viewed on the Compensatory Time tab in the summary section of the timesheet. The comp time balance is reflective of what is available as of the start of the Calendar Period when viewing the entire period, the start of the week when viewing by week, or as of a specific day when viewing by day.
1. To use comp time hours, select the CTUSE time reporting code from the Time/Absence code dropdown and enter the quantity of hours to be used.
2. Click Submit.
Comp Time Error:
If the employee has no comp time balance or the amount of the comp time usage exceeds the comp time balance, an error message will occur.
In the error message shown, the employee is trying to use one more hour of comp time than is available in their balance. (Note: This error is a bit misleading because the employee is trying to use too many hours, however the comp time balance may not go negative).
The number of hours associated with the CTUSE time reporting code must be reduced to an appropriate amount before the timesheet can be submitted.
Some departments may use additional time reporting features such as Taskgroup and Task Profile ID. These elements are accessed by clicking the "Additional Elements" tab. For more information on Taskgroup/Task Profile IDs refer to TL - Taskgroup/Task Profile Reference Setup.
Once expanded, enter the desired information into the appropriate fields. You may choose for the additional elements section to remain expanded each time you access the timesheet. To default the expanded timesheet view, put a checkmark in the "Show all columns by default" box prior to submitting time on the timesheet.
Copy from Previous:
Depending on the timesheet view you are using, the Copy from Previous feature allows you to copy reported time and absences from the previous period, week, or day. If an employee works the same or similar hours from week to week, this feature saves the amount of manual entry necessary to complete the timesheet. Once time is copied, you may then make any additional necessary changes before submitting.
In the below example, time is reported for the first week of the period, with the "View By" set to Week view. On Friday the employee used 8 hours of vacation.
1. To copy the same hours into the next week, click the "Next Week" link.
2. On the blank week, click "Copy from Previous Week"
3. All reported time and absences from the prior week will populate.
4. If any changes are necessary, update/delete the punch times or absence rows accordingly. When finished, click Submit.
The Copy from Previous button will update depending on if you are viewing the timesheet by Day, Week, or Calendar period and will function accordingly.
View By Day:
View by Calendar Period:
Reviewing Absence Balances:
View the employee's Absence Balances by clicking the "Absence Balances" tab in the summary section underneath the punch timesheet.
NOTE: More information about each column can be found by clicking on the blue i (information icon)
- Posted Leave Balances show balance totals as of the last completed payroll (Available Balance).
- Projected Balances shows all absences that have been entered, approved and run through overnight processing, for the current and/or future pay periods.
- Beginning Balance – balance as of the end of the last pay period processed.
- Current Usage – any requests entered for current pay period that have been approved and overnight processing has run.
- Current Balance – beginning balance minus current usage.
- Future Usage - any requests entered for future pay period(s) that have been approved and overnight processing has run.
- Future Balance - beginning balance minus current usage and future usage.
Banked Leave Conversion:
1. To enter a banked leave conversion take, selected "Convert Vac Banked Lv (CLS)" Time / Absence Code on a non-scheduled day during the month of December.
2. Fill in the number of hours you would like to convert and payout based upon the employee's eligibility statement.
3. Click Submit.
Overtime for FLSA Exempt Employees
FLSA exempt employees who use the elapsed timesheet are technically exempt from overtime and Time Administration does not automatically calculate overtime for them as it does for nonexempt employees. In order to pay overtime to FLSA exempt employees in the elapsed timesheet the appropriate overtime time reporting codes must be selected and number of hours entered.
1. Click '+' to add a row on the corresponding day for which overtime is to be earned.
2. On the new row, enter the quantity of hours to be allocated as overtime and select the appropriate overtime time reporting code from the Time/Absence Code drop-down. (EOT10 = Straight Rate Overtime, EOT15 = Time and one half Rate Overtime).
3. Click Submit.
Night and Weekend Differentials for FLSA Exempt Employees:
1. Click '+' to add a row on the applicable day.
2. On the new row(s) for the respective dates, enter the number of hours which apply to the night or weekend work as shown below.
3. Click Submit.
Employees with Multiple Jobs:
If your employee search was for one employee who has multiple jobs, click the Next Empl/Job hyperlink at the top of the timesheet to go to the employee's previous or next Empl Rcd. If you employee search was for a group of employees, click the Next Empl/Job hyperlink to move to the next employee in your group selection. (Note: The group of employees retruned in the selection results will be sorted alphabetically by last name).
The timesheet retains the time period from the previous screen.
Enter time for the employee's other job(s), remember to click Submit before exiting the timesheet.
Employees with Alternate Work Week Schedules:
If exempt employees report more than 40 hours in a work week, any hours in excess of 40 will automatically be placed in a "NOPAY" status by the time administration process and will not process for payment.
In the event an alternate work schedule is approved by the employing department the NOPAY status for hours in excess of 40 can be avoided by using the ALTWK Time Reporting Code. This may be necessary in cases where an employee works more hours one week and less the next, for example a 36/44 schedule. To ensure all hours process for payment for the second week, associate the ALTWK TRC to any hours over 40 that should not be placed in NOPAY status.
In the example below, the employee crosses 40 hours after the 4th hour of work on Friday of the 2nd week in the pay period. A new row is added for the 4 hours over 40 to be associated to the ALTWK TRC. **Note: In some cases it may be necessary to break the shift at a different point.
1. Add a row and enter the quantity of hours associated with the ALTWK TRC.
2. Click Submit.