A pay table can include one or more pay plans. For example, the Oracle Federal Standard Pay Table includes several pay plans.

You create your agency-specific basic and special rate tables in each business group that requires the table. There are two types of table structures, one where you designate matching values for the steps for each pay plan and grade combination, and the other where you specify a range of pay for each pay plan and grade combination.

Step Tables

You set up user tables in the Table Structure window.

   To build a pay table for pay plan, grade, and step values:

1. Set your effective date to the date from which you want the table's row labels to take effect.

2. In the Name field, enter the name of the pay table using the naming convention described in Naming Pay Tables.

   Note: Do not duplicate the predefined table names or change their values. The system uses these for pay calculations. Table names must start with the four-digit pay table ID number.

3. In the Match Type field, enter Match.

4. In the Key Units of Measure field, enter Number.

5. In the Row title field, enter Grades.

6. Save your work.

   Column setup

7. Choose the Columns button. In the Names field, enter each step that applies to the pay plan. Step values must be two digits. (Insert a zero before the number for single-digit steps, such as 00, 01, 02.)

   Row setup

8. Choose the Rows button. In the Exact field, enter the pay plan and grade combinations, such as AL-01, AL-02. Remember to:

   • Follow the exact format: pay plan hyphen grade

   • Do not insert spaces

   • Use the pay plan code you entered in the Pay Plan form

   • Use two digits for grades (Insert a zero before the number for single-digit grades, such as 00, 01, 02.)

   Note: Make sure that you enter the combination correctly; otherwise the system won't find the pay table when performing pay calculations.

9. Enter a start date early enough to handle any historical information you want to enter.

10. Save your work.

11. Repeat these steps for each step in your pay plan.

12. Enter the pay values for the pay plan/grade combinations. See Entering Pay Values

    Pay Banding Tables

    The application provides a pay-for-performance system for Senior Executive Service (SES) pay tables. You can set up tables for your agency's pay banding plans in the Table Structure window.

    To build a pay table for pay banding or pay range pay plans:

1. Set your effective date to the date from which you want the table's row labels to take effect.

2. In the Name field, enter the name of the pay table using the naming convention described in Naming Pay Tables.

   Note: Do not duplicate the predefined table names or change their values. The system uses these for pay calculations. Table names must start with the four digit pay table ID number.

3. In the Match Type field, enter Range.

4. The Key Units of Measure automatically becomes Number.

5. Enter the row label as the Row Title, such as Salary.

6. Save your work.

   Column setup

7. Choose the Columns button. Enter the pay plan and grade combinations, such as AL-01, AL-02, for the table columns in the Name field. Remember to:

   • Follow the exact format: pay plan hyphen grade

   • Do not insert spaces

   • Use the pay plan code you entered in the Pay Plan form

   • Use two-digits for grades (Insert a zero before the number for single digit grades, such as 00, 01, 02.)

   Note: Make sure that you enter the combination correctly; otherwise the application will not find the pay table when performing pay calculations.

   Row setup

8. Choose the Rows button. In the Sequence field, you can optionally enter a number for each row label to determine the order in which it appears on a list in the Table Values window. Logical sequencing of row labels helps users enter table values rapidly and accurately.

9. In the Lower Bound row, enter the minimum amount for the pay range for that pay plan and grade level.

10. In the Upper Bound row, enter the maximum amount for the pay range for that pay plan and grade level.

11. Enter a start date early enough to handle any historical information you want to enter.

12. Save your work.

13. Repeat these steps to enter pay ranges for each pay plan/grade level combination in your pay plan.

Managing Overlapping Range Values

When entering row values, you cannot have overlapping values in different columns. To manage overlapping ranges, review the pay ranges for your grade levels and note where the amounts overlap. Subdivide the pay range into sequential ranges that you can enter on separate rows for each column.

For example, if you have three columns representing your pay plan and grade combinations (15800-23100, 18100-26399, and 20500-30799), you would first determine the values that overlap the first and second columns (18100-23100), and the second and third columns (20500-26399).

You would then subdivide the overlapping amounts into smaller ranges. For example, for the first column 15800-23100, you would enter row amounts of: 15800-18099, 18100-20499, and 20500-23100. For the next column 18100-26399, you would enter row amounts of 18100-20499 20500-23100, (repeating the same range as you had in the previous column), 23101-23599, and 23600-26399. For the final column 20500-23100, you would enter row amounts of 20500-23100, 23101-23599, and 23600-26399 (repeating the ones from the previous column), and 26400-27099, 27100-30799.