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 Deleted
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

Apprenticeship standards (Progtype 25)
R estarts (RES)

Change summary

Version 1

This rule has been deleted

Status summary

Current SLD severity

Error

Current FIS severity

Error

Is this rule in FIS?

Yes

Need help understanding some of these terms?

View the validation rules glossary of terms