Employment status

EmpStat_11

Changes to the latest version will be highlighted

View the validation rules glossary of terms

Name	EmpStat_11
Version	1
Status	Changed
Category	Employment status
Severity	Error
Error message	An Employment status record has not been returned that applies prior to the Learning start date
Intent	To ensure that, for certain apprenticeships and start dates, an Employment status record has been returned that applies prior to the Learning start date
Guidance	Ensure that, if the learner is undertaking an apprenticeship, with a start date on or before 31 July 2014, there must be an Employment status record with a Date that applies on or before the Programme start date
Description	If the learner is undertaking an apprenticeship, and the aim is a programme aim, with a start date on or before 31 July 2014, there must be an Employment status record with a Date that applies on or before the Programme start date

Detailed error condition

Detailed description

If the Learning aim start date is on or after 1 August 2014 ( LearningDelivery.LearnStartDate => 2014-08-01), and the provision is 16-19 non-apprenticeship ( LearningDelivery.FundModel = 25 or 82), and the total of the Planned learning hours and the Planned employability, enrichment and pastoral hours is less than 540 (sum of ( Learner.PlanLearnHours and Learner.PlanEEPHours ) < 540), there must be an applicable Employment status record (error where there is no Employment status record where LearnerEmploymentStatus.DateEmpStatApp < LearningDelivery.LearnStartDate )

Flow chart

Open flow chart in a new window Flow chart details Flowchart for 'EmpStat_11' rule 1. Is the aim 16-19 funded? If 'No' then the rule is not triggered If 'Yes' then: 2. Is the Learning start date on or after 1 August 2014? If 'No' then the rule is not triggered If 'Yes' then: 3. Is the total of the Planned learning hours and the Planned employability, enrichment and pastoral hours less than 540? If 'No' then the rule is not triggered If 'Yes' then: 4. Is there an Employment status recorded returned? If 'No' then the rule is triggered If 'Yes' then the rule is not triggered

Change summary

Version 1	Removal of text - 'This rule is not triggered by traineeships ( LearningDelivery.ProgType = 24)' from the rule Exclusions

Status summary

Current SLD severity	Error
Current FIS severity	Error
Is this rule in FIS?	Yes
Field values	LearnerEmploymentStatus.DateEmpStatApp Learner.PlanLearnHours Learner.PlanEEPHours LearningDelivery.ProgType LearningDelivery.FundModel LearningDelivery.LearnStartDate

Need help understanding some of these terms?

View the validation rules glossary of terms