Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-11-01
Example: Set Up Calculations for Applicant Scores

Example: Set Up Calculations for Applicant Scores

This example illustrates how to set up calculations for student applicant scores. This example includes these calculations:
  • Conditional
  • Constant Value
  • Logic
  • Value Comparison
Alma Mater University (AMU) rates an undergraduate applicant's likelihood for admission based on the grade point average (GPA) and SAT total on their application. Workday uses the GPA and SAT total to calculate an applicant score that maps to the rating on an applicant score scale.
GPA and SAT Total
Applicant Score
Rating
GPA greater than or equal to 3.0 AND SAT total greater than or equal to 1280.
10
Presumptive Admit
GPA greater than or equal to 3.0 AND SAT total less than 1280.
OR
GPA less than 3.0 AND SAT total greater than or equal to 1280.
5
Committee Review
GPA less than 3.0 AND SAT total less than 1280.
3
Presumptive Deny
You need to create a series of nested calculations to calculate the applicant score.
Create these constant value calculations in the Admissions category:
ADM: 0
,
ADM: 3
,
ADM: 3.0
,
ADM: 5
,
ADM: 10
,
ADM: 1280
.
Security:
  • Access Calculation (Segmented)
     domain in the functional areas for Core Payroll, Implementation, Payroll Interface, and Time Off and Leave.
  • 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.
  1. Create aggregate calculations for cumulative GPAs.
  2. Create value comparison calculations for student applicant scores.
  3. Access the
    Create Logic Calculation
     task.
    Create a calculation that determines when an applicant has a high GPA and high SAT total.
    1. Enter or select these values:
      Field
      Value
      Name
      Cumulative GPA >= 3.0 AND SAT Total >= 1280
      Category
      Admissions
      Academic Unit
      Alma Mater University
      Comment
      Cumulative GPA is greater than or equal to 3.0 AND Highest SAT Total is greater than or equal to 1280.
    2. In the
      Calculation
       grid, add these rows:
      Operator
      Calculation
      AND
      Cumulative GPA >= 3.0
      SAT Total >=1280
    3. Click
      OK
       and
      Done
      .
  4. Access the
    Create Logic Calculation
     task.
    Create a calculation that determines when an applicant has a high GPA and low SAT total, or a low GPA and high SAT total.
    1. Enter or select these values:
      Field
      Value
      Name
      Cumulative GPA < 3.0 AND SAT Total >= 1280
      Category
      Admissions
      Academic Unit
      Alma Mater University
      Comment
      Cumulative GPA is less than 3.0 AND Highest SAT Total is greater than or equal to 1280.
    2. In the
      Calculation
       grid, add these rows:
      Operator
      Calculation
      AND
      Cumulative GPA < 3.0
      SAT Total >=1280
    3. Click
      OK
       and
      Done
      .
    4. Access the
      Create Logic Calculation
       task.
    5. Enter or select these values:
      Field
      Value
      Name
      Cumulative GPA >= 3.0 AND SAT Total < 1280
      Category
      Admissions
      Academic Unit
      Alma Mater University
      Comment
      Cumulative GPA is greater than or equal to 3.0 AND Highest SAT Total is less than 1280.
    6. In the
      Calculation
       grid, add these rows:
      Operator
      Calculation
      AND
      Cumulative GPA >= 3.0
      SAT Total 1280
    7. Click
      OK
       and
      Done
      .
    8. Access the
      Create Logic Calculation
       task.
    9. Enter or select these values:
      Field
      Value
      Name
      Combo Logic Cumulative GPA AND SAT Total
      Category
      Admissions
      Academic Unit
      Alma Mater University
      Comment
      Cumulative GPA is less than 3.0 AND SAT Total is greater than or equal to 1280
      OR
      Cumulative GPA is greater than or equal to 3.0 AND SAT Total is less than 1280
    10. In the
      Calculation
       grid, add these rows:
      Operator
      Calculation
      OR
      Cumulative GPA < 3.0 AND SAT Total >= 1280
      Cumulative GPA >= 3.0 AND SAT Total < 1280
  5. Access the
    Create Logic Calculation
     task.
    Create a calculation that determines when an applicant has a low GPA and low SAT total.
    1. Enter or select these values:
      Field
      Value
      Name
      Cumulative GPA < 3.0 AND SAT Total < 1280
      Category
      Admissions
      Academic Unit
      Alma Mater University
      Comment
      Cumulative GPA is less than 3.0 AND Highest SAT Total is less than 1280.
    2. In the
      Calculation
       grid, add these rows:
      Operator
      Calculation
      AND
      Cumulative GPA < 3.0
      SAT Total < 1280
    3. Click
      OK
       and
      Done
      .
  6. Access the
    Create Conditional Calculation
     task.
    Create a calculation that returns an applicant score based on the GPA and SAT total.
    1. Enter or select these values:
      Field
      Value
      Name
      AMU - Top Level Calculation for Applicant Scores
      Category
      Admissions
      Academic Unit
      Alma Mater University
      Comment
      10 = Presumptive Admit
      5 = Committee Review
      3 = Presumptive Deny
      0 = Check the calculation
      If Cumulative GPA >= 3.0 AND Highest SAT Total >= 1280 then the app score is 10 (Presumptive Admit)
      If Cumulative GPA GPA is less than 3.0 AND Highest SAT Total is greater than or equal to 1280 OR if Cumulative GPA is greater than or equal to 3.0 AND Highest SAT Total Score is less than 1280 then app score is 5 (Committee Review)
      If Cumulative GPA < 3.0 AND Highest SAT Total < 1280 then the app score is 3 (Presumptive Deny)
    2. In the
      Conditional Calculations
       grid, enter these rows:
      Order
      Condition
      Result
      a
      Cumulative GPA >= 3.0 AND SAT Total >= 1280
      ADM: 10
      b
      Combo Logic Cumulative GPA AND SAT Total
      ADM: 5
      c
      Cumulative GPA < 3.0 AND SAT Total < 1280
      ADM: 3
    3. In the
      Default Response
       field, select
      ADM: 0
      .
    4. Click
      OK
       and
      Done
      .
Add the
AMU - Top Level Calculation for Applicant Scores
 calculation to a student applicant score calculation policy.