Schools List - Alphabetical list of Western Australian schools (XLSX)
This list is stored in Synergetic in the table refExternalSystemSchool with ExternalSystemType value of 'MCEETYA', and is used to populate the 'External System Code' and External System Value fields in luSchool.
The Patcher provided in this hotfix will update refExternalSystemSchool with the WA Government Schools List from 8 August 2023.
Obtaining and applying the hotfix
We have created a SQL fix that make the changes listed above.
2) Save to a location of your choosing, that you can access from your SQL Server
3) Open and run the patcher
Open the zip file and extract the included exe file to your SQL server (or to a location that is able to communicate with the SQL Server)
Run the exe - this will run a database patcher wizard which will take you through the steps to update the required reference data table.
The patcher can be applied with Users remaining logged in and will only take seconds to run
3) Once the patcher has completed successfully, your system's School Reference Data set should be updated with the new Schools List. You will now be able to update luSchool with these latest School Codes.
As always, if you have any further questions or concerns, our Support team is available to assist: