Student Tracking System - Evaluation Run Procedures


This package contains functions that are used for Student Tracking Evaluation of students at risk on {SSTUDTO-1}. 



Prerequisites to use this option:

Personnel Roles to be defined on {SSTUDTM-1}.

Define Risk Codes on {SSTUDTC-3}

Link Risk Codes to STS Validation Rules on {SSTUDTM-3}  block 1 and define required barriers on block 3.

Define System Operational Definitions on {SMNT-12}. 

The following SOD's are used for assigning personnel linked to a specific role to a student on {SSTUDTO-2}.

The SOD used for a specific procedure Subject FT E Greater Than (Barrier), to determine the type of credit to be used.
The following SOD's are used to determine the risk code to be written away for emails sent or notes entered on the Master detail on {SSTUDTO-2}
The following SOD's are used to determine if the SMS functionality may be used for the STS.

The sequence linked to run will be unique and is programmatically handled to obtain the next available number



Function/Procedure Name Function Description Comments
VALIDATIONMAIN Main Validation

This procedure is to determine which validation rules on {SSTUDTM-3} is active and  to select students for the year on the primary qualification.
Fields
  • Year
  • Student Number
  • Campus
  • Qualification
  • Period Of Study
  • Run Sequence 
  • Run Date
  • Status
  • Student Balance
 Master Record per Run Sequence
FAILASS_MIN

Fail Test/Assessment Sub-minimum

  1. Barrier:  If barrier is NULL, program checks the Sub-minimum for the assessment nr /marktype/grouptype/group value on {SSTUD3-7}, Tab - assessment Mark Criteria
  2. Risk Code detail:  {SSTUDTC-3}
  • Risk Type:  Academic
  • Risk Level : Assessment
 Rule Code Z10
FULL_LESS_BARRIER Year/Full Period Mark Less Than (Barrier)

  1. Barrier: If barrier is NULL, program checks the Sub-minimum for the subject to get exam admission on {SSTUD3-2}, Tab  -  Exam Admission.
  2. Risk Code detail:  {SSTUDTC-3}
  • Risk Type: Academic
  • Risk Level: Subject
 Rule Code Z20
REP_QUAL_SP Repeat Qualification Study Period

  1. No barrier, program checks if the qualification registration count for same study period > 1, for “normal” blocks, not exam only blocks.
  2. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Academic
  • Risk Level: Qualification
 Rule Code Z30
REP_SUBJ_1 1st Repeat Of Subject
  1. No Barrier set: When subject was registered for in previous years = 1 (normal registration), and now registered again. The count is done irrespective of the previous result codes on the subject.
  2. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Academic
  • Risk Level: Subject
 Rule Code Z40
REP_SUBJ_2 2nd Repeat Of Subject

  1. No Barrier set: When subject was registered for in previous years = 2 (normal registration), and now registered again. The count is done irrespective of the previous result codes on the subject.
  2. Risk Code: {SSTUDTC-3}.
  • Risk Type: Academic
  • Risk Level: Subject
 Rule Code Z50
REP_SUBJ_3 3rd Or More Repeats Of Subject
  1. No Barrier set: When subject was registered for previous years = 3  (normal registration) and now registered again. The count is done irrespective of the previous result codes on the subject.
  2. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Academic
  • Risk Level: Subject
 Rule Code Z60: 
FTE_BARRIER Subject FT E Greater Than (Barrier)
  1. SOD 'CD' for Sub-system 'SR', to indicate which credits will be used: Internal(I), National(N) on {SACAD-14} Tab Subject , p2 or {SACAD-15} Stats Credits(S).
  2. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Academic
  • Risk Level: Qualification
 Rule  Code Z70
NOT_GRAD Degree not Awarded - Enrolled Time More Than Formal Time + (Barrier)

  1. Barrier set : Rule = Formal Time + Barrier +1 year
  2. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Academic
  • Risk Level: Qualification
 Rule Code Z80
FIN_PERC Current Year Credits Are Less Than Percentage Of Current Year Debits (Barrier), using system date.

  1. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Financial
  • Risk Level: Financial
 Rule code - Z90
FIN_BALANCE Account Balance Greater Than (Barrier), reflects outstanding student balances according to payment agreements.
  1. Risk Code detail:  {SSTUDTC-3}.
  • Risk Type: Financial
  • Risk Level: Financial
  Rule Code Z100
