Skip to main content

Student 2016/17: Support guides

This page provides an overview of the 2016/17 Student collection (C16051).

This should be used alongside the C16051 coding manual, which provides more detailed, technical information about the collection.

Need help? Contact us by email or on +44 (0)1242 211144

Student overview

What is the Student stream?

We collect data across a number of streams. These streams focus on different aspects of higher education.

The Student stream collects data about students studying at higher education providers in the UK. Details of which students need to be returned to us are included in the Coverage document found in the Coding manual.

The data we collect on behalf of the sector is provided to governments and fundng bodies in order to support the regulation of higher education. We also make anonymised data available to the public to enhance understanding of UK higher education and to support its advancement

What is a coding manual?

Our coding manuals provide you with all the necessary documentation to support your data return. The coding manual contains technical documents giving detailed information on the record's coverage, data specification and submission formats. Familiarising yourself with these documents will help you make an accurate and timely return.

Each collection has its own coding manual which can be found in the Data collection section of our site. By default, you will land on the open collection for each record; you can then select previous or future years.

The coding manuals will be updated throughout the data collection cycle and Record Contacts informed by email when new versions are made live. Be sure to check the manual's Revision history for a summary of changes.

How do I submit data to HESA?

You submit data via our online data collection system. To access this, you will need to have an appropriate role in our Identity System (IDS). We publish an IDS user guide which includes information on creating and editing your account.

You will need to be given access to the data collection system by the relevant record contact at your provider.

Once you have access to the system you will be able to upload files, track the progress of your submission, view data quality issues and download reports. An overview of the submission and validation process is given below. Further details are provided in the Coding manual under the 'Submission process and quality assurance' section heading.

Submit data

Where can I find...?

The coding manual homepage includes all the technical information you require, including:

  • The data specification
  • File format specifications
  • A detailed collection schedule
  • Our XML data entry tool (available for some streams)
  • Quality rules.

This Support guides page collects together the following resources:

  • Preparation guide
  • Stream user guide
  • Data collection system: Known issues and release history.

In the Contact and support area of our site, you can find:

Our Data innovation section includes information about:

  • Open and recently completed record reviews, including information about changes we are implementing
  • Our Data Futures programme which will transform the higher education information landscape.

In the About us section, you can find:

Where can I find further help with the Student record? Who are Liaison?
 

Our expert analysts have a thorough understanding of our records and processes. We are here to support you throughout the data submission process.

Contact Liaison by email or on +44 (0)1242 211144 

Find out more about Liaison

Student record JISCMail list

Our JISCMail groups allow you to discuss specific streams with colleagues from across the sector. We also use the lists to circulate news regarding data requirements and coding manual and validation kit releases.

Join the HESA-Student JISCMail list

If you encounter any problems, contact Liaison

Preparation guide

Collection news (C16051)

Release - overview

For the C16051 Student record, we have adopted an agile approach to data collection. Functional components of the system are being released incrementally during the period leading up to full functionality being released by early August. This approach gives more flexibility in when data can be submitted. This in turn provides a longer window for data quality checks to be made. 

Details of the contents of each release so far can be found in the Release History section of this page.

HESA Amal tool

For the C16051 collection you need to submit a single file containing full data. Each subsequent file you upload will replace the previous one. If you prepare your data in multiple *.xml files, our XML amalgamator tool will combine these records prior to submission.

NCTL Performance Profiles

As in the previous year, a full commit will not be required to populate the NCTL Performance Profiles and meet the deadline. As long as valid data has been received that generates all possible reports (i.e. data does not fail Entry Profile or other fundamental rules) then data will also successfully transfer to the NCTL webservice.

Guidance from statutory customers (C16051)

HEFCE would like to remind providers about the importance of meeting the published collection schedule. HEFCE will review providers' performance as part of the annual provider review process.

Together with the UK funding councils, we have published a code of practice on data collection, which came into practice from the reporting year 2015/16. You will wish to ensure that your 2016/17 returns are prepared in a way that is consistent with the code.

From 2017-18 it is proposed that students studying certain healthcare qualifications in England will no longer be supported by bursaries but will instead have access to mainstream student support supplemented by HEFCE grant. It is therefore likely that 2016-17 data on these professions will be of particular significance in informing allocations. You are therefore encouraged to pay particular attention to the coding of COURSEAIM, REGBODY and JACS for these courses.

Providers in Scotland are reminded of the importance of providing information on care leavers through the CARELEAVER field. This information is required to monitor the participation in higher education of such students and to assist with the development of national policy to support this vulnerable group of students. Providers in Scotland should also record the rest of UK students paying deregulated tuition fees as being 'eligible to pay home fees' (code 1 for FEEELIG) and as being on the 'post-September 2012 fee regime' (code 20 for FEEREGIME).

Reminders (C16051)

Validation kit

The validation kit for the 2016/17 student data is now available to download. A user guide for the kit is available from the same link. The new kit has both increased functionality and a greatly improved processing speed. This gives you earlier access to validation processes and allows you to test against a wider set of quality rules.

Please note that if you have a previous version of our validation kit it will not be updated to include the C16051 quality rules. You will need to download the new validation kit.

Minerva queries

We expect you to respond to all queries raised within the collection window. As a guide, these queries should be answered within 5 working days.

Data collection system releases and known issues

All reported issues relating to this collection are available under Known issues. These include any fixed and open issues that we are aware of.

Derived field specifications     

Full details of the derived fields that we use in analysis of the C16051 Student record data are available from the C16051 coding manual.  

Record contact changes

The record contact is the first point of communication during data collection. Access to our data collection system is also managed by the nominated record contact. If these details change please ensure you notify Liaison to prevent any delay in the granting of this access.

Data collection system: Release history and known issues

Known issues (C16051)
Issue Summary Status Date raised Date resolved

Issue ID: Unistats report

The Unistats preview report does include apprenticeship students, however, these students are not required to be included in the populations used in Unistats. Therefore there could potentially be a mis-match to the populations in the Unistats report in Student, and the populations appearing in the Unistats record. 

Please note: we are not planning to change this for C16051 - it will be fixed for C17051. 

For info only 12 March 2018  

Issue ID: 46519 - XTARIFF Derived Field

We have three qualifications with '+'s in the qualification grade (which is the 'IB Bonus points' qualifications, that could have grades +1, +2 or +3 with Tariff scores - 40 80 and 120 respectively). When an update was done earlier in 2017 this caused these particular grades to have the '+'s removed from them. The knock on effect of this is that when one of these qualifications is assigned a Tariff score during submission, it can't match the qualification grade, so it comes back as a non-match, meaning that no Tariff score is allocated to it. 

Closed  7 November 2017 13 November 2017

Issue ID: 47283 - NSS Person Report

The new fields that have been added to the NSS Person Report this year (STULOADY1_1, STULOADY1_2, YEARADJ, EXPEND, TOTFTE) are not populating correctly - many of them are blank. 

Please note: we are not planning to change this for C16051 - it will be fixed for C17051. 

Open 8 November 2017  

Issue ID: 46283 - Emails

Following the system unavailibility on Thursday 26th October, the email system didn't restart correctly. No emails have been sent from the data collection system since last Thursday. 

Note: this was fixed by restarting up our email sending system, and the email queue has now been sent out. 

Closed 31 October 2017 31 October 2017

Issue ID: 45670 - Reports

There may be some students missing from the Unistats table 3. The new restriction we introduced this year on the INITIATIVES field (to exclude any postgraduate EYITT courses in previous years) did not take into account the possibility of null values, where no UHN link can be found. 

Closed 20 October 2017 9 November 2017

Issue ID: 45674 - Reports

The Expected Instance Population report does not have the same line as last year that counts the number of records contained within the download, i.e. 

"The list for provider <UKPRN> (<INST ID>) contains <NNNN> records." 

Closed 20 October 2017 9 November 2017

Issue ID: 45376 - Credibility Reports

The columns headings on the SYR3 and SYR4 tables (in the Study Years chapter) are incorrect - they should all be rolled forward a year. 

Currently it says:

 

2015/16 2014/15 2013/14 2012/13 Earlier than 2012/13 Total
Year Student: 1            

But it should say:

  2016/15 2015/14 2014/13 2013/14 Earlier than 2013/14 Total
Year Student: 1            
Closed 19 October 2017 9 November 2017

Issue ID: 45376 - Reports

The Expected Instance Population report doesn't have the correct tags in the download file: '<TARL>' should be '<TARLROW>' as per the XML Schema

Closed 13 October 2017 9 November 2017

Issue ID: 44407 - Reports

The CCAnalysis report is not showing the 'FE FTE' figure for cost centre 136 Continuing education. However, this cost centre is being counted in the 'Total FTE' figure. 

Closed 27 September 2017 11 October 2017

Issue ID: 44405 - Credibility Reports

The credibility table DISAB1 needs some old codes removing from the report, due to changes that have been made in the XSTUDIS01 derived field it is using (remove XSTUDIS01 valid entries E, L, M and N). 

Please note: we are not planning to change this for C16051 - it will be fixed for C17051. 

Open 27 September 2017  

Issue ID: 44088 - Quality Rules

