Functions called from package iy3pkg.sql


This package contains functions that are used to create routing records for student service requests on {SSTUDS-3} and {SNAPPA-3}.



The route type must be defined on {GROU-1} and linked to the Service Request Code on {SSTUDS-1}.

The Organization structure code could be setup in {GCS-10} and then linked to the routing process via sequence 0(Zero). This could then be used to substitute a user/email address for the routing process.



Function/Procedure Name Function Description Comments
Public Procedures and Functions
create_route  This procedure is used to start a new route for the given service request
set_outcome   This procedure will populate the Student Notes table with the outcome
  • It is used to update the note amendment at every stage of the route. This procedure updates line with the date on which the student has been updated, thus the sysdate. The procedure will be used in {GROU-1}, TAB - User/Routing Sequences, at different stages(sequences) within the validation route.
  • The procedure selects the note number from the seq 0 of a route. The note number will be written to line 30 and the last date a note was amended will be updated on line 29.
Private Procedures and Functions
DoRouteExtras    A private procedure to create Extra Detail on Sequence 0 (Zero):
Line Parameter Detail for Student Service Requests
1 Service request number
2 Service request sequence
3 Service request service code
4 Service : xxxx - xxxxxxxxxx
5 Student Number
6 Student Email Address
7 Student : xxxx - xxxxxxxxxx
8 Email Address : xxxxxxxxxxxxxxxxx
9 Year
10 Year : xxxx
11 Assesmen(T)/(E)xam paper Indicator
12 T ==> Indicator : Assessment
E ==> Indicator : Exam Paper
13 Block Code
14 Block :xxxx - xxxxxxxxxx
15 S/Q Indicator
16 S/Q Code
17 Q ==> Qualification : xxxx - xxxxxxxxxx
S ==> Subject : xxxx - xxxxxxxxxx
18 Department Code
19 Department : xxxx - xxxxxxxxxx
20 Group Type
21 Group Value
22 C ==> Class Group : xxxx
P ==> Practical Group : xxxx
T ==> Tutorial Group : xxxx
E ==> Exam Group : xxxx
? == > xxxx : xxxx
23 Mark Type
24 Mark Number
25 Mark Type: xxxxxxx,  Assessment/Paper Name : xxxxxxxx
26 User Creating the route originally
27 Email address of above user
28 Originating User : xxxx - xxxxxxxxxx
29 The Student Note Last Updated On  'fmDD Month yyyy "at" hh24:mi'
30 The Student Note Number (GKDNOTENUM) in 0
NOTE:::: gen.gr01pkg.conv_org_structure records can be added by end-user (Line zero Only)
format $Ox,yzzz,0$
x : N ==> Personnel number
x : E ==> Personnel Email Address
x : U ==> ITS user of Personnel number
y : D ==> Department Codes
y : F ==> Faculty Codes
zzz : Organization structure code as setup in {GCS-10}
create_note    This function is used to create an entry into the student Notes table




History Of Changes

Date System Version By Whom Job Description
16-Jan-2008 v01.0.0.0 Melanie Zeelie t137090 New manual format repeat
14-Nov-2007 v01.0.0.0 Melanie Zeelie t144699 New manual format.
31-Jan-2008 v01.0.0.0 Melanie Zeelie t144699 Added info.