Using Sample Rules

Oracle has delivered seventeen sample rules based on the Rule Category described above. Three of those rules are based on the Rule Group EMS Rating Component Calculation; one is based on the Rule Group EMS Rating Scheme Calculation and two are based on the Early Result Rule Group. The rules are intended as examples that you can take and clone or rebuild under your own Rules Engine Category as you begin to assess how you can implement and leverage Rules Engine functionality in Evaluation Management System. The sample rules delivered as system data represent a simple use case for an admissions evaluation to demonstrate how a calculated rating scheme might be used to automate an evaluation.

Note:

These rules use Campus Solutions sample data: you will need to modify values to use the rules. See the Modifying and Using System Data Rules section later in this topic.

The sample rules can be accessed using the Rules Engine Manager Component (Set Up SACR, and then System Administration, and then Rules Engine Manager).

In our examples for the Rating Component Calculation and Rating Scheme Calculation rule groups, there are four main rules which call other rules:

  • Academic Qualification Example

  • Courses Completed Requirement Example

  • Test Score Rule Example

  • Rating Scheme Calculation Example

For the Early Result Rule group, we have provided two sample rules:

  • Early Result Calc Evaluation Workflow Rule Example

  • Early Result Evaluation Workflow Rule Example

Below we take a closer look at a rule from the Rating Component Calculation rule group and the Early Result rule group to see how the rules may be compromised.

SCC_RULE_ID_20140303114951 Test Score Rule Example - Rating Component Calculation Rule Group

This rule returns a rating value for the rating component based on the highest score value in a comparison of ACT scores and SAT 1 scores. Calls a number of rules to get the scores from the test score records, evaluate those results against a rating scale to obtain the rating value to populate the rating component. Rules called from the Test Score Rule Example are:

└ SCC_RULE_ID_20140226160705 Get Highest Test Component Score
			└ SCC_RULE_ID_20140226155857 Get Test Component Scores
└ SCC_RULE_ID_20140304120320 Get ACT Rating Value
└ SCC_RULE_ID_20140304121526 Get SAT 1 Rating Value
Rule Evaluation Calculation Statement Process Description/Definition

CALL Function Get Highest Test Component Score passing in Evaluation Information.ID as in_EMPLID, ACT as in_TEST_ID, COMP as in_TEST_COMPONENT returning out_Highest_Score as highest_ACT_Score

Calls the function ‘Get Highest Test Component Score’ passing in values for EMPLID, TEST_ID and TEST_COMPONENT. In this case the function returns the Highest ACT Composite score for the EMPLID.

CALL Function Get Highest Test Component Score passing in Evaluation Information.ID as in_EMPLID, SAT 1 as in_TEST_ID, MATH as in_TEST_COMPONENT returning out_Highest_Score as highest_SAT_1_MATH_Score

Calls the function ‘Get Highest Test Component Score’ passing in values for EMPLID, TEST_ID and TEST_COMPONENT. In this case the function returns the Highest SAT 1 Math score for the EMPLID.

CALL Function Get Highest Test Component Score passing in Evaluation Information.ID as in_EMPLID, SAT 1 as in_TEST_ID, VERB as in_TEST_COMPONENT returning out_Highest_Score as highest_SAT_1_VERB_Score

Calls the function ‘Get Highest Test Component Score’ passing in values for EMPLID, TEST_ID and TEST_COMPONENT. In this case the function returns the Highest SAT 1 Verbal score for the EMPLID.

CALL Function Add passing in highest_SAT_1_MATH_Score as Value 1, highest_SAT_1_VERB_Score as Value 2 returning Result as SAT_1_Total

Calls the function ‘Add’ passing in the Highest SAT 1 Math score and the Highest SAT 1 Verbal score to calculate a SAT 1 Total score.

CALL Function Get ACT Rating Value passing in highest_ACT_Score as in_ACT_Score returning out_Rating as ACT_Rating

Calls the function ‘Get ACT Rating Value’ passing in the Highest ACT Composite score. The function returns an ACT Rating based on the score passed in.

CALL Function Get SAT 1 Rating Value passing in SAT_1_Total as in_SAT_1_Total returning out_Rating as SAT_1_Rating

Calls the function ‘Get SAT 1 Rating Value’ passing in the SAT 1 Total score. The rule returns a SAT 1 Rating based on the score passed in.

IF ACT_Rating > SAT_1_RATING | - ASSIGN Result Rating Value = ACT_Rating

ELSE IF ACT_Rating > SAT_1_Rating | - ASSIGN Result Rating Value = SAT_1_Rating

If the ACT Rating is greater than the SAT 1 Rating, the ACT Rating is assigned to the Result Rating Value output variable.

Otherwise, the SAT 1 Rating is assigned to the Result Rating Value output variable.

ASSIGN Result Calculated = True

The Result Calculated output variable is set to True to indicate the rule has successfully calculated a value for the Result Rating Value output variable.

SCC_RULE_ID_20140226160705 - Get Highest Test Component Score Example

Rule Evaluation Calculation Statement Process Description/Definition

CALL Rule Get Test Component Scores passing in in_EMPLID as in_EMPLID, in_TEST_ID as in_TEST_ID, in_TEST_COMPONENT as in_TEST_COMPONENT returning out_Test_Score_list as test_score_list

Calls the rule ‘Get Test Component Scores’ passing in the EMPLID, TEST_ID and TEST_COMPONENT. A list of Test Scores is returned. If no test scores of this type are found for the EMPLID an empty list will be returned.

CALL Function Max passing in test_score_list as List of Values returning Maximum as out_Highest_Score

Calls the function Max passing in a list of Test Scores. The function returns the maximum test score in the list. The function returns zero if the test score list is empty.

SCC_RULE_ID_20140226155857 - Get Test Component Scores Example

Rule Evaluation Calculation Statement Process Description/Definition

CLEAR LIST Using List out_Test_Score_list

Initializes the Test Score List output variable to empty.

FOR EACH Test Score Component - Process Immediate Children Only

Loop through each Test Score Component that is returned based on the statements in the Criteria section of this rule.

| - IF Test Score Component.Test Component = in_TEST_COMPONENT |    | - ADD TO LIST Using List out_Test_Score_list Value Test Score Component.Test Score

If the Test Component is equal to the value in the Test Component input variable, add the Test Score to the Test Score List output variable.

SCC_RULE_ID_20140304120320 - Get ACT Rating Value Example

Rule Evaluation Calculation Statement Process Description/Definition

IF in_ACT_Score > 0

| - IF in_ACT_Score >= 35

|    | - ASSIGN out_Rating = 35

| - ELSE IF in_ACT_Score >= 35

|    | - IF in_ACT_Score >= 30

|    |    | - ASSIGN out_Rating = 30

|    | - ELSE IF in_ACT_Score >= 30

|    |    | - IF in_ACT_Score >= 25

|    |    |    | - ASSIGN out_Rating = 25

|    |    | - ELSE IF in_ACT_Score >= 25

|    |    |    | - IF in_ACT_Score >= 20

|    |    |    |    | - ASSIGN out_Rating = 20

|    |    |    | - ELSE IF in_ACT_Score >= 20

|    |    |    |    | - IF in_ACT_Score >= 15

|    |    |    |    |    | - ASSIGN out_Rating = 15

|    |    |    |    | - ELSE IF in_ACT_Score >= 15

|    |    |    |    |    | - ASSIGN out_Rating = 10

Calculates a Rating Value based on the ACT Score input variable by using a series of IF/ELSE statements.

The function returns a rating when the ACT Score is greater than zero. Otherwise, the function returns zero.

SCC_RULE_ID_20140304121526 - Get SAT 1 Rating Value Example

Rule Evaluation Calculation Statement Process Description/Definition

IF in_SAT_1_Total > 0 And in_SAT_1_Total <= 1600

| - IF in_SAT_1_Total >= 1400

|    | - ASSIGN out_Rating = 35

