Learner

DateOfBirth_40

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	DateOfBirth_40
Version	1
Status	Active
Category	Learner
Severity	Error
Error message	The learner is 19 or over and the actual duration of the programme does not reach the required minimum duration of an apprenticeship
Intent	To ensure that learners who started a funding model FM = 35 or 81 apprenticeship, where the learner was over 19 at the start, have an actual programme duration of 365 days or more
Guidance	Ensure that, for learners who started a funding model FM = 35 or 81 apprenticeship on or before 31 July 2016, where the learner was over 19 at the start, the minimum actual programme duration is 365 days or more
Description	For aims starting on or before 31 July 2016, that are an apprenticeship standard (FM = 35 or 81) and a programme aim, and if the learner is 19 or over, and the outcome is achieved, then the minimum duration of the apprenticeship must not be less than 365 days

Detailed error condition

Detailed description	For aims starting on or before 31 July 2016 ( LearningDelivery.LearnStartDate =< 2016-07-31), that are an apprenticeship standard ( LearningDelivery.FundModel = 35 or (81 and LearningDelivery.ProgType = 25), and a programme aim ( LearningDelivery.AimType = 1), and if the learner is 19 or over ( LearningDelivery.LearnStartDate - Learner.DateOfBirth >= 19 year), and the outcome is achieved ( LearningDelivery.Outcome = 1), then the minimum duration of the apprenticeship must not be less than 365 days (error where LearningDelivery.LearnStartDate - LearningDelivery.LearnActEndDate < 365 days)
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_40' rule 1. Is the learner a restart or on an apprenticeship standard? If 'Yes' then the rule is not triggered If 'No' then: 2. Did the programme aim start on or before 31 July 2016? If 'No' then the rule is not triggered If 'Yes' then: 3. Is the learner 19 or over at the programme start? If 'No' then the rule is not triggered If 'Yes' then: 4. Is the programme duration less than 365 days? 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	Learner.DateOfBirth LearningDelivery.AimType LearningDelivery.LearnStartDate LearningDelivery.FundModel LearningDelivery.ProgType LearningDelivery.LearnActEndDate LearningDelivery.Outcome LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms