Functions called from package i44pkg.sql


This package check completion of Subjects.

Function/Procedure Name Function Description Comments
i44_integrated_subject
Check if subject exist on student assessment, if yes, update student assessment with  Mark, Exempt and Result from {TASKS1-2}, if not insert student assessment record.
For Subject that is marked as a standard on {SACAD-14} Standard Type is not NULL, there can only be one Assessment record, if more than one give error message "More than one assessment for this Mark Type XX"
 
i44_ass_can_complete
This function calls the next 3 functions i44_ass_weight_comp_calc_comp,  i44_ass_compul_best_complete, test this function only if "Complete Only when Assessment Result leads to Pass [Y]es/(N)o" were 'Y' in the input parameters i44_check_fail, if all are passed then subject can complete, if one function failed then subject can't complete. Used in {SSTUD4-15}
i44_ass_weight_comp_calc_comp   Calculate Result after last Assessment Mark Entry is N or NULL on {SSTUD3-2} Tab Exam Admission and Final Result Criteria then give message 'Subject XXXXXXX' not defined to calculate result after the last compulsory assessment mark entry and subject can't complete.
Full Period Mark Weight should be 100 for Method of Evaluation = 'O' Objective Evaluation
If Full Period Mark Weight is not equal to 100 on {SSTUD3-2} Tab Exam Admission and Final Result Criteria and Method of Evaluation is C on {SACAD-14} Tab Subjects then give message 'Full period mark weight < 100%, cannot complete XXXXXXX.. Weight is NNN'% and subject can't complete.
 
i44_ass_compul_best_complete Compulsory assessment outstanding, Subject XXXXXXX will not be completed.
Validation for best nr of tests failed. Subject XXXXXXX will not be completed.
 
i44_check_fail Student failed one or more Assessment(S), Subject XXXXXXX will not be completed.  
i44_AssessmentNeedConfirm Get all the Standards on {SACAD-14} that is linked on the Integrated Assessment Structure {SACAD-12} for the Year, Subject, Offering Type, Group Type and Group, Mark Type and Mark Number.
Send back that Subject needs confirmation
If no records found above, Check if this subject is a standard on {SACAD-14}
Send back that Subject needs confirmation

If no records found above, Subject doesn't need confirmation
Used in {SSTUD1-4}
i44_SubjectConfirmation Loop trough all Assessments for Mark Type/Marknumber combination and check if any of those that need confirmation or have been confirmed
NOTE : if module is 'standard' than all Assessments will require confirmation therefore exculude I - incidental learning on Assessment records.

Exit the loop when first Assessment is found that is not confirmed and give message back 'Confirmation not received for all assessments that require it!'
Used in {SSTUD1-4}




History Of Changes

Date System Version By Whom Job Description
02-Sep-2008 V01.0.0.0 Bea Swart t152378 Create new manual
31-Aug-2010 V02.0.0.0 Bea Swart T164727 i44_ass_weight_comp_calc_comp - Full Period Mark Weight should be 100 for Method of Evaluation 'O'
27-Jan-2011 V02.0.0.1 Bea Swart T172079 Add new functions - i44_AssessmentNeedConfirm and i44_SubjectConfirmation
09-Feb-2012 V02.0.0.2 Bea Swart T176455 Add processing rules for i44_integrated_subject
12-Jul-2012 V02.0.0.3 Bea Swart T184318 Change manuals after work on T173978, T173981, 176455