Defining compensation tables

Use this procedure to define the payout calculation that is based on levels of attainment. You can reuse these tables for more than one compensation program.

Note: 

Tables may require formulas if multiple factors are involved. Specify a long and short description for the compensation table. For example, Success Sharing or Sales Performance.

  1. Select Compensation > Set Up > Incentive Compensation.
  2. On the Compensation Tables tab, click Create.
  3. Specify this information:
    Compensation Table

    Version Date

    Select a version date for the table. The version must be in effect on or earlier than the compensation program version date.

    Table Type

    Select the type of table to use. For more information, see External metrics and Bonus objectives.

    Rating Scale

    If you select Percent with Specify a long and short description for the compensation table.Rating for Bonus Objective in the Table Type field, select the rating scale to attach to the table. The rating scale is used for bonus objectives based on a goal.

    Note: 

    This scale must be the same scale that is used on the pay component.

    Number Of Decimals For Attainment, Payout, Quota

    Specify the number of decimals to display for numeric and percent attainment, payout, and quota values.

    The default is no decimals.

  4. Click Save.
  5. On the Attainments table, define the attainment values and corresponding payout values for this compensation table.
    For each attainment value, complete these steps to define the attainment and corresponding payout values for this compensation table.
    1. Click Create, and specify this information:
      Attainment

      Specify the attainment value. For example, .25.

      Depending on the table type, this value can be a numeric, alpha, or percent attainment, or a combination of these.

      Rating

      If the Table Type is Percent Steps With Ratings for Bonus Objectives, select the attainment rating for each percent attainment.

      Amount

      Specify the compensation that the resource receives if they achieve the corresponding attainment value.

      Note: 

      You can leave this field blank and type a percent in the Percent field or select a formula in the Percent Formula field.

      Percent

      Specify the percent that correlates with the attainment value.

      Note: 

      You can leave this field blank and type an amount in the Amount field or select a formula in the Percent Formula field.

      Percent Formula

      Specify the formula that correlates with the attainment value.

      Note: 

      You can leave this field blank and type an amount in the Amount field or a percent in the Percent field.

      Factor Formula

      If you specified a percent or a percent formula, select one of the formulas that you created on the Compensation Formula tab. The percent or result of the percent formula is multiplied by the result of the factor formula to calculate the payout amount. For more information, see Defining compensation formulas.

    2. Click Save.