Learning delivery

LearnAimRef_97

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	LearnAimRef_97
Version	1
Status	Changed
Category	Learning delivery
Severity	Error
Error message	The Learning aim reference is not valid in the LARS database for this Funding model for this teaching year
Intent	To ensure that Adult funded learning aims are returned for the correct valid dates in the LARS service
Guidance	Ensure that for aims starting on or prior to 31 July 2024, that are Adult Skills funded, that the Learning start date of the aim is between the validity dates in the Validity table in the LARS database, shown through the FALA service
Description	For learning aims starting on or prior to 31 July 2024 and are Adult Skills funded, the Learning start date of the aim must be between the validity start date and end date for the corresponding validity category in the Validity table in the LARS database

Detailed error condition

Detailed description	For new starts on or prior to 31 July 2024 ( LearningDelivery.LearnStartDate <= 2024-07-31) and if the learning aim is funded through Adult Skills, then the validity end date (if entered) on the record with the latest validity start date in the LARS database for this Learning aim reference must be after the end of the previous teaching year for the corresponding Validity in the LARS database. (error where LearningDelivery.LearnStartDate <= 2024-07-31 and LearningDelivery.FundModel = 35 and LARS_EndDate in the LARS_Validity table <= end of previous teaching year using the record with the latest validity start date from the LARS_Validity table where ( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = ADULT_SKILLS))
Exclusions	This rule excludes: Apprenticeship provision (DD07 = Y) OLASS learners ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 034) Combined authorities (DD35 = Y) or Level 3 Free Courses for Jobs ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378)
Flow chart	Open flow chart in a new window Flow chart details Flowchart for 'LearnAimRef_97' rule 1. Is the aim an Apprenticeship component, OLASS funded, learners with a Combined Authority, or Level 3 Free Courses for Jobs? If 'Yes' then the rule is not triggered If 'No' then: 2. Is the aim start on or prior to 31 July 2024? If 'No' then the rule is not triggered If 'Yes' then: 3. Is the aim Adult skills funded? If 'No' then the rule is not triggered If 'Yes' then: 4. Is the Learning start date between the validity start date and end dates for the aim 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	Addition of text - 'For new starts on or prior to 31 July 2024 ( LearningDelivery.LearnStartDate <= 2024-07-31) and' and ' LearningDelivery.LearnStartDate <= 2024-07-31' to the rule (highlighted)

Status summary

Current SLD severity	Error
Current FIS severity	Error
Is this rule in FIS?	Yes
Field values	LearningDelivery.FundModel LearningDelivery.LearnAimRef LearningDelivery.LearnStartDate

Need help understanding some of these terms?

View the validation rules glossary of terms