Annual Result Calculation functions (i8fpkg)

This package contains the rules and functions that are used in the Annual Result Calculation (ARC).

• check across academic years
• for any qualification
• for any study period
• subjects enrolments that are not cancelled
  
• exempted subjects are regarded as pass
• exclude attend only subjects
• check if a substitue subject was passed
  

• Not applicable (A).  This means that the rule does not apply to the particular student scenario.
• Data Problem (D). The function expects parameter values but it does not exist. Users must define the parameter values before the progression stage rule can be excuted.
• Not successful (N). The student did not comply with the requirements of the rule.
• Successful (Y). The student complies with all the requirements of the rule.

Function Name/ Rule/ Detail displayed	Procedure	Rule Set up / Updates
VALIDATIONMAINFUNCTION	Manage the processing of all active auto progression stage rules This function manages the processing of all active annual result calculation rules as defined in {SSTUDP-15} and linked to active stages of the PROG process in {SSTUDP-16}. It performs the following actions for each rule for the student being processed: Check if the rule set up was done Each rule will be evaluated for the student against values indicated in the Set up for the rule. The outcome of each rule evaluated and associated detail is displayed in {SSTUDP-18}.	{SSTUD4-30} Annual Result Compute Rules {SSTUDP-16} Link Auto Progression Stage Rules
CHECK_SP_CREDITS Rule  Z310 Result Success SQLERRM	Check that student has enough credits for SP If the Calculated Credits Passed by the student for all subjects listed in Qualification code, Study Period within Qualification Block is at least Check credit from this Study Period  using Type of credits specified. If true, set Result Success  Successful (Y) if not true, set Result Success to Not successful (N) Credits for subjects linked to this qualification, study period on the Curriculum are available to contribute to the Calculated Credits Passed.	{SACADO-17} Curriculum {SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Check credit from this Study Period, Type of Credits 1-Stats {SACADO-17} Credit 2-National {SACADO-10} National Credit 3 {SACADO-10} Internal Credit
CHECK_NUM_SUBJECTS_SEM Rule Z311 Result Success SQLERRM	Check that student has enough passed subjects for Block If the Number of Subjects Passed by the student for all subjects listed in Qualification code, Study Period with Registration within Qualification Block  and registered subjects within Subject Block List is at least Number of Subjects to Pass If true, set  Result Success  to Successful (Y) If not true, set Result Success to Not successful (N) This rule translates to: Check that the student passed 2 subjects from the second semester (Block 2) and include results from the 2nd exam opportunity (Block A2)	{SACADO-17} Curriculum {SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Number of Subjects to Pass, Subject Block List
CHECK_SUBJ_LIST Rule  Z312 Result Success SQLERRM	Check that student pass enough subjects listed If the Number of Subjects Passed by the student with Registration within Qualification Block and all subjects in Subject List is at least Number of Subjects to Pass. If no value is entered as Number of subjects to Pass, a student must pass all the subjects in the list. If true, set  Result Success  to Successful (Y) If not true, set Result Success to Not successful (N)	{SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Number of subjects to Pass  Subject List
CHECK_SUBJ_EXP_LIST Rule  Z313 Result Success SQLERRM	Check that student pass enough subjects listed and prerequisites If the Number of Subjects Passed by the student with Registration within Qualification Block for all subjects in Subject List and is at least Number of Subjects to Pass and the prerequisites of subjects in Subject List is passed. If no value is entered as Number of subjects to Pass, a student must pass all the subjects in the list. If true, set  Result Success  to Successful (Y) If not true, set Result Success to Not successful (N)	{SACADO-14} Subject Prerequisites {SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Number of subjects to Pass  Subject List
CHECK_ALL_SUBJ_SP Rule  Z314 Result Success SQLERRM	Check that student passed all enrolled subjects for SP Check that student passed all subjects from Curriculum for Check this Study Period  for Qualification code If true, set  Result Success  to Successful (Y) If not true, set Result Success to Not successful (N)	{SACADO-17} Curriculum {SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Check this Study Period
CHECK_ALL_SUBJ Rule Z315 Result Success SQLERRM	Check that student passed all enrolled subject up to SP Check that student passed all subjects from Curriculum for all study periods up to Check up to this Study Period If true, set  Result Success  to Successful (Y) If not true, set Result Success to Not successful (N)	{SACADO-17} Curriculum {SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Check up to this Study Period
CHECK_SUBJGRP_LIST Rule Z316 Results Success SQLERRM	Check that student pass enough subject groups listed If the Number of Subjects Groups Passed by the student is at least Number of subject Groups to Pass from the SubjectGroup  List . If Number of subject Groups to Pass = 0, all subjects in all groups must be passed If true, set  Result Success  to Successful (Y) If not true, set Result Success to Not successful (N)	{SSTUDP-7} Annual Result Calculation Group {SSTUD4-30} Rule parameters: Qualification code, Study Period, Qualification Block Subject Group Study Period, Number of subject Groups to Pass Subject Group List

• Procedures:
• Refer to Annual Result Calculation operational manual for additional information
  
• Refer to Auto promotion operational manual for additional information