The U.S. Department of Labor Employment Standards Administration Wage and Hour Division states, “Unless specifically exempted, employees covered by the Act must receive overtime pay for hours worked in excess of 40 in a workweek at a rate not less than time and one-half their regular rates of pay . . . Where an employee in a single workweek works at two or more different types of work for which different straight-time rates have been established, the regular rate for that week is the weighted average of such rates. That is, the earnings from all such rates are added together and this total is then divided by the total number of hours worked at all jobs.” This information originates from the following website: http://www.dol.gov/esa/regs/compliance/whd/whdfs23.htm.
Overtime premium recast refers to the ability to reassign the premium portion of overtime charges to a specific recast project, account, and/or pay type that is different from the charge accounts noted on the original timesheet.
Use this screen to recast the overtime premium portion of non-exempt employees' timesheet lines to the recast project, recast account, recast org, and/or recast pay type specified in the Overtime Premium Recast screen. You can recast all unposted timesheets for your login company or you can recast the timesheets for only one cycle. If you choose to recast for one cycle, this application reads the timesheet table for the "Regular," "Replacement," and "Labor Only" type timesheets that are assigned to the timesheet cycle chosen and that fall within the start and end dates for that cycle. The timesheet period for the selected timesheet cycle can be either "Open" or "Closed."
Timesheets with computed leave or payroll, or those posted to Costpoint Payroll, Labor, or Leave, are excluded from the recasting process. You can recast hourly and/or salaried employees. Two additional timesheet lines generate for each timesheet line with a project account group, labor group, and/or pay type that is eligible for recasting, based upon the parameters assigned for these items in the Overtime Premium Recast screen. The two lines reduce the original timesheet line and charge the overtime premium portion to the recast project, recast account, and/or recast pay type.
The generated timesheet lines contain the recasted labor costs for the overtime premium portion, zero charge hours, the recast account, the recast project, and/or the recast pay type.
Contingent upon the setup in the Overtime Premium Recast screen, the recast project and/or recast account could be the same as the original timesheet line, or could be one specified in the Overtime Premium Recast screen. The recast organization could be the same as the original timesheet line, the timesheet line project's owning organization, the employee's home organization, or one specified in the Overtime Premium Recast screen.
The recast pay type, if specified in the Overtime Premium Recast screen, is written as the pay type on the generated timesheet lines. If you did not specify the recast pay type in the Overtime Premium Recast screen, the pay type designated in the Pay Type table for the original timesheet line's pay type (the Pay Type to Use designated in the Pay Types screen for the original timesheet line's pay type record) has the next highest priority, and if no recast pay type is designated in either of these two screens, the OT Premium Recast Default Pay Type in the Overtime Settings screen is used on the generated timesheet lines. This application gets the above information from the Overtime Premium Recast screen based on the timesheet line's account group code, labor group code, and pay type.
The Recast Overtime Premium Report prints as part of the recast process; it contains the recast timesheet lines in employee ID order. The report contains the original timesheet line, along with the "back-out" line and the overtime premium recast line. The generated timesheet lines contain the recast labor costs for the overtime premium portion, zero charge hours, the recast project, the recast account, and/or the recast pay type. The compute method code on the timesheet line is set to "G" for the generated lines and updated to append a "*" on the original timesheet line. If the program finds any invalid account/organization combinations, it prints an error report.
After reviewing the report, you can recast the changes to the Timesheet Line table to change the eligible timesheets.
Run this screen after entering "R" (Regular), "D" (Replacement), or "L" (Labor Only) timesheets, but before computing leave or payroll, and before posting them for Costpoint Payroll, Labor, or Leave. This program will recast only "R," "D," or "L" timesheets; other timesheet types ("C," "B," etc.) are not processed. If you use the Apply Weighted Average Rates screen, you must run it before running this screen. If you do not run it first, the correct overtime premium amounts are not recast for hourly non-exempt employees.
Use the items in this group box to enter the timesheet cycle you want to recast.
Select this checkbox to process all unposted timesheets for your login company. If you do not select this checkbox, you must enter a timesheet cycle in the Cycle field.
Enter, or use Lookup to select, the timesheet cycle code for the timesheets you want to process. Other timesheet cycles will not be processed, and only one timesheet cycle can be processed at a time. Only eligible timesheets in this range are recast. Each regular timesheet and timesheet line is recasted by itself, even if several are included in the time range. If you do not select the All Timesheet Cycles checkbox, this is a required field. After you make your selection, the cycle's start date and end date display in the Start Date and End Date fields.
This editable field displays the start date of the selected Cycle. To change it, enter, or use Lookup to select, a timesheet cycle start date for the timesheets to be included in the recast process. This is a required field.
This editable field displays the end date of the selected Cycle. To change it, enter, or use Lookup to select, a timesheet cycle end date for the timesheets to be included in the recast process. This is a required field.
Select this checkbox to include Regular timesheets when recasting overtime premiums.
Select this checkbox to include Labor-Only timesheets when recasting overtime premiums.
Select this checkbox to include C-Correcting timesheets when recasting overtime premiums.
Select this checkbox to include D-Replacement timesheets when recasting overtime premiums.
Use this group box to select the employees, hourly and/or salaried, to include in the recasting process. You must select at least one of these checkboxes.
Select this checkbox to include "Hourly" employees, as designated by an "H" in the Hourly/Salary field in the Salary Info and History screen in Costpoint Employee, when recasting overtime premium timesheet lines.
Select this checkbox to include salaried employees, designated by either "S" or "F" in the Hourly/Salary field in the Salary Info and History screen in Costpoint Employee, when recasting overtime premium timesheet lines.
Select this checkbox to allow recasting of "M" (Manufacturing Order) type timesheet lines to a project/account/org combination that is not linked to the timesheet line's MO.
If you select this checkbox and an "M" type timesheet line is being recast to a project/account/org combination that is not linked to the MO, the overtime premium portion of the timesheet line recasts to an "A" type timesheet line (rather than an "M" type timesheet line), and the positive recast doesn't reflect in the Manufacturing Order Timesheet Line (TS_LN_MO) table.
If you do not select this checkbox and an "M" type timesheet line is being recast, the overtime premium portion of the timesheet line recasts to an "M" type timesheet line, and the positive recast reflects in the Manufacturing Order Timesheet Line (TS_LN_MO) table. You cannot recast to a project/organization/account combination that is not assigned to the MO.
Select this button on the toolbar to begin the recasting process. The report must have already been printed (while still in this screen) for this button to be enabled.
Select this button on the toolbar to print the report and then continue immediately (without user intervention) into the recasting process.
Changes to this screen update the following tables:
Timesheet Line - TS_LN
Timesheet Header - TS_HDR
Timesheet Line Utility Adjust – TS_LN_UTIL_ADJUST