Skip to main content

Staff record 2015/16

Back to C15025

Credibility report mapping document

Version 1.0 Produced 2016-06-23

Contents: Background | Mapping

The purpose of this document is to provide a mapping between the locations of tables as presented in the C14025 Check documentation and the tables in the new C15025 Credibility report, along with details of any key changes.

Please note that the release of tables in the new credibility report is part of the new agile process. As such tables will be released over the coming weeks.

Background

HESA is updating the way in which management information is presented back to HEPs to review and assess the data quality of the submission. In previous years this management information has taken the form of a series of tables presented in an Excel workbook known as Check documentation. For C15025 the majority of those items used by HESA to form the basis of data quality queries will be replaced with web-based Credibility report output tables. These tables will be grouped into chapters, where each chapter is a category e.g. Contract.

Functionality of the Credibility report allows for there to be more year-on-year comparisons shown on the output tables than has previously been possible in the Check documentation. These year-on-year comparisons are shown as both percentage and numerical changes. These will however be displayed within the data cells rather than in separate columns or rows. Display of these calculations will be controlled using dynamic features that can be toggled on and off within the report view allowing the user to customise their display.

Mapping

C14025 Check documentation item worksheet -> item C15025 Credibility report chapter -> table Key changes to data presentation
Institutional_Information -> Item 1 - Number of staff by legal sex and nationality Person -> Number of staff by nationality and legal sex (NAT1)
  • 'Value not returned' column for sex is no longer needed as non-academic atypical staff have been removed from the coverage.
  • Static data provided for comparison with data in the previous year.
Institutional_Information -> Item 2 - Number of contracts by terms of employment and mode of employment Contract -> Number of contracts by mode of employment and terms of employment (MOE1)
  • Static data provided for comparison with data in the previous year.
Institutional_Information -> Item 3 - Number of contracts by mode of employment and contract FTE Contract -> Number of contracts by FTE and mode of employment (CFTE1)
  • Static data provided for comparison with data in the previous year.
Institutional_Information -> Item 4 - Full-time equivalent (FTE) by SOC2010 major groups by academic employment function and mode of employment Activity -> Staff FTE by mode of employment, SOC2010 major groups and academic employment function (MOE2)
  • Static data provided for comparison with data in the previous year.
Institutional_Information -> Item 5 - FTE by mode of employment and SOC2010 major groups Activity -> Staff FTE by SOC2010 major groups and mode of employment (SOC1)
  • SOC2010 groups moved to rows and mode of employment moved to columns for presentation.
  • Static data provided for comparison with data in the previous year.
Institutional_Information -> Item 6a - Full-person equivalent (FPE) by activity after leaving for staff Person -> Staff FPE (excluding atypical) for activity after leaving (ACTL3)
  • No changes to data presentation.
Institutional_Information -> Item 6b - Number of academic teaching qualifications as at 1 Dec Person -> Number of academic teaching qualifications as at 1 December (ATQ3)
  • Figures for Scottish providers now included.
Institutional_Information -> Item 7a - Healthcare professional specialty of academic staff with NHS contracts Clinical -> Number of academic staff with healthcare professional specialty by NHS contracts (HSPC1)
  • Static data provided for comparison with data in the previous year.
  • Table only displays the specialties that have been returned.
Institutional_Information -> Item 7b - Clinical sub-specialty of academic staff with NHS contracts Clinical -> Number of academic staff with clinical sub-specialty by NHS contracts (CLIN1)
  • Static data provided for comparison with data in the previous year.
  • Table only displays the sub-specialties that have been returned.
Institutional_Information -> Item 8 - NHS contract grade of academic staff with NHS contracts Clinical -> Number of academic staff by NHS contract grade and NHS contracts (NHSC1)
  • Static data provided for comparison with data in the previous year.
CCANALYSIS_2 -> Item 9 - Analysis of Academic Employment Function and Activity by Cost Centre HESA cost centres -> HESA cost centre by terms of contract and academic type (HCC1)
  • Item now split into two tables.
HESA cost centres -> HESA cost centre by academic employment function (HCC2)
  • New table for the split of academic employment function.
  • Staff denominator for SSR has been included.
Checkdoc_I -> Item 10a - Number of staff (excluding atypical) by legal sex and age as at 1 Dec Person -> Number of staff (excluding atypical) by age and legal sex (AGE1)
  • No changes to data presentation.
Checkdoc_I -> Item 10b - Number of academic staff with only atypical contracts during the reporting year by legal sex and age Person -> Number of staff with only atypical contracts by age and legal sex (AGE2)
  • No changes to data presentation.
Checkdoc_I -> Item 11 - Staff FPE (excluding atypical) by previous employment Person -> Staff FPE (excluding atypical) by previous employment for staff as at 1 December and new starters (PREV3)
  • No changes to data presentation.
Checkdoc_I -> Item 12 - Number of staff (excluding atypical) by disability as at 1 Dec Person -> Number of staff (excluding atypical) by disability as at 1 December (DISB1)
  • No changes to data presentation.
  • Some checks now moved to quality rules.
Checkdoc_I -> Item 13a - Unknown values for staff (excluding atypical) as at 1 Dec.

Checks previously carried out on checkdoc are now quality rules.		 Unknown -> Academic teaching qualification unknowns for staff (excluding atypical) as at 1 December (ATQ1)
  • Item split into individual tables for each field.
  • Table for academic teaching qualification.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Nationality unknowns for staff (excluding atypical) as at 1 December (NAT2)
  • New table for nationality.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Ethnicity unknowns for staff (excluding atypical) as at 1 December (ETH1)
  • New table for ethnicity.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Highest qualification held unknowns for staff (excluding atypical) as at 1 December (HQHD1)
  • New table for highest qualification held.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Previous employment unknowns for staff (excluding atypical) as at 1 December (PREV1)
  • New table for previous employment.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Location after leaving unknowns for staff (excluding atypical) as at 1 December (LOCL1)
  • New table for location after leaving.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Activity after leaving unknowns for staff (excluding atypical) as at 1 December (ACTL1)
  • New table for activity after leaving.
  • No shading present on the table.
  • No historic data provided.
Checkdoc_I -> Item 13b - Unknown values for staff with atypical contracts only during the reporting period.

Checks previously carried out on checkdoc are now quality rules.		 Unknown -> Ethnicity unknowns for staff with atypical contracts only (ETH3)
  • Nationality and Ethnicity have been split into separate tables.
  • No historic data provided.
Unknown -> Nationality unknowns for staff with atypical contracts only (NAT4)
  • Nationality and Ethnicity have been split into separate tables.
  • No historic data provided.
Checkdoc_I -> Item 13c - Unknown values for staff (excluding atypical) who started during the reporting period.

Checks previously carried out on checkdoc are now quality rules.		 Unknown -> Academic teaching qualification unknowns for staff (excluding atypical) who started during the reporting period (ATQ2)
  • Item split into individual tables for each field.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Nationality unknowns for staff (excluding atypical) who started during the reporting period (NAT3)
  • New table for nationality.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Ethnicity unknowns for staff (excluding atypical) who started during the reporting period (ETH2)
  • New table for ethnicity.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Highest qualification held unknowns for staff (excluding atypical) who started during the reporting period (HQHD2)
  • New table for highest qualification held.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Previous employment unknowns for staff (excluding atypical) who started during the reporting period (PREV2)
  • New table for previous employment.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Location after leaving unknowns for staff (excluding atypical) who started during the reporting period (LOCL2)
  • New table for location after leaving.
  • No shading present on the table.
  • No historic data provided.
Unknown -> Activity after leaving unknowns for staff (excluding atypical) who started during the reporting period (ACTL2)
  • New table for activity after leaving.
  • No shading present on the table.
  • No historic data provided.
Checkdoc_I -> Item 13d - Number of unknown and information refused values for national identity - For Welsh HEPs only.

Checks previously carried out on checkdoc are now quality rules.		 Unknown -> Unknown values for national identity - Welsh only (NATD1)
  • Item will be split across two tables.
  • New table for unknowns.
  • No shading present on the table.
Unknown -> Information refused values for national identity - Welsh only (NATD1)
  • New table for information refused.
  • No shading present on the table.
Checkdoc_I -> Item 13e - FPE for staff (excluding atypical) in SOC2010 major groups 1, 2 or 3 by previous employment and activity after leaving for staff who have left during the reporting period Person -> Staff FPE (excluding atypical) by previous employment and activity after leaving for staff who have left during the reporting period (PREV4)
  • No shading present on the table.
Checkdoc_II -> Item 14 - Staff FPE (excluding atypical) by levels and academic employment function Contract -> Staff FPE (excluding atypical) by academic employment function and levels (LVL1)
  • No changes to data presentation.
  • Some checks now moved to quality rules.
Checkdoc_II -> Item 15a - FTE by contract levels and SOC2010 major groups Contract -> Staff FTE by contract levels and SOC2010 major groups (LVL2)
  • Item will be split across two tables.
  • New table for SOC major groups.
  • Static data provided for comparison with data in the previous year.
