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

R_132

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_132
Previous name R132
Version 1
Status Active
Category Cross Record
Severity Error
Error message

Learner must be unemployed or return LDM 382 'Free Courses for Jobs (Level 3 Offer) for Low Wage Learners'

Intent

This rule ensures learners who have a prior attainment of full level 3 or above, who have the free courses for jobs LDM code recorded are unemployed or a low wage learner

Guidance

Ensure that if the LDM code 382 is returned for learners who have a full level 3 prior attainment and is studying an applicable programme, they are unemployed or valid for Low wage provision

Description

For starts on or after 1st April 2022 and on or prior to 31 July 2024 if the learner's Prior Attainment is full level 3 or above and the 'Level 3 Free Courses for Jobs' Learning Delivery Monitoring code has been returned then the learner must be unemployed on benefits or be a Free Courses for Jobs (Level 3 Offer) Low Wage Learner using LDM 382

Detailed error condition
Detailed description

For starts on or after 1st April 2022 ( LearningDelivery.LearnStartDate >= 2022-04-01), and on or prior to 31 July 2024 ( LearningDelivery.LearnStartDate =< 2024-07-31) if the learner's Prior Attainment is full level 3 or above ( PriorAttain.PriorLeve l = 6,7,8,9,10, 97 or 98) and the 'Level 3 Free Courses for Jobs' Learning Delivery Monitoring code has been returned ( LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378) then the learner must be unemployed on benefits or be a Free Courses for Jobs (Level 3 Offer) Low Wage Learner

error where
LearningDelivery.LearnStartDate >= 2022-04-01
and
PriorAttain.PriorLevel = 6, 7, 8, 9, 10, 97 or 98
and
LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 378
and
DD38 = N
and
there is no record where LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 382
Exclusions

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

Flow chart R132

Open flow chart in a new window

Flow chart details

Flowchart for 'R132' rule

1. Is the learners start date after 1st April 2022 and before the 31 July 2024?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Has DAM code 023 been returned?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

3 . Has the learner been recorded with a prior attainment of full level 3 or above and DFE funded with LDM code 378?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

4 . Is the learner recorded as unemployed?

  • If 'Yes' then the rule is not triggered

  • If 'No' then:

5 . Is the learner recorded with LDM 382?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is 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

PriorAttain.PriorLevel

PriorAttain.DateLevelApp

LearningDelivery.LearnStartDate

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

EmploymentStatusMonitoring.ESMCode

EmploymentStatusMonitoring.ESMType

LearnerEmploymentStatus.EmpStat

Need help understanding some of these terms?

View the validation rules glossary of terms