Validation rules for Advanced Learner Loans
- Updated:
- 03 September 2025
| Rule name | Version | Status | Error message |
|---|---|---|---|
| R_06 | 1 | Active |
There must not be more than one Learner record with the same Learner reference number |
| R_07 | 1 | Active |
There must not be more than one Learning Delivery record with the same Learner reference number and Aim sequence number combination |
| R_31 | 1 | Active |
An open programme must have an associated learning aim with the same Programme type, Framework code, Pathway and Standard code (if returned) |
| R_43 | 1 | Active |
The learner must not have more than one Learner Employment status record with the same Date employment status applies |
| R_45 | 1 | Active |
The learner must not have more than one LLDD and Health Problem record with the same LLDD and health problem category |
| R_47 | 1 | Active |
The learner must not have more than one Learner Contact Preference record with the same Contact preference type and Contact preference code |
| R_49 | 1 | Active |
The learner must not have more than one Learner Provider Specified Monitoring record with the same occurrence code |
| R_50 | 1 | Active |
The learner must not have more than one Learning Delivery Provider Specified Monitoring record with the same occurrence code |
| R_51 | 1 | Active |
The learner must not have more than one Learner Funding and Monitoring record with the same FAM type and code |
| R_52 | 1 | Active |
The learning aim must not have more than one Learning Delivery FAM record with the same FAM type and code |
| R_59 | 1 | Active |
The ILR file should not have more than one record with the same ULN |
| R_61 | 1 | Active |
The learning aim must not have more than one Learning Support Funding record at the same time |
| R_67 | 1 | Active |
The learner must not have more than one Learning Delivery Work Placement record with the same Work placement start date and Work placement employer identifier |
| R_96 | 1 | Active |
The learner must not have more than one Learning Delivery Work Placement record with the same Work placement start date |
| R_97 | 1 | Active |
The learner must not have consecutive Learner Employment status records with the same Employment status, Employer identifier, Agreement Identifier and Employment Status Monitoring |
| R_106 | 1 | Active |
There must not be more than one LSF record at the same time |
| R_110 | 7 | Changed |
The employment status is not valid for this apprenticeship contract type |
| R_131 | 1 | Changed |
There must be a prior attainment record matching the earliest learning aim start date for the learner |
| R_132 | 1 | Changed |
Learner must be unemployed or return LDM 382 'Free Courses for Jobs (Level 3 Offer) for Low Wage Learners' |