Contract -> FTE by contract levels and academic marker (LVL3)
  • New table for academic marker.
  • Static data provided for comparison with data in the previous year.
  • Check previously carried out on this item in checkdoc is now a quality rule.
Checkdoc_II -> Item 15b - Staff FTE (excluding atypical) by SOC2010 major group, mode of employment and basic salary Salary -> Staff FTE (excluding atypical) basic salary by academic marker and mode of employment (SAL1)
  • Static data provided for comparison with data in the previous year.
Checkdoc_II -> Item 15c - Staff FTE (excluding atypical) by SOC2010 major group, contract level, mode of employment and basic salary Salary -> Staff FTE (excluding atypical) basic salary for SOC2010 major groups 1-3 by contract level and mode of employment (SAL2)
  • Item will be split in to two tables.
  • New table for SOC major groups 1-3.
  • Static data provided for comparison with data in the previous year.
Salary -> Staff FTE (excluding atypical) basic salary for SOC2010 major groups 4-9 by contract level and mode of employment (SAL3)
  • New table for SOC major groups 4-9.
  • Static data provided for comparison with data in the previous year.
Checkdoc_II -> Item 15d - Staff FPE (excluding atypical) by mode of employment and salary group Salary -> Staff FPE (excluding atypical) by salary group and mode of employment (SALG1)
  • Updated salary groups following change to national framework spine points.
Checkdoc_III -> Item 16 - Staff FPE (excluding atypical) by mode of employment and salary group Clinical -> Healthcare professional specialty of staff with clinical status (HSPC2)
  • Item 17a and 16 merged.
  • Static data provided for comparison with data in the previous year.
Checkdoc_III -> Item 17a - Number of staff members by Healthcare professional specialty
Checkdoc_III -> Item 17b - Number of staff members by Clinical Excellence/Merit/Distinction Awards Clinical -> Number of staff by clinical excellence awards (AWRD1)
  • No changes to data presentation.
Checkdoc_IV -> Item 18a - FPE by SOC2010 major groups (Staff (excluding atypical) as at 1 Dec) Activity -> Staff FPE as at 1 December by SOC2010 major groups (SOC2)
  • Static data provided for comparison with data in the previous year.
Checkdoc_IV -> Item 18b - FPE by SOC2010 major groups (Atypical staff within the reporting period) Activity -> Staff FPE for atypical staff by SOC2010 major groups (SOC3)
  • SOC2010 major groups 4-9 no longer displayed due to removal of non-academic atypical contracts.
  • Static data provided for comparison with data in the previous year.
Checkdoc_IV -> Item 19 - FPE by Terms of employment of academic staff Contract -> Staff FPE (excluding atypical) for terms of employment (TERM1)
  • No changes to data presentation.
Checkdoc_IV -> Item 20a and b - FPE by Mode of employment of staff (excluding atypical) Contract -> Staff FPE by mode of employment (excluding atypical) and academic marker (MOE3)
  • Parts a and b combined into one new table.
Checkdoc_IV -> Item 21 - All staff FPE by Terms of employment, Mode of employment and published groupings Person -> Staff FPE for ethnicity by mode of employment and academic marker (ETH4)
  • Item will be split in to three tables for ethnicity and source of basic salary.
  • New table for ethnicity by mode of employment and academic marker.
  • Static data provided for comparison with data in the previous year.
Person -> Atypical staff FPE for ethnicity (ETH5)
  • New table for atypical staff ethnicities.
  • Static data provided for comparison with data in the previous year.
Activity -> Staff FPE for source of basic salary by mode of employment and academic marker (SOBS1)
  • New table for source of basic salary by mode of employment and academic marker.
  • Static data provided for comparison with data in the previous year.
CCANALYSIS_1 -> Item 22 - Analysis of 2013-14 Student, Staff & Finance & 2014-15 Staff data by Cost Centre Not appearing in credibility report. Moved to new web report.
  • All checks previously carried out on CCAnalysis are now quality rules.
New for 2015/16 Person -> Summary of staff (excluding atypical) by disability as at 1 December (DISB2)
  • Table displays disability groupings.
  • Static data provided for comparison with data in the previous year.
Salary -> Average salary (£) for staff (excluding atypical) by contract level and legal sex (SAL4)
  • Table displays average salary by contract level, mode of employment and legal sex.
  • Static data provided for comparison with data in the previous year.

Need help?

Contact Liaison by email or on +44 (0)1242 388 531.