Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-11-01
Example: Create a Lookup Table for Enterprise Award Percentages Based on GPA

Example: Create a Lookup Table for Enterprise Award Percentages Based on GPA

This example illustrates how to create an advanced lookup table to store enterprise award percentages based on GPA.
Alma Mater University awards the Enterprise Award to students who are registered for 13 or more units, with a cumulative grade point average (GPA) of 3.0 or above. The university awards students with higher cumulative GPAs higher percentages of the unit-based amounts.
You're preparing to create a step-based calculation for the enterprise award amounts. You want to create a lookup table with these GPA-based percentages:
Cumulative GPA
Percentage
Greater than 3.7
70% of the overtime unit amount.
Greater than or equal to 3.2 and less than 3.7
30% of the overtime unit amount.
Greater than or equal to 3.0 and less than 3.2
10% of the overtime unit amount.
Security:
  • Set Up: Calculations - Generic
     domain in the Core Payroll functional area.
  • Access Calculation (Segmented)
     domain in the functional areas for Core Payroll, Implementation, Payroll Interface, and Time Off and Leave.
  • Set Up: Time Off (Calculations - Generic)
     domain in the Time Off and Leave functional area.
  1. Access the
    Create Lookup Table
     task.
  2. Select
    Advanced Lookup Table - Numeric Calculation Search Criteria
    .
  3. Enter these values:
    Option Description
    Name
    Percentage Based on GPA
    Category
    Financial Aid
    Numeric Search Criteria
    Academic Period Cumulative GPA
    Effective Date
    Enter January 1, 2019.
  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
    Percentage
  7. Click
    Done
    .
  8. Access the
    Edit Lookup Table
     task for your lookup table.
    Enter these values in the
    Values
     grid:
    Search Value
    Percentage
    3.0
    0.1
    3.2
    0.3
    3.7
    0.7
  9. Click
    OK
    .
Create a step-based condition to identify students with more than 12 academic units.