Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2025-08-22
Example: Calculate Flat Rate Tuition (Lookup Tables)

Example: Calculate Flat Rate Tuition (Lookup Tables)

This example illustrates how to use a lookup table and lookup calculation to calculate a flat rate tuition that increases every year, and includes these calculations:
  • Lookup
  • Lookup Table
Alma Mater University charges a flat rate for tuition for both undergraduate and graduate students, and this amount increases slightly each award year. The tuition rates are:
Award Year
Undergraduate Rate
Graduate Rate
2018-2019
2000
3000
2019-2020
2100
3100
2020-2021
2200
3200
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.
    1. Select
      Advanced Lookup Table - Report Field Search Criteria
      .
    2. Enter or select these values:
      Field
      Value
      Name
      AMU Undergraduate and Graduate Tuition
      Category
      Student Financials
      Country
      Leave blank.
      Comment
      Lookup table for UGRD and GRAD flat rate tuition amounts.
      Context Instance
      Student Financials Period Record
      Report Field Search Criteria
      Financial Aid Award Year
      Effective Date
      07/01/2017
    3. In the
      Values
       grid on the
      Table Data
       tab, add these rows:
      Search Value
      a
      Default
      2018-2019 Award Year
      2000
      (leave clear)
      2019-2020 Award Year
      2100
      (leave clear)
      2020-2021 Award Year
      2200
      (leave clear)
    4. Click
      OK
      . (Don't click
      Done
      .)
      If you accidentally click
      Done
      , use the
      View Lookup Table
       task to navigate back to the lookup table.
    5. From the related actions menu of the lookup table, select
      Lookup Table
      Column Labels
      .
    6. In the grid, enter or select these values:
      Display on Page
      Display Name
      Select this check box.
      Undergraduate
      Select this check box.
      Graduate
    7. Click
      OK
      . (Don't click
      Done
      .)
      If you accidentally click
      Done
      , use the
      View Lookup Table
       task to navigate back to the lookup table.
    8. From the related actions menu of the lookup table, select
      Lookup Table
      Edit
      .
    9. Enter these values:
      Graduate
      3000
      3100
      3200
    10. Click
      OK
      .
      You should have these values in the
      Values
       grid:
      Search Value
      Undergraduate
      Graduate
      2018-2019 Award Year
      2000
      3000
      2019-2020 Award Year
      2100
      3100
      2020-2021 Award Year
      2200
      3200
  2. Access the
    Create Lookup Calculation
     task.
    1. Enter or select these values:
      Field
      Value
      Name
      AMU Undergraduate Tuition
      Category
      Student Financials
      Academic Unit
      (leave blank)
      Comment
      Lookup calculation for UGRD tuition.
      Lookup Table
      AMU Undergraduate and Graduate Tuition
      Column
      Undergraduate
      Period Date Indicator
      (leave blank)
    2. Click
      OK
      .
    3. From the related actions menu of the calculation, select
      Calculation
      Copy
      .
    4. Enter or select these values:
      Field
      Value
      Name
      AMU Graduate Tuition
      Category
      Student Financials
      Academic Unit
      (leave blank)
      Comment
      Lookup calculation for GRAD tuition.
      Lookup Table
      AMU Undergraduate and Graduate Tuition
      Column
      Graduate
      Period Date Indicator
      (leave blank)
The calculations are available to use in student charge items. When you assess charges to students for the charge item, Workday calculates the charge amount based on the award year and the academic level of the student.
Create student charge items for undergraduate tuition and graduate tuition and add the calculations to them.