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

LearnDelFAMDateTo_05

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The Date applies to must not be after the Learning actual end date

Intent

To ensure that valid FAM types are returned for apprenticeships

Guidance

Ensure that, where the returned FAM type is ACT, the 'Date applies to' is before the achievement date of the aim for apprenticeships

Description

Where the FAM type is ACT, if returned, the 'Date applies to' must not be after the achievement date of the aim for apprenticeships

Detailed error condition
Detailed description

Where LearningDeliveryFAM.LearnDelFAMType = ACT, if returned, the 'Date applies to' ( LearningDeliveryFAM.LearnDelFAMDateTo is known) must not be after the achievement date of the aim for apprenticeships, ( LearningDelivery.FundModel = 36)

(error where LearningDeliveryFAM.LearnDelFAMDateTo > LearningDelivery.AchDate )

Flow chart LearnDelFAMDateTo-05

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnDelFAMDateTo_05' rule

1. Is the FAM type ACT returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the aim an apprenticeship?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the the 'Date applies to' after the achievement date of the aim?

  • If 'Yes' then the rule is triggered

  • If 'No' then the rule is not 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.LearnStartDate

LearningDelivery.FundModel

LearningDelivery.LearnActEndDate

LearningDeliveryFAM.LearnDelFAMDateTo

Need help understanding some of these terms?

View the validation rules glossary of terms