Defining Payout Formulas

Pay Formula SQL

When you save the record, the system displays the payout formula SQL statement that you define using the following fields. The system checks the syntax of the SQL statement and lists any errors.

Rounding Rule

Select a rule to apply to award calculations that use this payout formula. Select from:

• Down: Round the value down to the number of significant digits indicated in the Decimal Places field.

• Standard: Use the standard IEEE (Institute of Electrical and Electronics Engineers) rounding rules.

• Up: Round the value up to the number of significant digits indicated in the Decimal Places field.

If the plan is a stock-type plan, the system uses the rounding rules established on the Stock Option Plan table (ST_OPTION_PLAN) when rounding award calculations.

Decimal Places

Enter the number of decimal places to which you want the system to round the payout formula.

Sequence

(Required) This number determines the order in which the SQL generator builds the formula. Entering sequence numbers in increments of 5 or 10 gives you room to add a component to the formula without renumbering all the existing components. When you save the page, the system sorts your components according to their sequence numbers.

Insert a new row and enter a sequence number for each component of the SQL statement while you build it.

Operand

Enter an operand for the component. The operand that you select determines the other fields that are hidden or displayed on the page. This table lists the valid operand values and the additional fields displayed for each.

(none)

Use this value to eliminate the field of an unwanted value.

None

(

Open Bracket

None

)

Close Bracket

None

*

Multiply

None

+

Add

None

-

Subtract

None

/

Divide

None

Constant

Fixed value

Value/Rec/Rate Code

Rate Code

Refers to a Rate Code that you specify from the Rate Code table.

Value/Rec/Rate Code

Rec. Field

Refers to a field that you specify from a record.

Value/Rec/Rate Code and Field Name

Value/Rec/Rate Code

The value that you enter here depends on the operand that you select. This is a summary of the relationship between the operand and the Value/Rec/Rate code.

Constant

Enter a fixed amount. This value can be a percent or other fixed value to be used in the calculation.

For non-monetary plans, enter the number of units to be awarded to each plan member.

Rate Code

Enter a rate code from the Rate Code table.

Rec. Field

Select a record from these options: EMPLOYMENT, JOB, PERSONAL_DATA, and SAL_GRADE_TBL.

Field Name

Select from the available options for the record that you selected. When the system runs the SQL statement, it uses the value of the selected field in the plan member's record.