Validation rules by category
- 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_20 | 1 | Active |
The learner must not have more than one competency aim at the same time |
| R_30 | 1 | Active |
All aims that are part of a programme must have a corresponding programme aim with the same Programme type, Framework code and Pathway (if returned) |
| 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_56 | 1 | Active |
An SFA or EFA funded component aim must not have a non-funded programme aim |
| R_58 | 1 | Active |
The learner must not have more than one core aim at the same time |
| 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_63 | 1 | Active |
The learner must have a core aim for this Funding model |
| R_64 | 1 | Active |
The learner must not have more than one competency aim with the same Programme type, Framework code and Pathway where an earlier competency aim has been achieved |
| R_66 | 1 | Active |
All funded component aims must have a corresponding programme aim with the same Programme type, Framework code, Pathway code or Standard code (where applicable) |
| 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_68 | 1 | Active |
The learner must not have more than one Apprenticeship Financial Record with the same Apprenticeship financial type, code and date |
| R_72 | 1 | Active |
The payment amounts must not exceed the employer contribution proportion of the total negotiated price |
| R_73 | 1 | Active |
The payment amounts must not exceed the employer contribution proportion of the total negotiated price |
| R_89 | 1 | Active |
The Learning actual end date for the latest programme aim must not be before the Learning actual end date of the latest component aim (not including English and maths) |
| R_90 | 1 | Active |
The Learning actual end date of the component aims must be returned for this programme |
| 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_100 | 1 | Active |
There must be an assessment price recorded |
| R_101 | 1 | Active |
The learning aim must not have more than one Apprenticeship contract type record at the same time |
| R_102 | 1 | Active |
The aim must have an Apprenticeship contract type in the first day |
| R_104 | 1 | Active |
There must be an apprenticeship contract type for the full duration of the aim |
| R_105 | 1 | Active |
The learner must not have different Apprenticeship contract types recorded at the same time |
| 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_112 | 1 | Active |
There must be a Date applies to that matches the Learning actual end date for this aim. |
| R_113 | 1 | Active |
The Learning actual end date is not known, therefore the Date applies to record must not be returned. |
| R_114 | 1 | Changed |
The learner is currently apprenticeship funded and cannot start an Adult skills funded English/maths aim |
| R_119 | 1 | Active |
The apprenticeship financial record cannot be before the Learning start date when the total negotiated price has been returned |
| R_121 | 1 | Active |
There must be a Date applies to that matches the achievement date for this aim. |
| R_122 | 1 | Active |
The achievement date is not known, therefore the Date applies to record must be the same as the Learning actual end date |
| R_123 | 1 | Active |
The learner is continuing or intending to continue, therefore do not return the 'Date applies to' for the latest ACT record |
| R_124 | 1 | Active |
The learner must not have overlapping programme aims |
| R_125 | 1 | Active |
T Level and T Level Foundation Year component or core aims must have a corresponding programme aim with the same combination of funding model and programme type |
| R_126 | 1 | Active |
T Level and T Level Foundation Year component or core aims must have a corresponding programme aim with the same combination of funding model and programme type |
| R_129 | 1 | Changed |
The T Level Technical qualification must have a corresponding programme aim with the same Programme type, Framework code and Pathway (if returned) |
| R_130 | 1 | Changed |
For T Level programme learning aims, planned learning hours and Planned employability, enrichment and pastoral hours must not be returned |
| 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' |
| R_134 | 1 | Active |
The programme type must be Skills Bootcamps for this Employment Status Monitoring Type |
| R_135 | 1 | Active |
Skills Bootcamp component aims must have a corresponding programme aim with the same combination of funding model, programme type and contract reference number |