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

LearnAimRef_147

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name LearnAimRef_147
Version 3
Status Changed
Category Learning delivery
Severity Error
Error message

The aim must have FCFJ_ADULT_SKILLS Validity category in the Validity table in the LARS database

Intent

To ensure that only aims valid for Adult Skills Fund - Free Courses for Jobs provision are recorded

Guidance

Ensure that, for new starts on or after 1 August 2024, that are Free Courses for Jobs provision, the aims have Free Courses for Jobs Validity Category in the Validity table in the LARS database, as shown through the FALA service

Description

For new starts on or after 1 August 2024 and are Free Courses for Jobs provision, then the aims must have Free Courses for Jobs Validity Category in the Validity table in the LARS database

Detailed error condition
Detailed description

For new starts on or after 1 August 2024 and are Free Courses for Jobs provision, then the aims must have Free Courses for Jobs Validity Category in the Validity table in the LARS database.

(error where LearningDelivery.LearnStartDate >= 2024-08-01 and LearningDelivery.FundModel = 38 and LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378 and LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory <> FCFJ_ADULT_SKILLS)

Exclusions

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

or Free Courses for Jobs MCA and GLA only flexible delivery qualifications (LARS_CategoryRef = 56)

Flow chart LearnAimRef-147

Open flow chart in a new window

Flow chart details

Flowchart for 'LearnAimRef_147' rule

1. Is the aim part of a Project S Pilot for Adult Skills Fund Providers or Free Courses for Jobs MCA and GLA only flexible delivery qualification?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the start date on or after 1 August 2024?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the aim part of the Free Courses for Jobs provision?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

4. Does the aim have Free Courses for Jobs 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 3

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

Version 2

Addition of text 'Free Courses for Jobs MCA and GLA only flexible delivery qualifications (LARS_CategoryRef = 56)' to the rule exclusions

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.LearnStartDate

LearningDelivery.FundModel

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms