Considerations for Rate Tables

Use rate tables to establish percentage rates or fixed amounts for different performance levels.

Rate dimension input expressions determine the attainment information used to identify the performance level tier on the rate table. Incentive formulas determine how to use the resulting rate in the earnings calculation.

When creating rate tables In the Compensation Plans work area, specify the rate table type and create rate dimensions and tiers. Don't associate a rate table with a performance measure or incentive formula if the rate table rate attribute isn't used in the associated expressions.

Rate Table Types

You have two types of rate tables.

Rate Table Type	Description
Percent	The calculation process treats the rates that you enter as a percentage when it uses the rate in an expression. You enter whole numbers in the table (for example, 25). The numbers are stored as decimal numbers (for example, 0.25) and calculations use the decimal number.
Amount	The calculation process treats the rate that you enter as a number.

Rate Dimensions

Rate tables contain one or more dimensions. Rate dimensions define the nature of the tiers that you use in a rate table. Tiers contain the from and to values that compose the ranges the calculation process calculates incentive compensation from. The rate table input depends on the type of dimensions that you use:

Percent
Amount
Expression
String

Here are some things to know about rate dimensions:

A multidimensional rate table can use a mix of dimensions types.
If you delete a rate dimension, then the delete process also removes the rates for that dimension from the rate table.

For example, if you delete the second dimension in a two-dimensional rate table, only the rates for the first dimension remain.
If you don't provide rates, then the save process assumes that they're zero.

Tip: Specify as many input expressions as the number of rate table dimensions.

Rate Dimension Input Expressions

Rate dimension input expressions can include these items:

Attainment of one or more measures
Credit amount, quantity, margin, or a combination of these transaction attributes

In odd cases, the dimension input can be other transaction attributes that aren't quantifiable, like these examples:

Region name
Customer type

In these cases, the rate varies depending on the location of the sale or the customer.