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 Schedule - Percents 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 - Percents tab.
Note: If the table is locked, the tab will be disabled; if needed, unlock the table.
Complete the Salary Schedule - Percents 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 - Percents 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.
If the steps increment by percentages, enter the percent increase for each step in the specified range in the Step Percent Increment field. For example, if the steps increase by 3%, enter 3 in this field. The percentage can be up to 12 digits long (including the decimal point) and will be rounded to 4 decimal places if capable. If the steps do not increment by percentages, enter a 0 in this field or leave it blank.
If the specified range includes the first step in the package, the Lane Percent Increment field is enabled. If the lanes increment by percentages, enter the percent increase for each lane in the specified range in the Lane Percent Increment field. For example, if the lanes increase by 4%, enter 4 in this field. The percentage can be up to 12 digits long (including the decimal point) and will be rounded to 4 decimal places if capable. If the lanes do not increment by percentages or each lane is calculated on a different base, enter a 0 in this field or leave it blank.
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 steps increment by fixed dollar amounts rather than or in addition to percents, enter the dollar amount increase for each step in the specified range in the Step Dollar Increment field. For example, if the steps increase by $500, enter 500 in this field, or if the steps increment by 25 cents, enter 0.25 in this 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 the steps do not increment by dollar amounts, enter a 0 in this field or leave it blank.
Note: The amount entered in this field will be the amount in the Additional Dollars field for each step in the specified range (excluding the first step in the package, if applicable); for example, if the Step Dollar Increment is $500, $500 will be in the Additional Dollars field for all the steps in the range (except the first step in the package, if applicable).
If the specified range includes the first step in the package, the Lane Dollar Increment field is enabled. If the lanes increment by fixed dollar amounts rather than or in addition to percents, enter the dollar amount increase for the lanes in the specified range in the Lane Dollar Increment field. For example, if the lanes increase by $250, enter 250 in this field, or if the lanes increment by 25 cents, enter 0.25 in this 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 the lanes do not increment by dollar amounts or each lane is calculated on a different base, enter a 0 in this field or leave it blank.
Note: The amount entered in this field will be the amount in the Additional Dollars field for the first step in each lane in the specified range (excluding the first lane in the package, if applicable); for example, if the Lane Dollar Increment is $250, $250 will be in the Additional Dollars field for the first step for all the lanes in the range (except the first lane in the package, if applicable). The amount entered in this field can be calculated progressively for each lane, if applicable, by selecting the Geometric Progression field (see below); then the amounts in the Additional Dollars field for the first step in the lanes in the range would be $250, $500, $750, $1,000, and so on.
If applicable, select the Zero field to delete (zero out) the amount calculated as the Step Dollar Increment and/or Lane Dollar Increment in the specified range. A checkmark will appear in the box if the field is selected.
If applicable, select the Geometric Progression field if the percentage entered in the Step Percent Increment and/or Lane Percent Increment fields is calculated on the previous step and lane rather than as an additional percentage of the base, or if the amount entered in the Lane Dollar Increment field is calculated on the previous lane rather than as an additional amount of the base. For example, select the Geometric Progression field if the percent increment is an additional 5% on the previous step and lane and the amounts should be 100%, 105%, 110.25%, 115.7625%, and so on, instead of 100%, 105%, 110%, 115%, etc.; or if the dollar increment for the lanes is an additional $250 on the previous lane and the amounts should be $250, $500, $750, $1,000, and so on, instead of $250 for each lane. A checkmark will appear in the box if the field is selected. The Geometric Progression field is only applicable if using the Step Percent Increment, Lane Percent Increment, and/or Lane Dollar Increment fields.
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 - Percents 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 - Percents 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.