Functions called from package i43pkg.sql


This package contains functions that are used in the calculation programs.

Function/Procedure Name Function Description Comments
I43_IS_COMPETENCY To check if the subject is marked as Competency Based on {SACAD-13}, Method of Evaluation is 'C' Used in i41pkg
I43_CHK_ALL_MODULE_RES To check if all the modules linked to the main subject for which the student are registered has a result. Used in {SSTUD4-23}
I43_UPD_PASS_COMP_MODULES    To check if all the compulsory modules linked to the main subject for which the student are registered has a pass result. 

If the type on {SACAD-14} Tab – Pre-requisites is defined as module substitute, and the calculation program {SSTUD4-23} is run, the program checks if all the compulsary modules are passed and if the compulsary module is not found, the check is done on the module substitute type.

 Used in {SSTUD4-23}
I43_UPD_FAIL_SUBMIT_MODULES To check if  results for the modules exists as yet. Used in {SSTUD4-23}
I43_UPD_ABSENT_MODULES To check if any module with 'Absent from exam' result as defined on {SSTUD3-1} exists. Used in {SSTUD4-23}
I43_UPD_FAIL_COMPUL_MODULES To check if any of the compulsory modules has a 'Failed Compulsory' result as defined on {SSTUD3-1} Used in {SSTUD4-23}
I43_UPD_FAIL_SUBMIN_MODULES  To check if any of the compulsory modules has a 'Failed Subminimum' result as defined on {SSTUD3-1} Used in {SSTUD4-23}
I43_UPD_MAIN_MIN_REQ To check if any of the compulsory modules has a 'Minimum Requirements not Met' result as defined on {SSTUD3-1} Used in {SSTUD4-23}
I43_COMPUL_MODULES_REGISTERED To check if the student is enrolled for all Compulsory Modules of not. @If the type on {SACAD-14} Tab – Pre-requisites is defined as module substitute, and the calculation program {SSTUD4-23} is run, the program checks if all the compulsary modules are registered and if the compulsary module is not found, the check is done on the module substitute type.@@ Used in {SSTUD4-23}
I43_CHK_NYC_MODULES     To get the default not yet competent result code and test for existence of not yet competent module. Print Student number and error message, "Not Yet Competent Module - Module: XXXXXXX Exam Year: NNNN Exam Month: NN" Used in {SSTUD4-23}
I43_CHK_ASS_SUBMIT_BUND The program using this procedure must not calculate an assessment result or mark type mark or result if either a Holding Bin or Bundle with no mark exists for any of the assessments.

For Bundles and input from program is:

  • Assessment give error: “No Assessment Result calculated for NNNNNNNNN - assessment submitted but without mark” - Used in {SSTUD4-14}, {SSTUD1-11}
  • Mark give error: “No Mark Type Mark calculated for NNNNNNNNN - assessment submitted but without mark” - Used in {SSTUD4-11}
  • Result give error: “No Mark Type Result calculated for NNNNNNNNN - assessment submitted but without mark” - Used in {SSTUD4-13}

For Holding Bin and input from program is:

  • Assessment give error: “'No Assessment Result calculated for NNNNNNNNN - assessment submitted but not in a bundle.” - Used in {SSTUD4-14}, {SSTUD1-11}
  • Mark give error: “'No Mark Type Mark Assessment Result calculated for NNNNNNNNN - assessment submitted but not in a bundle.” - Used in {SSTUD4-11}
  • Result give error: “'No Mark Type Result Assessment Result calculated for NNNNNNNNN - assessment submitted but not in a bundle.” - Used in {SSTUD4-13}




History Of Changes

Date System Version By Whom Job Description
16-Oct-2007 v01.0.0.0 Melanie Zeelie t137011 New manual format.
02-Sep-2008 V01.0.0.2 Bea Swart t152378 Add I43_CHK_ASS_SUBMIT_BUND
08-Oct-2009 V01.0.0.3 Melanie Zeelie t161368 Add detail regarding module substitute
31-Aug-2010 V02.0.0.0 Bea Swart T164727 I43_CHK_NYC_MODULES, I43_IS_COMPETENCY change to work withCompetence Method of Evaluations. 'C'