FEED_SCHOOL Socio: Student Coming from Identified Feeder School
  1. Procedure: FEED_SCHOOL
  2. Barrier: List Schools at risk, use LOV
  3. Risk Code: {SSTUDTC-3}.
  • Risk Type: S
  • Risk Level: M
 Rule Code Z110
JUNIOR_LECT Socio: Senior Student Tutored By Junior lecturer

  1. Procedure: JUNIOR_LECT
  2. Barriers
  •  Subject Level from {SACAD-14} - Tab Subject , p2
  • Lecturer Stats Level linked to the rank/post combination on {PBOP-2}.
  1. Risk Code: {SSTUDTC-3}.
  • Risk Type: S
  • Risk Level: L
 Rule Code Z120:
CREDITF Will the student obtain enough credits?

To determine which fields to be populated on the insert into {SSTUDTO-2} , Tab - Risk Detail Per student block 2 for Qualification level Risks

  • Year
  • Student Number
  • Risk Code
  • Status
  • Qualification Code
  • Period of Study
  • Offering Type
  • Indicator = Q
  • Risk Sequence
  • Run Date

Only final year students on {SSTUDY-21} Tab - Qualification Detail will be evaluated.


The function checks if the student will obtain enough credits at the end of the year, for the type defined in parameter  Values are 1 - Stats, 2 - National or 3 - Subject. The minimum number of credits units for graduation is defined on the Qualification {SACAD-13} tab - Qualification page 2 or the minimum credits  for a qualification to be awarded on Qualification Type on {SCODE3-1} Tab -  Qualifications Types. Subjects passed as well as those where the result is NULL will be taken into account.
  • If the sum of the student credits (passed/exempted or no result)< the minimum on the qual or qual type, then student will be identified as a risk.
  • If If the sum of the student credits (passed/exempted or no result)=> the minimum on the qual or qual type, then student will NOT be identified as a risk.

 G1
INSERT_SUBJ_RISK To determine which fields to be populated on the insert into {SSTUDTO-2} , Tab - Risk Detail Per student block 2 for Subject level Risks
                       
  • Year
  • Student Number
  • Risk Code
  • Status
  • Qualification Code
  • Period of Study
  • Offering Type
  • Indicator = S
  • Risk Sequence
  • Run Date
  • Campus
  • Personnel Number
  • Subject Code
  • Subject Number
  • Group Type = C
  • Group Value
INSERT_QUAL_RISK To determine which fields to be populated on the insert into {SSTUDTO-2} , Tab - Risk Detail Per student block 2 for Qualification level Risks

  • Year
  • Student Number
  • Risk Code
  • Status
  • Qualification Code
  • Period of Study
  • Offering Type
  • Indicator = Q
  • Risk Sequence
  • Run Date
INSERT_ASS_RISK To determine which fields to be populated on the insert into {SSTUDTO-2} , Tab - Risk Detail Per student block 2 for Assessment level Risks
Fields:
  • Year
  • Student Number
  • Risk Code
  • Status
  • Subject Code
  • Indicator = A
  • Offering Type
  • Group Type
  • Class Group
  • Mark Type
  • Mark Number
  • Personnel Number
  • Run date
INSERT_SCHOOL_RISK To determine which fields to be populated on the insert into {SSTUDTO-2} , Tab - Risk Detail Per student block 2 for Socio Risks

  • Year
  • Student Number
  • Campus Code
  • Qualification Code
  • Period of Study
  • Offering Type
  • Risk Code
  • School code
  • Personnel Number
  • Status
  • Run Date
INSERT_FIN_RISK To determine which fields to be populated on the insert into {SSTUDTO-2} , Tab - Risk Detail Per student block 2 for Financial Risks

  • Year
  • Student Number
  • Campus Code
  • Risk Code
  • Status
  • Qualification Code
  • Period of Study
  • Offering Type
  • Mark Number
  • Personnel Number
  • Run date




History of Changes

Date System Version By Whom Job Description
24-Feb-2018 v03.0.0.0 Melanie Zeelie T217989 New manual package used by {SSTUDTO-1}
2-May-2018 v03.0.0.1 Melanie Zeelie T227269 New procedure CREDITF rule added.