HESES11 re-creation

The HESES re-creation is a funding data reconciliation output that is a re-creation of the HESES11 workbook using 2011-12 HESA student data. It is primarily of interest to those responsible for student data, audit or finance.

The workbook (HESR11H-XXXX.xls, where XXXX denotes the HESA institution identifier) contains all original HESES11 tables, a copy of these tables that have been re-created using 2011-12 HESA student data and difference and summary tables.

HESES11 re-creation workbook
Further information
HESES re-creations from earlier years

HESES11 re-creation workbook

The HESES11 re-creation workbook and individualised file can be accessed from the HEFCE extranet (see see How to access outputs for further details). The main components of the HESES11 re-creation workbook are:

Coversheet - this page details how HESES re-creation data are used to inform the HESES re-creation coversheet. It also describes how these data can be rebuilt from the HESES re-creation individualised file.
Summary - this summarises the comparison of HESES11 and HESES11 re-creation, together with highlighting where problems of fit may occur and also specifying how the values can be rebuilt from the individualised file.
Funding worksheets - this page details how HESES re-creation data are used to inform the HESES re-creation funding worksheets.

Further information

Linking student instances between years

We have linked the 2011-12 HESA data to earlier years’ data using the HUSID, UKPRN and NUMHUS (HIN) triple. This is to help account for definitional differences between HESA and HESES data.

These data from earlier years will be used to help determine the following:

FTE for some students on standard years of instance
Price group and NHS bursary status for students on medical or dental programmes that have either intercalated a degree or taken a foundation year
NHS bursary status for students who have taken a foundation year.

For the algorithms used to re-create Table 6 we have linked the 2011-12 HESA data to the 2009-10 and 2010-11 HESA returns using the HUSID and UKPRN combination. We linked across these three years of data to identify students that were not active at the institution in either of the two academic years prior to 2011-12.

Where a student (HUSID) from the 2011-12 HESA data has more than one record in the 2010-11 HESA return, we linked to records from the full-time undergraduate population (SNCFTUGPOP10 = 1) in preference to those not in the population. If the student had more than one record with the same value of SNCFTUGPOP10 we linked to records that were active in 2010-11 (SNCACT10 = 1) in preference to those that were not active.

If the student had more than one record with the same value of SNCACT10, we linked to the record with the lowest COURSEAIM10 value.

If this failed to uniquely identify the student we continued to prioritise using highest STULOAD10 value and then earliest COMDATE10 value until we identified a single record. We took an equivalent approach when linking to the 2009-10 HESA record. If in a previous year a student generated multiple years of instance that match on all criteria, we simply select one of the records.

Teaching grant information

Further details on each aspect of the calculation of teaching grant can be found in the 'Annex to funding agreement with higher education institutions' and 'Funding agreement with higher education institutions' on our Annual funding allocations page under 'For institutions'. The 2011-12 documents can be found in the Archive of funding allocations. In addition, the three worksheets (HBK, STD and F11) are described in more detail in Appendix 3, 'Guidance on the grant adjustment tables and related worksheets' of HESES11 (HEFCE 2011/27).