The rule QR.C16051.Student.SSN.4 is triggering correctly, but is displaying data for a different MSTUFEE value. 

Closed 18 September 2017 11 October 2017

Issue ID: 44068 - Quality Rules

The rule QR.C16051.Instance.EXCHANGE.4 is triggering incorrectly when there is no change between the incoming and previous instances. 

Closed 15 September 2017 11 October 2017

Issue ID: 43810 - Credibility Reports

PGR1 is not displaying the correct historic 15/16 data.

Closed 15 September 2017 29 September 2017

Issue ID: 44060 – Quality Rules

The rule QR.C16051.CourseSubject.SBJCA.15 is incorrectly displaying a column heading “ITTPHSC = 54-57, 78-81”,  this column heading should be displayed as "Count of instances where Instance.ITTPHSC = 54-57, 78-81".

Closed 15 September 2017 11 October 2017

Issue ID: 24977 - Continuity Reports

The count of continuity issues being displayed on the dashboard is not matching up with the number of issues being displayed in the Continuity Report.

This is because it is trying to trigger some FE rules which shouldn't be triggered. As these errors shouldn't be triggered, providers cannot see them on the continuity report (as it only shows the HE ones). We will supress these rules correctly, in order to fix the count on the dashboard. 

Closed 7 September 2017 15 September 2017

Issue ID: 33472 - NSS report testing window (31 Aug - 13 Sep)

The NSS report will be tested by HEFCE and HESA in the next two weeks. You may see this report disappear for a while, whilst this happens. If it does appear - please don't use the results yet, as it may still be changed. 

We will let you know when the testing is complete and the report has been finalised. 

Note added 11 Sep: Testing is now complete. Nothing has been changed with the NSS report and therefore you can continue to use any previous downloads you may have. 

Closed 31 August 2017 11 September 2017

For info only: Credibility Reports

Shading rules on credibility reports do not appear until your submission has finished processing. The reports and tables will appear first and the shading rules later. So whilst you're transaction is processing, please wait until it has completely finished before checking if you have triggered any shading rules.  

For info only 31 August 2017  

Issue ID: 22435 and 43184 - Report downloads

The CCAnalysis and Unistats reports do not yet have Excel / zip download options. These will be available shortly. 

Closed 30 August 2017

Unistats zip - 7 September 2017

CCAnalysis Excel - 15 September 2017

Issue ID: 43227 - Frequency Counts report

The INITIATIVES1 and INITIATIVES2 tables in the Frequency Counts report have not been updated to include the most recent codes added. In particular code T 'Postgraduate Loan' should be removed, and code U 'Postgraduate Loan Eligibility' should be added. 

Closed 30 August 2017 15 September 2017

Issue ID: 43223 - Quality Rules

The rule QR.C16051.Course.AWARDBOD.6 and QR.C16051.Course.AWARDBOD.7 rules are triggered for two providers where it shouldn't (Courtauld Institute of Art and Institute of Cancer Research) as they are part of the University of London.

Closed 30 August 2017 7 September 2017

Issue ID: 43136 - Quality Rules

The rule QR.C16051.CourseSubject.SBJCA.24 does not have the same ENTRYRTE = 3 clause as the equivalent QR.C16053.CourseSubject.SBJCA.9 rule does. 

Closed 29 August 2017 Not going to be amended - rule is correct for Student.

Issue ID: 41945 - Quality Rules download

The CSV download for the Quality Rules report is inserting blank rows every 10,000 lines. This isn't happening in the XLSX version. 

Closed 15 August 2017 15 September 2017

Issue ID: 41198 - Quality Rules

The rule QR.C16051.Course.FEQAIMC.10 is triggering incorrectly.

Closed 8 August 2017 17 August 2017

Issue ID: 41562 - Quality Rules

The rule QR.C16051.QualificationsOnEntry.QUALTYPE.2 is triggering incorrectly. It is triggering per student instead of per instance. 

Closed 10 August 2017 30 August 2017

Issue ID: 41530 - Credibility Reports

To use the drill down functionality on the credibility reports please always go into the chapters by clicking on the 'view' button; you can then use the blue triangles to view the figures. If this method is not followed then you will experience issues with this information displaying. 

For info only 9 August 2017  

Issue ID: 40966 - Credibility Reports

Some of the credilbility reports are not displaying the correct historic 15/16 data, instead it is showing zeros. These are tables: SBJ1, SBJF1, SBJ2, SBJ3 and DLHE2. 

Closed 3 August 2017 17 August 2017

Issue ID: 40490 - IRIS for providers in Wales

The IRIS system isn't displaying the EYM report from HEFCW on the data collection dashboard, for providers to download. 

Until the issue is fixed, the EYM output from the IRIS system will be available from the HEFCW secure download area of the HEFCW website, as a live link to the latest output. In order to access this for your provider, you will need a username and password. Please call Hannah Falvey at HEFCW on 029 2085 9720 to obtain these. Please contact Hannah or email [email protected] if you are having any difficulties in accessing the output. 

Closed 24 July 2017 27 July 2017

Issue ID: 40424 - Quality Rules

Providers are triggering the exception rule QR.C16051.Instance.CAMPID.1 as the static data needs to be updated to use the latest Provider Profile data, now that it is available. 

Closed 24 July 2017 17 August 2017

Issue ID: 39858 - Schema

The valid entry QualifcationsOnEntry.QUALTYPE EY isn't being allowed through the system at the moment - it is triggering a schema error for anyone who tries to submit the code. 

Closed 17 July 2017 2 August 2017

Issue ID: 39772 - Quality Rules

The rule QR.C16051.Course.FEQAIMC.10 is triggering incorrectly. It seems to be triggering when a student fits the criteria for not triggering (i.e. ILRGEN = 1, and associated Instance being PROGTYPE = 25 and FUNDMODEL = 36) 

Closed 17 July 2017 2 August 2017

Issue IDs: 38997, 38998, 38999, 39000 - Quality Rules

The four checksum-related rules QR.C16051.Student.HUSID.3, QR.C16051.Student.SCN.1, QR.C16051.Student.ULN.1 and QR.C16051.EntryProfile.UCASAPPID.1 are triggering incorrectly. 

Closed 16 June 2017 20 July 2017

Issue ID: 38462 - Quality Rules

The rule QR.C16051.Instance.MODE.33 is triggering incorrectly. It doesn't seem to be treating the COLTODATE 2016-08-01 into account correctly. 

Closed 22 June 2017 6 July 2017

Issue ID: 38079 - Quality Rules

The rule QR.C16051.QualificationsOnEntry.QUALTYPE.2 is triggering incorrectly. It is triggering where there is more than one occurence of QUALTYPE WB, WE or WS across the whole submission, instead of across a single student. 

Closed 21 June 2017 6 July 2017

Issue ID: 38036 - Quality Rules

The rule QR.C16051.Instance.ENDDATE.14 is over reporting and triggering incorrectly. It appears to be looking across the collection rather than across the components for that person. 

Closed 20 June 2017 6 July 2017

Issue ID: 37848 - Downloadable Validation Kit

Providers have reported different problems they are having with the downloadable validation kit, and we are working to try to understand what the problems are. In the meantime, please continue to use the validation in the data collection system as normal - as this is working fine. 

Closed 16 June 2017 6 July 2017

Issue ID: 37825 - Quality Rules

The rules QR.C16051.Instance.ENTRYRTE.6 and QR.C16051.Instance.ENTRYRTE.7 are again not working correctly. They are incorrectly triggering when the ENTRYRTE field has not been returned. 

Closed 16 June 2017 6 July 2017

Issue ID: 37669 - Quality Rules

The rule QR.C16051.Student.NATIOND.6 is triggering for a lot more records than it shouldn't be triggering for. 

Closed 13 June 2017 23 June 2017

Issue ID: 37521 - Quality Rules

The rules QR.C16051.Instance.ENTRYRTE.1 and QR.C16051.Instance.ENTRYRTE.5 are triggering when the data has not been returned in the Instance.ENTRYRTE field (as the field is optional). 

Closed 8 June 2017 13 June 2017

Issue ID: 36878 - Quality Rules

The rules QR.C16051.Instance.ENTRYRTE.6 and QR.C16051.Instance.ENTRYRTE.7 are incorrectly triggering. 

Closed 2 June 2017 9 June 2017

Issue ID: 36865 - Quality Rules

The rule QR.C16051.ITTPlacement.PLMNTSCH.1 seems to be triggering on all ITTPlacement.PLMNTSCH across the collection, regardless of matching or not matching combinations. 

Closed 2 June 2017 9 June 2017

Issue ID: 36254 - Quality Rules

The rule QR.C16051.Engagement.ENGEND.4 is incorrectly triggering when there is no ENDDATE. 

Closed 24 May 2017 9 June 2017

Issue ID: 36255 - Quality Rules

The rule QR.C16051.Engagement.ENGSTATUS.3 is incorrectly triggering when ENGEND is null. 

Closed 24 May 2017 9 June 2017

Issue ID: 35487 - Quality Rules

The rule QR.C16051.Instance.ENTRYRTE.1 is incorrectly applying where the ENTRYRTE field doens't exists. 

