2009-10 derived statistics overview

Documentation

Information for HEIs
Publications	2009-10 statistics derived from HESA data for monitoring and allocation of funding 2009-10 statistics derived from HESA data: Guide to HEFCE web facility
FAQs	Derived statistics exercise FAQs
SAS code	SAS code for 2009-10 statistics derived from HESA data Download the SAS code for 2009-10 statistics derived from HESA data as PDF (446 KB)  | Download the SAS code for 2009-10 statistics derived from HESA data as MS Word (302 KB) Accompanying note - SAS functions and procedures Download the Accompanying note - SAS functions and procedures as PDF (95 KB)  | Download the Accompanying note - SAS functions and procedures as MS Word (31 KB) 2009-10 percentage of institutions mapping subjects in the sector norm cost centre Download the 2009-10 percentage of institutions mapping subjects in the sector norm cost centre as MS Excel Spreadsheet (29 KB)

 

Information for FECs
Publications	2009-10 statistics derived from ILR data for the monitoring and allocation of funding in FECs 2009-10 statistics derived from ILR data: Guide to HEFCE web facility
FAQs	Web facility FAQs Derived statistics exercise FAQs
SAS code	SAS code for 2009-10 statistics derived from ILR data Download the SAS code for 2009-10 statistics derived from ILR data as PDF (244 KB)  | Download the SAS code for 2009-10 statistics derived from ILR data as MS Word (122 KB) Accompanying note - SAS functions and procedures Download the Accompanying note - SAS functions and procedures as PDF (95 KB)  | Download the Accompanying note - SAS functions and procedures as MS Word (31 KB)

Outputs

The tables below list the derived statistics outputs that were provided as part of the 2009-10 web facility and derived statistics exercise. These outputs were made available via the HEFCE extranet.

Indicative funding summaries

Output	Web facility	Derived statistics exercise
2011-12 widening participation (WP) allocations	Yes	Yes
2011-12 teaching enhancement and student success (TESS) allocations	Yes	Yes
2011-12 partial completion weighting	Yes	Yes

Funding data reconciliations

Output	Web facility	Derived statistics exercise
HESES09 re-creation	Yes	Yes
HEIFES09 re-creation	Yes	Yes
HESES09 re-creation based on cost centre sector norms	Yes	Yes
RAS09 re-creation	Yes	Yes
CFEE09 re-creation	Yes	Yes

Other derived statistics

Output	Web facility	Derived statistics exercise
2009-10 HEFCE-fundable student FTEs for TRAC(T)	Yes	No
National student survey (NSS) Targets	Yes	No
Destinations of leavers from higher education (DLHE)	Yes	No
Unistats summaries	Yes	No
Derived statistics that may inform HESES10 data audits	Yes	No
Derived statistics used for publication and to inform policy	Yes	No
Lifelong Learning Network (LLN) student summaries	Yes	No
Research degree qualification rates (RDQRs)	Yes	No

Submission deadlines

Date	Action
15 September 2010	C09051 HESA student record return deadline
22 November 2010	2009-10 Learner Responsive data return (F05)
11 May 2011	Deadline for receipt of action plans for HEIs or FECs wishing to make amendments for their WP and TESS allocations
13 May 2011	Deadline for receipt of final action plans produced by each HEI required to respond
20 May 2011	Deadline for receipt of final action plans produced by each FEC required to respond
25 May 2011	Deadline for sign-off for HEIs or FECs wishing to make amendments for their WP and TESS allocations
27 May 2011	Deadline for submitting amendments and overrides to primary derived fields for each HEI required to respond
3 June 2011	Deadline for submitting amendments and overrides to primary derived fields for each FEC required to respond
10 June 2011	Final deadline for sign-off for 2009-10 HESA data amendments and overrides to primary derived fields as detailed in action plans for each HEI required to respond
17 June 2011	Final deadline for sign-off for 2009-10 ILR data amendments and overrides to primary derived fields as detailed in action plans for each FEC required to respond

Action plans

The following guides for completing the action plans are available:

For HEIs

• General HESA amendments action plan guide
• HESES, RAS and CFEE re-creation action plans guide
• HESES re-creation based on cost centre sector norms action plan guide

For FECs

• General ILR amendments action plan guide
• HEIFES re-creation action plan guide

Example action plans for HEIs

Download the Example action plans for HEIs as MS Excel Spreadsheet (91 KB)  

Example action plans for FECs

Download the Example action plans for FECs as MS Excel Spreadsheet (327 KB)  

Downloading action plans

• Action plans for HEIs
  On the HEFCE extranet, navigate to the 'HEFCE resources' page, then click on '2009-10 statistics derived from HESA data', and then for:
  • General HESA amendments action plan, click on 'APHESA09 data collection'
  • HESES re-creation action plan, click on 'APHESR09 data collection'
  • RAS re-creation action plan, click on 'APRASR09 data collection'
  • CFEE re-creation action plan, click on 'APCFEE09 data collection'
  • HESES re-creation based on cost centre sector norms action plan, click on 'APSNCC09 data collection'
• Action plans for FECs
  On the HEFCE extranet, navigate to the 'HEFCE resources' page, then click on '2009-10 statistics derived from ILR data', and then for:
  • General ILR amendments action plan, click on 'APILR09 data collection'
  • HEIFES re-creation action plan, click on 'APHEIR09 data collection'

Uploading action plans

Once the action plan has been completed, you can upload by navigating back to the same page (for example, for HESA action plans, navigate back to 'APHESA09 data collection'). Next click on 'Upload', browse to the location where the action plan is saved and click 'Upload'.

Override and amendment files

The guide to action plans provides descriptions about the different types of data correction. We will invite institutions to submit an override or amendment file to us on approval of a valid action plan.

Uploading

An override or amendment file may be uploaded via the HEFCE extranet through the locations described below. From these locations click on the 'Upload' button and then, on the subsequent page, click on the 'Browse' button to find the file you wish to submit. Once you have selected this file and the pathname has appeared in the entry field, click on 'Upload File' to complete the upload.

For HEIs

To amend HESA student data, post-collection amendments must be made to the HESA return (Fixed database). If amendments are required after the closing date of the Fixed database, it may be possible to submit an Historic data error file to us.

To submit overrides for primary derived fields or an Historic data error file, navigate to the 'HEFCE resources' page, then click on '2009-10 statistics derived from HESA data', then on 'HESAOVR09 data collection'.

For FECs

To submit ILR amendment files, overrides for primary derived fields or overrides for LAD fields, navigate to the 'HEFCE resources' page, then click on '2009-10 statistics derived from ILR data', then on 'ILROVR09 data collection'.

Example override and amendment files

Override files
Example HDE file  Download the Example HDE file as zip (1 KB)	This is an HDE file to correct the primary derived field RDPEXCL. This example will change 2 students to be included in the RDP population who were previously not included, and exclude 2 students from the RDP population who were previously included.
Example override file for primary derived fields for HEIs  Download the Example override file for primary derived fields for HEIs as zip (1 KB)	This is an override to the primary derived field HESFEELV. This example will change the fee level of 4 students to either FULL or HALF.
Example override file for primary derived fields for FECs Download the Example override file for primary derived fields for FECs as zip (1 KB)	This is an override to the primary derived field HEFFEELV. This example will change the fee level of (hypothetical) learner aim 00012345 to FULL and aim 00023456 to HALF. Note the use of RECNO to create a suitable field to allow the check sum to be computed.
Example override for LAD fields  Download the Example override for LAD fields as zip (1 KB)	This is an override to the LAD field AWARD_BO. This example will change the awarding body of (hypothetical) learning aim references ABCDE001, ABCDE002 and ABCDE003. Note the use of RECNO to create a suitable field to allow the check sum to be computed.

 

ILR amendment files
CHANGE FILES
Example HE data set change file  Download the Example HE data set change file as zip (1 KB)	This example changes fields Type of instance year (H13), Mode of study (H14), Level applicable to funding council HESES (H15) and Student instance FTE (H17) for students identified by Provider number (H01), Learner reference number (H03), Learning aim data set sequence (H05) and Student instance identifier (H09).
Example learning aim data set change file  Download the Example learning aim data set change file as zip (1 KB)	This example changes the Programme type (A15) identified by the combination of Provider number (A01), Learner reference number (A03), Learning aim data set sequence (A05) and Provider specified learning aim data (A48a, A48b).
Example learner data set change file  Download the Example learner data set change file as zip (1 KB)	This example changes the Country of domicile (L24) for students identified by the combination of Provider number (L01), Contract/allocation type (L02), Learner reference number (L03) and Provider specified learner data (L42a, L42b).
DELETION FILES
Example HE data set deletion file  Download the Example HE data set deletion file as zip (1 KB)	This example removes learner data incorrectly returned from the HE data set identified by the combination of Provider number (H01), Learner reference number (H03), Learning aim data set sequence (H05) and Student instance identifier (H09).
Example learning aim data set deletion file  Download the Example learning aim data set deletion file as zip (1 KB)	This example removes learning aim data incorrectly returned. The records are identified by the combination of Provider number (A01), Learner reference number (A03), Learning aim data set sequence (A05) and Provider specified learning aim data (A48a, A48b).
Example learner data set deletion file  Download the Example learner data set deletion file as zip (1 KB)	This example removes learners incorrectly returned. The records are identified by the combination of Provider number (L01), Contract/allocation type (L02), Learner reference number (L03) and Provider specified learner data (L42a, L42b).
ADDITION FILES
Example HE data set addition file  Download the Example HE data set addition file as zip (1 KB)	This example adds HE data to three existing learning aims.
Example learning aim data set addition file  Download the Example learning aim data set addition file as zip (1 KB)	This example adds learner data to the learning aim data set.
Example learner data set addition file  Download the Example learner data set addition file as zip (1 KB)	This example adds three students to the learner data set.

 

Page last updated 24 November 2011