Routing Rules on Student Tracking System (ist2pkg.sql) in progress


This package is used to send the emails to personnel and/or students during the identification of students at risk {SSTUDTO-1} as well as during the management of the students at risk {SSTUDTO-2}. The record created when the email is kicked off can be viewed on {GROU-2}.



Prerequisites to use this option

1 Personnel email
2 Mail subject
3 Outcome: RISK=RSK,FIN=FIN,ADMIN=ADM,STUD=RAS
4 Image(intervention)
5 Personnel number (student assigned to)
6 Personnel name
7 Run sequence number
8 Run date
9 Person that action the route - number,name
10 Role description (of person student assigned to)
11 Role level (Institution, Faculty, Department)
12 Level code description
13 Number of students
14 Student number
15 Student name
16 Subject code and description
17 Qualification code and description
18 Mark type
19 Group type and group
20 Mark number
21 Routing Number
22 Risk code
23 Status code
24 Risk type (Academic,Financial,Socio)
25 Risk description
26 Status description

1 Student email
2 Mail subject
3 Outcome: STUD=STD,RISK=RSK,STUD=RAS
4 Image
5 Personnel number (that action the route)
6 Personnel name
8 Run date
9 Person assign to student - number,name
10 Role description (of person that action the route)
11 Role level (Institution, Faculty, Department)
12 Level code description
13
14 Student number
15 Student name
25 Message to student as enter in the message content field
Following lines for RISK only
7 Run sequence number (RISK only)
16 Subject code and description 
17 Qualification code and description 
18 Mark type
19 Group type and group
20 Mark number
21 Routing number
22 Risk code 
23 Status code 
24 Intervention code and description
26 Risk type (Academic,Financial,Socio)
27 Risk description
28 Status description
29 Intervention description

Possible routing sequences kicked off for the different routing types involved:

 Entry Type Outcome Sequence number Origin
STS2 - Email RSK 5 SSTUDTO-1
FIN 10 SSTUDTO-1
ADM 15 SSTUDTO-1
RAS 20 SSTUDTO-2 (risks)
iEnabler
STS2 - SMS RSK 50 SSTUDTO-1
FIN 100 SSTUDTO-1
ADM 150 SSTUDTO-1
RAS 200 SSTUDTO-1
STS3 - Email STD 5 SSTUDTO-2 (master)
A 10  SSTUDTO-2 (intervention)
  RAS 20 SSTUDTO-2 (risks)
iEnabler
STSS - SMS 20 iEnabler (tick box)
The following lines are used to either display the detail on the email or to write the detail of the email to {GROU-2}.
Email to personnel/student

Procedure Function Description Comments
create_route_STS2 Personnel email detail 
Via {SSTUDTO-1} or {SSTUDTO-2} and Lecturer iEnabler.
    
create_route_STS3 Assigned/Re-assigned - Students at risk
Via {SSTUDTO-1} or {SSTUDTO-2}  and Lecturer iEnabler.
 
InsRouteDetail Detail inserted into {GROU-2}
{SSTUDTO-1}
Routing Number
Sequence
line Number
Remarks
 DoRouteExtras_STS3
Detail for student email into {GROU-2}

Routing Type
ID
Email/user Type
User Code or Email Address
Sequence
Possible Outcome: STUD=STD,RISK=RSK,STUD=RAS,FIN=FIN,ADMIN=ADM
Date
User
Header
Message
Run Sequence
Student Number
Year
Risk
Risks
Intervention
Routing Number





History of Changes

Date System Version By Whom Job Description
28-Jan-2018 v03.0.0.0 Melanie Zeelie t217997 New manual format.
17-May-2018 v03.0.0.1 Melanie Zeelie t227269 New email sms rules added.