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

R_156

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_156
Version 1
Status New
Category Cross Record
Severity Error
Error message

The Maths Minimum Hours field must be returned for this learner

Intent

This rule ensures that the Maths minimum hours has been returned for an applicable programme

Guidance

If the learner is 16 or over on the 31 August and if the aim is 16-19 funded and if the aim has EFA Funding Condition and and the learner's planned hours are 150 or over, then the Maths Minimum Hours must be returned to clear this error, unless they have a pass grade for Maths functional skills

Description

If the learner is 16 or over on the 31 August and if the aim is 16-19 funded and if the aim has EFA Funding Condition with no valid exemptions the Maths minimum hours must be returned

Detailed error condition
Detailed description

If the learner is 16 or over on the 31 August and if the aim is 16-19 funded and if the aim has EFA Funding Condition - English qualification validity category (LARS_ValidityCategory = EFAConFundEnglish) or an aim under the King's Trust TEAM programme, the learner does not hold a GCSE English condition of funding exemption ( there is no record of LearnFamType. MCF and Learner.LearnFAMCod e = 1,2,3,4), the learner's highest Maths GCSE grade is 3,2,1,U,D,E,F,G,X,NONE ( Learner.MathGrade = 3,2,1,U,D,E,F,G,X,NONE) and the learner's planned hours are 150 or over, then the Maths Minimum Hours must be returned.

Error where
Learner.DateOfBirth is returned and >= 16 years on the 31 August of the current teaching year
and
LearningDelivery.FundModel = 25
and
LearningDeliveryFAM.LearnDelFAMType = SOF and LearningDeliveryFAM.LearnDelFAMCode = 107
And
( LearningDelivery.LearnAimRef = LARS_LearnAimRef and LARS_ValidityCategory = EFAConFundMaths or (LearningDelivery.LearnAimRef = LARS_LearnAimRef = 60023995,60027307,60027629,60032121,60033344 and LearningDeliveryFAM.LearnDelFAMType = LDM and LearningDeliveryFAM.LearnDelFAMCode = 331))
and
there is no record of Learner.FAM LearnFamType.MCF and Learner.LearnFAMCode = 1,2,3,4
And
Learner.MathGrade = 3,2,1,U,D,E,F,G,X,NONE
and
(Learner.PlanLearnHours + Learner.PlanEEPHours = > 150 or ( LearningDelivery.ProgType = 31 and LearningDelivery.AimType = 1 with the latest LearningDelivery.LearnStartDate and LearningDelivery.Phours = >150 ))
and
there is no record where LearnerFAM.LearnFAMType = MMH

Exclusions

This rule is not triggered by:

Learner holds a pass grade for functional skills level 2 in Maths and Maths GCSE grade is below grade 3 (LearnerFAM.LearnFamType.MCF Learner.LearnFAMCode = 5 and Learner.MathGrade = 2,1,U,E,F,G,X,NONE)

T Levels that started before 1 August 2022 (LearningDelivery.ProgType = 31 and LearningDelivery.LearnStartDate < 2022-08-01)

Flow chart R156

Open flow chart in a new window

Flow chart details

Flowchart for 'R156' rule

1. Is the learner 16 or over on the 31 August and recorded on a 16-19 funded aim or a T level that started after 1st of August 2022?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Does the aim have EFA Funding Condition - Maths qualification validity category or is the aim under the King's Trust TEAM programme?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

3. Is the learner's planned hours are 150 or over?

  • If 'No' then the rule is not triggered

  • If 'Yes' then

4. Has the learner got a GCSE Maths condition of funding exemption?

  • If 'Yes' then the rule is not triggered

  • If 'No' then

5. Has the Maths Minimum Hours must be returned?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is triggered

Change summary

Version 1

New rule for version 1

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.ProgType

LearningDelivery.AimType

LearningDelivery.LearnStartDate

LearningDelivery.LearnAimRef

LearnerFAM.LearnFAMCode

LearnerFAM.LearnFAMType

LearningDeliveryFAM.LearnDelFAMType

LearningDeliveryFAM.LearnDelFAMCode

Learner.MathGrade

Need help understanding some of these terms?

View the validation rules glossary of terms