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

LearnDelFAMDateTo_03

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnDelFAMDateTo_03
Version 2
Status Changed
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

Guidance

Ensure that, where returned, the 'Date to' is not after the Learning actual end date of the aim for apprenticeships, adult and non-funded

Description

If returned, the 'Date to' must not be after the Learning actual end date of the aim for apprenticeships, adult and non-funded

Detailed error condition
Detailed description

If returned, the 'Date To' ( LearningDeliveryFAM.LearnDelFAMDateTo is known) must not be after the Learning actual end date of the aim for apprenticeships, adult and non-funded ( LearningDelivery.FundModel = 35, 36, 38, 81 or 99)

(error where LearningDeliveryFAM.LearnDelFAMDateTo > LearningDelivery.LearnActEndDate )

Exclusions

This rule does not trigger where LearningDeliveryFAM.LearnDelFAMType = ACT

Flow chart LearnDelFAMDateTo-03

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnDelFAMDateTo_03' rule

1. Is the FAM type ACT?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the aim an apprenticeship, adult and non-funded?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the FAM type 'Date to' returned?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

4. Is the 'Date applies to' after the Learning actual end date of the aim?

  • If 'No' then the rule is triggered

  • If 'Yes' then the rule is not triggered

Change summary

Version 2

Addition to rule text - '38' (highlighted)

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