| - ELSE IF in_SAT_1_Total >= 1400

|    | - IF in_SAT_1_Total >= 1300

|    |    | - ASSIGN out_Rating = 30

|    | - ELSE IF in_SAT_1_Total >= 1300

|    |    | - IF in_SAT_1_Total >= 1200

|    |    |    | - ASSIGN out_Rating = 25

|    |    | - ELSE IF in_SAT_1_Total >= 1200

|    |    |    | - IF in_SAT_1_Total >= 1100

|    |    |    |    | - ASSIGN out_Rating = 20

|    |    |    | - ELSE IF in_SAT_1_Total >= 1100

|    |    |    |    | - IF in_SAT_1_Total >= 1000

|    |    |    |    |    | - ASSIGN out_Rating = 15

|    |    |    |    | - ELSE IF in_SAT_1_Total >= 1000

|    |    |    |    |    | - ASSIGN out_Rating = 10

Calculates a Rating Value based on the SAT 1 Total input variable by using a series of IF/ELSE statements.

The function returns a rating when the total is greater than zero and less than or equal to 1600. Otherwise, the function returns zero.

SCC RULE ID 20140519124427 Early Result Evaluation Workflow Rule Example - Rating Component Calculation Rule Group

This rule can return an Early Result variable value of True based on the outcomes of the segment of the evaluation using Overall Rating and Recommendation values as the determinant.

Rule Evaluation Calculation Statement Process Description/Definition

LENGTH OF LIST Using List Evaluator List Returning Length in evaluatorCount

Returns a count of evaluators in the evaluation.

IF evaluatorCount > 0

From the EvaluatorList results, if evaluator count is greater than 0, then proceed in evaluating the evaluator types and accompanying conditions.

| - FOR EACH Evaluator List

|    | - ASSIGN Evaluator = Evaluator List

|    | - IF Evaluator.Evaluator Type = 5 And Evaluator.Scheme = LAFIRSTREV And Evaluator.Overall Rating >= 30

|    |    | - ASSIGN Early Result = True, Route To Administrator = False, Recommendation = ADMIT, Recommended Prize = MCL

|    | - IF Evaluator.Evaluator Type = 5 And Evaluator.Scheme = LAFIRSTREV And Evaluator.Overall Rating <= 10

|    |    | - ASSIGN Early Result = True, Route To Administrator = False, Recommendation = DENY

|    |    | - EXIT FOR EACH

|    | - IF Evaluator.Evaluator Type = 4 And Evaluator.Scheme = UGLAFACREV And Evaluator.Recommendation = ADMIT

|    |    | - ASSIGN Early Result = True, Route To Administrator = False, Recommendation = ADMIT

|    | - IF Evaluator.Evaluator Type = 4 And Evaluator.Scheme = UGLAFACREV And Evaluator.Recommendation = DENY

|    |    | - ASSIGN Early Result = True, Route To Administrator = True, Recommendation = DENY

|    |    | - EXIT FOR EACH

|    | - IF Evaluator.Evaluator Type = 3 And Evaluator.Scheme = LADEANREV And Evaluator.Overall Rating >= 35 And Evaluator.Recommendation = ADMIT

|    |    | - ASSIGN Early Result = True, Route To Administrator = True, Recommendation = ADMIT, Recommended Prize = DEANLS

|    | - IF Evaluator.Evaluator Type = 3 And Evaluator.Scheme = LADEANREV And Evaluator.Overall Rating <= 15 And ( Evaluator.Recommendation = DENY Or Evaluator.Recommendation = WAITLIST )

|    |    | - ASSIGN Early Result = True, Route To Administrator = True, Recommendation = DENY

|    |    | - EXIT FOR EACH

Using a series of IF statements evaluates the statement conditions to return the Early Result value, Recommendation and Recommend Prize values when met.

Rules Belonging to the Evaluation Management System Category

Rule ID Name Long Description

SCC_RULE_ID_20140306170755

Rating Scheme Calculation Example

