| Note |
|---|
Please bear in mind |
...
PICS is are not responsible for your data or its validity – we can explain how to use |
...
the system to identify and solve problems but many of the errors themselves will be either out of our control or responsibility. |
To locate errors from the /wiki/spaces/POH/pages/276450835 produced by PICSThe PICSWeb Learner Validation Report can be used to identify learners with ILR rule violations. After producing the report, you can locate the errors in the learner record using the following method:
1. Open the Validation Report spreadsheet and locate the Error Codes ILR Rule column.
2. Note down or copy the relevant error code.
3. Download the ILR Validation Rules spreadsheet from the ESFA website.
4. In the spreadsheet, press Ctrl + F to open the Find window.
...
5. Select Options > > and select Workbook from the Within drop-down menu.
...
6. Enter or paste the error code into the Find What field and select Find Next. You will then be taken to the row for the error, which will explain the validation rules for the relevant . Then click either Find All for a list of all cells containing that value, or Find Next to show the first cell with that value and then repeat as necessary. Check the detail in the relevant row, especially the Rule Description and Field Values columns. The problem may be caused by a combination of conflicting values in different fields, so you may need to check more than one field.
7. You can then Finally, go to the learner episode as indicated by the rule violations spreadsheet in PICSWeb and make the necessary change.
We recommend correcting errors before first then warnings, as they have they will make the submission invalidthe former will cause rejection of that learner record with a consequent loss of funding. Once you have made your corrections, you can /wiki/spaces/POH/pages/276450596 and /wiki/spaces/POH/pages/276450491are happy with your ILR data, you can continue to the ILR Exporter to generate your ILR submission as normal.