Steps to Unlock a TableNote: In most cases, the Salary Schedule - Percents table should be built before the Salary Schedule - Amounts table.
From 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 Schedule - Amounts table in the Package ID field, or click the down-arrow button to select the correct one.
Click the Recalculate tab.
Click the Salary Schedule - Amounts tab.
Note: If the table is locked, the tab will be disabled; if needed, unlock the table.
Complete the Salary Schedule - Amounts 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 Schedule - Amounts 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 dollar amount to use as the base for the specified range in the Base field, if applicable. 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 Base field is only enabled if Base is specified as the Salary Calculation Type, or if First Step in Lane or Previous is specified as the Salary Calculation Type and the specified range includes the first step in the package.
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).
Enter the appropriate option for how to calculate the table (Base, First Step in Lane, or Previous) in the 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, and additional dollar amount if applicable, of the base (as specified in the Base field for the range), enter Base. To calculate the amounts on the table as a percentage, and additional dollar amount if applicable, of the amount in the first step for the lane, enter First Step in Lane. To calculate the amounts on the table as a percentage, and additional dollar amount if applicable, of the amount in the previous step in the lane, enter Previous.
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 Schedule - Amounts 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 Schedule - Amounts 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.