1. Implementing Payroll for Bahrain
  2. Calculation Types in Calculation Value Definitions

Calculation Types in Calculation Value Definitions

The calculation type determines which values you must provide in the Calculation Values section of the Create or Edit Calculation Value Definition page.

For example, if you select Flat Amount as the calculation type, then you must provide a flat amount value. You specify a default calculation type for the definition, which you can override on individual rows in the Calculation Values section.

Predefined Calculation Types

Predefined calculation types are available for each type of calculation. These work in conjunction with the predefined payroll formulas that contain specific rules for each calculation type, such as the CALL_CALC_VALUE formula.

This table describes the predefined calculation types, and indicates whether a calculation type is available for selection when you create a new value definition.

Calculation Type

Description

UOM

Available in Create Flow

Flat Amount

Uses the specified flat amount as the total amount.

Money

Yes

Flat Amount Times Multiplier

Multiplies a flat amount by a multiplier value. If you select this option, you must specify a database item that provides the value of the multiplier.

Money

Yes

Rate Definition

Retrieves a value by calling a rate definition.

Money

Yes

Number

Uses the number entered on the value definition as the calculated value.

Number

Yes

Flat Rate

Applies the specified percentage rate to the balance.

For example, to apply a rate of 10 percent, enter 10.

Number

Yes

Incremental Rate

Applies a different percentage rate to portions of the balance.

For example, assuming that the balance is 80,000, you could apply a 1 percent rate for the first 20,000 of the balance. A 3 percent rate for the next 30,000, and a 5 percent rate to the next 30,000. This is also referred to as a blended rate.

Number

Yes

Flat Rate by Derived Base

Applies the percentage rate to a value. This value type derives the value from another value definition.

Number

Yes

Identifier

A new calculation type is required to support identifiers. For example, the value definition could capture a job ID and the value set feature would enable the user to display the name of the job on the page.

Number

Yes

Text

Uses the specified character string as the calculated value.

Text

Yes

Date

Uses the date entered as the calculated value.

Text (YY-MM-DATE, HOURS MINS SECS)

Yes

Conditional Flat Amount

Uses the specified flat amount if the condition defined in the Calculation section is met.

For example, if a person's filing status is married or head of household, that person qualifies for an exemption. In such a scenario, you specify a flat amount value in the value definition and the condition database item returns the person's filing status.

This calculation type supports predefined calculations, such as tax and social insurance.

Money

No

Flat Calculation Total

Supports retrieving value definitions for different range value criteria, including predefined calculations, such as tax and social insurance.

Money or Number

No

Incremental Calculation (Graded)

Supports retrieving value definitions for different range value criteria, including predefined calculations, such as tax and social insurance.

Money or Number

No

Standard Formula 1

Calculates the total amount based on the following formula:

y = Ax - Bz

Where:

  • y is the deducted amount.

  • x is the calculated amount.

  • A and B are specified values.

  • z is a factor from a predefined formula. The value defaults to 1.

Money or Number

No

Standard Formula 2

Calculates the value based on the following formula:

y = (x - A) x B + Cz

Where:

  • y is the deducted amount.

  • x is the calculated amount.

  • A, B, and C are specified values.

  • z is a factor from a predefined formula. The value defaults to 1.

Money or Number

No

Specify View Objects

A view object is a query result set. You can specify a view object to define the valid values that are available to the selected calculation type.

Note:

  • The view objects you can specify vary depending on the calculation type. For example, if the calculation type is Conditional Flat Amount, then specify view objects for the condition and flat amount values.

  • When you specify a view object, include the fully qualified path name, such as: oracle.apps.hcm.locUS.payrollSetup.details.publicView.UsStatePVO

Related Topics