Scheduled Validation error SV00115

Scope

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

Logic

For each record on the 'dbo.UnitsForUpFrontDiscountProcessing' table that has a census date (E489) that is 7 days in the past: If the sum of Amounts Paid Upfront (E381) for all the AOUs linked to the UE is greater than [the sum of Amounts Charged (E384) for all the AOUs linked to the UE multiplied by Lookup.UpfrontDiscount_DiscountRate] ± 0.20 then send a provider notification to the provider.

Message

The Amount Paid Upfront (E381) for a unit enrolment exceeds the maximum amount payable once the applicable discount is applied to the Amount Charged (E384).

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: SV00115
Notification Category Code: SVE
Origin: Scheduled validations. Event Unit Enrolment Census Date
HEP: Yes
VET: No
Element Number: E381
Element Name: Amount Paid Upfront
Packet: