HEIFES10 re-creation

The HEIFES re-creation is a funding data reconciliation output that is a re-creation of the HEIFES10 workbook using 2010-11 ILR student data. It is primarily of interest to those responsible for student data, audit or finance.

The workbook (HEIFR10YYYYYY.xls, where YYYYYY is the provider number (ST_UPIN (L01)) for the college) contains all original HEIFES10 tables, a copy of these tables that have been re-created using 2010-11 ILR student data and difference and summary tables.

HEIFES10 re-creation workbook
Further information
HEIFES re-creations from earlier years

HEIFES10 re-creation workbook

The HEIFES10 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 HEIFES10 re-creation workbook are:

Coversheet - this page details how HEIFES re-creation data are used to inform the HEIFES re-creation coversheet. It also describes how these data can be rebuilt from the HEIFES re-creation individualised file.
Summary - this summarises the comparison of HEIFES10 and HEIFES10 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 HEIFES re-creation data are used to inform the HEIFES re-creation funding worksheets.

Further information

Linking student instances between years

We have linked the 2010-11 ILR LR05 data to 2009-10 ILR F05 data using the fields ST_REF (L03), ST_UPIN (L01), HQ_NUMHU (H09). This is to help account for definitional differences between ILR and HEIFES data.

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

Instance attributes for the first countable year for students who are generating two countable years.
FTE and price group distribution for final year students on non-standard years of programme of study.

For the algorithms used to re-create Table 6 we have linked the 2010-11 ILR LR05 data to the 2008-09 ILR F04 data and 2009-10 ILR F05 data using the ST_REF (L03) and ST_UPIN (L01) combination. We linked across these three years of data to identify students that were not active at the college in either of the two academic years prior to 2010-11.

Where a student (ST_REF (L03)) from the 2010-11 ILR LR05 data has more than one record in the 2009-10 ILR F05 return, we linked to records from the full-time undergraduate population (SNCFTUGPOP09 = 1) in preference to those not in the population.

If the student had more than one record with the same value of SNCFTUGPOP09 we linked to records that were active in 2009-10 (SNCACT09 = 1) in preference to those that were not active. If the student had more than one record with the same value of SNCACT09, we linked to the record with the lowest HEFQAIM09 value.

If this failed to uniquely identify the student we continued to prioritise using highest HQ_FTE09 (H17) value and then earliest QA_ST_DA09 (A27) value until we identified a single record. We took an equivalent approach when linking to the 2008-09 ILR F04 record.

Teaching grant information

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