HR/Payroll Salary Grid Comparison Process
The HR/Payroll Salary Grid Comparison Process will compare employee HR demographic and assignment salary grids to their payroll master function line salary grid and report instances where HR and PAYROLL are out of sync. This process has a preliminary/final option which allows you to review a report of the discrepancies before updating and HR information. This process is only useful in instances where the employee demographic and assignment salary grids should be the same as the payroll master function line salary grid. This would often be the case with teaching staff.
As the update of HR demographic and assignment salary grid records occur, you can choose how you want to update the assignment information. You can end an existing assignment and create a new one, you can leave the assignment alone and end the existing salary record and create a new salary record or you can merely change the existing salary record without creating any history of the changes.
Assignment As Of Date Range
Enter valid start and end dates in (YY)YYMMDD format for selection of assignments and update purposes.
Assignment salary records that overlap any part of the specified date range including the start and end dates will be considered during this process. If the assignment salary grids are different than the employee's master function line salary grid, the employee will be reported. If you choose to run this process in final mode, reported employees will also have their demographic and assignment records updated with the payroll function line grid.
If you choose update method 1 or 2, the date before the specified start date will be used to end date assignment and salary records and the start date will be used as the start date for assignment and salary records. If you choose update method 3, then existing assignment and salary records will merely be updated with the new salary grid information without changing any dates.
Status Codes To Exclude
Enter up to 10 employee Status codes. Employees with matching status codes will be excluded from the report. If no status codes are entered, all employees will be considered for reporting.
Enter all Status Codes to exclude in the field at once. For example, TL for Terminated and Leave.
Employee Categories
Enter up to 10 Employee Categories. Employees with matching Category codes will be considered for processing. If no categories are entered, all employees will be considered for processing.
Assignment Types
Enter up to 10 Assignment Types. Assignments with matching Types will be considered for comparing their salary grids to the employee payroll master function line grid. If no assignment types are entered, all assignments will be considered for comparison.
Assigned Positions
Enter up to 10 Positions. Employees that have eligible assignments with matching Positions will be considered for processing. If no positions are entered, all assignments will be considered for processing.
Payroll To Compare To
Enter the Payroll ID you want to look at for the employee's master function line grid. If the employee does not exist in the specified payroll, s/he will be not be processed.
Function Line To Use
Enter the Payroll function line number to use for comparison.
Enter A to update assignments checking all of the employee’s function lines. This method will only update assignments matching the Pay ID and salary grid range on the position code. It will produce a report that includes why any assignments were skipped.
Enter * to update the same way as “A” above, but exclude the skipped assignment messages.
Update methodology:
Preliminary/Final
Enter 'P' to prepare a listing of instances where the employee's HR demographic or assigned salary grids are not the same as the employee's PAYROLL master function line salary grid.
Enter 'F' to prepare the same report as above and update the HR demographic and assigned salary grids to be the same as the employee's PAYROLL master function line salary grid.If this is the 'Final'
mode processing, following three prompts must be answered.
Update Method
Enter '1' to end the existing assignment and create a new assignment with the new salary grid information on it.
Enter '2' to end the existing salary record and create a new salary record with the new salary grid information on it.
Enter '3' to update the existing salary record with the new salary grid information.
Multiply Grid Rate By FTE
Enter 'Y' to multiply the grid rate by the assigned FTE to calculate the new rate that should be placed on the assignment as a result of the salary grid change.
Enter 'N' to place the unaltered salary grid rate onto the assignment.
Enter 'X' to multiply the grid rate by the assigned FTE (even if the assignment position is Hourly) to calculate the new rate that should be placed on the assignment as a result of the salary grid change.
Update Timestamp
Enter 'Y' to update the assignment timestamp as the salary grid information is updated.
Enter 'N' to not update the assignment timestamp.