Validation rules for Advanced Learner Loans
- Updated:
- 03 September 2025
| Rule name | Version | Status | Error message |
|---|---|---|---|
| DD35 | 1 | Changed |
N/A |
| DD36 | 6 | Changed |
N/A |
| DD37 | 1 | Active |
N/A |
| DD38 | 1 | Active |
N/A |
| DD39 | 1 | Active |
N/A |
| DD40 | 1 | New |
N/A |
| DelLocPostCode_03 | 1 | Active |
The Delivery location postcode is not valid |
| DelLocPostCode_11 | 1 | Active |
The Delivery location postcode is not in the correct format |
| EmpId_01 | 1 | Active |
The Employer identifier is not valid |
| EmpId_02 | 1 | Active |
The Employer identifier is not valid |
| EmpOutcome_02 | 1 | Deleted |
The Employment outcome is not a valid code |
| 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. |
| Entity_1 | 1 | Changed |
There are no valid learners in the the Learner record |
| 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 |
| Ethnicity_01 | 1 | Active |
The Ethnicity is not a valid code |
| Filename_1 | 1 | Active |
The filename is not in the correct format |
| Filename_2 | 1 | Active |
A file with the same UKPRN, collection year and date/time combination has been received before |
| Filename_3 | 1 | Active |
The UKPRN is not valid |
| Filename_4 | 1 | Active |
The year of collection is not the current year |
| Filename_5 | 1 | Active |
The serial number is not a 2 digit number |
| Filename_6 | 1 | Active |
The serial number must not be 00 |
| Filename_7 | 1 | Active |
The file date/time is after today's date/time |
| Filename_8 | 1 | Active |
The date/time of the file is earlier than a previous transmission for this collection |
| FundModel_01 | 1 | Active |
The Funding model is not a valid code |
| FundModel_03 | 1 | Active |
The Funding model is not valid for a learning aim financed by an Advanced Learner Loan |
| GivenNames_01 | 1 | Active |
The learner's Given names must be returned |
| Header_2 | 1 | Active |
The file preparation date is after today's date |
| Header_3 | 1 | Active |
The UKPRN in the filename does not match the UKPRN in the Header |
| Inconsistent UKPRN | 1 | Active |
The UKPRN in the file name does not match the provider's UKPRN in the Submit Learner Data service |
| LearnActEndDate_01 | 1 | Active |
The Learning actual end date must be after the Learning start date |
| LearnActEndDate_04 | 1 | Active |
The Learning actual end date must be before the file preparation date |
| LearnAimRef_01 | 1 | Active |
The Learning aim reference is not a valid lookup on LARS |
| LearnAimRef_30 | 1 | Active |
The Learning aim reference is not valid for a programme aim |
| LearnAimRef_88 | 1 | Active |
The Learning aim reference is not valid in the LARS database for this Funding model and this Learning start date |
| LearnAimRef_110 | 4 | Changed |
The Learning aim reference is not valid in the LARS database for this Funding model and this Learning start date |
| LearnAimRef_111 | 4 | Changed |
The Learning aim reference is not valid in the LARS database for this Funding model for this teaching year |
| LearnAimRef_112 | 4 | Active |
The Learning aim reference is not valid in the LARS database for this Funding model and this Learning start date |