Steps to Unlock a TableFrom the Negotiations screen, select the Maintenance menu and then Salary Schedules.
At the Salary Schedules screen, enter the ID of the package for which to build the new Salary Totals table in the Package ID field, or click the down-arrow button to select the correct one.
Click the Recalculate tab.
Click the Salary Totals tab.
Note: If the table is locked, the tab will be disabled; if needed, unlock the table.
Complete the Salary Totals Recalculate Options List to define the options for calculating the table. If the calculations on the table are consistent throughout, only enter one line using the dimensions for the entire package; otherwise, multiple ranges of cells (steps and lanes) can be entered with different options stipulated, if needed. To enter the calculate options for a range, complete the following:
In the blank line (indicated with an asterisk) at the bottom of the Salary Totals Recalculate Options List, enter the number of the first step to calculate in the Starting Step field, or click the down-arrow button to select the correct one.
Enter the number of the last step to calculate in the Ending Step field, or click the down-arrow button to select the correct one.
Enter the number of the first lane to calculate in the Starting Lane field, or click the down-arrow button to select the correct one.
Enter the number of the last lane to calculate in the Ending Lane field, or click the down-arrow button to select the correct one.
Enter the number of decimal places (0 to 4) to use when calculating the table in the Decimal Places field. Leave the field blank to default to 2.
Note: The number entered here is not the number of the decimal places that will automatically be displayed on the table, as the table defaults to show 2 decimal places unless a greater number is entered here and the amount in the cell contains a value with that number of decimals. For example, if 0 is entered in this field, the system will calculate the amounts using 0 decimals, but the table will display the amounts with 2 decimal places (the decimals will be all zeros since decimal places were not calculated); or if 4 is entered in this field, the system will calculate the amounts using 4 decimals, but the table will only display the amounts with 4 decimal places if the amount contains 4 decimals (otherwise, 2 (or 3, if applicable) decimal places will show on the table).
If the employees included in the specified range are to be paid a percent increase from their previous year’s wages (and not use the amounts on the Salary Schedule - Amounts table), enter the percentage for the increase in the Percent Increase field. The percentage can be up to 12 digits long (including the decimal point) and will be rounded to 4 decimal places by the system if capable. If a percent increase from the prior year's wages will not used, enter a 0 in this field or leave it blank.
Note: The Percent Increase field is disabled if the package is defined with Extracurricular specified as the Package Type.
If the employees included in the specified range are to be paid a fixed dollar increase from their previous year’s wages (and not use the amounts on the Salary Schedule - Amounts table), enter the dollar amount for the increase in the Dollar Increase field. The amount can be up to 14 digits long (including the decimal point) and will be rounded to 4 decimal places by the system if capable. If a fixed dollar increase from the prior year's wages will not used, enter a 0 in this field or leave it blank.
Note: The Dollar Increase field is disabled if the package is defined with Extracurricular specified as the Package Type.
If applicable, enter the fixed dollar amount to be paid for each additional day the employees are contracted to work beyond the regular number of days in the Dollars Per Additional Day field. The amount can be up to 14 digits long (including the decimal point) and will be rounded to 4 decimal places by the system if capable.
Note: The Dollars Per Additional Day field is disabled if the package is defined with Extracurricular specified as the Package Type.
If applicable, enter the extra dollar amount paid for each additional degree hour earned for the employees (as entered in the Additional Degree Hours field on the Wages screen in the Employee File for the applicable pay code) in the Dollars Per Additional Degree Hour field. The amount can be up to 14 digits long (including the decimal point) and will be rounded to 4 decimal places by the system if capable.
Note: The Dollars Per Additional Degree Hour field is disabled if the package is defined with Extracurricular specified as the Package Type.
If applicable, select the Use Daily Rate For Additional Days field to use the individual daily rates (the Absence Per Day rate calculated for an employee's contract) as the amount to be paid for each additional day the employees are contracted to work beyond the regular number of days. A checkmark will appear in the box if the field is selected.
Note: If the Use Daily Rate For Additional Days field is selected, the Dollars Per Additional Day field should be blank. The Use Daily Rate For Additional Days field is disabled if the package is defined with Extracurricular specified as the Package Type.
If the package is defined with Extracurricular specified as the Package Type, the Total Salary Calculation Type field is enabled. Enter the appropriate option for how to calculate the table (Percent of Actual, Percent of Main Package, or Salary Table) in the Total Salary Calculation Type field, or click the down-arrow button to select the correct one. To calculate the amounts on the table as a percentage of each employee’s total wages (total includes all additional dollars on the main contract) in the main package, enter Percent of Actual. To calculate the amounts on the table as a percentage of the dollar amount for each employee’s particular step and lane on the Salary Schedule - Amounts table of the main package, enter Percent of Main Package. To calculate the amounts on the table based on the Salary Schedule - Amounts table created for the package, enter Salary Table.
If applicable, repeat these steps until the calculate options for all the ranges have been entered.
Note: If needed, to remove the calculate options for a range, click the Delete button located to the left of the desired line in the Salary Totals Recalculate Options List; when prompted to delete the record, click Yes.
Click the Execute button to build the table as specified, or click the Save button to save the changes and wait to calculate the table at a later time.
After building the table, click the Salary Schedules tab and then the Salary Totals tab located on the bottom of the screen to view the table.
Once the table has been built successfully, lock the table to prevent it from being accidentally recalculated.