What is the error?
This error means that the Entity Record does not have an Establishment Number recorded, or that the recorded Establishment Number is not in the correct format.
How is this error calculated?
This error checks the ESTCODE table to ensure that the Entity has a valid 7-digit value recorded.
Checking the entity in the ESTCODE MI Count Type table to ensure it has a valid 7-digit value.
How do I resolve this error?
Please take the following steps to resolve this error.
Firstly, locate the record within the ESTCODE table by following these steps:
Click the Administration menu set and then click the Count Types Admin menu
Click the CCIS count type category.
Search for the table ESTCODE using the filter boxes available on the grid.
Click on the table
Using the filter boxes available on the grid, filter the available records using the Entity Reference number.
Once the record has been located, please follow the steps below:
Confirm the Entity has an ESTCODE recorded and that it is 7 digits
If the ESTCODE does not exist, ensure it is created within the ESTCODE table
Add the entity to ESTCODE, ensure it has 7 digits
For information on how to add a new Count Type, see our handy guide.
After correcting any MI errors for the current submission period, it is important to re-run your MI submission to ensure the latest data is being calculated. For more information on MI Administration and how to re-run your data, please see our MI administration article.
ESTCODEs are made up in the following way:
First 3 digits - LEA code
Last 4 digits - The School Code
They can be searched for here: https://www.get-information-schools.service.gov.uk/
📌Note: If you are raising a new case regarding this, please reference this article.