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

LearnStartDate_13

Changes to the latest version will be highlighted

View the validation rules glossary of terms

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

The Learning start date of the apprenticeship standard programme must not be after the Effective to date of this apprenticeship standard

Intent

This rule ensures that the apprenticeship standard programme is valid in LARS on the learners start date

Guidance

Check that the learners start date is recorded correctly and check that the standard that the learner is enrolled on is valid on that date, if the start learner start date is correct then the standard is not valid for the learner to study.

Description

If the learner is undertaking an apprenticeship standard programme then the Learning start date of the programme must not be after the 'Effective to' date for this Standard in the Standard table in LARS

Detailed error condition
Detailed description

If the learner is undertaking an apprenticeship standard programme ( LearningDelivery.ProgType = 25), then the Learning start date of the programme ( LearningDelivery.AimType = 1), must not be after the 'Effective to' date for this Standard in the Standard table in LARS

(error where (LARS_Standard_EffectiveTo <> null and LearningDelivery.LearnStartDate > LARS_Standard_EffectiveTo) from the LARS_Standard table where (LARS_Standard = LearningDelivery.StdCode ))

Exclusions

This rule is not triggered by Restarts (RES)

Flow chart LearnStartDate_13

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnStartDate_13' rule

1. Is the Learner enrolled on an Apprenticeship Standard?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the learner a restart?

  • If "Yes" rule is not triggered

  • If "No" the:

3. Is the Programme aim passed the effective to date in the LARS database?

  • If "No" rule is not triggered

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

LearningDelivery.LearnStartDate

LearningDelivery.ProgType

LearningDelivery.StdCode

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms