Validation rules for Adult education budget
- Updated:
- 17 October 2025
| Rule name | Version | Status | Error message |
|---|---|---|---|
| Accom_01 | 1 | Active |
The Accommodation is not a valid code |
| 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_01 | 1 | Active |
The Additional delivery hours must not be returned for learning aims that started prior to 1 August 2015 |
| AddHours_03 | 1 | Active |
The Additional delivery hours must only be returned for ESOL qualification or unit aims |
| AddHours_04 | 1 | Active |
The Additional delivery hours must not exceed 24 hours in a day |
| AddHours_05 | 1 | Active |
The Additional delivery hours should not exceed 35 hours in a week |
| AddHours_06 | 1 | Active |
The Additional delivery hours divided by the number of days of study is not greater than 9 and less than 24 |
| AddLine1_03 | 1 | Active |
Address line 1 has not been returned |
| 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_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 |
| ConRefNumber_03 | 1 | Changed |
The Contract reference number must not be returned for this Funding model |
| ContPrefType_01 | 1 | Deleted |
The Contact preference type and code is not valid |
| ContPrefType_02 | 1 | Deleted |
The combination of Contact preference type and code is not valid, this learner is not to be contacted |
| ContPrefType_03 | 1 | Deleted |
The Contact preference type and code is not valid for this Learning start date |
| ContPrefType_04 | 1 | Deleted |
These contact preference types cannot all be used at the same time |
| ContPrefType_05 | 1 | Deleted |
These contact preference types cannot all be used at the same time |
| ContPrefType_06 | 1 | Deleted |
There must not be more than two records with a Contact preference type of RUI |
| ContPrefType_07 | 1 | Deleted |
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_01 | 1 | Active |
The Date of birth must be returned |
| DateOfBirth_04 | 1 | Active |
The learner is 115 or over |
| DateOfBirth_14 | 1 | Active |
The learner is under 18 |
| DateOfBirth_24 | 1 | Active |
The Unique learner number has been returned and the Date of birth has not been returned |
| DateOfBirth_25 | 1 | Active |
The learner is under 19 |
| DateOfBirth_27 | 1 | Active |
The learner's Date of birth is on or after the start of the current teaching year |
| DateOfBirth_30 | 1 | Active |
The learner is between 19 and 24 and has an Education health plan, and the Funding model and/or Source of funding is not the 16-19 funded |
| DateOfBirth_32 | 1 | Active |
The learning aim started on or after 1 August 2015 and the learner is 24 or over and the aim is Level 3 or above and the Funding model is Adult skills |
| DateOfBirth_34 | 1 | Active |
The learner is recorded as a High Needs Student but there is no Education health care plan recorded |
| DateOfBirth_35 | 1 | Deleted |
The learner is under 19 and the planned duration of the programme does not reach the required minimum duration of an apprenticeship |
| DateOfBirth_36 | 1 | Deleted |
The learner is 19 or over and the planned duration of the programme does not reach the required minimum duration of an apprenticeship |
| DateOfBirth_37 | 1 | Active |
The learner is 19 or over and the planned duration of the programme does not reach the required minimum duration of an apprenticeship |
| DateOfBirth_38 | 1 | Deleted |
The learner is under 19 and the actual duration of the programme does not reach the required minimum duration of an apprenticeship |
| DateOfBirth_40 | 1 | Active |
The learner is 19 or over and the actual duration of the programme does not reach the required minimum duration of an apprenticeship |
| DateOfBirth_48 | 1 | Active |
The learner is not over the school leaving age |
| DateOfBirth_49 | 1 | Active |
The learning aim started on or after 1 August 2016 and the learner is 24 or over and the aim is Level 3 or above and the Funding model is Adult skills |
| DateOfBirth_55 | 1 | Active |
The learning aim started on or after 1 August 2017 and the learner is 24 or over and the aim is Level 3 or above and the Funding model is Adult skills |