This rule can be used at the Evaluation Rating Scheme level as an alternate calculation of the Overall Rating value for the scheme. This example returns the sum of the component rating values.

SCC_RULE_ID_20140303114951

Test Score Rule Example

This rule returns a rating value for the rating component based on the highest score value in a comparison of ACT scores and SAT 1 scores. Calls a number of rules to get the scores from the test score records, evaluate those results against a rating scale to obtain the rating value to populate the rating component.

SCC_RULE_ID_20140306173039

Academic Qualification Example

This rule returns a rating value to the rating component based on education data fields of percentile rank and converted GPA contained in External Academic Summary. Calls a number of other rules which get the GPA and percentile values, evaluate those results against a rating scale to obtain the rating value to populate the rating component.

SCC_RULE_ID_20140306172622

Courses Completed Requirement Example

This rule returns a rating value to the rating component based on a count of completed subjects in External Academic Subjects.

SCC_RULE_ID_20140304120320

Get ACT Rating Value Example

Returns the rating value for an ACT score.

SCC_RULE_ID_20140306141320

Get Course Count Rating Example

Gets the rating value for Course Count.

SCC_RULE_ID_20140306143945

Get Course Requirement Rating Example

Returns a rating value based on the number of Courses Completed for all Academic History entries that have External Academic Data rows where External Career = HS and Transcript Type = OFF.

SCC_RULE_ID_20140306161125

Get Courses Completed Count Example

Returns a count of completed courses in External Academic Subjects.

SCC_RULE_ID_20140304123947

Get GPA Rating Example

Returns the rating value for a GPA.

SCC_RULE_ID_20140304162158

Get High School Rating Example

Gets the highest rating value of the Converted GPA and Percentile values and passes to Get High School Rating Driver rule.

SCC_RULE_ID_20140304170413

Get High School Rating Driver Example

Loops through External Academic Data where External Career = HS for an EMPLID and calls Get High School Rating. Returns the highest High School Rating.

SCC_RULE_ID_20140226160705

Get Highest Test Component Score Example

Returns the highest score for the specified EMPLID, TEST_ID, and TEST_COMPONENT.

SCC_RULE_ID_20140304155504

Get Percentile Rating Example

Returns the rating value for a Percentile Rank.

SCC_RULE_ID_20140304121526

Get SAT 1 Rating Value Example

Returns a rating value for a SAT 1 Test Score Total.

SCC_RULE_ID_20140226155857

Get Test Component Scores Example

Returns a list of test component scores for the specified EMPLID, TEST_ID and TEST_COMPONENT.

SCC_RULE_ID_20140604075859

Early Result Calc Evaluation Workflow Rule Example

Early Result Calc Evaluation Workflow Rule Example – multiple schemes including a calculated scheme.

SCC_RULE_ID_20140519124427

Early Result Evaluation Workflow Rule Example

Early Result Evaluation Workflow Rule Example

Evaluation Management Rules Engine Rule Hierarchy for rules in the Rating Component Calculation Rule Group

SCC_RULE_ID_20140306173039 Academic Qualification Example

└ SCC_RULE_ID_20140304170413 Get High School Rating Driver
			└ SCC_RULE_ID_20140304162158 Get High School Rating
						└ SCC_RULE_ID_20140304123947 Get GPA Rating
						└ SCC_RULE_ID_20140304155504 Get Percentile Rating

SCC_RULE_ID_20140306172622 Courses Completed Requirement Example

└ SCC_RULE_ID_20140306143945 Get Course Requirement Rating
			└ SCC_RULE_ID_20140306161125 Get Courses Completed Count
			└ SCC_RULE_ID_20140306141320 Get Course Count Rating

SCC_RULE_ID_20140303114951 Test Score Rule Example

└ SCC_RULE_ID_20140226160705 Get Highest Test Component Score
			└ SCC_RULE_ID_20140226155857 Get Test Component Scores
└ SCC_RULE_ID_20140304120320 Get ACT Rating Value
└ SCC_RULE_ID_20140304121526 Get SAT 1 Rating Value