Scheduled Validation error SV00096

Scope

Units of Study with an applicable iupfront discount associated with them.

Logic

Where E490 is '111' or '202' If Total E381 = (Total E384 x Lookup.UpfrontDiscount_DiscountRate) ± 0.20, then delete the record from the 'dbo.UnitsForUpFrontDiscountProcessing' table Else place notification message on the provider's table with reference to each of the Unit Enrolment records (UID16) affected

Message

The Amount Charged (E384) multiplied by the applicable discount does not equal the Amount Paid Upfront (E381) for a unit enrolment that this paid upfront (where Student Status Code (E490) = '111' or '202').

Lead in time

7 days

Trigger Date

Unit of Study Census Date (E489) plus 7 days

Deadline Date

Unit of Study Census Date (E489) plus 14 days

Event

Unit Enrolment Census Date

Logic for updated data

Checked nightly after trigger date

Logic for deleting a message

When nightly review detects that The sum of Amounts Charged (E384) is not blank (null).

Details

Error code: SV00096
Notification Category Code: SVE
Origin: Scheduled validations. Event Unit Enrolment Census Date
HEP: Yes
VET: No
Element Number: E381
Element Name: Amounts Paid Upfront
Packet: