2023-08 - WA School Code List Update

Owned by Graham Kidd
Aug 30, 2023

Table of Contents

Overview of changes included in this hotfix package

The WA Government maintain a list of Active WA Schools at


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. 

1) Download the fix from the link below :

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.

Requesting Assistance


As always, if you have any further questions or concerns, our Support team is available to assist:

Please make sure to mention that your query is in relation to the ‘NZQA Specification 3.4 Iwi Name Changes' fix as appropriate to help our support team action your request as efficiently as possible.