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

LearnAimRef_141

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnAimRef_141
Version 4
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 only aims valid for Adult Skills Fund funding are recorded

Guidance

Ensure that, for starts on or after 1 August 2024 where the aim is funded through the Adult Skills Fund funding model, the validity end date (if entered) on the record with the latest validity start date in the LARS database for the Learning aim reference is after the end of the previous teaching year for the corresponding Validity in the LARS database, as shown through the FALA service

Description

For new starts on or after 1 August 2024 and if the learning aim is funded through Adult Skills Fund, 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

Detailed error condition
Detailed description

For new starts on or after 1 August 2024 and if the learning aim is funded through Adult Skills Fund, 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-08-01 and LearningDelivery.FundModel = 38 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: Combined authorities (DD35 = Y)

Level 3 Free Courses for Jobs ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378)

or Project S Pilot for Adult Skills Fund Providers ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 395)

Flow chart LearnAimRef-141

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_141' rule

1. Is the aim funded by a Combined authority, part of a Level 3 Free Courses for Jobs programme or a Project S pilot aim?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

2. Is the aim start date on or after 1 August 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 validity end date (if entered) on the record with the latest validity start date in the LARS database for this Learning aim reference after the end of the previous teaching year for the corresponding Validity in the LARS database?

  • If 'Yes' then the rule is triggered

  • If 'No' then the rule is not triggered

Change summary

Version 4

Addition of text 'or Project S Pilot for Adult Skills Fund Providers ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 395)' to the rule exclusions (highlighted)

Version 1

New rule for 24/25

Status summary

Current SLD severity

Error

Current FIS severity

Error

Is this rule in FIS?

Yes

Field values

LearningDelivery.FundModel

LearningDelivery.LearnAimRef

Need help understanding some of these terms?

View the validation rules glossary of terms