Assessment Marks


Assessment Marks as used in {SSTUD1-4} and {SSTUD1-5} - i80pkg.sql



Function/Procedure Name Function Description Comments
get_jdj Parameters:
None
Processing Rules:
Check if the Mark Type record exist for the Student Number, Year, Subject, Subject Number, Group Type, Group, Mark Type
Values to Return:
Return 1 if found		 Used in i80_do_tasks_logic
get_passfail Parameters:
None
Processing Rules:
Get the pass/fail indicator on {SCODE-23} for the Result Code
Values to Return:
Pass/Fail Indicator		 Used in i80_do_tasks_logic
i80Insert Parameters:
Student Number, Year, Subject, Subject Number, Result, Mark Type, Mark Number, Group Type, Outcome, Mark, Result, Level, Comment, Curriculum Link, Assess by Comment
Processing Rules:
Insert on the Assessment with paramenters and Program Name = i80app.fmb
Value to Return:
Assessment Record Inserted		 Used in {SSTUD1-4} and {SSTUD1-5}
i80Query Parameters:
  • resultSet
  • Student Number
  • Year
  • Block
  • Subject
  • Offering Type
  • Mark Type
  • Mark Number
  • Item
  • Not Assessed Indicator
  • Curriculum Link
  • Resubmit
  • Assess by Comment
  • ASSESS (from {SSTUD1-4}) or COMMENT (from {SSTUD1-5})
Processing Rules:
Get all records from {SSTUD1-2} and {TASKS1-1} for the Student Number, Subject, Year, Block, Offering Type, Mark Type en Mark Number. If one of these are empty, give all records found.

  • For {SSTUD1-2} - 
    • Date Bundle Created is NULL
    • Confirm (Declaration date is NULL field will be N, else Y)
    • Number of Submissions = NULL
    • Bundle Nr = Null
    • Origin = 'JCH'
    • Cancel (Cancel date is NULL field N, else Y)
    • Resubmit (funciton i80_get_AssessmRe_submit)
    • When called from {SSTUD1-5} the rubric on the Assessment should have only 1 result for Professional Judgement
    • When called from {SSTUD1-4} the rubric on the Assessment should have more than 1 result for Professional Judgement
    • Not Assessed Indicator is Y, then Assignment Record should have a Result.
  • For {TASKS1-1}
    • Confirm (Declaration date is NULL field will be N, else Y)
    • Number of Submissions (i80pkg.i80SubmissNbr)
    • Origin = 'IEN'
    • Cancel (Cancel date is NULL field N, else Y)
    • When called from {SSTUD1-5} the rubric on the Assessment should have only 1 result for Professional Judgement
    • When called from {SSTUD1-4} the rubric on the Assessment should have more than 1 result for Professional Judgement
    • Not Assessed Indicator is Y, then Assignment Record should have a Result.
      • For {SSTUD1-4}
        • For all Evaluation Types and for professional judgement only records that has more than one result linked to the rubric.
      • For {SSTUD1-5}
        • Only for professional judgement records that has one result linked to the rubric.

