Payroll > Utilities > Mass Update
Use the Mass Update utility to update employee data in preparation for the new school year. This utility allows you to quickly and easily mass change data resulting in minimal manual changes to individual employee records with less possibility of manual entry errors.
Important: To avoid entering data in an incorrect pay frequency, be mindful of the payroll frequency to which you are logged on as you may be changing back and forth between the current year and next year pay frequencies for several months.
Payroll > Utilities > Mass Update > Deductions
This utility is used to update deductions for a number of employees at a single time. Deduction data may be updated by a variety of criteria including pay type, pay grade, primary campus, and pay frequency. The Deductions tab allows users to add, change, and delete deduction codes as well as alter the number of remaining payments and the existing dollar amounts associated with the deductions. Mass deduction updates are very useful at the beginning of the year when many employees are being added to insurance programs. Once deductions are added using this tab, they are reflected in the individual deduction records.
❏ Under Parameters, select the appropriate parameters for the employees whose deduction data is to be changed.
TIP: Prior to processing a mass update, capture a screenshot of the parameters used for future reference.
❏ Under Method, select the type of deduction change to be implemented.
❏ Click Execute to execute the process. A preview report is displayed. Review the report.
❏ Click Process to accept the changes and continue.
A message is displayed indicating that the process was completed successfully.
❏ Click Cancel to return to the Mass Update page.
Reset | Click to reset all previously selected parameter options to the default. |
---|
The Leave tab is disabled as leave is only updated in the current year.
Payroll > Utilities > Mass Update > Employee
This utility is used to update employee data for a number of employees at a single time. Employee data may be updated by a variety of criteria including pay type, pay grade, primary campus, and pay frequency. The Employee tab allows users to reset, increment, or modify employee data. The data that may be altered includes the number of annual payments, number of days employed, contract begin date, and number of years of local experience. Once employee data is altered using this page, changes are reflected in the individual employee records.
❏ Under Parameters, select the appropriate parameters for the employees whose employee data is to be changed.
TIP: Prior to processing a mass update, capture a screenshot of the parameters used for future reference.
❏ Under Reset, select the employee data to reset:
❏ Under (Number of):
Annual Payments | Select to reset employee data for a number of annual payments, or leave blank to not reset the number of annual payments. To the right of Annual Payments, type the number of annual payments. If left blank, the value is zero. |
---|---|
Remaining Payments | Select to reset employee data for a number of remaining payments, or leave blank to not reset the number of remaining payments. To the right of Remaining Payments, type the number of remaining payments. If left blank, the value is zero. |
WC Annual Payments | Select to reset employee data for a number of annual workers' compensation payments, or leave blank to not reset the number of annual workers' compensation payments. To the right of WC Annual Payments, type the number of annual payments. If left blank, the value is zero. |
WC Remaining Payments | Select to reset employee data for a number of remaining workers' compensation payments, or leave blank to not reset the number of remaining workers' compensation payments. To the right of WC Remaining Payments, type the number of remaining payments. If left blank, the value is zero. |
❏ Under Increment, select the employee data to increment:
WARNING: Data should only be incremented one time.
Pay Step | Select to increment the pay step for employees, or leave blank to not increment the pay step. If you select this field, you can select Limit to limit the pay step increment. To the right of Limit, type the two-digit maximum pay step that is allowed by the LEA. Note: When Pay Step is selected, the system verifies that the Increase Pay Step field on the Job Codes table is selected. The Increase Pay Step field must be selected for the specific job code in order for the Pay Step field to increment the pay step for those employees. |
---|---|
State Step | Select to increment state step for employees, or leave blank to not increment the state step. If you select this field, you can select Limit 20 to increment everyone by one to a maximum. Leave the field blank to not set 20 as a state step maximum. |
Total Job Experience | Select to increment total job experience by one, or leave blank to not increment total job experience by one. If you select this field and leave the If Employment Date < field blank, all employees who met the original selection parameters are incremented by one. If you select this field, and the Original Emp Date or Latest Re-employ Date field on the Employee Info tab is equal to or less than the date entered in the If Employment Date < field, the employee data is updated. If the Original Emp Date or Latest Re-employ Date field on the Employee Info tab is greater than the date entered in the If Employment Date < field, the employee data is not updated. |
❏ Under Modify, select the employee data to modify:
❏ Click Execute to execute the process. A preview report is displayed. Review the report.
❏ Click Process to accept the changes and continue.
A message is displayed indicating that the process was completed successfully.
❏ Click Cancel to return to the Mass Update page.
Reset | Click to reset all previously selected parameter options to the default. |
---|
Note: Never use the Reset, Increment, and Modify options at the same time.
Example of Reset:
Example of Increment:
Example of Modify:
Note: The Prior Year Employment Date field uses the date in the Latest Re-Employ Date field on the Personnel > Maintenance > Employment Info. If this date is blank or contains zeros, it uses the date in the Original Emp. Date field. If no date exists in either field, the employee is not updated.
Caution: Do not update any experience fields at this time. Experience should not be updated until after the service records have been extracted and saved. Once the service records are complete, you can update records in either the current year or the next year. It is important not to forget this step as it must be completed prior to PEIMS reporting in October.
Use the Extra Duty tab to change employee extra duty assignments that display on the Pay Info tab.
Run the Personnel > Reports > Payroll Information Reports > HRS6550 - Employee Extra Duty Report by code before performing the extra duty mass updates. Once you update your changes, run the HRS6550 report in the NYR frequency to verify that the changes are correct.
Payroll > Utilities > Mass Update > Extra Duty
This utility is used to update extra duty assignments for a number of employees at a single time. Extra duty data may be updated by a variety of criteria including pay type, pay grade, primary campus, and pay frequency. The Extra Duty tab allows users to add, change, and delete extra duty codes as well as alter the existing dollar amounts associated with the extra duty assignments. Once extra duty assignments are changed or deleted using this page, modifications are reflected in the individual extra duty records.
❏ Under Parameters, select which employees and records are to be copied to the current year.
TIP: Prior to processing a mass update, capture a screenshot of the parameters used for future reference.
❏ Under Method, select the extra duty changes to be implemented.
Change Extra Duty Code to Another Code |
In the If Extra Duty Code field, click to select the extra duty code to be changed. The system displays the account type associated with the selected extra duty code (e.g., S - Supplemental pay or G - Standard gross pay). In the Change To field, click to select the new extra duty code. The system displays the account type associated with the selected extra duty code (e.g., S - Supplemental pay or G - Standard gross pay). In the Amount field, accept the amount that the system displays based on data in the Change To field, or type the dollar value of the extra duty assignment. In the Remain Amt field, if the account type for the extra duty code in the Change To field is S - Supplemental pay, this field is active, and the user can type an amount remaining for this extra duty code. If the extra duty pay code is an account type S - Supplemental pay and has multiple distributions on the Maintenance > Staff Job/Pay Data > Distributions tab, all changes are appropriately distributed across the multiple extra duty account codes according to the existing percentages. If the previous extra duty pay code was an account type G - Standard Gross pay, the extra duty amount must be manually deducted from the Contract Info, Total field on the Maintenance > Staff Job/Pay Data > Job Info tab. If the new extra duty pay code is an account type G - Standard Gross pay, the job amount must be manually added to the Contract Info, Total field on the Maintenance > Staff Job/Pay Data > Job Info tab. In the Remain Pymts field, if the account type for the extra duty code in the Change To field is S - Supplemental pay, the field is active, and the user can type the number of payments remaining for this code. |
---|---|
Change Existing Extra Duty Code Information |
Note: If the existing extra duty code is associated with an account type G - Standard Gross pay, the process updates the Amount field on the Maintenance > Staff Job/Pay Data > Pay Info tab. If the existing extra duty code is associated with an account type S - Supplemental pay, the process updates the Amount, Remain Amt, and Remain Pymts fields on the Maintenance > Staff Job/Pay Data > Pay Info tab and the related distribution records on the Maintenance > Staff Job/Pay Data > Distributions tab according to the distribution percentages. In the If Extra Duty Code field, click to select the extra duty code to be changed. The system displays the account type associated with the selected extra duty code (e.g., S - Supplemental pay or G - Standard gross pay). In the Amount field, type the dollar value of the extra duty assignment. In the Remain Amt field, if the account type for the extra duty code is S - Supplemental pay, this field is active, and the user can type an amount remaining for this extra duty code. Note: If the extra duty pay code is an account type G - Standard gross pay, the extra duty amount must be manually deducted from the Contract Info, Total field on the Maintenance > Staff Job/Pay Data > Job Info tab. If the new extra duty pay code is an account type G - Standard gross pay, the job amount must be manually added to the Contract Info, Total field on the Maintenance > Staff Job/Pay Data > Job Info tab. In the Remain Pymts field, if the account type for the extra duty code is S - Supplemental pay, the field is active, and the user can type the number of payments remaining for this code. |
Delete Extra Duty Code from Employees |
The list of extra duty codes associated with the employee are displayed showing the extra duty code, description, and account type (e.g., S - Supplemental pay or G - Standard Gross pay). Locate the extra duty code that needs to be deleted. Select the Delete field for each code that needs to be removed. Note: Extra duty pay codes that are account type G - Standard gross pay must have the extra duty amount manually deducted from the Total field on the Job Info tab. Extra duty pay codes that are account type S - Supplemental pay are automatically removed from the XTRA - Extra Duty job code on the Distributions tab. When all extra duty pay codes that are account type S - Supplemental are deleted, the XTRA job code is automatically removed from the Maintenance > Staff Job/Pay Data > Job Info tab and the Maintenance > Staff Job/Pay Data > Distributions tab. |
Add Extra Duty Code to Employees |
This feature allows the user to mass add type S - Supplemental pay codes to employees. If the employee already has the extra duty code as type S - Supplemental pay, the employee is not included. If the employee is processed, the employee extra duty record, XTRA - Extra Duty job code, and distribution records are inserted. The account code on the Extra Duty table must be valid. If the organization and/or fiscal year is masked, the completed account code, as created by the system for each employee, must be valid. If the organization is masked, the employee's pay campus is used. ❏ In the Add Extra Duty Code field, click to select the type S - Supplemental pay extra duty code. ❏ In the Amount field, type the dollar value of the extra duty assignment. ❏ In the Remain Amt field, type an amount remaining for this extra duty code. Note: If the organization and/or the fiscal year are masked (containing Xs), the completed account code as created by the system for each employee must be valid. If the organization is masked, the employee's pay campus is used. ❏ In the Remain Pymts field, the user can type the number of payments remaining for this extra duty code. |
❏ Click Populate Extra Duty Code Description to update the Amount field when a different extra duty code is selected.
❏ Click Execute to execute the process. A preview report is displayed. Review the report.
❏ Click Process to accept the changes and continue.
A message is displayed indicating that the process was completed successfully.
❏ Click Cancel to return to the Mass Update page.
Reset | Click to reset all previously selected parameter options to the default. |
---|
Payroll > Utilities > Mass Update > Job Code
This utility is used to update job code data for a number of employees at a single time. Job code data may be updated by a variety of criteria including pay type, pay grade, primary campus, and pay frequency. The Job Code tab allows users to modify job code data. Once job code data is altered using this page, changes are reflected in the individual records
Use the Job Code tab to change employee job assignments that display on the Job Info tab. This change modifies the Job Info and Distribution tabs.
Note: If accruals are associated with job codes, make changes with caution and verify.
❏ Under Parameters, select the employees whose job code data is to be changed.
TIP: Prior to processing a mass update, capture a screenshot of the parameters used for future reference.
❏ Under Change Job Code to Another Code:
❏ Click Execute to execute the process. A preview report is displayed. Review the report.
❏ Click Process to accept the changes and continue.
A message is displayed indicating that the process was completed successfully.
❏ Click Cancel to return to the Mass Update page.
Reset | Click to reset all previously selected parameter options to the default. |
---|
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.