Learning delivery

LearnStartDate_18

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnStartDate_18
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 LastDateStarts date of this apprenticeship standard
Intent	This rule ensures that the Apprenticeship Standard is still available on the learners start date and is not passed the last date for new starts for the standard.
Guidance	Check the Learners start date is recorded correctly in the ILR and check the last date for new starts on the Standard in LARS, if the standard is no longer available an alternative will need to be selected as the learner would not be able to start unless they are returning from a break in learning. If the learner is returning from a break ensure that the restart indicator is recorded on the new learning aims.
Description	For new Apprenticeship standard starts after the 1st of August 2020 the learners start date must not be after the last date for new starts for the standard in the LARS database.

Detailed error condition

Detailed description	For starts on or after 1 August 2020 ( LearningDelivery.LearnStartDate >= 2020-08-01), 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 'LastDateStarts' date for this Standard in the Standard table in LARS. (error where (LARS_Standard_LastDateStarts <> null and LearningDelivery.LearnStartDate > LARS_Standard_LastDateStarts) from the LARS_Standard table where (LARS_Standard = LearningDelivery.StdCode ))
Exclusions	This rule is not triggered by restarts (RES)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'LearnStartDate_18' rule 1. Is the Learner enrolled on an Apprenticeship Standard after the 1st of August 2020? 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 last date for new starts of the standard 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 AppFinRecord.AFinType LearningDelivery.StdCode

Need help understanding some of these terms?

View the validation rules glossary of terms