Learner

DateOfBirth_59

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	DateOfBirth_59
Version	2
Status	New
Category	Learner
Severity	Error
Error message	The learner must not be 25 or over at the start of the learning for a funded foundation apprenticeship standard programme
Intent	To ensure that a learner is not over the age of 25 at the start of a funded foundation apprenticeship standard
Guidance	Ensure that, the learners date of birth is recoded correctly, if they are over the age of 25 they are not eligible for a funded foundation apprenticeship and an alternative apprenticeship standard should be used.
Description	For new starts from 1st August 2025, if a funded foundation apprenticeship standard programme has been returned, the learner must not be 25 or over at the start of the learning aim.

Detailed error condition

Detailed description	For new starts from 1st August 2025, if a funded foundation apprenticeship standard programme has been returned, the learner must not be 25 or over at the start of the learning aim. error where LearningDelivery.LearnStartDate >= 2025-08-01 and LearningDelivery.FundMode l = 36 and LearningDelivery.ProgType = 25 and LearningDelivery.AimType = 1 and LearningDelivery.StdCode = LARS_StandardCode and LARS_ApprenticeshipStandardTypeCode = A0001 and LearningDelivery.LearnStartDate - Learner.DateOfBirth >= 25 years
Exclusions	This rule is not not triggered by aims that are a restart ( LearningDeliveryFAM.LearnDelFAMType = RES)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'DateOfBirth_59' rule 1. Is the aim a Restart? If 'Yes' then the rule is not triggered If 'No' then: 2. Is the aim start date on or after the 1st August 2025? If 'No' then the rule is not triggered If 'Yes' then: 3. Is the learner on a funded foundation apprenticeship? If 'No' then the rule is not triggered If 'Yes' then: 4. Is the learner 25 or over at the start of the aim? If 'No' then the rule is not triggered If 'Yes' then the rule is triggered

Change summary

Version 3	New rule at version 3

Status summary

Current SLD severity	Error
Current FIS severity	Error
Is this rule in FIS?	Yes
Field values	LearningProvider.UKPRN Learner.DateOfBirth LearningDelivery.LearnStartDate LearningDelivery.FundModel LearningDeliveryFAM.LearnDelFAMType LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms