1. Home
  2. Validation rules
  3. R_148
Cross Record

R_148

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_148
Version 5
Status Changed
Category Cross Record
Severity Error
Error message

The learner must be earning below the earnings threshold by returning LDM 391 or the learner's prior attainment must be below a full level 3

Intent

This rule ensures adult skills fund funding is allocated correctly using the learnings threshold

Guidance

Ensure that both the T level technical qualification and occupational specialism match in LARS database, update the ILR accordingly to ensure that the correct T level is recorded

Description

For starts on or after 1st August 2024, and the 'Level 3 Free Courses for Jobs' Learning Delivery Monitoring code has been returned for learners aged between 19 -23 at the start of the aim, then the learner must be earning below the earnings threshold or the learner's Prior Attainment is below a full level 3

Detailed error condition
Detailed description

For starts on or after 1st August 2024 ( LearningDelivery.LearnStartDate >= 2024-08-01), and the 'Level 3 Free Courses for Jobs' Learning Delivery Monitoring code has been returned ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378) for learners aged between 19 -23 at the start of the aim (( LearningDelivery.LearnStartDate - Learner.DateOfBirth ) >= 19 years and <=23 years) then the learner must be earning below the earnings threshold ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 391) or the learner's Prior Attainment is below a full level 3 ( PriorAttain.PriorLevel =1,2,3,4,5,99)

error where
LearningDelivery.LearnStartDate >= 2024-08-01
and
LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378
and
LearningDelivery.LearnStartDate - Learner.DateOfBirth >= 19 years and <=23 years
and
there is no record where LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 391
and
there is no record where PriorAttain.PriorLevel =1,2,3,4,5,99

Exclusions

This rule is not triggered for devolved authorities where the delivery exclusion is used (LearningDeliveryFAM.LearnDelFAMType = DAM and LearningDeliveryFAM.LearnDelFAMCode = 023)

This rule is not triggered by
Restarts (LearningDelivery.LearnDelFAMType = RES)
Flow chart R148

Open flow chart in a new window

Flow chart details

Flowchart for 'R148' rule

1. Has a the learner started on a DFE funded free courses for jobs aim after the 1st of August 2024?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the learner between the age of 19-23 at the start of the aim?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is triggered

3 . Does the learner has a prior attainment below a full level 3?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

4. Has the earnings threshold LDM code been returned?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is triggered

Change summary

Version 5

changes to the rule include an exclusion for restarts and adding the following to the rule condition "for learners aged between 19 -23 at the start of the aim ((LearningDelivery.LearnStartDate - Learner.DateOfBirth) >= 19 years and <=23 years)"

Version 2

Removal of combined authority from the error condition to ensure it did not trigger for these learners

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.LearnStartDate

PriorAttain.PriorLevel

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

Need help understanding some of these terms?

View the validation rules glossary of terms