Validation rules for Advanced Learner Loans
- Updated:
- 03 September 2025
| Rule name | Version | Status | Error message |
|---|---|---|---|
| AchDate_02 | 1 | Active |
The Achievement date should not be after the current teaching year end date |
| AchDate_03 | 1 | Active |
The Achievement date must not be before the Learning start date |
| AchDate_04 | 1 | Active |
The Learning actual end date must be returned for this Achievement date |
| AchDate_05 | 1 | Active |
The Achievement date must be after the Learning actual end date |
| AchDate_07 | 1 | Active |
The Achievement date must be before the file preparation date |
| AddHours_02 | 1 | Active |
The Additional delivery hours must not be returned for EFA, Community Learning or Non-funded provision |
| AimSeqNumber_02 | 1 | Active |
The Aim sequence number is greater than the count of the learning aims |
| AimType_01 | 1 | Active |
The Aim type is not a valid code |
| AimType_05 | 1 | Active |
The Aim type is not valid for this Funding model |
| AimType_07 | 1 | Active |
A core aim must not be recorded with a source of funding of 105 |
| CampID_01 | 1 | Active |
The Campus identifier is not valid |
| CampID_02 | 1 | Active |
The UKPRN is not the same as recorded in the Header |
| CompStatus_01 | 1 | Active |
The Completion status is not a valid code |
| CompStatus_02 | 1 | Active |
The Learning actual end date must not be returned for this Completion status |
| CompStatus_03 | 1 | Active |
The Learning actual end date must be returned for this Completion status |
| CompStatus_04 | 1 | Active |
The Outcome must be returned for this completion status |
| CompStatus_05 | 1 | Active |
The Completion status is not valid for this Outcome |
| CompStatus_06 | 1 | Active |
The Completion status is not valid for this Outcome |
| ContPrefType_01 | 1 | Active |
The Contact preference type and code is not valid |
| ContPrefType_02 | 1 | Active |
The combination of Contact preference type and code is not valid, this learner is not to be contacted |
| ContPrefType_03 | 1 | Active |
The Contact preference type and code is not valid for this Learning start date |
| ContPrefType_04 | 1 | Active |
These contact preference types cannot all be used at the same time |
| ContPrefType_05 | 1 | Active |
These contact preference types cannot all be used at the same time |
| ContPrefType_06 | 1 | Active |
There must not be more than two records with a Contact preference type of RUI |
| ContPrefType_07 | 1 | Active |
There must not be more than three records with a Contact preference type of PMC |
| 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 |
| DateOfBirth_04 | 1 | Active |
The learner is 115 or over |
| DateOfBirth_23 | 1 | Active |
The Date of birth has not been returned |
| DateOfBirth_24 | 1 | Active |
The Unique learner number has been returned and the Date of birth has not been returned |
| DateOfBirth_26 | 1 | Active |
The learner is under 19 and financed by an Advanced Learner Loan |
| DateOfBirth_27 | 1 | Active |
The learner's Date of birth is on or after the start of the current teaching year |
| DD01 | 1 | Active |
N/A |
| DD04 | 1 | Active |
N/A |
| DD05 | 1 | Active |
N/A |
| DD06 | 1 | Active |
N/A |
| DD07 | 1 | Active |
N/A |
| DD12 | 1 | Active |
N/A |
| DD14 | 1 | Active |
N/A |
| DD17 | 1 | Active |
N/A |
| DD18 | 1 | Active |
N/A |
| DD21 | 1 | Active |
N/A |
| DD27 | 1 | Active |
N/A |
| DD28 | 1 | Active |
N/A |
| DD29 | 2 | Changed |
N/A |
| DD31 | 1 | Active |
N/A |
| DD32 | 1 | Active |
N/A |
| DD33 | 1 | Active |
N/A |
| DD34 | 1 | Active |
N/A |
| DD35 | 1 | Changed |
N/A |