Functions to create Route processes for Academic Application Validations - i25pkg.sql

The functions in this package create an entry into the Routing System according to the values set in the Academic Application Validation rules.

The user must enter the Routing Type and the User in {SNAPPA-8} for those rules that will create a route entry on final validation of an application (see the manual for i23pkg.sql to determine which validation rules will create a route entry). The user must furthermore define the steps in the Route Type that will generate the different steps in the route. The user are referred to {GROU-1} for the steps to define a Routing Type.

Users must make sure that the correct data restrictions are defined in {SMNT-5} for access to the note and amendments that is created during the processing of the route.

The user can view the route in {GROU-2} or by clicking on the list of outstanding routes in the 'Work List' on the Entry Screen of the ITS system (tip left mouse click inside the 'Work List' frame to query outstanding route jobs).

Function/Procedure Name	Function Description	Comments
create_note	This function creates a note against the applicant for the student number, year, block code qualification code, choice and failed validation rule code.	This note can be viewd by opening the Student Validation Results screen in {SNAPPA-1/3} or {SNAPPA-9}. Move to the record where the route number is displayed. Right click on the canvas (not inside in field). The pop-up menu have a 'Notes' option that will give access to the student notes screen. Do not link this function to a step in the Route Type
create_route	This is the function that creates the Route Type sequence 0. The function will not create a second route entry as long as the previous route number is still on the student validation result record, See the procedure 'clear_route' below.	Do not link this function to a step in the Route Type
set_outcome	The procedure must be linked to a step in the Routing Type. This updates the amendment field of the student note that was created for the route number. It is dependent on the lines of each route step.These steps must be copied from the previous step in the route (a set-up feature of the Route Type).	This procedure creates a step in the routing system and can not be called from only one step in the sequence of routing steps.
clear_route	The procedure must be linked to the last step in the Routing Type. This procedure clears the route number from the student validation result record when the last step in the routing sequence is completed. This indicates that all the steps in the route has been completed. The procedure does not create a step in the routing system.	The procedure should only be called from the 'last' step in the Routing Type.