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.
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.