ILR Compare
This tool compares two ILR files from the same academic year and identifies changed learner and learning-delivery data. For a high-level view of either file, use ILR Summary; to compare consecutive years, use ILR Year Crossover.
The ILR files are processed in your browser. There is nothing to download, and your ILR data never leaves your computer.
Drop both ILR XML files here
or click to browse
Drop first ILR XML file here
or click to browse
Drop second ILR XML file here
or click to browse
File Details
Added Learners
Learners not in the earlier ILR, but in the later ILR. Matched based on Student ID and ULN.
| Learner Ref Number | Aim Reference | Funding Model | Start Date | Planned End Date |
|---|
Removed Learners
Learners in the earlier ILR, but not in the later ILR. Matched based on Student ID and ULN.
| Learner Ref Number | Aim Reference | Funding Model | Start Date | Planned End Date |
|---|
Added Aims
Aims not in the earlier ILR, but in the later ILR. Matched based on Student ID, ULN, and Aim Reference, Funding Model, Start Date and Planned End Date.
| Learner Ref Number | Learner Added | Aim Reference | Funding Model | Start Date | Planned End Date |
|---|
Removed Aims
Aims in the earlier ILR, but not in the later ILR. Matched based on Student ID, ULN, and Aim Reference, Funding Model, Start Date and Planned End Date.
| Learner Ref Number | Learner Removed | Aim Reference | Funding Model | Start Date | Planned End Date |
|---|
Learner FAM Changes
Changes in counts of Learner FAM types and codes between the earlier and later ILR.
| FAM Type | Type Description | FAM Code | Code Description | Before | After | Change |
|---|
Learner FAM Changes by Learner
Learner FAM types and codes added or removed on individual learners between the earlier and later ILR. Learners are matched on Student ID.
| FAM Type | Type Description | FAM Code | Code Description | Change | Learner Ref Number | Learner Status |
|---|
Learning Delivery FAM Changes
Changes in counts of Learning Delivery FAM types and codes between the earlier and later ILR, excluding LDM which is shown separately.
| FAM Type | Type Description | FAM Code | Code Description | Before | After | Change |
|---|
Learning Delivery FAM Changes by Aim
Learning Delivery FAM types and codes added or removed on individual aims between the earlier and later ILR, excluding LDM. Aims are matched on Student ID, Aim Reference, Funding Model, Start Date and Planned End Date.
| FAM Type | Type Description | FAM Code | Code Description | Change | Learner Ref Number | Learner Status | Aim Reference | Funding Model | Start Date | Planned End Date |
|---|
LDM Code Changes
Changes in counts of LDM codes between the earlier and later ILR.
| LDM Code | Description | Before | After | Change |
|---|
LDM Code Changes by Aim
LDM codes added or removed on individual aims between the earlier and later ILR. Aims are matched on Student ID, Aim Reference, Funding Model, Start Date and Planned End Date.
| LDM Code | Description | Change | Learner Ref Number | Learner Status | Aim Reference | Funding Model | Start Date | Planned End Date |
|---|
Study Programme Band Changes
Changes in learner counts by Study Programme Band between the earlier and later ILR.
| Band | Before | After | Difference |
|---|
Learners with Study Programme Band Changes
Learners where Study Programme Band input data changed between files.
| Learner Ref | Band | Academic Age | EHCP | EEP Hours | Planned Learner Hours | Total | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Before | After | Before | After | Before | After | Before | After | Before | After | Before | After | |
Condition of Funding Changes
Changes in learner Condition of Funding summary between earlier and later ILR files for study programme learners only.
| Category | Before | After | Difference |
|---|
Condition of Funding Learners (Earlier ILR)
Study programme learners in the earlier ILR considered for Condition of Funding.
| Learner Ref Number | Planned Hours (PLH + PEEP) | Maths Grade | English Grade | Maths Exception | English Exception | Maths Has Grade >4 or >C | English Has Grade >4 or >C | Studying Maths | Studying English | Meets Maths Condition | Meets English Condition |
|---|
Condition of Funding Learners (Later ILR)
Study programme learners in the later ILR considered for Condition of Funding.
| Learner Ref Number | Planned Hours (PLH + PEEP) | Maths Grade | English Grade | Maths Exception | English Exception | Maths Has Grade >4 or >C | English Has Grade >4 or >C | Studying Maths | Studying English | Meets Maths Condition | Meets English Condition |
|---|
Condition of Funding Exceptions (Earlier ILR)
Study programme learners with maths/English exceptions in the earlier ILR.
| Learner Ref Number | Planned Hours (PLH + PEEP) | Maths Grade | English Grade | Maths Exception | English Exception | Maths Has Grade >4 or >C | English Has Grade >4 or >C | Studying Maths | Studying English | Meets Maths Condition | Meets English Condition |
|---|
Condition of Funding Exceptions (Later ILR)
Study programme learners with maths/English exceptions in the later ILR.
| Learner Ref Number | Planned Hours (PLH + PEEP) | Maths Grade | English Grade | Maths Exception | English Exception | Maths Has Grade >4 or >C | English Has Grade >4 or >C | Studying Maths | Studying English | Meets Maths Condition | Meets English Condition |
|---|
Condition of Funding Grade >4 or >C (Earlier ILR)
Study programme learners with maths or English grade above threshold in the earlier ILR.
| Learner Ref Number | Planned Hours (PLH + PEEP) | Maths Grade | English Grade | Maths Exception | English Exception | Maths Has Grade >4 or >C | English Has Grade >4 or >C | Studying Maths | Studying English | Meets Maths Condition | Meets English Condition |
|---|
Condition of Funding Grade >4 or >C (Later ILR)
Study programme learners with maths or English grade above threshold in the later ILR.
| Learner Ref Number | Planned Hours (PLH + PEEP) | Maths Grade | English Grade | Maths Exception | English Exception | Maths Has Grade >4 or >C | English Has Grade >4 or >C | Studying Maths | Studying English | Meets Maths Condition | Meets English Condition |
|---|