Calculate Time Based on a User-Defined Value

Let's look at an example that shows how to calculate time using a business-specific attribute such as company code.

This example doesn't cover the payroll calculation. But it does support the configuration to calculate a rate based on a user-defined value for a time element in the payroll run.

Create Element

You can choose to calculate relief allowance payments based on a worker's company code. Use the Elements task to create an hours rate element for relief allowance.

1. In the Primary Classification field, select Standard Earnings.

2. In the Category field, select Time.

Create Value Definition

Use the Calculation Value Definitions task to create a company code value definition. You can capture the company code on the worker's time card and pass it to payroll for calculation purposes.

1. In the Value Definition Group field, select Time.

2. In the Calculation Type field, select Identifier.

3. Select Enterable Calculation Values on the calculation card and complete these steps:

   1. Select Identifier as the value type.

   2. Enter a display value, such as Company.

   Note:

   Ensure that you select the total amount.

4. Create Usage Rules by completing these steps:

   1. In the Calculation Card field, select Time Cards.

   2. Select your relief allowance calculation component.

   3. Select a value set, if appropriate.

Create Calculation Step

Use the Payroll Calculation Information task to create a company code calculation step.

1. In the Component Group field, navigate to the Calculation Overview page, and search for time.

2. Navigate through all the calculation steps tasks.

3. Create a calculation step and enter a name, such as Company Code.

Create Calculation Factor on Element

Use the Elements task to create a calculation factor.

1. Search for your relief allowance element.

2. Navigate to the Calculation Factor page.

3. In the Calculation Step field, select the company code calculation step.

4. In the Value Definition field, select the company code value definition.

Edit Formula on Element

Use the Elements task to edit the element formula.

1. Edit the appropriate relief allowance element formula to use the company code value using the CALL_CALC_VALUES formula.

Note:

Remember to run the Generate Data Dictionary Time Attributes process in the Oracle Time and Labor application after you've created the value definitions. This process creates the attributes necessary to capture the information, such as company code, on a time card and pass these details to Payroll.