Create Lookup Calculations for Multicriteria Advanced Lookup Tables

Create a multicriteria advanced lookup table.

Security:

Set Up: Calculations - Generic
domain in the Core Payroll functional area.

Set Up: Time Off (Calculations - Generic)
domain in the Time Off and Leave functional area.

To configure access to calculations using segment-based security groups: Access Calculation (Segmented)
domain in the Core Payroll, Implementation, Payroll Interface, and Time Off and Leave functional areas.

Multicriteria lookup calculations can handle high volumes of data, and provide 1 place to update data for easy maintenance. They also enable you to assign an effective date for search and return values. Lookup calculations are an integral part of multicriteria advanced lookup tables.

Access the

Create Lookup Calculation

task.

Enter a name for the calculation and select the same category as your multicriteria advanced lookup table. Example: Payroll.

In the Calculation
section, from

Lookup Table

, select your multicriteria advanced lookup table.

Select the

Column

for the lookup calculation.

Select

Period Date Indicator for Lookup Calculation

for the table effective dates for Workday Payroll and Absence Management.

You can select Based on a Custom Date
and select an option in

Date Calculation

In the Multicriteria Search Items
grid, select the

Calculation Value

for each search criteria.

For report field search criteria or text report search criteria, you can only select class report fields available with the business object you selected in your multicriteria advanced lookup table.

For numeric calculation search criteria, select an existing calculation or create a new calculation.

Create a lookup calcuation for each column label in the multicriteria advanced lookup table.

Example: Multicriteria Advanced Lookup Table Customized Allowances for Payroll