In order to build reliable data sets that will help improve policies pertaining to staff specialisms, pay, DfE programmes, and skill gaps within the Education sector, it is a mandatory requirement from September 2022 to collect Further Education workforce data for the 2021 to 2022 academic year.
Within Cintra iQ, you have the ability to create the Further Education Workforce Data (FEWD) return.
Data that can be generated using existing payroll data is derived from:
-
- FTE
- Number of Contracts
- Annual Salary
- Hourly Rate
- Hourly rate contracts for zero hours
Note:
Ensure the Is Hourly Rate for FE Workforce Data Submission is set for any Units and Rates Addition headings used in the submission.
- Pay Rise
- Contract Type
- Employment Start Date
- Employment End Date
- Reason for Leaving
Data relating to teaching qualifications and roles that has to be collected and entered into the Cintra iQ database via the Cintra iQ application.
About the FE Workforce Data Collection window
Within this window, you can generate data and also validate each record. After which you can produce a FE Workforce Data (FEWD) collection file to send to the Further Education body.
Go to Cintra iQ: Tools> FE Workforce Data Collection
Collection Window
Name | Description |
---|---|
Year |
You can select the Year to which the return applies. |
Employer |
You can select the Employer payroll to which the return applies.
|
FEWD Data tab |
This tab displays the employee records which contain FEWD data. |
Validation tab |
This tab identifies those fields within the affected employee's FEWD record, which needs updating in order to complete the file. Note:You need to return to the relevant import .xlsx file, update the missing information, save to a .csv file, and then re-import before creating a new return file. |
Buttons
Name | Description |
---|---|
Retrieve Return
|
Click this button to retrieve the data already generated for the selected return period.
|
Generate Return Data
|
Click this button to generate the data specific to the Further Education Workforce return for the selected year.
|
Create Return File
|
Click this button to create the .xml return file.
|
Copy Data to Clipboard
|
Click this button to to copy the Further Education Workforce data into the Template app from GOV.UK, where you can then paste it into the FE Workforce Desktop Application Template.
|
Submission Process
- Ensure that the UKPRN numbers exist in the Cintra iQ database via the Lookup Tables.
- Ensure the Is Hourly Rate for FE Workforce Data Submission is set for any Units and Rates Addition headings used in the submission.
- Prepare the Teaching Import template.
- Prepare the Post Import template.
- Import the Teaching Import template into Cintra iQ.
- Import the Post Import template into Cintra iQ.
- Generate the submission.