Values to Return:
Student Number, Year, Subject, Offering Type, Link Block, Block, Mark Type, Mark Number, Item, Subject Number, Mark Result, Outcome, Type of Evaluation, Date of signing of Declaration, Confirm, Number of Submissions, Bundle Number, Origin, Cancel, Not Assessed Indicator, Curriculum Link, Re-Submit, Assess by Comment 		Core Select for {SSTUD1-4} and {SSTUD1-5}
i80SubmissNbr Parameters:
Student Number, Year, Subject, Link Block, Mark Type, Mark Number, Date
Processing Rules:
Count records of Assignments for:
The Student, Subject, Year, Block,  Mark Type and Mark Number where the date is less than Parameter Date
Value to Return:
Number of Subnmissions		 Used in {SSTUD1-4} and {SSTUD1-5}
i80Update Parameters:
Student Number, Year, Subject, Subject Number, Mark Type, Mark Number, Group Type, Outcome, Level, Comment, Mark, Result, Curriculum Link, Assess by Comment
Processing Rules:
The following fields will be updated on Assessment Record: Outcome, Level, Commment, Mark, Result, Curriculum Link, Assess by Comment
The following fields will be updated on Assignment Record: Comment, Mark, Result, Date of signing of Declaration, Level, Resubmit, Assess by Comment
Value to Return:
Assessment or  Assignment Record will be updated		 Used in {SSTUD1-4} and {SSTUD1-5}
i80_create_ass_allowed Parameters:
Mark Type
Processing Rules:
Get the Field "Create of Assessments Allowed" from {SCODE-10} for the Mark Type, if the field is 'Y' and the the field "Mark Type Use" is not "I" (Incidental Learning) then return value Y, for any other value make the return value N
Value to Return:
Return Value 		Used in {SSTUD1-4} and {SSTUD1-5}
i80_cycle_open Parameters:
Type, Year, Block, Offering Type
Processing Rules:
Is the cycle open for the paramenters and is system date between start and end date of the cycle then the return value is True, else the return value is False
Value to Return:
Return Value		 Used in {SSTUD1-4} and {SSTUD1-5}
i80_do_mark_logic Parameters:
Student Number, Year, Block Code, Offering Type, Bundle, Subject, Mark Number, Mark Type, Group Type, Group
Processing Rules:
Is there another Bundle records for this Assessment where the Mark is not null?
If not, Test if the Maximum Mark from {SSTUDE-1} is less than the Mark of the Bundle, then make the Mark the same as on {SSTUDE-1}

Get the Result Code from {SSTUDE-3} for the Mark between Low and High, if more than one row on {SSTUDE-3} because of overlapping criteria, then make Result NULL.
Value to Return:
Return Value - Mark and Result code		 Used in {SSTUD1-4} and {SSTUD1-5}
i80_do_tasks_logic Parameters:
Student Number, Year, Subject, Subject Number, Mark Number, Mark Type, Group Type, Group, Offering Type, Evaluation Type, Rubric Code, Mark, Result, Level, Outcome, Sign Decleration Date, Comment, Program Name
Processing Rules:
Get the Mark, Result, Outcome, Level, Sign Decleration Date from Assessment Record and Rubric Code from {SSTUD3-7}
Get value of the SOD (NT,SR)

Use function i80_get_ietval('CS','TS') to see if validation is set on
if validation is Y then do function set_submin
if validation is N then set value of submin to 999

If Evaluation Type is Objective Evaluation
  • check if assessment record should be updated with input parameters - and set update_indicator to TRUE
  • in case where marks are the same check if confirmation received or if result/level changed from default - and set update_indicator to TRUE
  • check if level changed - and set update_indicator to TRUE
  • check if result changed - and set update_indicator to TRUE
  • when marks are different but do not satisfy better mark/subminimum rule the program ignore confirmation/result/level as this is not the IEN that is copied into JCH make return message 'i80pkg:Assessment Record not updated! Better Mark and/or Subminimum rule not satisfied!'
 
If Evaluation Type is Competance Evaluation
  • check if pass/fail indicator for the result changes from fail/null to pass  - and set update_indicator to TRUE
  • check if confirmation done on Assignment (IEN) record with the same pass/fail indicator for the result on Assessment (JCH) record - and set update_indicator to TRUE
  • check if level changed - and set update_indicator to TRUE
  • else results differ but do not satisfy better result rule make the return message ' i80pkg:Assessment Record not updated! Better Result rule not satisfied!'
 
If Evaluation Type is Professional Judgement Evaluation
  • check if sequnece of rubric new result higher then previous result's sequence use i80_get_resseq - and set update_indicator to TRUE
  • if the sequences above is equal, check if confirmation done on Assignment (IEN) record and not on the Assessment (JCH) record - and set update_indicator to TRUE
  • check if level changed - and set update_indicator to TRUE
  • check if Assess by Comment is not the same - and set update_indicator to TRUE
  • when results are different but do not satisfy better result rule the program ignore confirmation/level as this is not the Assignment (IEN) recird that is copied into the Assessment Record (JCH) make the return message 'i80pkg:Assessment Record not updated! Better Result rule not satisfied!'
