Validation rules for All Provision

• Published: 17 December 2024

Rule name	Version	Status	Error message
DateEmpStatApp_01	1	Active	The Date employment status applies must not be after the current teaching year
DateEmpStatApp_02	1	Active	The Date employment status applies must not be before 1 August 1990
EmpId_01	1	Active	The Employer identifier is not valid
EmpId_02	1	Active	The Employer identifier does not pass the checksum calculation
EmpStat_05	1	Active	The Employment status is not a valid code
EmpStat_20	1	Active	The learner must be in paid employment for this Learning Delivery Monitoring code to be used.
ESMType_01	1	Active	The Employment status monitoring type and code is not valid
ESMType_02	1	Active	The learner's Employment status is 'in paid employment' and the Employment intensity indicator has not been returned
ESMType_05	1	Active	The learner's Employment status is 'in paid employment' and the Length of unemployment has been returned
ESMType_07	1	Active	The learner is self employed and the Employment status is not 'in paid employment'
ESMType_08	4	Changed	The Length of unemployment has not been returned
ESMType_10	1	Active	The Length of employment has been returned
ESMType_11	1	Active	The Length of employment has been returned
ESMType_12	1	Active	The Employment intensity indicator or Self employed indicator has been returned
ESMType_15	1	Active	There must not be more than one record with an ESM type of SEI, EII, LOU, LOE, BSI, PEI, or SEM
ESMType_17	1	Active	The learner must be receiving work related benefits for this Learning Delivery Monitoring code to be used
ESMType_18	1	Active	The redundancy indicator has been returned and the Learner's Employment status is 'In paid employment'
ESMType_19	1	Active	The 'Small or Medium Employer' indicator has been returned but the Learner's Employment status is 'Not in paid employment'
ESMType_20	1	Active	There must not be more than one of the same OET codes recorded on the employment status