Example: Create Value Comparison Calculations for Applicant Scores
This example illustrates how to create value comparison calculations for student applicant scores. This example includes these calculations:
- Constant Value
- 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 |
To support higher-level calculations for student applicant scores, you need to create these value comparison calculations:
- Cumulative GPA >= 3.0
- Cumulative GPA < 3.0
- SAT Total >= 1280
- SAT Total < 1280
Create these constant value calculations in the Admissions category:
ADM: 3.0
, 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 - Genericdomain in the Core Payroll functional area.
- Set Up: Time Off (Calculations - Generic)domain in the Time Off and Leave functional area.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values:FieldValueNameCumulative GPA >= 3.0CategoryAdmissionsAcademic UnitAlma Mater UniversityCommentADM: Cumulative GPA is greater than or equal to 3.0.1st OperandCumulative GPA - Student External TranscriptOperatorgreater than or equal to2nd OperandADM: 3.0
- ClickOKandDone.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values:FieldValueNameCumulative GPA < 3.0CategoryAdmissionsAcademic UnitAlma Mater UniversityCommentADM: Cumulative GPA is less than 3.0.1st OperandCumulative GPA - Student External TranscriptOperatorless than2nd OperandADM: 3.0
- ClickOKandDone.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values:FieldValueNameSAT Total >=1280CategoryAdmissionsAcademic UnitAlma Mater UniversityCommentADM: Highest SAT Total is greater than or equal to 1280.1st OperandHighest SAT TotalOperatorgreater than or equal to2nd OperandADM: 1280
- ClickOKandDone.
- Access theCreate Value Comparison Calculationtask.
- Enter or select these values:FieldValueNameSAT Total < 1280CategoryAdmissionsAcademic UnitAlma Mater UniversityCommentADM: Highest SAT Total is less than 1280.1st OperandHighest SAT TotalOperatorless than2nd OperandADM: 1280
- ClickOKandDone.
Add the value comparison calculations to higher-level calculations for student applicant scores.