Note issued by Capita:Summary Report Enquiries (Update 05/11 15:40)Our developers have had a look at the DfE coding for the Summary report and they suggest that the following could explain many of the enquiries from schools. Item 5, 6 and 7 below are issue we have found today and have not yet been confirmed by the DfE.
- The SWC summary report calculation is based on Contracts/Service agreements. It does not count staff where contracts/SAs are not included in the Return.
- Table B excludes workforce members with posts of AVT, SUP and TAS (Advisory Teachers, Support staff, and Teaching Assistants)
- Tables D, E and F do NOT exclude workforce members with the post of AVT, SUP and TAS (Advisory Teachers, Support staff and Teaching Assistants), so in many cases we would expect table D, E and F to include staff that are excluded from table B.
- The Ethnicity staff count in table E does not include staff that have not been assigned an Ethnicity code, so it is possible for table A to include more staff than table E.
- Table C seems to have a bug when looking at contract end dates which means that all contracts with an end date (even if it is in the future) will be excluded.
- Table D seems to have a bug when dealing with workforce members with more than one contract. There is no particular order for contracts in the XML file but the report always uses the first contract it meets for deciding if the member of staff should be included in the calculations for the table. So if the first contract that it checks for the workforce member has an end date before the Census day that workforce member will be ignored even if they have another contract that has no end date or has an end date after the Census day.
- Table E seems to have the same bug as described for Table D above.