 |
This option is used to define promotion rules that will be used within
the Progression validation stage of Auto Promotion
process to determine if a student may progress to the next study period
based on the results of the student.
| Field | Type & Length |
Description |
|---|---|---|
| Rule Code | A4 | A 'Rule Code' that will uniquely identify a progression validation rule. |
| Sequence | N3 | Enter the sequence in which this validation must be performed. |
| Stop Quote | A1 | Not used |
| Stop Admits | A1 | Not used |
| Admit Status | A2 | Not used |
| Database Procedure | A30 | Enter the name of the database
procedure that
will be used to
execute the logic of this validation rule. Database procedures
are created by AdaptIT. |
| Active | A1 | Enter a 'N' if the progression validation rule is no longer needed or if the user wants to disable the validation rule temporarily. The promotion engine will only evaluate active rules. |
| Rule Code Description | A250 | Enter the 'Progression Validation Rule' description. |
| Error Message | A250 | Enter the error message that will be generated for internal use when a validation of the progression is not successful. |
| Student Message | A250 | Enter
the message that will be included in a progression validation
correspondence document sent to the progression students. |
The rule code is not displayed in
this block, instead it is populated automatically in a hidden
field in the background.
Note: Please remember
that each parameter record inserted for a rule code must be defined in
the corresponding database procedure.
| Field | Type & Length |
Description |
|---|---|---|
| Parameter No | N4 | Enter the number of the parameter. This value does not necessarily denote the sequence in which the parameter is evaluated in the database procedure. |
| Description | A512 | Enter a description for this prompt. |
| Table Reference | A40 | Enter the ORACLE database
table against which the prompt
values must be validated. This table is used in block 3 to
determine if valid parameter values are used in the graduation
application validation process. This value must exist in {DMAIN-1} and
is installed with the AdaptIT system. We suggest that this data is
inserted
with the help of the systems administrator.
|
| Column Reference | A20 | Enter the ORACLE column in the ORACLE table against which the prompt values must be validated. This value must exist in {DMAIN-1} and is installed with the ITS system. |
| Description Column | A40 | Enter the column in the
table that contains the description for the column value referred to in
the previous field |
| LOV SQL | A8 | Enter the code of an additional SQL clause that will be included in the LOV. |
| Data Type | A1 | Enter the data type of the parameter value that will be entered in the parameter value table. (N)umeric, (C)haracter, (D)ate. This is used as a second validation mechanism to ensure that the user enters the correct type of data for the parameter values in block 3. |
| Field | Type & Length |
Description |
|---|---|---|
| Parameter Value | A30 | Enter the 'Value' for this rule and
parameter. Multiple values can be entered for each parameter. |
|
| Field | Type & Length |
Description |
|---|---|---|
| Validation Rule | A4 | Lov is available with values from block 1. |
| Detail Type | A4 | A LOV's is available with valid Phrase Types. |
| Detail to Add | A1 | Valid Values: V - Value L - List |
| Phrase Code | A10 | A user defined 'Phrase Code' |
| Phrase Text | A40000 | A user defined 'Phrase Text Description'. |
|
| Processing Rules |
|
|---|---|
| No special processing rules. |
| Date | System Version | By Whom | Job | Description |
|---|---|---|---|---|
| 20-Mar-2020 | v04.1.0.0 | Magda van der Westhuizen | T241180 | New manual |
| 27-Jun-2022 | v04.1.0.1 | Esther Nel |
T255431 |
Revise |
