Validation error 10687

Deletion of or amendment to the Course Admission record not permitted

Description

Attempt to delete the Course Admission record (UID15), or amend the Course Admission record (UID15) resulting in a student's total Allocated SLE being exceeded after the resulting change in Additional SLE.

Error Logic

WHERE a Course Admission (UID15) is Allocating ASLE for a Student USI (E584_USI) and an attempt is made to delete OR amend the following:
- Course (UID5)
- Course of Study Commencement Date (E534)
- Course Outcome Date (E592)
- Course Outcome Code (E599)
AND that change will reduce or remove the ASLE allocation for that student,

Then find
(1) the sum of allocated SLE which is Allocated OSLE + Allocated ASLE + Allocated LSLE + AllocatedRSLE for the student (E584_USI), truncated to 4 decimal places; and
(2) the sum of covered UEs where UE SLE use status is 'consumed' or 'reserved' for the student (E584_USI) including the incoming updated or reported UE, truncated to 4 decimal places

IF the value of (2) is greater than (1), then trigger the RTV error and prevent the change,
ELSE permit the change

WHERE the Course Admission (UID15) is Allocating ASLE for a Student USI (E584_USI) and an attempt is made to amend the Student (UID8),
AND that change will reduce or remove the ASLE allocation for the original student (E584_USI) or the student (E584_USI) the course is now linked to,

Then find
(1) the sum of allocated SLE which is Allocated OSLE + Allocated ASLE + Allocated LSLE + Allocated RSLE for the student (E584_USI), truncated to 4 decimal places; and
(2) the sum of covered UEs where UE SLE use status is 'consumed' or 'reserved' for the student (E584_USI) including the incoming updated or reported UE, truncated to 4 decimal places

IF the value of (2) is greater than (1), then trigger the RTV error and prevent the change,
ELSE permit the change

Error Resolution

Please check the attempted deletion of the Course Admission record (UID15), or amendment to the Student (UID8), Course (UID5), Course Outcome Date (E592), Course Outcome Code (E599) on the Course Admission record (UID15). The proposed deletion or amendment result is in one or more students' (USI (E584)) exceeding their SLE entitlement after the resulting change in Additional SLE.

Details