USE `test_tg`; DROP PROCEDURE IF EXISTS memleaktest; DELIMITER ;; CREATE PROCEDURE `memleaktest`() begin set autocommit=0; Start Transaction; insert into test_tg.table_a (table_b_id,table_c_id,table_d_id,field_1,field_2,field_3,field_4,field_5,field_6,field_7,field_8) values (123456, 123456, 654321,'ASDFGHJKLQWE ASDFGHJ Only5','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only5" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','6dcd0ee8a8b911e58b921252fbd63c63'), ( (select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'), (select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'), (select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Permanent Student Restriction','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Permanent Student Restriction" when Map($map : this) Map( StringUtils.isNotBlank(this["code"]) && this["temporary"] == false ) not (exists Class2 (code == "core_customer_feature_date_override")) then errorList.add(new ValidationError("null", "null", "null", "null")); end ',0,'view',null,null,'This rule is to prevent editing of a permanent student by any user NOT a Program aaas Administrator (as indicated by the Feature Date Override Class2).','97b05628beed11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'UUID','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "UUID" when Map($map : this) not (exists Class2 (code == "core_customer_student_merge")) then errorList.add(new ValidationError("null", "null", "null", "null")); end',0,'view',null,null,'UUID should only be visible to the Program Admin role only','c580b85ca8e311e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only19','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only19" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','480864c5a8bb11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Fives','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Fives" when Map($map : this) Map(this["code"] == "S55555555") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "5"s.','b7d0464f4a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only11','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only11" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','48941772a82a11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only6','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only6" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','21eab720a82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Fours','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Fours" when Map($map : this) Map(this["code"] == "444444444") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "4"s.','cc86ae484a9711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only14','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only14" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','7310a1f8a8ba11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only10','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only10" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','4283d0c6a8bc11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasMath Cut1 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasMath Cut1 Std" when Map($map : this) Map(this["aaasMathCutASDFGHJ"] != "2058") Map(this["aaasPassingStandard"] == "1") then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "The aaasMATHEMATICSPASSINGCUTASDFGHJ must be 2058 if the aaasPASSINGSTANDARD is \\"1.\\"", "aaasMathCutASDFGHJ", "The aaas Mathematics Passing Cut ASDFGHJ must be 2058 if the aaas Passing Standard is \\"1.\\"")); end',0,'validation','The aaasMATHEMATICSPASSINGCUTASDFGHJ must be 2058 if the aaasPASSINGSTANDARD is "1."','The aaas Mathematics Passing Cut ASDFGHJ must be 2058 if the aaas Passing Standard is "1."','Rule to validate the aaas Math Cut ASDFGHJ when the Passing Standard is "1".','29ccdd777c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only13','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only13" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','fb3c7608a82a11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasMath Cut2 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasMath Cut2 Std" when Map($map : this) Map(this["aaasMathCutASDFGHJ"] != "2015") Map(this["aaasPassingStandard"] == "2") then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "The aaasMATHEMATICSPASSINGCUTASDFGHJ must be 2015 if the aaasPASSINGSTANDARD is \\"2.\\"", "aaasMathCutASDFGHJ", "The aaas Mathematics Passing Cut ASDFGHJ must be 2015 if the aaas Passing Standard is \\"2.\\"")); end',0,'validation','The aaasMATHEMATICSPASSINGCUTASDFGHJ must be 2015 if the aaasPASSINGSTANDARD is "2."','The aaas Mathematics Passing Cut ASDFGHJ must be 2015 if the aaas Passing Standard is "2."','Rule to validate the aaas Math Cut ASDFGHJ when the Passing Standard is "2".','3a0a4eab7c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only6','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only6" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','3b0693c1a82611e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only18','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only18" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','963d7139a82b11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasScience Cut1 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasScience Cut1 Std" when Map($map : this) Map(this["aaasScienceCutASDFGHJ"] != "2068") Map(this["aaasPassingStandard"] == "1") then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "The aaasSCIENCEPASSINGCUTASDFGHJ must be 2068 if the aaasPASSINGSTANDARD is \\"1.\\"", "aaasScienceCutASDFGHJ", "The aaas Science Passing Cut ASDFGHJ must be 2068 if the aaas Passing Standard is \\"1.\\"")); end',0,'validation','The aaasSCIENCEPASSINGCUTASDFGHJ must be 2068 if the aaasPASSINGSTANDARD is "1."','The aaas Science Passing Cut ASDFGHJ must be 2068 if the aaas Passing Standard is "1."','Rule to validate the aaas Science Cut ASDFGHJ when the Passing Standard is "1".','822124f37c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Date Of Birth More Recent Than 2016','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Date Of Birth More Recent Than 2016" when Map($map : this) Map(new SimpleDate(this["dateOfBirth"]) >= new SimpleDate("20160101")) then errorList.add(new ValidationError("dateOfBirth", "Date of Birth must be less than 20160101.", "dateOfBirth", "Date of Birth must be less than 20160101.")); end',1,'validation','Date of Birth must be less than 20160101.','Date of Birth must be less than 20160101.','This validation is to trap future dates of birth and dates more recent than 20160101.','b4231293cb5b11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Threes','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Threes" when Map($map : this) Map(this["code"] == "333333333") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "3"s.','af4615f44a9711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only8','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only8" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) then errorList.add(new ValidationError("aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','5702bbfca82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only2','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only2" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','8ab9850aa82511e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only6','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only6" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','8a0066eea8b911e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Program aaas Admin Only','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Program aaas Admin Only" when Map($map : this) not (exists Class2 (code == "core_customer_feature_date_override")) then errorList.add(new ValidationError("null", "null", "null", "null")); end',0,'view',null,null,'This rule is to prevent editing of certain data elements unless the user is a Program aaas Administrator (as indicated by the Feature Date Override Class2).','b294a22d6ba711e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'zzABCDESFG Positions 4 and 5 Are Zero','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG Positions 4 and 5 Are Zero" when Map($map : this) Map(this["code"] matches "^.{3}0{2}.{4}$") Map(this["code"] not matches "^S.{2}0{2}.{4}$") then errorList.add(new ValidationError("code", "ABCDESFG cannot have zeroes in positions 4 and 5 unless the first character is an \\"S.\\"", "code", "ABCDESFG cannot have zeroes in positions 4 and 5 unless the first character is an \\"S.\\"")); end',1,'validation','ABCDESFG cannot have zeroes in positions 4 and 5 unless the first character is an "S."','ABCDESFG cannot have zeroes in positions 4 and 5 unless the first character is an "S."','This validation is to trap ABCDESFGs with zeroes in position 4 and 5, without an "S" in position 1.','b196b2bd9de211e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only15','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only15" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','9347f949a8ba11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only11','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only11" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','6ae6f498a8bc11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only14','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only14" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','1cf7f2daa82b11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Fours','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Fours" when Map($map : this) Map(this["code"] == "S44444444") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "1"s.','94da93a44a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only14','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only14" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','3da4010ca8bd11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only12','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only12" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','6351f470a82a11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Sixes','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Sixes" when Map($map : this) Map(this["code"] == "S66666666") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated. ", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated. ','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "1"s.','cabe52e84a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only9','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only9" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','7717ea3ca82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasMath CutP Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasMath CutP Std" when Map($map : this) Map(this["aaasMathCutASDFGHJ"] != "2100") Map(this["aaasPassingStandard"] == "P") then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "The aaasMATHEMATICSPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is \\"P.\\"", "aaasMathCutASDFGHJ", "The aaas Mathematics Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is \\"P.\\"")); end',0,'validation','The aaasMATHEMATICSPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is "P."','The aaas Mathematics Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is "P."','Rule to validate the aaas Math Cut ASDFGHJ when the Passing Standard is "P".','192184c97c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only7','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only7" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','b9e8a5eca82911e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only2','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only2" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','bef70fcda82211e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasScience Cut2 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasScience Cut2 Std" when Map($map : this) Map(this["aaasScienceCutASDFGHJ"] != "2035") Map(this["aaasPassingStandard"] == "2") then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "The aaasSCIENCEPASSINGCUTASDFGHJ must be 2035 if the aaasPASSINGSTANDARD is \\"2.\\"", "aaasScienceCutASDFGHJ", "The aaas Science Passing Cut ASDFGHJ must be 2035 if the aaas Passing Standard is \\"2.\\"")); end',0,'validation','The aaasSCIENCEPASSINGCUTASDFGHJ must be 2035 if the aaasPASSINGSTANDARD is "2."','The aaas Science Passing Cut ASDFGHJ must be 2035 if the aaas Passing Standard is "2."','Rule to validate the aaas Science Cut ASDFGHJ when the Passing Standard is "2".','8f9b0b7e7c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Date Of Birth Older Than 1900','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Date Of Birth Older Than 1900" when Map($map : this) Map(new SimpleDate(this["dateOfBirth"]) < new SimpleDate("19000101")) then errorList.add(new ValidationError("dateOfBirth", "Date of Birth must be greater than or equal to 19000101.", "dateOfBirth", "Date of Birth must be greater than or equal to 19000101.")); end',0,'validation','Date of Birth must be greater than or equal to 19000101.','Date of Birth must be greater than or equal to 19000101.','This validation is to ensure date of birth values greater than 19000101, and trap any erroneous 5digit inputs.','2e4fa8d0c90311e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Twos','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Twos" when Map($map : this) Map(this["code"] == "222222222") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "2"s.','a04f593b4a9711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only7','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only7" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','bbe97c6ba8bb11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only1','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only1" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','5d0a235ea81f11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only20','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only20" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','6ba27c8ea8bb11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Nines','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Nines" when Map($map : this) Map(this["code"] == "999999999") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "9"s.','21f83dfc4a9811e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only15','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only15" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','47fa117ea82b11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Nines','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Nines" when Map($map : this) Map(this["code"] == "S99999999") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "9"s.','0f8aad994a9c11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only2','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only2" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','03e60c68a8b811e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Threes','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Threes" when Map($map : this) Map(this["code"] == "S33333333") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "3"s.','7888df7f4a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only16','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only16" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','b1c2cf58a8ba11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only12','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only12" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','8f0b34eda8bc11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasELA Cut1 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasELA Cut1 Std" when Map($map : this) Map(this["aaasELACutASDFGHJ"] != "2072") Map(this["aaasPassingStandard"] == "1") then errorList.add(new ValidationError("aaasELACutASDFGHJ", "The aaasELAPASSINGCUTASDFGHJ must be 2072 if the aaasPASSINGSTANDARD is \\"1.\\"", "aaasELACutASDFGHJ", "The aaas ELA Passing Cut ASDFGHJ must be 2072 if the aaas Passing Standard is \\"1.\\"")); end',0,'validation','The aaasELAPASSINGCUTASDFGHJ must be 2072 if the aaasPASSINGSTANDARD is "1."','The aaas ELA Passing Cut ASDFGHJ must be 2072 if the aaas Passing Standard is "1."','Rule to validate the aaas ELA Cut ASDFGHJ when the Passing Standard is "1".','f15dfa067c1411e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only10','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only10" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','939e3f53a82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasNo Passing ASDFGHJ','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasNo Passing ASDFGHJ" when Map($map : this) Map(StringUtils.isBlank(this["aaasELACutASDFGHJ"])) Map(StringUtils.isBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isBlank(this["aaasScienceCutASDFGHJ"])) Map(StringUtils.isBlank(this["aaasSocialStudiesCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasPassingStandard"])) then errorList.add(new ValidationError("aaasPassingStandard", "aaas Passing Cut ASDFGHJs must be populated before entering a value in the aaas Passing Standard field.", "aaasPassingStandard", "aaas Passing Cut ASDFGHJs must be populated before entering a value in the aaas Passing Standard field.")); end',0,'validation','aaas Passing Cut ASDFGHJs must be populated before entering a value in the aaas Passing Standard field.','aaas Passing Cut ASDFGHJs must be populated before entering a value in the aaas Passing Standard field.','If there is no aaas Passing ASDFGHJs, then there should not be a value saved in the aaas Passing Standard field','ae825b8aa81f11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only3','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only3" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) then errorList.add(new ValidationError("aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','1323cb5ba82311e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasScience CutP Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasScience CutP Std" when Map($map : this) Map(this["aaasScienceCutASDFGHJ"] != "2100") Map(this["aaasPassingStandard"] == "P") then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "The aaasSCIENCEPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is \\"P.\\"", "aaasScienceCutASDFGHJ", "The aaas Science Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is \\"P.\\"")); end',0,'validation','The aaasSCIENCEPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is "P."','The aaas Science Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is "P."','Rule to validate the aaas Science Cut ASDFGHJ when the Passing Standard is "P".','62de359a7c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ELL Year ELL Plan Determined','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ELL Year ELL Plan Determined" when Map($map : this) Map(this["ellYearELLPlanDetermined"] < "2014") Map(StringUtils.isNotBlank(this["ellYearELLPlanDetermined"])) then errorList.add(new ValidationError("ellYearELLPlanDetermined", "2014 is the earliest year that is valid for the Year ELL Plan Determined data field.", "ellYearELLPlanDetermined", "2014 is the earliest year that is valid for the Year ELL Plan Determined data field.")); end',0,'validation','2014 is the earliest year that is valid for the Year ELL Plan Determined data field.','2014 is the earliest year that is valid for the Year ELL Plan Determined data field.','This rule validates the Year ELL Plan Determined is equal to or greater than 2014.','24ac8aae9d2511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Zeros','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Zeros" when Map($map : this) Map(this["code"] == "000000000") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "0"s.','8023580a4a9911e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasSS CutP Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasSS CutP Std" when Map($map : this) Map(this["aaasSocialStudiesCutASDFGHJ"] != "2100") Map(this["aaasPassingStandard"] == "P") then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "The aaasSOCIALSTUDIESPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is \\"P.\\"", "aaasSocialStudiesCutASDFGHJ", "The aaas Social Studies Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is \\"P.\\"")); end',0,'validation','The aaasSOCIALSTUDIESPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is "P."','The aaas Social Studies Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is "P."','Rule to validate the aaas Social Studies Cut ASDFGHJ when the Passing Standard is "P".','f7b5b2067c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only3','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only3" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','af221e08a82511e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Ones','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Ones" when Map($map : this) Map(this["code"] == "111111111") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "1"s.','e8d0d0ea4a9211e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only3','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only3" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','2a0906bda8b811e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Twos','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Twos" when Map($map : this) Map(this["code"] == "S22222222") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "2"s.','616c73cd4a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only8','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only8" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','d7e40afda8bb11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only17','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only17" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','0b970f55a8bb11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only13','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only13" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','f6ec86f0a8bc11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only16','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only16" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','61f18e73a82b11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Ones','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Ones" when Map($map : this) Map(this["code"] == "S11111111") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "1"s.','5f1e6d9e4a9a11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only4','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only4" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) then errorList.add(new ValidationError("aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasReadingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','389182f4a82311e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasSS Cut1 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasSS Cut1 Std" when Map($map : this) Map(this["aaasSocialStudiesCutASDFGHJ"] != "2067") Map(this["aaasPassingStandard"] == "1") then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "The aaasSOCIALSTUDIESPASSINGCUTASDFGHJ must be 2067 if the aaasPASSINGSTANDARD is \\"1.\\"", "aaasSocialStudiesCutASDFGHJ", "The aaas Social Studies Passing Cut ASDFGHJ must be 2067 if the aaas Passing Standard is \\"1.\\"")); end',0,'validation','The aaasSOCIALSTUDIESPASSINGCUTASDFGHJ must be 2067 if the aaasPASSINGSTANDARD is "1."','The aaas Social Studies Passing Cut ASDFGHJ must be 2067 if the aaas Passing Standard is "1."','Rule to validate the aaas Social Studies Cut ASDFGHJ when the Passing Standard is "1".','0be8cfcb7c1611e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Eights','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Eights" when Map($map : this) Map(this["code"] == "888888888") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "8"s.','1233adce4a9811e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasSNo Passing ASDFGHJ','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasSNo Passing ASDFGHJ" when Map($map : this) Map(StringUtils.isBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isBlank(this["aaassMathCutASDFGHJ"])) Map(this["TNumber"] >= "1") then errorList.add(new ValidationError("TNumber", "aaasS Passing Cut ASDFGHJs must be populated before entering a value in the TNumber field", "TNumber", "aaasS Passing Cut ASDFGHJs must be populated before entering a value in the TNumber field")); end',0,'validation','aaasS Passing Cut ASDFGHJs must be populated before entering a value in the TNumber field','aaasS Passing Cut ASDFGHJs must be populated before entering a value in the TNumber field','If there is no aaasS passing ASDFGHJs, then there should not be anything saved in the TNumber field','97f8d47da81f11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasELA Cut2 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasELA Cut2 Std" when Map($map : this) Map(this["aaasELACutASDFGHJ"] != "2045") Map(this["aaasPassingStandard"] == "2") then errorList.add(new ValidationError("aaasELACutASDFGHJ", "The aaasELAPASSINGCUTASDFGHJ must be 2045 if the aaasPASSINGSTANDARD is \\"2.\\"", "aaasELACutASDFGHJ", "The aaas ELA Passing Cut ASDFGHJ must be 2045 if the aaas Passing Standard is \\"2.\\"")); end',0,'validation','The aaasELAPASSINGCUTASDFGHJ must be 2045 if the aaasPASSINGSTANDARD is "2."','The aaas ELA Passing Cut ASDFGHJ must be 2045 if the aaas Passing Standard is "2."','Rule to validate the aaas ELA Cut ASDFGHJ when the Passing Standard is "2".','03080dc47c1511e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only11','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only11" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','afcf1cf9a82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG Last 4 Characters Are Zero','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG Last 4 Characters Are Zero" when Map($map : this) Map(this["code"] matches "^.{5}0{4}$") Map(this["code"] not matches "^S.{4}0{4}$") then errorList.add(new ValidationError("code", "ABCDESFG cannot have zeroes in positions 69 unless the first character is an \\"S.\\"", "code", "ABCDESFG cannot have zeroes in positions 69 unless the first character is an \\"S.\\"")); end',0,'validation','ABCDESFG cannot have zeroes in positions 69 unless the first character is an "S."','ABCDESFG cannot have zeroes in positions 69 unless the first character is an "S."','This validation is to trap ABCDESFGs with zeroes in positions 69, without an "S" in position 1.','8004b4be9de711e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only1','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only1" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','2296787ba82511e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Sevens','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Sevens" when Map($map : this) Map(this["code"] == "777777777") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "7"s.','05f1da9a4a9811e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only4','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only4" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','06e09cffa82611e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only8','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only8" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','eef03a4ea82911e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only18','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only18" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','28561577a8bb11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Sevens','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Sevens" when Map($map : this) Map(this["code"] == "S77777777") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "7"s.','e43f90c34a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only4','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only4" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) then errorList.add(new ValidationError("aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassMathCutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','524cb343a8b911e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Zeros','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Zeros" when Map($map : this) Map(this["code"] == "S00000000") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "0"s.','23bf04d74a9c11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only9','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only9" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','234a7403a8bc11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only13','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only13" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasELACutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','507bf7afa8ba11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ASDFGHJKLQWE ASDFGHJ Only1','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ASDFGHJKLQWE ASDFGHJ Only1" when Map($map : this) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) then errorList.add(new ValidationError("aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.", "aaassELACutASDFGHJ", "If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.")); end',0,'validation','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','If there are aaasS passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaas.','1477c62ea82c11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasELA CutP Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasELA CutP Std" when Map($map : this) Map(this["aaasELACutASDFGHJ"] != "2100") Map(this["aaasPassingStandard"] == "P") then errorList.add(new ValidationError("aaasELACutASDFGHJ", "The aaasELAPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is \\"P.\\"", "aaasELACutASDFGHJ", "The aaas ELA Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is \\"P.\\"")); end',0,'validation','The aaasELAPASSINGCUTASDFGHJ must be 2100 if the aaasPASSINGSTANDARD is "P."','The aaas ELA Passing Cut ASDFGHJ must be 2100 if the aaas Passing Standard is "P."','Rule to validate the aaas ELA Cut ASDFGHJ when the Passing Standard is "P".','b52bccf87c1411e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only12','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only12" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','c91dcfa8a82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG S and All Eights','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG S and All Eights" when Map($map : this) Map(this["code"] == "S88888888") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.", "code", "Invalid ABCDESFG, [S] followed by one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be an [S] followed by one digit repeated.','Invalid ABCDESFG, [S] followed by one digit repeated.','A ABCDESFG cannot be "S" followed by eight "8"s.','f5ac41804a9b11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only10','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only10" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasSocialStudiesCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasReadingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasSocialStudiesCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','2e1777fda82a11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only5','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only5" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','04b950dca82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasSS Cut2 Std','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasSS Cut2 Std" when Map($map : this) Map(this["aaasSocialStudiesCutASDFGHJ"] != "2033") Map(this["aaasPassingStandard"] == "2") then errorList.add(new ValidationError("aaasSocialStudiesCutASDFGHJ", "The aaasSOCIALSTUDIESPASSINGCUTASDFGHJ must be 2033 if the aaasPASSINGSTANDARD is \\"2.\\"", "aaasSocialStudiesCutASDFGHJ", "The aaas Social Studies Passing Cut ASDFGHJ must be 2033 if the aaas Passing Standard is \\"2.\\"")); end',0,'validation','The aaasSOCIALSTUDIESPASSINGCUTASDFGHJ must be 2033 if the aaasPASSINGSTANDARD is "2."','The aaas Social Studies Passing Cut ASDFGHJ must be 2033 if the aaas Passing Standard is "2."','Rule to validate the aaas Social Studies Cut ASDFGHJ when the Passing Standard is "2".','1aa0d5f07c1611e580a812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Fives','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Fives" when Map($map : this) Map(this["code"] == "555555555") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "5"s.','dda83e344a9711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only7','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only7" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) then errorList.add(new ValidationError("aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasWritingCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','3ba22a5aa82411e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only5','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only5" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasWritingCutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','206c96dba82611e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only17','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only17" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaassELACutASDFGHJ"])) then errorList.add(new ValidationError("aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasMathCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','7caaafdaa82b11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'aaasPassing ASDFGHJ Only9','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "aaasPassing ASDFGHJ Only9" when Map($map : this) Map(StringUtils.isNotBlank(this["aaasScienceCutASDFGHJ"])) Map(StringUtils.isNotBlank(this["aaasMathCutASDFGHJ"])) then errorList.add(new ValidationError("aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.", "aaasScienceCutASDFGHJ", "If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.")); end',0,'validation','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','If there are aaas passing ASDFGHJs, then there cannot be ASDFGHJs for aaas or aaasS.','0ae3c97aa82a11e58b921252fbd63c63'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Date of Birth less than Current Date','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Date of Birth less than Current Date" when Map($map : this) Map(new SimpleDate(this["dateOfBirth"]) >= new SimpleDate("currentDate")) then errorList.add(new ValidationError("null", "The student birthdate cannot be greater than or equal to the current date.", "null", "The student birthdate cannot be greater than or equal to the current date.")); end',0,'validation','The student birthdate cannot be greater than or equal to the current date.','The student birthdate cannot be greater than or equal to the current date.','','4ba823a6e71a11e6b5df12391312caa2'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'ABCDESFG All Sixes','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "ABCDESFG All Sixes" when Map($map : this) Map(this["code"] == "666666666") then errorList.add(new ValidationError("code", "The ABCDESFG is invalid. The MMMMcannot be all the same digit.", "code", "Invalid ABCDESFG, one digit repeated.")); end',0,'validation','The ABCDESFG is invalid. The MMMMcannot be all the same digit.','Invalid ABCDESFG, one digit repeated.','A ABCDESFG cannot be nine "6"s.','f65fa0ff4a9711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'OrgCodeCampus','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "OrgCodeCampus" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(this["code"] not matches "[09]{9}") then errorList.add(new ValidationError("code", "Invalid Organization Code", "code", "Invalid Organization Code")); end',0,'validation','Invalid Organization Code','Invalid Organization Code','Campus code must be 9 bytes.','9643d945393511e4b1c4120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'viewCampus','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "viewCampus" when Map($map : this) Map(this["campusType"] matches "00|01|02") then errorList.add(new ValidationError("null", "null", "null", "null")); end',0,'view',null,null,'viewable only at campus','db5f2776392011e4b1c4120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'OrgCodeDistrict','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "OrgCodeDistrict" when Map($map : this) Map(this["orgTypeCode"] matches "02") Map(this["code"] not matches "[09]{6}") then errorList.add(new ValidationError("code", "Invalid Organization Code", "code", "Invalid Organization Code")); end',0,'validation','Invalid Organization Code','Invalid Organization Code','Must be 6 bytes numeric.','e4d4eac9393611e4b1c4120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'viewDistrict','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "viewDistrict" when Map($map : this) Map(this["districtType"] matches "00|01|03") Map(this["districtCustomerNumber"] matches "00|01|03") then errorList.add(new ValidationError("null", "", "null", "")); end',0,'view',null,null,'viewable only at district ','979b22df392011e4b1c4120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'viewDistrictCampus','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "viewDistrictCampus" when Map($map : this) Map(this["orgTypeCode"] matches "00|01") then errorList.add(new ValidationError("null", "", "null", "")); end',0,'view',null,null,'viewable only at district and campus','9dec3e23391c11e4b1c4120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Blank District Customer Number','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Blank District Customer Number" when Map($map : this) Map(this["orgTypeCode"] matches "02") Map(StringUtils.isBlank(this["districtCustomerNumber"])) then errorList.add(new ValidationError("districtCustomerNumber", "District Customer Number must be provided for each District.", "districtCustomerNumber", "No District Customer Number provided for record type = District.")); end',1,'validation','District Customer Number must be provided for each District.','No District Customer Number provided for record type = District.','District Customer Number must not be blank for a district.','001846235d8411e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'OrgCodeRegion','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "OrgCodeRegion" when Map($map : this) Map(this["orgTypeCode"] matches "01") Map(this["code"] not matches "[09]{2}") then errorList.add(new ValidationError("code", "Invalid Organization Code", "code", "Invalid Organization Code")); end',0,'validation','Invalid Organization Code','Invalid Organization Code','Must be 2 byte numeric','199debc1393711e4b1c4120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Campus Type Required','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Campus Type Required" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isBlank(this["campusType"])) then errorList.add(new ValidationError("campusType", "Campus Type cannot be blank", "campusType", "Campus Type cannot be blank")); end',0,'validation','Campus Type cannot be blank','Campus Type cannot be blank','Campus Type cannot be blank','4ef91e149d2a11e6af8412cb4fae369f'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'OrgCodeRegion2','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "OrgCodeRegion2" when Map($map : this) Map(this["orgTypeCode"] matches "01") Map(this["code"] not matches "01|02|03|04|05|06|07|08|09|10|11|12|13|14|15|16|17|18|19|20|21") then errorList.add(new ValidationError("code", "Invalid Organization Code", "code", "Invalid Organization Code")); end',0,'validation','Invalid Organization Code','Invalid Organization Code','Validate Region is from 01 to 21.','e2f002d2566e11e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Display on District records only','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Display on District records only" when Map($map : this) Map(this["orgTypeCode"] matches "00|01|03") then errorList.add(new ValidationError("null", "null", "null", "null")); end',0,'view',null,null,'','39c2afb00fbf11e597a6120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'OrgRegionNumber','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "OrgRegionNumber" when Map($map : this) Map(this["orgTypeCode"] matches "02|03") Map(this["regionNumber"] not matches "01|02|03|04|05|06|07|08|09|10|11|12|13|14|15|16|17|18|19|20|21") Map(StringUtils.isNotBlank(this["regionNumber"])) then errorList.add(new ValidationError("regionNumber", "Invalid Region Number", "regionNumber", "Invalid Region Number")); end',0,'validation','Invalid Region Number','Invalid Region Number','Validate Region Number is from 01 to 21 on District and Campus records.','faf0a266567011e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'Display on Campus records only','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "Display on Campus records only" when Map($map : this) Map(this["orgTypeCode"] matches "00|01|02") then errorList.add(new ValidationError("null", "null", "null", "null")); end',0,'view',null,null,'','64a0ad540fbf11e597a6120a7699a4ab'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'District Type Required','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "District Type Required" when Map($map : this) Map(this["orgTypeCode"] matches "02") Map(StringUtils.isBlank(this["districtType"])) then errorList.add(new ValidationError("districtType", "District Type cannot be blank", "districtType", "District Type cannot be blank")); end',0,'validation','District Type cannot be blank','District Type cannot be blank','District Type field cannot be blank. ','edfad01e9d2911e6af8412cb4fae369f'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CEmail on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CEmail on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["email"])) then errorList.add(new ValidationError("email", "A Contact Email address cannot be defined for a Campus type record.", "email", "A Contact Email address cannot be defined for a Campus.")); end',0,'validation','A Contact Email address cannot be defined for a Campus type record.','A Contact Email address cannot be defined for a Campus.','Prevent a contact email address being defined for a Campus record.','57678eb65d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CState on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CState on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["state"])) then errorList.add(new ValidationError("state", "A Contact State cannot be defined for a Campus type record.", "state", "A Contact State cannot be defined for a Campus.")); end',0,'validation','A Contact State cannot be defined for a Campus type record.','A Contact State cannot be defined for a Campus.','Prevent a contact state being defined for a Campus record.','007c175b5d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CTitle on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CTitle on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["title"])) then errorList.add(new ValidationError("title", "A Contact Title cannot be defined for a Campus type record.", "title", "A Contact Title cannot be defined for a Campus.")); end',0,'validation','A Contact Title cannot be defined for a Campus type record.','A Contact Title cannot be defined for a Campus.','Prevent a contact title being defined for a Campus record.','403aa3665d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CFax on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CFax on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["fax"])) then errorList.add(new ValidationError("fax", "A Contact Fax number cannot be defined for a Campus type record.", "fax", "A Contact Fax number cannot be defined for a Campus.")); end',0,'validation','A Contact Fax number cannot be defined for a Campus type record.','A Contact Fax number cannot be defined for a Campus.','Prevent a contact fax number being defined for a Campus record.','a330a33e5d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CZip on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CZip on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["zip"])) then errorList.add(new ValidationError("zip", "A Contact Zip code cannot be defined for a Campus type record.", "zip", "A Contact Zip code cannot be defined for a Campus.")); end',0,'validation','A Contact Zip code cannot be defined for a Campus type record.','A Contact Zip code cannot be defined for a Campus.','Prevent an address zip code being defined for a Campus record.','1c409ff65d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CAddress 1 on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CAddress 1 on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["addressLine1"])) then errorList.add(new ValidationError("addressLine1", "A Contact Address 1 cannot be defined for a Campus type record.", "addressLine1", "A Contact Address 1 cannot be defined for a Campus.")); end',0,'validation','A Contact Address 1 cannot be defined for a Campus type record.','A Contact Address 1 cannot be defined for a Campus.','Prevent a contact address 1 being defined for a Campus record.','ab6c3b1f5d8611e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CName on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CName on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["name"])) then errorList.add(new ValidationError("name", "A Contact Name cannot be defined for a Campus type record.", "name", "A Contact Name cannot be defined for a Campus.")); end',0,'validation','A Contact Name cannot be defined for a Campus type record.','A Contact Name cannot be defined for a Campus.','Prevent a contact name being defined for a Campus record.','e6099e005d8411e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CAddress 2 on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CAddress 2 on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["addressLine2"])) then errorList.add(new ValidationError("addressLine2", "A Contact Address 2 cannot be defined for a Campus type record.", "addressLine2", "A Contact Address 2 cannot be defined for a Campus.")); end',0,'validation','A Contact Address 2 cannot be defined for a Campus type record.','A Contact Address 2 cannot be defined for a Campus.','Prevent a contact address 1 being defined for a Campus record.','c13fd8ff5d8611e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CPhone Ext on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CPhone Ext on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["phoneExtension"])) then errorList.add(new ValidationError("phoneExtension", "A Contact Phone Extension cannot be defined for a Campus type record.", "phoneExtension", "A Contact Phone Extension cannot be defined for a Campus.")); end',0,'validation','A Contact Phone Extension cannot be defined for a Campus type record.','A Contact Phone Extension cannot be defined for a Campus.','Prevent a contact phone extension being defined for a Campus record.','81af1d6d5d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CPhone on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CPhone on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["phone"])) then errorList.add(new ValidationError("phone", "A Contact Phone Number cannot be defined for a Campus type record.", "phone", "A Contact Phone Number cannot be defined for a Campus.")); end',0,'validation','A Contact Phone Number cannot be defined for a Campus type record.','A Contact Phone Number cannot be defined for a Campus.','Prevent a contact phone number being defined for a Campus record.','6d99befc5d8711e587c812d3f6ced045'), ((select fk.`id` from `test_tg`.`table_b` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_c` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),(select fk.`id` from `test_tg`.`table_d` fk where fk.`field_6`='3eb493bd346411e4b1c4120a7699a4ab'),'CCity on Campus Record','import java.util.Map; import java.util.List; import com.myproject.testPackage.service.common.ValidationError; import com.myproject.testPackage.service.object.Class2; import com.myproject.testPackage.service.common.SimpleDate; import org.apache.commons.lang3.StringUtils; global java.util.List errorList rule "CCity on Campus Record" when Map($map : this) Map(this["orgTypeCode"] matches "03") Map(StringUtils.isNotBlank(this["city"])) then errorList.add(new ValidationError("city", "A Contact City cannot be defined for a Campus type record.", "city", "A Contact City cannot be defined for a Campus.")); end',0,'validation','A Contact City cannot be defined for a Campus type record.','A Contact City cannot be defined for a Campus.','Prevent a contact city being defined for a Campus record.','e21e0bf75d8611e587c812d3f6ced045'); rollback; END;; DELIMITER ;