1. Home
  2. Validation rules
  3. DateOfBirth_58
Learner

DateOfBirth_58

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name DateOfBirth_58
Version 1
Status New
Category Learner
Severity Error
Error message

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

Intent

To ensure that learners starting aims on or after 1 August 2025 the actual duration of an apprenticeship is no less than 242 days

Guidance

Ensure that, for aims starting on or after 1 August 2025, the actual duration between the learners start and actual end date must be a minimum 242 days

Description

For aims starting on or after 1 August 2025 apprenticeship learners who are 16 and over must have a duration of over 242 days between the learners start and actual end date

Detailed error condition
Detailed description

For aims starting on or after 1 August 2025 (L earningDelivery.LearnStartDate >= 2025-08-01), that are an apprenticeship standard ( LearningDelivery.FundModel = 36 and LearningDelivery.ProgType = 25 ), and a programme aim ( LearningDelivery.AimType = 1) and the learner has completed all learning activities ( LearningDelivery.CompStatus = 2), then the duration of the apprenticeship must not be less than 242 days

(error where LearningDelivery.LearnStartDate - LearningDelivery.LearnActEndDate < 242 days)

Exclusions

This rule is not not triggered by aims that are a restart ( LearningDeliveryFAM.LearnDelFAMType = RES)

Flow chart DateOfBirth_58

Open flow chart in a new window

Flow chart details

Flowchart for 'DateOfBirth_58' rule

1. Is the aim a Restart?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the programme start on or after 1 August 2025?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the aim an apprenticeship standard?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

4. Is the aim a programme aim?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

5. Is the completion status 2 'the learner has completed all learning activities'?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

6. Is the actual programme duration less than 242 days?

  • If 'No' then the rule is not triggered

  • If 'Yes' then the rule is triggered

Change summary

Version 1

New rule for version 1

Status summary

Current SLD severity

Error

Current FIS severity

Error

Is this rule in FIS?

Yes

Field values

Learner.DateOfBirth

LearningDelivery.LearnStartDate

LearningDelivery.FundModel

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

LearningDelivery.ProgType

LearningDelivery.LearnActEndDate

Need help understanding some of these terms?

View the validation rules glossary of terms