Version 2 – Internal Review – Not a Production MIS
Back to dashboard
ILR & Funding Returns
DfE 2026/27 Individualised Learner Record view of the live NSPP learner database — one learner record, one or more learning aims. Editing a learner anywhere in the CRM changes this view immediately.
Legacy page — not yet moved to shared learners. Uses older browser or reference data (names may show as "Signed learner #N"); do not use its counts operationally. Live learners are on the Learners page.
Local checks only. Final validation remains DfE FIS / Submit Learner Data — a file that passes here can still be rejected there. Human-visible dates are UK format DD-MM-YYYY; ILR XML dates remain YYYY-MM-DD as the DfE schema requires.
Signed learner #21 (name in source spreadsheet)
YNYCA Adult Skills Fund — Free Courses for Jobs Level 3 · Programme details pending · Assessor James Fairbrother
LearnRefNumber NSPP984994 · CRM status Not started · Start Not recorded
Cannot Export
17 blocking · 2 warning(s)
- Devolved ASF: a Source of Funding (SOF) Learning Delivery FAM identifying the funding authority is required — the official SOF code must be entered by staff.
- Adult Skills Fund provision requires a programme aim plus the component aim(s) actually delivered.
- ConRefNumber must match the contract reference issued by the funding authority.
- Adult skills (FundModel 35) — devolved ASF delivery is reported on the adult skills funding model.
Validation issues
- Cannot exportLearner.ULNNo ULN held. A ULN is required for every funded learner.
- Cannot exportLearner.DateOfBirthDate of birth is not recorded against this learner.
- Cannot exportLearner.SexSex (M/F) is not recorded.
- Cannot exportLearner.EthnicityEthnicity code is not recorded. The official code must be taken from the DfE code list.
- Cannot exportLearner.LLDDHealthProbLLDD / health problem declaration is not recorded (1 yes, 2 no, 9 not known).
- WarningLearner.NINumberNo National Insurance number held — conditionally required where funding eligibility must be evidenced.
- Cannot exportLearner.PostcodePriorPostcode prior to enrolment is missing.
- Cannot exportLearner.PostcodeCurrent postcode is missing.
- Cannot exportLearnerEmploymentStatus.EmpStatEmployment status on entry (EmpStat) is not coded.
- Cannot exportLearnerEmploymentStatus.DateEmpStatAppDate the employment status applies is missing.
- Cannot exportLearnerPriorAttain.PriorLevelPrior attainment level is not coded — required for Adult Skills Fund learners.
- Cannot exportLearningDelivery.LearnAimRefNo LARS LearnAimRef held for "Programme details pending". The qualification name alone cannot be returned.
- Cannot exportLearningDelivery.LearnStartDateLearning start date is missing.
- Cannot exportLearningDelivery.LearnPlanEndDatePlanned end date is missing.
- Cannot exportLearningDelivery.DelLocPostCodeDelivery location postcode is missing.
- Cannot exportLearningDelivery.ConRefNumberContract reference for YNYCA Adult Skills Fund — Free Courses for Jobs Level 3 is not recorded.
- Cannot exportLearningDeliveryFAM.SOFSource of funding (SOF) FAM code for the devolved authority is not recorded.
- WarningHoursRecord.PlannedHoursPlanned hours are not recorded for a funding stream that requires an Hours Record.
- Cannot exportLearningDelivery.CompStatusCompletion status cannot be derived — the learner has no start/end dates.
Edit ILR fields
Saved against the same learner record used everywhere else in the CRM. Date inputs are day-first UK; values are stored as ISO and exported as YYYY-MM-DD in XML only.
Learner and child entities
| ILR field | CRM meaning | Value | Requirement |
|---|---|---|---|
| LearnerLearnRefNumber | CRM learner referenceGenerated by the CRM from the learner record | NSPP984994 | Required now |
| LearnerULN | Unique Learner NumberILR field — entered against the master learner record | Not held | Required now |
| LearnerFamilyName | SurnameLearner name (Learners page) | #21 | Required now |
| LearnerGivenNames | First name(s)Learner name (Learners page) | Signed learner | Required now |
| LearnerDateOfBirth | Date of birthLearner record (Personal tab) unless supplied hereXML format YYYY-MM-DD; shown in the CRM as DD-MM-YYYY. | Not held | Required now |
| LearnerEthnicity | Ethnicity codeILR field — official code entered by staffThe 2026/27 ethnicity code list is not reproduced in this prototype, so ethnicity is never auto-coded. Staff must enter the official code taken from the DfE specification. | Not held | Required now |
| LearnerSex | SexILR field — M or F | Not held | Required now |
| LearnerLLDDHealthProb | LLDD / health problem declarationILR fieldValue 1 requires child LLDDandHealthProblem records. | Not held | Required now |
| LearnerNINumber | National Insurance numberLearner record (Personal tab) unless supplied hereConditionally required where the funding rules require NI verification of eligibility. | Not held | Conditionally required |
| LearnerPostcodePrior | Postcode prior to enrolmentHome postcode (Learners page) unless overridden here | Not held | Required now |
| LearnerPostcode | Current postcodeHome postcode (Learners page) | Not held | Required now |
| LearnerAddLine1 | Address line 1Not held in this prototype dataset | Not held | Conditionally required |
| LearnerTelNo | TelephoneLearner record — restricted field | Not held | Conditionally required |
| LearnerEmail | EmailLearner record — restricted field | Not held | Conditionally required |
| LearnerEmploymentStatusEmpStat | Employment status on entryCRM employment status: Employed — official code entered here | Not held | Required now |
| LearnerEmploymentStatusDateEmpStatApp | Date employment status appliesILR field | Not held | Required now |
| LearnerPriorAttainPriorLevel | Prior attainment levelCRM prior attainment: Not recordedPriorLevel (Prior Attainment entity, with DateLevelApp) uses the official 2026/27 code list. Not reproduced here, so the CRM's plain-English prior attainment is shown for staff coding rather than auto-mapped. | Not held | Required now |
| LearnerPriorAttainDateLevelApp | Date prior level appliesILR field | Not held | Conditionally required |
Learning Delivery — aim 1
| ILR field | CRM meaning | Value | Requirement |
|---|---|---|---|
| LearningDeliveryLearnAimRef | LARS learning aim referenceCRM qualification: Programme details pendingThe LARS reference is the authoritative aim identifier; the friendly qualification name is not sufficient. | Not held | Required now |
| LearningDeliveryAimType | Aim typeDerived from the funding stream ruleThis funding stream requires a programme aim (AimType 1). | 1 | Required now |
| LearningDeliveryAimSeqNumber | Aim sequence numberGenerated — one aim per learner is held in the CRM today | 1 | Required now |
| LearningDeliveryLearnStartDate | Actual start dateStart date (Learners page) | Not held | Required now |
| LearningDeliveryOrigLearnStartDate | Original start dateOnly applicable where the aim has been restarted or transferred | Not held | Conditionally required |
| LearningDeliveryLearnPlanEndDate | Planned end datePlanned end date (Learners page) | Not held | Required now |
| LearningDeliveryFundModel | Funding modelAdult skills (FundModel 35) — devolved ASF delivery is reported on the adult skills funding model. | 35 | Required now |
| LearningDeliveryProgType | Programme typeNot applicable to ASF / Skills Bootcamp provision — apprenticeship field | Not held | Not applicable |
| LearningDeliveryDelLocPostCode | Delivery location postcodeFunded provision postcode (Learners page) | Not held | Required now |
| LearningDeliveryLSDPostcode | Learning support delivery postcodeOnly where learning support delivery differs from the delivery location | Not held | Conditionally required |
| LearningDeliveryPriorLearnFundAdj | Prior learning funding adjustmentOnly where prior learning reduces the funded content | Not held | Conditionally required |
| LearningDeliveryOtherFundAdj | Other funding adjustmentOnly where another funding adjustment applies | Not held | Conditionally required |
| LearningDeliveryConRefNumber | Contract referenceCRM contract: YNYCA Adult Skills Fund — Free Courses for Jobs Level 3 | Not held | Required now |
| LearningDeliveryCompStatus | Completion statusCRM learner status: Not started | Not held | Required now |
| LearningDeliveryLearnActEndDate | Actual end dateRequired once the learner completes or withdraws | Not held | Conditionally required |
| LearningDeliveryWithdrawReason | Withdrawal reasonWithdrawal reason codes are not reproduced here; a withdrawn aim is reported as needing the official code from the specification. | Not held | Not applicable |
| LearningDeliveryOutcome | OutcomeCRM outcome tab | Not held | Conditionally required |
| LearningDeliveryAchDate | Achievement dateRequired when Outcome = 1 (achieved) | Not held | Conditionally required |
| LearningDeliveryOutcomeGrade | Outcome gradeOnly where the aim carries a grade | Not held | Conditionally required |
| LearningDeliveryFAMSOF | Source of funding FAMSource of Funding (SOF) LearnDelFAM code for the relevant devolved authority must be taken from the DfE 2026/27 SOF list. Not guessed here. | Not held | Required now |
| HoursRecordPlannedHours | Planned hoursHours Record entity — required for this funding stream | Not held | Required now |