If update_indicator is TRUE, then update the following fields on the Assessment Record:
Mark, Result, Level, Outcome, Sign Decrelation Date, Assess by Comment,User and Program Name.

Use function get_jdj, if the value is 0 (Zero) then insert a Mark Type Record for the Student

Use function get_sodntsr_rec to get the value of the result that should be ignorred,
If the result on the SOD is not the same as the result that we want to update on Assessment (JCH) record then
create the Assessment Record for the Student

If the Evalutation Type is not one of the above (Objective, Competance or Professional Judgment give return message 'i80pkg:Invalid or missing Assessment Evaluation Type'
Value to Return:
Return Value - Message		 Used in {SSTUD1-4} and {SSTUD1-5}
i80_get_AssessmRe_submit Parameters:
Student Number, Year, Subject, Group Type, Mark Type, Mark Number
Processing Rules:
Get the resubmit for the last record for Assignments
Value to Return:
Assignment Resubmit
 Used in {SSTUD1-4} and {SSTUD1-5}
i80_get_ietval Parameters:
Validation Code, Subsystem
Processing Rules:
Get the validation Yes/No indicator from {SMNT-1} for the code and subsystem
Value to Return:
Validation Yes/No Indicator
 Used in i80_do_tasks_logic
i80_get_resseq Parameters:
Result Code, Rubric Code
Processing Rules:
Get the result sequence of the rubric from {SSTUD3-26}
Value to Return:
Result Sequence
 Used in i80_do_tasks_logic
i80_incidental_learning Parameters:
Mark Type
Processing Rules:
Get the Field "Mark Type Use" from {SCODE-10} for the mark type, if the field is 'I' then return value Y, for any other value make the return value N
Value to Return:
Return Value		 Used in {SSTUD1-5}
i80_no_of_submissions Parameters:
Indicator, Student Number, Link Block, Block, Offering Type, Bundle, Insert/Update Indicator
Processing Rules:
Get Maximum number of Assignments, Subject, Mark Number, Mark Type and Group Type for the Parameters, Bundle, Cyear, Link Block, Indicator, Block, Offering Type

Include submission rule on activity {TASKS1-8} = Y, then count bundle records for the student number, subject, year, Mark Number,  Indicator,  Block, Mark Type, Group Type and Resubmit not equal to Y and Result not equal to SOD (NT, SR)

 If Maximum number of Assignments is less or equal to Count of Submissions, if Insert/Update indicator = U then return value 'This is the last submission of this assessment allowed for this student.'. if Insert/Update indicator = I then return value is 'The maximum submissions allowed has been reached.No further submissions allowed.'
Value to Return:
Return Value		 Used in {SSTUD1-4} and {SSTUD1-5}
i80_validate_iem Parameters:
Year, Block, Bundle Number
Processing Rules:
If no Marker linked to bundle return value of "Marker not linked to the bundle XXX".
If no Marker Date return value of 'Missing bundle XXX Mark Date  DD-MON-YYYY
If Marker is not Null and Update of Activity is not Y, return value 'Activity linked to the bundle XXX must  allow update of Assessment Records.'
Value to Return:
Return Value		 Used in {SSTUD1-4} and {SSTUD1-5}
set_submin Parameters:
None
Processing Rules:
Get the sub minimum from {SSTUD3-7} for the subject, year, mark type, mark number, offering type, group type and group.
if no record on {SSTUD3-7} make subminimum 0 (Zero)
if record exist but no value in sub minimum then make value 100
Value to Return:
Sub minimum
 Used in i80_do_tasks_logic


See Also:



History of Changes

Date System Version By Whom Job Description
20-Aug-2010 v02.0.0.0 Bea Swart t161601 New manual.
27-Jan-2011 v02.0.0.1 Bea Swart t172079 Complete new manual
14-Aug-2012 v02.0.0.2 Bea Swart t184318 Change manual for Var 035, Var 038 and Var 054
23-Aug-2018
 v04.1.0.0
 Sarah Seeletse
 t226071
 Replace SSTUD3-2 with SSTUDE-1 and SSTUDE-5