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

AFinDate_13

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The price must not be after the achievement date

Intent

This rule ensures that the TNP date recorded is not after the achievement date

Guidance

Check that the financial details recorded to ensure that the TNP dates are not set after the learners achievement date

Description

For the apprenticeship standard programme, the apprenticeship financial record date for a price record must not be after the achievement date or must not be after the learning actual end date where the learner has withdrawn.

Detailed error condition
Detailed description

For the apprenticeship standard programme, the apprenticeship financial record date for a price record must not be after the achievement date or must not be after the learning actual end date where the learner has withdrawn.

(error where LearningDelivery.ProgType = 25 and LearningDelivery.AchDate is returned and AppFinRecord.AFinType = TNP and AppFinRecord.AFinDate > LearningDelivery.AchDate) or (LearningDelivery.ProgType = 25 and LearningDelivery.AchDate is not returned and LearningDelivery.WithdrawReason is returned and AppFinRecord.AFinType = TNP and AppFinRecord.AFinDate > LearningDelivery.LearnActEndDate )
Flow chart AFinDate_13

Open flow chart in a new window

Flow chart details

Flowchart for ' AFinDate_13 ' rule

1. Has the achievement date been returned?

  • If 'No' then the rule is not triggered

  • If 'YES" then

2. Is any of the financial records dated after the achievement date?

  • If '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

LearningDelivery.AchDate

AppFinRecord.AFinType

AppFinRecord.AFinDate

Need help understanding some of these terms?

View the validation rules glossary of terms