Closed 11 May 2017 25 May 2017

Issue ID: 35853 - Quality Rules

The rule QR.C16051.QualificationsOnEntry.QUALTYPE.2 is triggering incorrectly. It is triggering where there is more than one occurence of QUALTYPE WB, WE or WS across the whole submission, instead of across a single student. 

Closed 16 May 2017 25 May 2017

Issue ID: 35734 - Quality Rules

The rule QR.C16051.Instance.FUNDCOMP.1 is not triggering for as many records as it should be. It was counting an error for every instance triggering the rule, but now it is to be counting at course level - hence it appears as though less records have triggered the error.  

Closed  12 May 2017 25 May 2017

Issue ID: 35722 - Quality Rules

The rule QR.C16051.Instance.GROSSFEE.7 is triggering for a lot more students than it should be! It seems to be triggering where GROSSFEE has not been returned, when it should be ignoring these cases. 

Closed 11 May 2017 25 May 2017

Issue ID: 35226 - Derived Fields process

A provider entered 29 February for the COMDATE of a student. Our derived fields process that works our the anniversary of a student was not able to cope with this, as it was trying to make every year a leap year! 

Closed 8 May 2017 8 May 2017

Issue ID: 29288 - OFFA Financial Support data

Due to recent restrictions placed on the Financial Support data that OFFA supply to HESA, OFFA will not be able to supply this data until the middle of June. This means that quality rules QR.C16051.Instance.FinancialSupport.9 and QR.C16051.Instance.FinancialSupport.10 will be validating using last year's data. Providers are to be aware of this, and should contact Liaison if they need any rules switching off in the mean time. 

Closed 8 May 2017 23 June 2017

Issue ID: 34834 - Quality rules

The rule QR.C16051.Instance.LearningDeliveryFAM.4 is triggering when the conditions of ILRGEN = 1 and PROGTYPE = 25 do not apply, which is the opposite to what it should do. 

Closed 27 April 2017 28 April 2017

Issue ID: 34800 - Quality rules

The rule QR.C16051.Instance.Engagement.2 is triggering incorrectly as it is over reporting. It is trying to check where Engagements for a single instance overlap.  

Note: 28 April 2017: this rule has now been removed, and will likely be made an Exception rule in a future release. 

Closed 27 April 2017 9 June 2017

Issue ID: 34532 - Quality rules

The rule QR.C16051.QualificationsOnEntry.QUALTYPE.2 seems to be displaying the first Qualification on Entry returned for the student, instead of the relevant one. Currently only reported by one provider. 

Closed 26 April 2017 11 May 2017

Issue ID: 34377 - ILR generation process

The LearningDeliveryFAM.LearnDelFAMDateFrom and LearningDeliveryFAM.LearnDelFAMDateTo are not being generated when the LearningDeliveryFAM.LEARNDELFAMTYPE is coded 'ACT'.

Closed 20 April 2017 11 May 2017

Issue ID: 33031 - Quality rules

QR.C16051.Engagement.ApprenticeFinances.1 was triggering incorrectly. The check on AIMTYPE wasn't happening correctly, as it was triggering when AIMTYPE.3 was in the data, and it shouldn't have been. 

Closed 29 March 2017 18 April 2017

Issue ID: 30634 and 30628 - Schema

Following the release of the Student coding manual on 23 February, new codes were added into the QualificationsOnEntry.QUALSBJ and QualifcationsOnEntry.QUALTYPE fields. These changes have not yet been carried over into the schema used in the data collection system or validation kit. 

Closed 28 February 2017 6 March 2017

Issue ID: 31097 - Quality rules

QR.C16051.LearningDeliveryFAM.LEARNDELFAMTYPE.1 rule is triggering correctly, but is displaying incorrect data when you click to see more details on the rule. 

Closed 28 February 2017 6 March 2017

Issue ID: 30802 - Quality rules

QR.C16051.Instance.AIMTYPE.5 is currently triggering where there are two instances for a student, but the AIMTYPE for each instance were different (and therefore the rule shouldn't have triggered).

Closed 22 February 2017 6 March 2017
Release history (C16051)
Release ID Release date Release summary
55 14 November 2017

All providers have been reprocessed now - this was to fix bug 46519 with the XTARIFF derived field. 

As part of this reprocess others things will now have taken affect in the latest submission for providers. This includes:

  • Updates to the XTPOINTS derived field (see the XTPOINTS derived field spec revision history for more details)
  • Unistats table 3 fix (bug 45670) 
  • The columns have been corrected in the SYR3 and SYR4 credibility tables (in the Study Years chapter) (bug 45649) 
  • The line in the HE expected instance population report indicating the number of records in the download has been added (bug 45674) 
  • And any other items below that have been fixed or changed since providers uploaded their last file 
54 9 November 2017

A few bugs have been fixed in this sprint:

  • The columns have been corrected in the SYR3 and SYR4 credibility tables (in the Study Years chapter) - to fix bug 45649
  • The schema for the expected instance population report has been fixed to appear as '<TARLROW>' - to fix bug 45376
  • The line in the HE expected instance population report which indicates the number of records in the download has been added back in - to fix bug 45674
  • Unistats table 3 has been updated - to fix bug 45670 

Also the UKPRN static data has been updated for the last time - to include some more recent UKPRNs. 

52 11 October 2017

A few bugs have been fixed in this release:

  • QR.C16051.CourseSubject.SBJCA.15 - to fix bug 44060 
  • QR.C16051.Instance.EXCHANGE.4 - to fix bug 44068 
  • QR.C16051.Student.SSN.4 - to fix bug 44088
  • CCAnalysis report has been updated - FE FTE figures were not populating correctly. To fix bug 44407 

QR.C16051.Instance.INITIATIVES.37 - COURSEAIM L99 has been added into the business rule.

The coding manual links from quality rules have all been fixed. This is when you are in the Quality Rules Report and click on the coding manual link in the rule (right corner); or when you are in the validation kit and right click on a rule. 

51B 29 September 2017

ONS postcode static data has been updated. 

PGR credibility report has been updated (RCUK1 and RCUK2) - to fix bug 43810. 

51A 19 September 2017 Update to the IRIS process to include some new providers. 
50C 15 September 2017

In this release we have tried to get everything updated and ready for the return and commit deadlines for providers. 

  • Exception rule QR.C16051.Course.COURSEAIM.13 has been amended to remove dormant students
  • Exception rule QR.C16051.Instance.GROSSFEE.18 was triggering twice for the Open University only - to fix bug 43537
  • Business rule QR.C16051.Student.HUSID.2, an older INST ID was not being accepted - to fix bug 43558

The counts for Continuity (Quality Issues, Issues Remaining) on the dashboard were showing incorrectly for some providers. This has now been fixed - bug 24977.

Blank rows being were being inserted into the CSV downloads for the Quality Rules report. This has now been fixed - bug 41945.

Tolerances were not working correctly on the Quality Rules report. Now if a provider exceeds their tolerance for a quality rule, it will appear back in the 'Errors' tab for you to resolve. 

The fuzzy matching process has been updated for collaboration provision. 

Frequency counts report now has the updated INITIATIVES values (removed code T; added codes U, V and W) - to fix bug 43227. 

UKRLP static data has been updated. 

The NSS report has now been fully tested between HEFCE and HESA. This is now available again - to resolve bug 33472. 

An Excel download has been made available for the CCAnalysis report. The zip download file is now available for the Unistats report. This fixes bugs 22435 and 43184. 

50B 7 September 2017

A couple of minor updates for this release:

  • Two providers needed excluding from the rules QR.C16051.Course.AWARDBOD.6 and QR.C16051.Course.AWARDBOD.7 - to fix bug 43223
  • a zip download has been made available for the Unistats reports - which will appear on the dashboard page 
50A 5 September 2017

A number of bugs have been fixed in this interim release:

  • Switzerland have been added to quality rules QR.C16051.Instance.FUNDCODE.6 and QR.C16051.Instance.FUNDCODE.28
  • QR.C16051.LearningDeliveryFAM.LEARNDELFAMFROM.1 has had 'ACT' code added into the rule 
  • Four rules have been amended to speed up the process time (but the meaning hasn't changed) 
49 30 August 2017

The 'Commit' and 'Sign-off' functionality is now available. HESA is set up and ready to start data quality checking provider's data, once you have committed your data. 

Unistats report is now available. Minor updates have been made, to the specification of this preview report. 

Check documentation is now available. This included updates to the PI tab, Item 2 on the Campus tab, and the collaborative / franchise tab has been included again (following feedback that was useful to have back from the sector). 

Credibility reports: 

  • Shading rules added on EXPL1 and EXPL2 tables - instead of a diagram used in a Minerva query, raised in previous years. 
  • A number of notes have been updated on a number of the credibility tables, to aid provider's understanding. 

Rule updates:

Added 1 business rule:

  • QR.C16051.EntryProfile.QUALENT3.28 

Amended 5 exception rules:

  • QR.C16051.EntryProfile.PGCECLSS.5 - removed TTCID codes 8 and G
  • QR.C16051.EntryProfile.PGCESBJ.5 - removed TTCID codes 8 and G
  • QR.C16051.Student.ETHNIC.12 - added display of unknowns table 
  • QR.C16051.QualificationsOnEntry.QUALTYPE.2 - to fix bug 41562 
  • QR.C16051.CourseSubject.SBJCA.26 - to amend the population used in the rule 
  • QR.C16051.EntryProfile.QualificationsOnEntry.14 - to amend the base population used in the rule

Amended 1 continuity rule:

  • QR.C15051.Instance.EntryProfile.3 (updated for COLPROV) 

Deleted 3 rules:

  • CourseSubject.SBJCA.17 (business rule)
  • CourseSubject.SBJCA.18 (business rule)
  • CourseSubject.SBJCA.21 (exception rule) 

IRIS reports - now available for providers in England and Northern Ireland. 

The HEAPES16 comparison output is now available. Providers may view the output by submitting your data the data collection system; which will automatically trigger the generation of the output from HEFCE. The associated technical documentation is available at http://www.hefce.ac.uk/data/indstudata/altprovider/ If you require any further information or guidance on what's included in the reports, please contact HEFCE on 0117 931 7138 or email [email protected].

Dashboard page

A number of minor updates have been made to the user interface on the dashboard page, including:

  • The progress tracker table has been added - to indicate to provider's whether or not you have met the deadlines. 
  • Links updated to the known issues and HLS pages.
  • Numbers are displaying in the 'Quality Issues' and 'Issues Remaining' columns in the Activity log table. 
  • The collection and provider information is now displaying in the top menu. 
48B 17 August 2017

Some changes have been made to Credibility Reporting:

  • Shading rules have been applied to 3 tables: DLHE1, MOB1, QUAL2
  • Static data fixed for 5 tables where it wsn't displaying: DLHE2, SBJ1, SBJF1, SBJ2, SBJ3 (to fix bug 40966) 

Business rule QR.C16051.Course.FEQAIMC.10 amended (to fix bug 41198) 

A few links have been updated on the reports, now that these have been published in the coding manual. [Please let us know if you spot any more broken links - as these should now all be working!] 

The Continuity population report (Expected Instance populationis now available for both HE and FE, including the PGR collaborative students transferred in expected instance population. 

Some changes have been made to handle the collaborative provision reporting:

  • QR.C16051.Instance.NUMHUS.10 exception rule added for PGR Transfers In
  • Documentation reviewed and updated 

A number of changes have been made to the static data:

  • System now looking at C16041 data for CAMPID quality rules (to fix bug 40424)
  • Updated the URN lookup data for quality rule PLMNTSCH.2 
  • Updated Degree Awarding Powers lookup data
  • Updated RCUK lookup data for quality rules 
48A 9 August 2017

A few more changes have been made to the Credibilty reports:

2 new tables for ITT placements: ITT3 and ITT4. 

Shading rules have been added to QUAL1 and ITT1 tables. 

47 2 August 2017

QualificationsOnEntry.QUALTYPE EY is now allowed in the schema - to fix bug 39858 

 

We have made a number of changes to Credibilty reports for this release. 

The static data has been updated for this year and it is now using the 2015/16 data. 

3 tables amended to remove TTCID codes 8 and G:  ITT1, ITT2, QTS1. 

1 table amended to use ENTRYRTE codes for this year's data and continue to use INITIATIVES codes for previous year's data: EYTS1. 

8 tables amended to add new COURSEAIMs:  DOM1, DOM1P, EXPL3, EYTS1, QUAL1, SIN1, SIN2, SIN1P.

1 table amended to adjust for 2 occurences of REGBODY: REGB1. 

Three new tables have been added for Apprenticeship data: APP1, APP2 and APP3. 

Drill down has been applied to 7 tables: SIN1, FTES1, FTES2, FTES3, FTEN1, FTEN2, FTEN3. 

We have also made some efforts to improve the performance of generating these reports - so hopefully it won't be as slow as last year! 

 

This release also has a couple more quality rules: 

Amended 1 business rule:

  • QR.C16051.Course.FEQAIMC.10 - to fix bug 39772

Added 1 exception rule:

  • QR.C16051.Instance.RSNEND.11 (which looks back at the 3 previous year's data to find students who were returned as RSNEND 98, and qualifications weren't then sent in for them) 

We also added the unknown header into a number of our quality rules. 

46 20 July 2017

This release includes a number of reports:

  • PGR Transfers IN
  • PGR Transfers Out
  • FE Qual Aims
  • CC Analysis (incl. fixing rounding bug)

Also the new derived field XAPP01 has been added into data supply.

The HUSID Look-Up Service has now moved onto the data collection system and is now accessed with an IDS role. More information on the service is available here: https://www.hesa.ac.uk/support/tools-and-downloads/husid

This release also has a few more quality rules (and we are hoping this is the bulk of all the changes needed for this year): 

Amended 4 business rules:

  • QR.C16051.EntryProfile.UCASAPPID.1 - to fix bug 39000
  • QR.C16051.Student.HUSID.3 - to fix bug 38997
  • QR.C16051.Student.ULN.1 - to fix bug 38999
  • QR.C16051.Student.SCN.1 - to fix bug 38998

Added 1 exception rule:

  • QR.C16051.EntryProfile.QualificationsOnEntry.14

Amended 8 continuity rules:

  • QR.C16051.Student.ETHNIC.10
  • QR.C16051.Instance.NUMHUS.3
  • QR.C16051.Instance.PHDSUB.14
  • QR.C15051.EntryProfile.CARELEAVER.16 - downgrade to warning
  • QR.C16051.EntryProfile.PREVINST.5
  • QR.C16051.EntryProfile.PREVINST.6 
  • QR.C16051.EntryProfile.RELIGION.3
  • QR.C16051.EntryProfile.RELIGION.4
45 6 July 2017

Continuity has now been updated for this year and is now on. The small number of continuity rule changes will be coming soon. 

All of last year's Credibility reports have now been rolled forward to use this year's data. Please note that we still have all the changes and updates to make for this year - including updating the static data used in tables (although the label says it's 2015/16 data, it is still using the 2014/15 static data). This will be completed in the coming weeks, but we wanted to get it out there to you as soon as possible. We will be applying drill down initially in the following 7 tables: SIN1. FTES1, FTES2, FTES3, FTEN1, FTEN2 and FTEN3. 

A couple more static data loads have happened in this release, including the latest ONS postcode load and the Learning aims for English and Welsh FE. 

We have investigated a number of problems reported with the Validation Kit (bug 37848). Some of these were fixed by downloading another version of the validation kit; four checksum issues were reported with the rules (bugs 38997, 38998, 38999, 39000); and we have switched off the pivot table in the Excel download for now, as it's not working. If anyone found this useful and would like this fixed at some point, please let us know. 

And as usual, this release has a few more business and exception rules: 
    
Amended 6 business rules:

  • QR.C16051.Course.TTCID.15 
  • QR.C16051.Instance.ENTRYRTE.6 - to fix bug 37825
  • QR.C16051.Instance.ENTRYRTE.7 - to fix bug 37825 
  • QR.C16051.Instance.LearningDeliveryFAM.1 - to fix bug 38056 
  • QR.C16051.Instance.LearningDeliveryFAM.4 - to fix bug 38060 
  • QR.C16051.Instance.MODE.33 - to fix bug 38462 

Added 1 business rule:

  • QR.C16051.Instance.LearningDeliveryFAM.5 - to fix bug 38057 

Amended 4 exception rules:

  • QR.C16051.Instance.ENDDATE.14 - to fix bug 38036
  • QR.C16051.EntryProfile.QUALENT3.22 
  • QR.C16051.EntryProfile.QUALENT3.23 
  • QR.C16051.QualificationsOnEntry.QUALTYPE.2 - to fix bug 38079 

Added 7 exception rules:

  • QR.C16051.CourseSubject.SBJCA.26 (previously a check that were carried out on credibility reports) 
  • QR.C16051.Instance.AIMTYPE.5 (this was a business rule) 
  • QR.C16051.Instance.HEAPESPOP.14 
  • QR.C16051.Instance.HEAPESPOP.15 
  • QR.C16051.Instance.LOCATION.1 (this was a business rule)
  • QR.C16051.EntryProfile.QUALENT3.26 (split out from QR.C16051.EntryProfile.QUALENT3.22)
  • QR.C16051.EntryProfile.QUALENT3.27 (split out from QR.C16051.EntryProfile.QUALENT3.23)
44B 23 June 2017

The Data Supply and IRIS report (for providers in Wales) are now available (though you will need to submit another file before they will appear, as we have not reprocessed providers at this stage). 

A new derived field XAPP01 'Apprenticeship identifier' has been added - the specification will be up on the HESA website shortly. This derived field is not yet appearing in the data supply report, but will also be added shortly. 

There is now a draft version of the NSS report available. Please be aware that this is an early draft version, using last year's specification, and therefore may not be correct. The final version will be released in September, once any changes for this year have been agreed with HEFCE. 

This release has a few more business and exception rules: 

Amended 6 exception rules:

  • QR.C16051.Student.NATIOND.6 - to fix bug 37669 
  • QR.C16051.Student.SSN.5
  • QR.C16051.Student.TTPCODE.9 - bug with the download has now been fixed 
  • QR.C16051.Instance.EntryProfile.2 
  • QR.C16051.EntryProfile.Postcode.6 
  • QR.C16051.ModuleSubject.COSTCN.6 - to fix the fields to display

Added 5 exception rules (these were all previously checks that were carried out on credibility reports):

  • EntryProfile.QualificationsOnEntry.14
  • EntryProfile.QUALENT3.22
  • EntryProfile.QUALENT3.23
  • EntryProfile.QUALENT3.24
  • EntryProfile.QUALENT3.25

Static data loaded: 

  • *J data - used in various quality rules 
  • Franchise partners static data 
  • OFFA Financial Support data - quality rules QR.C16051.Instance.FinancialSupport.9 and QR.C16051.Instance.FinancialSupport.10 will now be using the correct data for C16051 - to fix bug 29288. 
44A 13 June 2017

An interim release to fix some bugs with the Exception rules.

  • QR.C16051.Instance.ENTRYRTE.1 - to fix bug 37521
  • QR.C16051.Instance.ENTRYRTE.5 - to fix bug 37521
  • QR.C16051.Instance.INITIATIVES.15 - removed as INITIATIVES E check no longer required
  • QR.C16051.Instance.STULOAD.14 - wasn't always triggering where it should
  • QR.C16051.Instance.STULOAD.21 - wasn't always triggering where it should
  • QR.C16051.Instance.STULOAD.22 - wasn't always triggering where it should
  • QR.C16051.Student.FNAMES.5 - new exception rule
43 9 June 2017

We have made a few minor amendments to business rules - to fix some bugs that had been found - then we have focused on updating the exception rules. 

Amended 7 business rules: 

  • QR.C16051.Engagement.ENGEND.4 - to fix bug 36254 
  • QR.C16051.Engagement.ENGSTATUS.3 - to fix bug 36255 
  • QR.C16051.Student.SSN.1 (to fix the fields to display) 
  • QR.C16051.Student.SSN.4 (typo in rule description) 
  • QR.C16051.Instance.ENTRYRTE.6 - to fix bug 36878 
  • QR.C16051.Instance.ENTRYRTE.7 - to fix bug 36878 
  • QR.C16051.ITTPlacement.PLMNTSCH.1 - to fix bug 36865

Amended 25 exception rules:

  • QR.C16051.Course.AWARDBOD.6 
  • QR.C16051.Course.AWARDBOD.7 
  • QR.C16051.Course.FEQAIMC.5
  • QR.C16051.Course.MSFUND.13
  • QR.C16051.ModuleSubject.COSTCN.10
  • QR.C16051.Instance.DISALL.7
  • QR.C16051.Instance.ENDDATE.11
  • QR.C16051.Instance.FinancialSupport.9
  • QR.C16051.Instance.FinancialSupport.10
  • QR.C16051.Instance.FUNDCODE.34
  • QR.C16051.Instance.GROSSFEE.16
  • QR.C16051.Instance.GROSSFEE.31
  • QR.C16051.Instance.MODE.30
  • QR.C16051.EntryProfile.DOMICILE.12 - amended fields to display 
  • QR.C16051.EntryProfile.PREVINST.3
  • QR.C16051.EntryProfile.RELIGION.5
  • QR.C16051.EntryProfile.QualificationsOnEntry.3 - amended fields to display 
  • QR.C16051.EntryProfile.QualificationsOnEntry.13 - rule text update only
  • QR.C16051.Student.DISABLE.5
  • QR.C16051.Student.ETHNIC.7
  • QR.C16051.Student.ETHNIC.12
  • QR.C16051.Student.ETHNIC.14
  • QR.C16051.Student.NATIOND.6
  • QR.C16051.Student.Instance.1
  • QR.C16051.QualificationsAwarded.OUTCOME.6

Added 4 exception rules:

  • QR.C16051.Instance.Engagement.2 (to fix bug 34800 - this was a business rule an is now an exception rule)
  • QR.C16051.LearnerContact.CONTPCODEPAST.2 
  • QR.C16051.Engagement.DELLOCPOSTCODE.3 
  • QR.C16051.Student.FNAMES.6

The 2015/16 Student fixed database is now open to providers who need to fix data from the C15051 collection. 

42 25 May 2017

We have finished all the known business rule changes this sprint, which are the following:

19 amended business rules: 

  • QR.C15051.Course.TQSSEC.1 (bug: to fix a bug for the OU specifically) 
  • QR.C16051.CourseSubject.ITTSUBJECT.1
  • QR.C16051.Instance.ADDSUPCT.1    
  • QR.C16051.Instance.AIMTYPE.5 (downgraded to warning)
  • QR.C16051.Instance.ENDDATE.1 (bug: rule wasn't triggering for REDUCEDI = 08)
  • QR.C15051.Instance.ENDDATE.13 (bug: rule needed to also check when ENDDATE is returned, but it NULL) 
  • QR.C16051.Instance.ENTRYRTE.1  - to fix bug 35487 
  • QR.C16051.Instance.FUNDCOMP.1 - to fix bug 35734
  • QR.C16051.Instance.FUNDLEV.1 - bug in code
  • QR.C16051.Instance.GROSSFEE.7 - to fix bug 35722
  • QR.C16051.Instance.HEAPESPOP.6 
  • QR.C16051.EntryProfile.DOMICILE.3
  • QR.C16051.EntryProfile.PREVINST.8 - UKPRN list needed updating 
  • QR.C16051.QualificationsOnEntry.QUALSBJ.2
  • QR.C16051.Student.HUSID.2
  • QR.C16051.Student.SSN.4
  • QR.C16051.DHREGREF.1
  • QR.C16051.PHDSUB.12  (added Instance.COMDATE into the fields to display when the rule is triggered)
  • QR.C16051.REFData.COLPROV.2 (bug: rule was only reporting one case, but should have been reporting multiple cases) 

16 new business rules:

  • QR.C16051.Institution.ILRGEN.1
  • QR.C16051.CourseSubject.SBJCA.25
  • QR.C16051.Instance.COURSEID.2 
  • QR.C16051.Instance.COURSEID.3 
  • QR.C16051.Instance.HEAPESPOP.10
  • QR.C16051.Instance.HEAPESPOP.11 
  • QR.C16051.Instance.HEAPESPOP.12 
  • QR.C16051.Instance.HEAPESPOP.13 
  • QR.C16051.Instance.LearnerEmploymentStatus.6
  • QR.C16051.Instance.LearnerEmploymentStatus.8
  • QR.C16051.Instance.ITTPlacement.1
  • QR.C16051.Instance.ITTPlacement.2
  • QR.C16051.Instance.ITTPlacement.3
  • QR.C16051.ITTPlacement.PLMNTSCH.1
  • QR.C16051.ITTPlacement.PLMNTSCH.2
  • QR.C16051.Student.NATIOND.7

Some Exception rules have also been added or amended:

  • QR.C16051.Instance.EntryProfile.2 - amended 
  • QR.C16051.Student.NINO.2 - was a business rule, but has now been made an exception rule
  • QR.C16051.Student.LLDDHEALTHPROB.2 - new exception rule 
  • QR.C16051.Instance.ACHDATE.6 - new exception rule
  • QR.C16051.QualiciationsOnEntry.QUALTYPE.2 - to fix bug 35853 

We have also finished developing all the dervied fields needed for C16051, which means the following 69 exception rules have now been switched on:

  • QR.C16051.EntryProfile.DOMICILE.6
  • QR.C16051.EntryProfile.PGCECLSS.2
  • QR.C16051.EntryProfile.PGCECLSS.5
  • QR.C16051.EntryProfile.PGCESBJ.5
  • QR.C16051.EntryProfile.POSTCODE.12
  • QR.C16051.EntryProfile.POSTCODE.6
  • QR.C16051.EntryProfile.POSTCODE.7
  • QR.C16051.EntryProfile.POSTCODE.8
  • QR.C16051.EntryProfile.PREVINST.3
  • QR.C16051.EntryProfile.QUALENT3.14
  • QR.C16051.EntryProfile.QualificationsOnEntry.2
  • QR.C16051.EntryProfile.QualificationsOnEntry.3
  • QR.C16051.EntryProfile.QualificationsOnEntry.6
  • QR.C16051.EntryProfile.QualificationsOnEntry.7
  • QR.C16051.EntryProfile.QualificationsOnEntry.8
  • QR.C16051.EntryProfile.QualificationsOnEntry.9
  • QR.C16051.EntryProfile.RELIGION.5
  • QR.C16051.EntryProfile.SEC.2
  • QR.C16051.EntryProfile.SOC2010.4
  • QR.C16051.Instance.FEEWAIVETYPE.2
  • QR.C16051.Instance.FEEWAIVETYPE.4
  • QR.C16051.Instance.FUNDCODE.30
  • QR.C16051.Instance.FUNDCODE.31
  • QR.C16051.Instance.GROSSFEE.16
  • QR.C16051.Instance.GROSSFEE.18
  • QR.C16051.Instance.GROSSFEE.20
  • QR.C16051.Instance.GROSSFEE.22
  • QR.C16051.Instance.GROSSFEE.28
  • QR.C16051.Instance.GROSSFEE.29
  • QR.C16051.Instance.GROSSFEE.31
  • QR.C16051.Instance.HEAPESPOP.9
  • QR.C16051.Instance.MODE.28
  • QR.C16051.Instance.MODE.31
  • QR.C16051.Instance.SSELIG.10
  • QR.C16051.Instance.STULOAD.15
  • QR.C16051.Instance.STULOAD.16
  • QR.C16051.Instance.STULOAD.17
  • QR.C16051.Instance.STULOAD.18
  • QR.C16051.Instance.STULOAD.19
  • QR.C16051.Instance.STULOAD.20
  • QR.C16051.Instance.YEARLGTH.4
  • QR.C16051.Instance.YEARSTU.4
  • QR.C16051.Instance.YEARSTU.5
  • QR.C16051.Instance.YEARSTU.6
  • QR.C16051.Instance.YEARSTU.7
  • QR.C16051.Instance.YEARSTU.8
  • QR.C16051.Instance.YEARSTU.9
  • QR.C16051.QualificationsOnEntry.QUALGRADE.4
  • QR.C16051.QualificationsOnEntry.QUALGRADE.5
  • QR.C16051.QualificationsOnEntry.QUALGRADE.6
  • QR.C16051.QualificationsOnEntry.QUALGRADE.7
  • QR.C16051.Student.BIRTHDTE.9
  • QR.C16051.Student.DISABLE.4
  • QR.C16051.Student.ETHNIC.12
  • QR.C16051.Student.ETHNIC.14
  • QR.C16051.Student.ETHNIC.6
  • QR.C16051.Student.NATION.5
  • QR.C16051.Student.NATIOND.6
  • QR.C16051.Student.TTPCODE.9
  • QR.C16051.Student.WELSSP.4
  • QR.C16051.StudentOnModule.MODCOUNT.3
  • QR.C16051.StudentOnModule.MODOUT.6
  • QR.C16051.StudentOnModule.MODOUT.7
  • QR.C16051.StudentOnModule.MODOUT.8
  • QR.C16051.StudentOnModule.MODOUT.9
  • QR.C16051.StudentOnModule.MODSTAT.2
  • QR.C16051.StudentOnModule.MODSTAT.3
  • QR.C16051.StudentOnModule.MODSTAT.4
  • QR.C16051.StudentOnModule.MODSTAT.5

The ILR generation process now generates a LearningDeliveryFAM entity when Instance.LearningDeliveryFAM.LEARNDELFAMTYPE is coded 'ACT' and Instance.AIMTYPE = 3. This is in addition to the ones generated for AIMTYPE = 1. 

41B 11 May 2017

Final few changes required to rules following the new Apprenticeship Levy:

  • New business rule: QR.C16051.Instance.AIMTYPE.8
  • New exception rule (previously a business rule): QR.C16051.Instance.AIMTYPE.6
  • New exception rule (previously a business rule): QR.C16051.Instance.AIMTYPE.7
  • New exception rule: QR.C16051.Student.NINO.3 

This release we have really tried to push out as many rule changes as possible. 

10 deleted rules:

  • QR.C16051.Instance.SSELIG.1
  • QR.C16051.Instance.SSELIG.3
  • QR.C16051.Instance.SSELIG.4
  • QR.C16051.Instance.SSELIG.5
  • QR.C16051.Instance.SSELIG.6
  • QR.C16051.Instance.SSELIG.7
  • QR.C16051.Instance.SSELIG.8
  • QR.C16051.Instance.SSELIG.9
  • QR.C16051.Instance.SSELIG.10 (SSELIG ones are to bring them in line with the AP Student record) 
  • QR.C16051.Instance.LearnerEmploymentStatus.1 (to be replaced with more simpler ones)

37 new rules:

  • QR.C16051.Instance.Engagement.3 
  • QR.C16051.Engagement.ENGAIM.1 
  • QR.C16051.Engagement.ENGEND.1
  • QR.C16051.Engagement.ENGEND.2
  • QR.C16051.Engagement.ENGEND.3
  • QR.C16051.Engagement.ENGEND.4
  • QR.C16051.Engagement.ENGEND.5
  • QR.C16051.Engagement.ENGOUTCOME.2
  • QR.C16051.Engagement.ENGOUTCOME.3
  • QR.C16051.Engagement.ENGSTATUS.3
  • QR.C16051.Engagement.ENGWITHDRAW.1
  • QR.C16051.Engagement.ENGWITHDRAW.2
  • QR.C16051.Engagement.OUTGRADE.1
  • QR.C16051.Instance.ACHDATE.1
  • QR.C16051.Instance.ACHDATE.2
  • QR.C16051.Instance.ACHDATE.4
  • QR.C16051.Instance.ACHDATE.5
  • QR.C16051.Instance.ENDDATE.14
  • QR.C16051.Instance.ENTRYRTE.2
  • QR.C16051.Instance.ENTRYRTE.3
  • QR.C16051.Instance.ENTRYRTE.4
  • QR.C16051.Instance.ENTRYRTE.5
  • QR.C16051.Instance.ENTRYRTE.6
  • QR.C16051.Instance.ENTRYRTE.7
  • QR.C16051.Instance.FESTUMK.8
  • QR.C16051.Instance.ITTAIM.1
  • QR.C16051.Instance.ITTAIM.2
  • QR.C16051.Instance.ITTAIM.3
  • QR.C16051.Instance.LearnerEmploymentStatus.7
  • QR.C16051.Instance.TREFNO.7
  • QR.C16051.Student.ContactPreference.1
  • QR.C16051.Student.ContactPreference.2
  • QR.C16051.Student.ETHNIC.17 
  • QR.C16051.Student.LEARNREFNO.1
  • QR.C16051.Student.PREVLEARNREFNO.1
  • QR.C16051.Student.PREVUKPRN.1
  • QR.C16051.Student.PRIORATTAIN.2

45 amended rules. All for a variety of reasons, including: adding COURSEAIM code M73, removing TTCID codes 8 and G, removing PROGTYPE code 10, adding FESTUMK code 5. 

  • QR.C16051.Course.CLSDCRS.1
  • QR.C16051.Course.COLLORG.1 
  • QR.C16051.Course.COURSEAIM.15
  • QR.C16051.Course.TTCID.1
  • QR.C16051.Course.TTCID.13
  • QR.C16051.CourseSubject.SBJCA.15
  • QR.C16051.CourseSubject.SBJCA.24 
  • QR.C16051.Student.BIRTHDTE.3
  • QR.C16051.Student.NATIOND.2
  • QR.C16051.Student.TTPCODE.1
  • QR.C16051.EntryProfile.CARELEAVER.5
  • QR.C16051.Instance.BRIDGE.1
  • QR.C16051.Instance.ELQ.8
  • QR.C16051.Instance.EXCHANGE.1
  • QR.C16051.Instance.FEEELIG.1
  • QR.C16051.Instance.FEEREGIME.5
  • QR.C16051.Instance.FEEREGIME.12
  • QR.C16051.Instance.FEEREGIME.16 
  • QR.C16051.Instance.FEEWAIVETYPE.7
  • QR.C16051.Instance.FUNDADJPRIOR.3
  • QR.C16051.Instance.FUNDCOMP.1
  • QR.C16051.Instance.FUNDLEV.1
  • QR.C16051.Instance.FUNDLEV.4
  • QR.C16051.Instance.FWORKCODE.1
  • QR.C16051.Instance.GROSSFEE.2
  • QR.C16051.Instance.GROSSFEE.6
  • QR.C16051.Instance.GROSSFEE.7
  • QR.C16051.Instance.GROSSFEE.12
  • QR.C16051.Instance.GROSSFEE.13
  • QR.C16051.Instance.GROSSFEE.25
  • QR.C16051.Instance.GROSSFEE.26
  • QR.C16051.Instance.GROSSFEE.27
  • QR.C16051.Instance.GROSSFEE.30
  • QR.C16051.Instance.GROSSFEE.32
  • QR.C16051.Instance.HEAPESPOP.2
  • QR.C16051.Instance.ITTSCHMS.4 
  • QR.C16051.Instance.LearnerEmploymentStatus.5
  • QR.C16051.Instance.MSTUFEE.20
  • QR.C16051.Instance.NETFEE.7
  • QR.C16051.Instance.PWAYCODE.1
  • QR.C16051.Instance.SPECFEE.7
  • QR.C16051.Instance.STULOAD.1
  • QR.C16051.Instance.TREFNO.1 
  • QR.C16051.Instance.TREFNO.6
  • QR.C16051.Instance.TYPEYR.1

QR.C16051.QualificationsOnEntry.QUALTYPE.2 has now been moved to exception - to fix bug 34532. 

The ILR generation process now generates dates for LearnDelFAM type ACT - to fix bug 34377. 

The derived fields process has been amended to make the anniversary date 28 Feb, for any student who has a COMDATE of 29 Feb - to fix bug 35226. 

A number of derived fields have also been developed this sprint, which means we have been able to make the following 28 Exception rules work now:

  • QR.C16051.EntryProfile.PREVINST.4
  • QR.C16051.Student.TTPCODE.17
  • QR.C16051.Student.TTACCOM.3
  • QR.C16051.Student.ETHNIC.13
  • QR.C16051.Student.ETHNIC.11
  • QR.C16051.Student.BIRTHDTE.12
  • QR.C16051.Module.TINST.15
  • QR.C16051.Module.TINST.14
  • QR.C16051.Module.TINST.13
  • QR.C16051.Module.TINST.12
  • QR.C16051.Instance.YEARPRG.8
  • QR.C16051.Instance.MSTUFEE.18
  • QR.C16051.Instance.DISALL.7
  • QR.C16051.EntryProfile.YRLLINST.3
  • QR.C16051.EntryProfile.QUALENT3.21
  • QR.C16051.EntryProfile.QUALENT3.20
  • QR.C16051.EntryProfile.DOMICILE.12
  • QR.C16051.EntryProfile.PARED.5
  • QR.C16051.EntryProfile.PREVINST.9
  • QR.C16051.EntryProfile.POSTCODE.16
  • QR.C16051.EntryProfile.POSTCODE.15
  • QR.C16051.ModuleSubject.COSTCN.9
  • QR.C16051.ModuleSubject.COSTCN.4
  • QR.C16051.ModuleSubject.COSTCN.5
  • QR.C16051.ModuleSubject.COSTCN.8
  • QR.C16051.ModuleSubject.COSTCN.7
  • QR.C16051.ModuleSubject.COSTCN.6
  • QR.C16051.ModuleSubject.COSTCN.10
41A 28 April 2017

This release is to fix bugs we had on a couple of rules. 

Amended 5 rules:

  • QR.C16051.Instance.LearningDeliveryFAM.4 (to fix bug 34834)
  • QR.C16051.Instance.ACHDATE.3 (another change following the new Apprenticeship Levy)
  • QR.C16051.EntryProfile.PREVINST.7
  • QR.C16051.EntryProfile.PREVINST.8
  • QR.C16051.Instance.FinancialSupport.7

Added 1 rule:

  • QR.C16051.Instance.Engagement.4 (another change following the new Apprenticeship Levy)

Deleted 1 rule:

  • QR.C16051.Instance.Engagement.2 (to the remove the problem of bug 34800). We will make this an Exception rule in a future release. 
40 27 April 2017

Added 2 new rules:

  • QR.C16051.Engagement.STANDCODE.1
  • QR.C16051.Instance.PROGTYPE.5

Amended 24 rules:

  • QR.C16051.Course.FEQAIMC.10 
  • QR.C16051.Instance.CSTAT.1
  • QR.C16051.Instance.Engagement.1 
  • QR.C16051.Instance.FEEREGIME.10
  • QR.C16051.Instance.FEEREGIME.11
  • QR.C16051.Instance.FESTUMK.7 
  • QR.C16051.Instance.FUNDMODEL.5
  • QR.C16051.Instance.LEARNPLANENDDATE.1
  • QR.C16051.Instance.LearnerEmploymentStatus.4 
  • QR.C16051.LearnerEmploymentStatus.EMPSTAT.1 
  • QR.C16051.Instance.LearningDeliveryFAM.4
  • QR.C16051.LearningDeliveryFAM.LEARNDELFAMTYPE.1
  • QR.C16051.Instance.MODE.35 
  • QR.C16051.Instance.PROGTYPE.4
  • QR.C16051.Instance.SPECFEE.1
  • QR.C16051.Instance.WITHDRAWREASON.1
  • QR.C16051.Student.ETHNIC.4
  • QR.C16051.Student.ETHNIC.15
  • QR.C16051.Student.ETHNIC.16
  • QR.C16051.Student.LLDDHEALTHPROB.1 
  • QR.C16051.Student.LearnerContact.1 
  • QR.C16051.Student.LearnerContact.3  
  • QR.C16051.Student.NINO.1 
  • QR.C16051.Student.PRIORATTAIN.1

The above rules are all due to the introduction of the Apprenticeship Levy, and subsequent changes required to validation (that are in this release). There are a handful more changes required to rules for the new Apprenticeship Levy, and these will be completed in the next couple of weeks. 

The rule QR.C16051.Course.REGBODY.4 has also been amended to be applicable to Northern Ireland, Scotland and Wales only. 

The Frequency Counts report is now available. Please note that if you have already sent a file to HESA, the new report will not show up until you have submitted another file, as we will not be reprocessing this time. 

39 18 April 2017

1 new rule added:

  • QR.C16051.Instance.GROSSFEE.33 

28 rules amended 

  • QR.C16051.Course.MSFUND.2
  • QR.C16051.Course.MSFUND.3
  • QR.C16051.Course.MSFUND.5 
  • QR.C16051.Course.MSFUND.6
  • QR.C16051.Course.REGBODY.1 
  • QR.C16051.Course.REGBODY.2
  • QR.C16051.Course.REGBODY.3
  • QR.C16051.CourseSubject.SBJCA.3
  • QR.C16051.CourseSubject.SBJCA.20
  • QR.C16051.Student.DISABLE.2
  • QR.C16051.Student.DISABLE.3
  • QR.C16051.Instance.ELQ.5
  • QR.C16051.Instance.FEEREGIME.3
  • QR.C16051.Instance.FUNDCODE.15
  • QR.C16051.Instance.FUNDCODE.25
  • QR.C16051.Instance.FUNDCODE.27
  • QR.C16051.Instance.INITIATIVES.5
  • QR.C16051.Instance.MODE.20
  • QR.C16051.Instance.MSTUFEE.16
  • QR.C16051.Instance.RCSTDNT.1
  • QR.C16051.Instance.SSELIG.4 
  • QR.C16051.Instance.TREFNO.3
  • QR.C16051.Instance.TREFNO.4
  • QR.C16051.Instance.TREFNO.5
  • QR.C16051.Instance.FinancialSupport.8
  • QR.C16051.QualificationsOnEntry.QUALYEAR.19
  • QR.C16051.QualificationsAwarded.QUAL.16
  • QR.C16051.Engagement.ApprenticeFinances.1 - to fix bug 33031
38 29 March 2017

42 rules amended (a lot of changes are due the TTCID codes 8 and G being removed):

  • QR.C16051.Course.COURSEAIM.4
  • QR.C16051.Course.MSFUND.9
  • QR.C16051.Course.TTCID.2
  • QR.C16051.Course.TTCID.8
  • QR.C16051.Course.TTCID.11
  • QR.C16051.Course.TTCID.12
  • QR.C16051.CourseSubject.ITTSUBJECT.1
  • QR.C16051.CourseSubject.SBJCA.2
  • QR.C16051.CourseSubject.SBJCA.5
  • QR.C16051.CourseSubject.SBJCA.6
  • QR.C16051.CourseSubject.SBJCA.7
  • QR.C16051.CourseSubject.SBJCA.8
  • QR.C16051.CourseSubject.SBJCA.16
  • QR.C16051.CourseSubject.SBJPCNT.2
  • QR.C16051.Student.ETHNIC.3
  • QR.C16051.Student.ULN.3
  • QR.C16051.Instance.DISALL.1
  • QR.C16051.Instance.DISALL.6 
  • QR.C16051.Instance.FEEWAIVEAMT.3 (to fix a bug, as it wasn't considering CAMPID, when it should have been) 
  • QR.C16051.Instance.GROSSFEE.31
  • QR.C16051.Instance.HEAPESPOP.6
  • QR.C16051.Instance.INITIATIVES.6
  • QR.C16051.Instance.INITIATIVES.11
  • QR.C16051.Instance.INITIATIVES.30
  • QR.C16051.Instance.INITIATIVES.32
  • QR.C16051.Instance.INITIATIVES.33
  • QR.C16051.Instance.ITTPHSC.1 
  • QR.C16051.Instance.ITTPHSC.8 
  • QR.C16051.Instance.ITTPHSC.9
  • QR.C16051.Instance.ITTPHSC.12 
  • QR.C16051.Instance.ITTSCHMS.1
  • QR.C16051.Instance.PROGTYPE.4
  • QR.C16051.Instance.SPECFEE.1
  • QR.C16051.Instance.SPLENGTH.1
  • QR.C16051.Instance.UNITLGTH.1
  • QR.C16051.Instance.YEARPRG.1 
  • QR.C16051.Instance.YEARSTU.1
  • QR.C16051.EntryProfile.CARELEAVER.17
  • QR.C16051.QualificationsAwarded.OUTCOME.3 
  • QR.C16051.QualificationsAwarded.OUTCOME.8
  • QR.C16051.QualificationsAwarded.TQGSEC.2 
  • QR.C16051.QualificationsAwarded.QUAL.2

10 new rules added:

  • QR.C16051.Course.REGBODY.4
  • QR.C16051.Course.COURSEAIM.19
  • QR.C16051.Course.COURSEAIM.20 
  • QR.C16051.Instance.ENTRYRTE.1
  • QR.C16051.Instance.Engagement.2
  • QR.C16051.Instance.INITIATIVES.35
  • QR.C16051.Instance.INITIATIVES.36
  • QR.C16051.Instance.INITIATIVES.37
  • QR.C16051.Instance.INITIATIVES.38 
  • QR.C16051.Instance.INITIATIVES.39

1 rule deleted - as it was no longer needed: 

  • QR.C16051.Instance.RSNEND.4

Also, a link to the DLHE population specification (from the DLHE pop report) was updated. 

37 17 March 2017

7 new rules added: 

  • QR.C16051.Student.LearnerContact.2 
  • QR.C16051.Student.LearnerContact.3
  • QR.C16051.ApprenticeFinances.APFINCODE.1
  • QR.C16051.EmploymentStatusMonitoring.ESMCODE.1
  • QR.C16051.LearnerFAM.LEARNFAMCODE.1
  • QR.C16051.LearningDeliveryFAM.LEARNDELFAMCODE.1
  • QR.C16051.ContactPreference.CONTPREFCODE.1

1 rule deleted:

  • QR.C16051.Instance.INITIATIVES.7

6 rules amended: 

  • QR.C16051.Instance.FEEREGIME.1
  • QR.C16051.Instance.FEEREGIME.10
  • QR.C16051.Instance.FEEREGIME.11
  • QR.C16051.Instance.FUNDMODEL.1
  • QR.C16051.Instance.MSTUFEE.1
  • QR.C16051.Instance.WITHDRAWREASON.1
36 6 March 2017

The DLHE population report is now available to providers. Following feedback from the sector, the download for this report now includes the DOMICILE and NATION fields. In order to access the population file you will need to submit a file that passes schema validation. 

The new codes in the QualificationsOnEntry.QUALSBJ and QualificationsOnEntry.QUALTYPE fields have now been updated in the schema (to fix bugs 30634 and 30628). 

New rules added: 

  • QR.C16051.Instance.FUNDMODEL.6
  • QR.C16051.Student.SEXID.4
  • QR.C16051.Student.ETHNIC.18

Rules deleted:

  • QR.C16051.Course.COURSEAIM.5
  • QR.C16051.Course.TTCID.16
  • QR.C16051.Student.DISABLE.3

Rules amended: 

  • QR.C16051.Instance.AIMTYPE.5 (to fix bug 30802) 
  • QR.C16051.LearningDeliveryFAM.LEARNDELFAMTYPE.1 (to fix bug 31097)
  • QR.C16051.Course.FEQAIMC.10 (rule was incorrectly triggering) 
  • QR.C16051.Engagement.ApprenticeFinances.1 (rule was incorrectly triggering)
35 15 February 2017

In this release a number of quality rules have been updated for this year. 

11 rules deleted: 

  • QR.C16051.Instance.INITIATIVES.2
  • QR.C16051.Instance.INITIATIVES.4
  • QR.C16051.Instance.INITIATIVES.8
  • QR.C16051.Instance.INITIATIVES.9
  • QR.C16051.Instance.INITIATIVES.19
  • QR.C16051.Instance.INITIATIVES.24
  • QR.C16051.Instance.INITIATIVES.25
  • QR.C16051.Instance.INITIATIVES.26
  • QR.C16051.Instance.INITIATIVES.27
  • QR.C16051.Instance.INITIATIVES.28
  • QR.C16051.Instance.FUNDCODE.20

4 amended rules: 

  • QR.C16051.Instance.AIMTYPE.1
  • QR.C16051.Instance.CSTAT.1
  • QR.C16051.Instance.LEARNPLANENDDATE.1
  • QR.C16051.Student.ETHNIC.4

26 new rules: 

  • QR.C16051.Course.COURSEAIM.17
  • QR.C16051.Course.COURSEAIM.18
  • QR.C16051.Course.FEQAIMC.10
  • QR.C16051.Student.ETHNIC.15
  • QR.C16051.Student.ETHNIC.16
  • QR.C16051.Student.LLDDHEALTHPROB.1
  • QR.C16051.Student.NINO.1
  • QR.C16051.Student.PRIORATTAIN.1
  • QR.C16051.Student.LearnContract.1
  • QR.C16051.Instance.AIMTYPE.4
  • QR.C16051.Instance.AIMTYPE.5
  • QR.C16051.Instance.AIMTYPE.6
  • QR.C16051.Instance.AIMTYPE.7
  • QR.C16051.Instance.FESTUMK.6
  • QR.C16051.Instance.FESTUMK.7
  • QR.C16051.Instance.FUNDMODEL.5
  • QR.C16051.Instance.MODE.34
  • QR.C16051.Instance.Engagement.1
  • QR.C16051.Engagement.ENGOUTCOME.1
  • QR.C16051.Engagement.ENGSTATUS.2
  • QR.C16051.Engagement.ApprenticeFinances.1
  • QR.C16051.Engagement.ApprenticeFinances.2
  • QR.C16051.Instance.LearnerEmploymentStatus.4
  • QR.C16051.LearnerEmploymentStatus.EMPSTAT.1
  • QR.C16051.Instance.LearningDeliveryFAM.4
  • QR.C16051.LeraningDeliveryFAM.LEARNDELFAMTYPE.1
33a 20 January 2017 The Entry Profile report has been released. This report includes validation to ensure that all records submitted can be linked to an entry profile either in the incoming data or submitted historically. This year the major change with this report is that any validation errors in this report will not prevent other reports from being generated and so will hopefully enable you to continue working. Please bear in mind however that missing entry profile data will affect other reporting.
33 19 January 2017

Validation has been introduced or updated for all postcode fields in the record to enforce that postcodes are returned in uppercase.

26 13 October 2016 A fix to the data type for Telephone number has been issued.
22 19 August 2016 ILR file production capability introduced.

Updated valid entries for Engagement.ENGOUTCOME and QualificationsOnEntry.QUALGRADE.

19 8 July 2016 The validation kit has been updated to include the rolled-on business stage rules from the 2015/16 record. We are currently identifying and specifying the changes required to validation to cater for the inclusion of Apprenticeship Standards and these rules will be included in future releases.
16 27 May 2016 The schema validation kit is now available for the 2016/17 Student record. This will allow users to validate their XML against the revised schema that caters for Apprenticeship Standards. If you already have the validation kit installed there is no need to install a new version. If you do not currently have the validation kit installed, you can access it by going here.
Upcoming releases (C16051)
Month Scheduled areas of work
  There are no planned upcoming releases 

Stages of data submission

Stage 1: Submitting and validating data

A. Sending data

Send data by clicking on the 'send data' button in the data collection system. Note that actions not currently available will be greyed out.

Data collection system - Process flow

Browse your computer to locate the file you wish to submit, and upload the file to the data collection system. 

Tips:

  • Files can have any name
  • Files must be in XML and conform to the relevant XML Schema Definition (XSD) file
  • Files can be compressed using PKZip/WinZip which will significantly reduce the upload time
  • Only a single file can be held on the system.

B. Validation

Automated validation checks (quality rules) will now run.

Further details on the quality rules which apply to this collection can be found in the coding manual.

The Quality rules report will contain the details of any rules triggered by the submission. Make any necessary amendments to the data and resubmit the file to the system. To pass validation, the file must not trigger any validation errors.

You can run some of these validation checks through our validation kit before submitting data to the data collection system. The kit enables you to test your data locally against schema and business stage validation rules prior to submission. You are strongly encouraged to use the validation kit as part of your data preparations.

Remember that you need to process and pass the business-stage validation in order to meet the requirements of the return deadline.

Stage 2: Committing and decommitting data

To proceed to the next stage in the submission process, a valid file needs to have been submitted. The data will then be classed as 'committable' and the option to process a COMMIT transaction will be made available through the data collection system.  

Prior to committing data, you should review all of the reports produced on the data collection system and make any necessary corrections to the data.

The COMMIT transaction sends a copy of your submission to our data quality assurance team and, where appropriate, to the relevant funding council. We analyse your return in parallel with your own analysis.

Decommitting

A passed commit transaction will lock the system to prevent the data from being amended. This is to allow our data quality assurance team to analyse the submission. To unlock the system you will need to request a DECOMMIT transaction.

Request a decommit by email or on +44 (0)1242 211144

Remember that you need to process and pass a COMMIT transaction in order to meet the requirements of the commit deadline.

Stage 3: Credibility checks

Once we have analysed your committed return, data quality queries will be posted onto the Minerva DQ database. Relevant users will be notified by email when these queries are available to view. The Minerva user guide provides help on using Minerva.

Access the Minerva Data Quality database

Stage 4: Sign off

Once your data has passed all the stages of validation, and any issues highlighted during credibility checking have been addressed, we will set the return to CREDIBLE. This produces the sign-off form.

When data is set to credible, a link to the sign-off form is automatically emailed to the head of the submitting organisation as well as the appropriate record contact. The form should be completed and signed by the head of the reporting organisation and returned to us by email or post. This verification offers both you and us assurances regarding onward use of the data.

Sign-off completes the data collection process.