To make bulk changes to employees' school workforce census (SWC) data, you can use the Data Manager option.
We do have functionality within the system that allows you to update most of the SWC information in bulk via the data manager.
⚠️ Important: Please ensure all data is correct before uploading it via Data Manager. Should any data be uploaded incorrectly we will not be able to reverse this.
Enable school workforce census
To view the SWC menu within Data Manager:
Go to Settings.
Click System Settings then click Global.
In the Name field, type Enable School Workforce Census.
Ensure the Settings column is set to True.
If set to False, click Enable School Workforce Census.
On the Boolean list, select True then click Save.
Access the school workforce census data manager
Within the SWC data manager, there are five areas of data you can manage. To view these:
Click Setup then click Data Manager.
Click School Workforce Census.
Employee
For details on each section, refer to the information below.
Area | Information |
SWC Disability | Enter the SWC code that matches an existing SWC disability. |
DfES Reference or Teacher Number | Enter the DfES reference here. |
SWC Pay Range | Enter the SWC code that matches an existing SWC pay range. |
SWC Pay Framework | Enter the SWC pay framework that matches an existing SWC pay framework. |
SWC Pay Range Min | Enter the pay range minimum value. |
SWC Pay Range Max | Enter the pay range maximum value. |
SWC Pay Review Date | Enter the last pay review date. |
Teacher Qualified Date | Enter the teacher qualification date. |
Teacher Achieved Qual Route | Enter the description of a teacher achieved qual route that matches an existing teacher achieved route lookup. |
HLTA Status | Enter true or false. |
SWC Central Staff | Enter true or false. |
Teacher QTS | Enter true or false. |
Teacher QTLS | Enter true or false. |
Teacher EYTS | Enter true or false. |
Origin / Destination
To quickly update the origin for staff records you import into the system, you can use the Origin / Destination option. Enter the appropriate SWC code for the following:
Employee number.
Post.
Post title.
Post start date.
Origin.
Destination.
Teacher academics
You can use teacher academics to update the qualification details for employees in bulk. To add additional data, type directly into the cells or paste data from a spreadsheet. The employee number is mandatory and you can't upload until you populate that field.
Teacher role identifiers
We recommend that you update the teacher role identifiers against the post. You can use the Teacher Academics option in Data Manager to view all the existing data that is held against each employee for the SWC role identifier.
To add additional data, type directly into the cells or paste data from a spreadsheet. The employee number and role are mandatory and you can't upload this data until you populate these fields.
Teacher subject codes
To view all existing data held in the system against each employee, you can use the Teacher Subject Codes option in Data Manager.
To add additional data, type directly into the cells or paste from a spreadsheet. The employee number and year group are mandatory and you can't upload this data until you populate these fields.