DTE Timesheet Retro Process

The DTE Timesheet Retro Process allows you to select timesheets to be either reversed out and replaced or have retro calculated, based on a new pay rate. Pay rates are taken from the appropriate salary grid point using the DTE rules. Timesheets that have a zero rate difference and the same salary grid will be omitted.

When the retro type processing is selected, occupation and shift code *** premiums difference will be calculated and when applicable the premium is paid out under the pay code from the occupation or shift code database definition.

When Reversal/Replacement retro is not selected, an additional details report #####D.LST is created to detail the timesheets used for the money only retro.

All newly generated batches will be automatically balanced and closed.

This process includes the option to maintain multiple sets of stored prompts.

Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.

This option will run in batch only.

Enter Starting Pay Period

Enter the starting pay period for a range of pay periods to be processed. Only timesheets within this range will be processed. This range of pay periods will also be used when costing based on GL history is selected.

Enter Ending Pay Period

Enter the last period to be used for the period range.

Enter Starting Date Range

Enter the starting date for a range of dates for timesheet entry selection.

Enter Ending Date Range

Enter the ending date for a range of dates for timesheet entry selection.

Select by Employee Number, Salary Grid, Pay Cycle

If 'E' selected above, the following prompt will appear:

Report All or Selected Employees

If 'S' selected above, the following prompt will appear:

Enter Salary Grids for Employee Selection

Enter up to 55 salary grids for employee selection. Employees with one of these salary grids on their master function line will be included in the process.

Leave the list of salary grids empty to include all employees.

If 'C' selected above, the following prompt will appear:

Enter Pay Cycles Codes for Employee Selection

Enter the pay cycles for employee selection. Employees with one of these pay cycles on their master function line will be included in the process.

Enter Salary Grid to Change to

Enter to have each timesheets use the salary grid from the timesheet for pay rate calculations.
Enter a salary grid to be used for pay rate calculations.

Enter Portion of Hours to Process

Enter to have the full hours be used in the retro and reversal timesheets.
Enter a percentage of hours to be used from selected timesheets.

Enter Location Codes for Selection

Enter to include all location codes.
Enter a list of location codes for timesheet selection.

Enter Salary Grid for Timesheet to Select

Enter when timesheet selection by salary grid is not applicable.
Enter a list of salary grids for timesheet selection. Only timesheets with the selected salary grids will be included.

Include/Exclude Pay Code List

Enter 'I' to include pay codes for timesheet selection.
Enter 'E' to exclude pay code for timesheet selection.

Enter Pay Code

Enter pay codes (one by one) to include/exclude.

Create Reversal/Replacement Timesheet Adjustments

Enter 'Y' to process the timesheet reversal/replacement process. This option will reverse out the select timesheets and create new timesheets using the new rate and or salary grid. All GL costing for the new timesheets is taken from the original timesheet.
Enter 'N' to generate the retro type process. The retro process will accumulate the dollar amount of difference and pay that amount out as a money only transaction. An additional detail report #####D.LST will be created.

When 'Y' Create Reversal was Selected, the Following Prompt will Display:

EI Allocation to Current Pay Period

Enter 'N' to have the EI allocated to the pay period defined by the entry date.
Enter 'Y' to have all EI allocated to the current pay period, as defined by the Batch Period. When this option is selected, the batches created by this process will be marked with the EI To Current Period flag. The Timesheet Entry and Timesheet Edit will both enforce the EI allocation rule when these batches are accessed.

If 'N' Create reversal was selected above, the following prompt will appear:

Costing by Base FUN/Multiple Function/History

For function line costing (B and M):

When the employees function line contains a GL code that GL will be used. When no GL code exists on a function line the GL is taken from the cost center for that function line.

Enter 'B' to distribute the retro pay based on the first or master function line.
Enter 'M' to distribute the retro pay over multiple function lines.
Enter 'H' when costing of the retro pay should be costed based on the GL accounts and cost centers taken from the employee's GL history for the range of pay periods defined above. A prompt follows that allows you to specify secondary pay codes to exclude from the GL account history selection. The GL history costing is first selected based on the pay code include/exclude list defined for the retro run. The retro amount will be costed to the accumulated history GL accounts on a ratio to the amount of the accumulated monies paid out under each GL and cost center set. For GL history where no cost center is available, the employee's cost center from the master function line will be used. Compressed GL history that will be omitted.

If 'H' selected, the following prompts will appear:

Pay Codes to Exclude for History Costing

Enter any additional pay codes to be excluded from the accumulation of GL history entries for costing based on GL history earnings.

The message Already Accounts for will be followed by the pay code include/exclude list entered above. The History Costing takes this previous pay code list into account.

If 'M' selected, the following prompt will appear:

Pay Codes to Exclude on Function Line Costing

Enter any pay codes to be excluded on function lines from the costing over multiple function lines.

Report Terminated Employees

Enter 'N' to omit Terminated and On Leave employees.
Enter 'Y' to include Terminated and On Leave employees. When field 'Allow Timesheet/Retro for Inactives' under the Users Specific Parameters Profile, is active you can generate Retro and pay Terminated and On Leave without reactivating them. When the Allow Retro field is inactive, then this prompt will generate a separate report listing the retro amount for the Terminated and On Leave employee without creating a retro entry.

Exclude Employees by Emp #/Salary Grid/Cycle/None

Enter 'N' when no specific employee's should be excluded.
Enter 'E' to select specific employees based on employee number to be omitted from this process.
Enter 'S' to define specific salary grids for employee exclusion.
Enter 'C' to define specific pay cycle code for employee exclusion.

If 'E' selected above, the following prompt will appear:

Enter the Number of Employee to be Excluded

Enter employee numbers one at a time for those employee s to be omitted from the retro process.

If 'S' selected above, the following prompt will appear:

Enter Salary Grids for Employee Exclusion

Enter up to 55 salary grids for employee exclusions. Employees with one of these salary grids on their master function line will be omitted from the retro process.

If 'C' selected above, the following prompt will appear:

Enter Pay Cycle Codes for Employee Exclusion

Enter up to 38 pay cycle codes for employee exclusions. Employees with one of these pay cycle codes on their master function line will be omitted.

Sort by Employee Name, Employee Number, Salary Grid

Enter 'N' to sort the report by employee name.
Enter 'E' to sort the report by employee number.
Enter 'G' to sort the report by master function line salary grid.

Enter Batch Period

Enter the pay period for the batch. This should be the period the retro is to be paid in. Employees not in cycle for this pay period will be bypassed.

When reversal/replacement processing was selected, the next two prompts will be omitted:

Enter Batch Pay Code

Enter the default Pay Code to pay the retro under.

Retro should be paid out under a money only Pay Code.

Batch Pay Code Exceptions allows retro from selective Pay Codes to be paid out under either the same Pay Code or another Pay Code.

Enter the Pay Code from history followed by the Pay Code to be used for payment of the retro for those earnings. Use the wild card * to indicate all digits in a series. For example, 7* means all 70 series Pay Codes.

Report Only or Process

Enter 'R' to generate just a report.
Enter 'P' to generate the reports and generate the retro timesheet entries.

Enter Batch Type

Enter a valid batch type code. The batch type code entered will be used to generate batches of retro transactions. This is validated by the system.

The reports lists the following:

This ######.LST report for Retro Processing lists the following:

The employee number, name.
Date of timesheet to be generated.
Pay Code for timesheet to be generated.
Total retro amount per Pay Code.
Employee costing distribution
GL account and cost center when costing by GL history was selected.
Total entries and moneys to be generated.

The #####D.LST report for Non-reversal Retro only, lists the following:

Timesheet details.
Original Rate
New Rate
Rate difference, adjustment per hour
Retro hours and retro amount applicable to timesheet
Retro Pay Code used.
Total retro and entries employee
Grand totals

The final run will create the payroll batches of transactions. The batch numbers generated will appear in the program log.

Note: On-leave employees are only reported if the terminated employee report is selected. No costing is done on Terminated/On-Leave employees. The amounts of retro pay for these types are reported only.

The report containing the Terminated and On-Leave employees is produced and printed separately. The report number is #####T.LST where ##### is the first 5 characters of the retro pay job number.