Learning delivery

LearnAimRef_120

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnAimRef_120
Version	1
Status	Active
Category	Learning delivery
Severity	Error
Error message	The Learning aim reference is not valid in the LARS database for this Source of Funding and this Learning start date
Intent	To ensure that learning aims are returned for the correct valid dates in the LARS service for Devolved delivery
Guidance	Ensure that, where the learning aims are ending on or after 1 August 2021 and are aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), and are not Restarts, the learning aim start date must not be before the validity start date or after the last date for new starts for the corresponding validity category in the Validity table in the LARS database, shown through the FALA service
Description	For new starts on or after 1 August 2021 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the learning aim start date must not be before the validity start date or be after the last date for new starts (unless the restart indicator is present) for the corresponding validity category in the Validity table in the LARS database

Detailed error condition

Detailed description

For new starts on or after 1 August 2021 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the learning aim start date must not be before the validity start date or be after the last date for new starts (unless the restart indicator is present) for the corresponding validity category in the Validity table in the LARS database. (error where LearningDelivery.LearnActEndDate >= 2021-08-01 and DD35=Y and ( LearningDelivery.LearnStartDate < LARS_StartDate in the LARS Validity table or ( LearningDelivery.LearnStartDate > LARS_LastNewStartDate in the LARS_Validity table and LearningDeliveryFAM.LearnDelFamType = RES does not exist)) where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = MCA_GLA))

Exclusions

Rule excludes: Adult Level 3 Offer ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378)

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.LearnStartDate LearningDeliveryFAM.LearnDelFAMType LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms