跳至主要內容
文件
文件
Administrator Guide
上次更新時間 ：2023-06-23
Example: Create a Lookup Table for Cost of Living Percentages

Example: Create a Lookup Table for Cost of Living Percentages

This example illustrates how to create an advanced lookup table to store the cost of living based on a worker's primary work state.
Your company has workers in California, Florida, New York, Pennsylvania, and South Carolina. You're preparing to create a calculation for bonuses based on the cost of living in each state. You want to create a lookup table with these percentages:
  • California: 25%
  • Florida: 20%
  • New York: 25%
  • Pennsylvania: 20%
  • South Carolina: 15%
  1. Access the
    Create Lookup Table
     task.
  2. Select
    Advanced Lookup Table - Report Field Search Criteria
    .
  3. Enter these values:
    選項 說明
    Name
    Bonus Percent (based on Cost of Living)
    Category
    Payroll
    Report Field Search Criteria
    Worker Primary Work State
    Effective Date
    Enter the effective date for the calculation.
  4. Remove the first row from the
    Values
     grid, and click
    OK
    .
  5. From the related actions menu of the lookup table, select
    Lookup Table
    Column Labels
    .
  6. Enter these values:
    Display on Page
    Display Name
    Selected
    Bonus Percent
  7. Click
    Done
    .
  8. Access the
    Edit Lookup Table
     task for your lookup table.
    Enter these values in the
    Values
     grid and click
    OK
    :
    Search Value
    Bonus Percent
    Default
    California
    0.25
    Florida
    0.20
    New York
    0.25
    Pennsylvania
    0.20
    South Carolina
    0.15
    0.10
    Selected
Create a step-based calculation for bonuses based on the cost of living.