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 |
| 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 |
| 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 |
| EmpOutcome_02 | 1 | Deleted |
The Employment outcome is not a valid code |
| 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 |
| 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 |
| LearnAimRef_113 | 4 | Active |
The Learning aim reference is not valid in the LARS database for this Funding model for this teaching year |
| LearnAimRef_131 | 4 | Changed |
The aim must have ADV_LEARN_LOAN Validity category in the Validity table in the LARS database |
| LearnDelFAMDateFrom_01 | 1 | Active |
The Date applies from or the Date applies to must be returned for this FAM type |
| LearnDelFAMDateFrom_02 | 2 | Changed |
The Date applies from must be after the Learning start date |
| LearnDelFAMDateFrom_03 | 1 | Active |
The Date applies from must not be returned for this FAM type |
| LearnDelFAMDateFrom_04 | 1 | Active |
The Date applies from must be returned for this FAM type |
| LearnDelFAMDateTo_01 | 1 | Active |
The Date applies to must not be before the Date applies from for this FAM type |
| LearnDelFAMDateTo_02 | 6 | Changed |
The Date applies to should not be after the Learning planned end date |
| LearnDelFAMDateTo_03 | 2 | Changed |
The Date applies to must not be after the Learning actual end date |
| LearnDelFAMDateTo_04 | 1 | Active |
The Date applies to must not be returned for this FAM type |
| LearnDelFAMDateTo_05 | 1 | Active |
The Date applies to must not be after the Learning actual end date |
| LearnDelFAMType_01 | 2 | Active |
The Source of funding must be returned |
| LearnDelFAMType_04 | 1 | Active |
The FAM type and code is not valid |
| LearnDelFAMType_06 | 1 | Active |
The FAM type and code is not valid for this Learning start date |
| LearnDelFAMType_14 | 1 | Active |
The Eligibility for enhanced apprenticeship funding is only valid for apprenticeship aims |
| LearnDelFAMType_15 | 1 | Active |
This Learning delivery monitoring code must not be returned where the Learning actual end date is completed |
| LearnDelFAMType_16 | 1 | Active |
This Learning delivery monitoring code is not valid for this return |
| LearnDelFAMType_18 | 1 | Active |
There must not be more than one record with a FAM type of SOF, FFI, EEF, RES, ADL, ACL, AFL, ASL or FLN |
| LearnDelFAMType_22 | 1 | Changed |
The Full or co-funding indicator must not be returned for this Funding model |
| LearnDelFAMType_31 | 1 | Active |
There must not be more than six occurrences for the FAM type LDM |
| LearnDelFAMType_35 | 1 | Active |
The Advanced Learner Loans indicator must not be returned for this Funding model |