1. Home
  2. Validation rules
  3. AFinDate_08
Learning delivery

AFinDate_08

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name AFinDate_08
Version 1
Status Active
Category Learning delivery
Severity Error
Error message

A total assessment price and residual assessment price record must not have the same financial date

Intent

This rule ensures that the TNP 2 and TNP 4 values are not recorded on the same date

Guidance

Check that the financial record dates to ensure that they are at least 1 day apart as the TNP 2 and 4 records cannot be the same day

Description

If a total assessment price has been returned for this aim, there must not be a residual assessment price returned on the same date

Detailed error condition
Detailed description

If a total assessment price has been returned for this aim ( AppFinRecord.AFinType = TNP and AppFinRecord.AFinCode = 2), there must not be a residual assessment price returned (AppFinRecord.AFinType = TNP and AppFinRecord.AFinCode = 4) on the same date

(error where AppFinRecord.AFinDate of (AppFinRecord.AFinType = TNP and AppFinRecord.AFinCode = 2) = AppFinRecord.AFinDate of (AppFinRecord.AFinType = TNP and AppFinRecord.AFinCode = 4))

Flow chart AFinDate_08

Open flow chart in a new window

Flow chart details

Flowchart for 'AFinDate_08' rule

1. Has a TNP 2 and TNP 4 been recorded?

  • I f 'No' then the rule is not triggered

  • If 'Yes" then the rule is triggered

2. Are the dates on the records the same?

  • I f 'No' then the rule is not triggered

  • If 'Yes" then the rule is triggered

Change summary

Version 1

The rule has been rolled over from the previous year

Status summary

Current SLD severity

Error

Current FIS severity

Error

Is this rule in FIS?

Yes

Field values

AppFinRecord.AFinType

AppFinRecord.AFinDate

Need help understanding some of these terms?

View the validation rules glossary of terms