Student Registration Validation Results {SDREGA-4}

This option is used to view and update the applicant's academic Registration validation results. A result can be changed from 'N' (i.e. not successful) to 'Y' (i.e. successful).

To view data in this screen an academic registration must be created in the academic registration program in {SDREGA-1}. Then either the trial or finalvalidation buttons must be executed. The registration process calls a special program that creates the validation result records for each student in respect of each registration. All registration validations are linked to system 'i' and the process 'REG'.

The control block 1 reflects academic registration information. Records can only be queried in this block and no new records can be created.

In block 2, records cannot be created, deleted or updated.

Fields in the option:

Block 1: Registration records

This program can be called from the menu as well as from the academic registration program. In the latter case, the registration program will provide the values for block one and the record will automatically be queried.

When the program is called from the menu, the user must use the <ENTER QUERY> function and provide values in the required fields. Multi record queries can be performed (e.g. select all the students for a particular year and qualification). The user can scroll through the records in block one and the corresponding records will be displayed in block 2.

When the user enters this option, the program is in <ENTER QUERY> mode. Any of the fields can be populated with a value and the <EXECUTE QUERY> action used to view the records. To query records directly on block 2, the user must execute the <CANCEL QUERY> action before moving to block 2.

It is possible to move from block 1 to block 2 using mouse navigation over and above the normal <NEXT BLOCK> and <PREVIOUS BLOCK> actions.

Field	Type & Length	Description
Student Number	N9	Enter a student number to be queried. The program displays the student surname and first names in the format surname then first names.
Academic Year	YYYY	Enter the academic year of registration.
Qual Nr	N2	Enter the Qualification Number for the Student's Registration
Cancel Date	DD-MON-YYYY	Enter the date that the qualification were cancelled.
Qualification Code	A6	Enter the qualification code to be queried. The description of the qualification displays in the next field.
Block Code	A2	Enter the academic period (block code) to be queried. The description of the block displays in the next field.
Offering Type	A2	Enter the offering type to query. The description of the offering type displays in the next field.

Example:

Block 2: Student Registration Validation Results

The program will always query the records in block 2 that conform to the parameters entered in block 1.

The user can enter a query on any query enabled field in block 2. This will only be successful if block one is cleared e.g. the user will be able to query all the students who failed rule 1A (or any other rule) for a particular year and particular block code.

No records can be created, deleted or updated in this block code. The records are created by package i23pkg.sql - this is called from the academic registration program.

The user can move from one record to the next using mouse navigation.

Field	Type & Length	Description
Student Number	N9	Displays the student number. The right-click of the mouse button displays the students's name.
Academic Year	YYYY	Displays the academic year of registration.
Qual Nr	N2	Displays the qualification Number of the registration.
Cancel Date	DD-MON-YYYY	Displays the cancellation date of the registration.
BC	A2	Displays the academic period (block code) of the registration. The right-click of the mouse button displays the description of the block code.
Validation Rule Code	A4	Displays the validation rule code. The right-click of the mouse button displays the description of the rule code as well as the error message and student message linked to the rule code, as defined in {SNAPPA-8}
Success	A1	This field displays the outcome of the academic registration validation. Four values will be used here, i.e.: "N" - No the student did not pass this validation rule. "Y" - Yes, the student passes this validation rule. "D" - there is a data error in the set-up of the validation rule parameters and parameter values. This means that the database procedure expects, parameters values but none are defined in {SDREGA-5}, Block 3 - Parameter Values. "A" - This registration validation rule is not applicable to this student.
Route Number	N10	Display is used to see what validation route has been started for a validation. This is done via i25pkg.sql.

Example:

Processing Rules
	No special processing rules.

Processing Rules
	No special processing rules.