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

R_110

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name R_110
Version 7
Status Changed
Category Cross Record
Severity Error
Error message

The employment status is not valid for this apprenticeship contract type

Intent

This rule ensures that there is an employment status record of employed for an apprentice who is funded via the levy

Guidance

Ensure that an employment status of 10 is added to the learners ILR file, if the apprentice is not employed then they are not valid for funding

Description

If an apprenticeship programme is funded through a contract for services with an employer the learner must have an employment status of 'Employed'

Detailed error condition
Detailed description

If an apprenticeship programme is funded ( LearningDelivery.FundModel = 36) through a contract for services with an employer (LearnDelFAMType = ACT and LearnDelFAMCode = 1), the learner must have an employment status of 'Employed'

(error where if the LearnerEmploymentStatus.EmpStat (applicable on LearnDelFAMDateFrom ) <> 10)
Exclusions

Restarts (LearningDeliveryFAM.LearnDelFAMType = RES)
Learner has been made redundant (EmploymentStatusMonitoring.ESMType = OET and EmploymentStatusMonitoring.ESMCode = 1) on the latest LearnerEmploymentStatus.DateEmpStatApp

Flow chart R110

Open flow chart in a new window

Flow chart details

Flowchart for 'R110' rule

1. Has ACT 1 been recorded?

  • If 'No' then the rule is not triggered

  • If 'Yes' then:

2. Is the apprentice recorded as Employed?

  • If 'Yes' then the rule is not triggered

  • If 'No' then the rule is triggered

Change summary

Version 7

An exclusion for redundancy has been added to the rule

Status summary

Current SLD severity

Error
Current FIS severity

Error
Is this rule in FIS?

Yes
Field values

LearningDelivery.FundModel

LearnerEmploymentStatus.EmpStat

LearningDeliveryFAM.LearnDelFAMDateFrom

LearningDeliveryFAM.LearnDelFAMDateTo

LearningDeliveryFAM.LearnDelFAMType

Need help understanding some of these terms?

View the validation rules glossary of terms