Learning delivery

LearnAimRef_119

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnAimRef_119
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 for this teaching year
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 2020 and are aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), the Learning Actual End Date of the aim must be before the validity end date for the corresponding validity category in the Validity table in the LARS database, shown through the FALA service
Description	For learning aims ending on or after 1 August 2020 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the Learning Actual End Date of the aim must be before the validity end date for the corresponding validity category in the Validity table in the LARS database

Detailed error condition

Detailed description	For learning aims ending on or after 1 August 2020 and aims specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA), then the Learning Actual End Date of the aim must be before the validity end date for the corresponding validity category in the Validity table in the LARS database. (error where LearningDelivery.LearnActEndDate >= 2020-08-01 and DD35=Y and LearningDelivery.LearnActEndDate > LARS_EndDate in the LARS_Validity table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = MCA_GLA))
Exclusions	Rule excludes: Adult Level 3 Offer ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'LearnAimRef_119' rule 1. Is the the aim Actual end date on or after 1 August 2020? If 'No' then the rule is not triggered If 'Yes' then: 2. Is LDM 378 returned on the aim record? If 'Yes' then the rule is not triggered If 'No' then: 3. Is the aim specific to Mayoral Combined Authorities (MCA) and Greater London Authority (GLA)? If 'No' then the rule is not triggered If 'Yes' then: 4. Is the Learning Actual End Date of the aim before the validity end date for the corresponding validity category in the Validity table in the LARS database? If 'No' then the rule is triggered If 'Yes' then the rule is not 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.LearnActEndDate LearningDeliveryFAM.LearnDelFAMType LearningDeliveryFAM.LearnDelFAMCode LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms