1. Home
  2. Validation rules
  3. DateOfBirth_53
Learner

DateOfBirth_53

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name DateOfBirth_53
Version 1
Status Active
Category Learner
Severity Error
Error message

The programme does not reach the required minimum duration of an apprenticeship

Intent

To ensure that learners who started an FM = 36 apprenticeship standard have an actual duration of not less than 365 days

Guidance

Ensure that, for apprenticeships starting on or after 1 May 2017 and has completed all aims, the actual duration of the apprenticeship must not be less than 365 days

Description

If the learner is undertaking an apprenticeship starting on or after 1 May 2017, and has completed all aims, then the actual duration of the apprenticeship must not be less than 365 days

Detailed error condition
Detailed description

If the learner is undertaking an apprenticeship starting on or after 1 May 2017 ( LearningDelivery.FundModel = 36 and LearningDelivery.LearnStartDate >= 2017-05-01 and DD07 = Y and LearningDelivery.AimType = 1), and has completed ( LearningDelivery.CompStatus = 2), then the actual duration of the apprenticeship must not be less than 365 days.

(Error where LearningDelivery.LearnStartDate - LearningDelivery.LearnActEndDate < 365 days)

Exclusions

This rule is not triggered by aims that are a restart ( LearningDeliveryFAM.LearnDelFAMType = RES) or part of an apprenticeship standard ( LearningDelivery.ProgType = 25)

Flow chart DateOfBirth_53

Open flow chart in a new window

Flow chart details

Flowchart for 'DateOfBirth_53' rule

1. Is the aim a restart or an apprenticeship standard?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the programme start on or after 1 May 2017?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the programme actual duration 365 days or more?

  • If 'No' then the rule is triggered

  • If 'Yes' 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.AimType

LearningDelivery.LearnStartDate

LearningDelivery.LearnActEndDate

LearningDelivery.FundModel

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms