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

LearnStartDate_07

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnStartDate_07
Version 1
Status Active
Category Learning delivery
Severity Error
Error message

The Learning start date of the apprenticeship programme must not be after the Effective to date of this component aim for this pathway

Intent

This rule ensures that the Apprenticeship Framework is valid for study on the learners start date.

Guidance

Check the Apprenticeship frame work and the learners start date to ensure that they are both recorded correctly and update accordingly.

Description

If the learner is undertaking an apprenticeship framework the learning start date must not be after the "Effective to" date for the Framework on LARS.

Detailed error condition
Detailed description

If the learner is undertaking an apprenticeship (DD07 = Y) framework programme ( LearningDelivery.AimType = 3), then the Learning start date of the programme must not be after the 'Effective to' date for this framework in the Framework table in LARS

(error where (LARS_EffectiveTo <> null AND DD04 > LARS_EffectiveTo) from the LARS_FrameworkAims table where (LARS_ProgType = LearningDelivery.ProgType and LARS_FworkCode = LearningDelivery.FWorkCode and LARS_PwayCode = LearningDelivery.PwayCode and LARS_LearnAimRef = LearningDelivery.LearnAimRef )

Exclusions

This rule is not triggered by: Restarts (RES)

or Apprenticeship Frameworks (progType 25)

Flow chart LearnStartDate_07

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnStartDate_07' rule

1. Is the Learner enrolled on an Apprenticeship framework?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the programme passed its effective to date in LARS?

  • If "Yes" rule is not triggered

  • If "No" the:

3 . Is the learner a restart?

  • If "Yes" rule is not triggered

  • If "No" then the rule is 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.LearnAimRef

LearningDelivery.AimType

LearningDelivery.ProgType

LearningDelivery.PwayCode

LearningDelivery.FworkCode

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms