Skip to main content

Student 2017/18: Support guides

This page provides an overview of the 2017/18 Student collection (C17051).

This should be used alongside the C17051 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

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

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.

You submit data via our 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 and track the progress of the collection.

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:

  • User guide
  • Data collection system: Known issues and release history.

In the Support area of the HESA website, 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 section, you can find:

 

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 388531 

Find out more about Liaison

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 C17051

Release - overview

For the C17051 Student record, we adopt 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 in July. 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 Amalgamator tool

For the C17051 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.

Changes to the Student Record

There have been several changes to the Student Record when compared to C16051. These are highlighted in our Annual Update and Supplementary Changes. It is important that providers are aware of all the changes for C17051.

DfE (previously NCTL) Performance Profiles

As in the previous year, a full commit will not be required to populate the DfE 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 DfE webservice.

HEFCW will provide, as in previous years, end of year monitoring (EYM) tables and other analyses through IRIS. The EYM tables will be available earlier than the rest of the analyses and HEPs are encouraged to look at them at the earliest opportunity to ensure that any errors in the student record that lead to incorrect information appearing in the tables can be resolved in plenty of time. Welsh HEPs are reminded that HEFCW staff are available at [email protected] if there are any questions about the EYM tables or any other part of the HEFCW IRIS output.

Providers in Scotland should 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).

Providers in Scotland are reminded that student carers are identified for the first time in the C17051 Student record, see the CARER field.

OfS would like to remind providers about the importance of meeting the published collection schedule. For registered providers, the OfS will monitor compliance with ongoing conditions of registration.

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 2017/18 returns are prepared in a way that is consistent with the code.

Validation kit

The validation kit for the 2017/18 student data is available to download. A user guide for the kit is available from the same link. 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 C17051 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 C17051 Student record data are available from the C17051 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

Issue Summary Status Date raised Date resolved

Issue ID: 67276 - GO population report

The CENSUS column in the GO sruvey population download (for both XML and CSV) has 'DEC' instead of 'Dec' as is says in the specification

Please note: this will not be fixed for C17051 now and this report will not exist in C18051 anyway as this was only an interim solution for this year. From next year you should get your Graduate Outcomes population from the Graduate Outcomes provider portal. 

Open 12 November 2018  

Issue ID: 67215 - Continuity Population 

The Expected Instance Population report has a couple of bugs. 1) the YEAR field is populating with 2016, instead of 2017. 2) the XML tags are incorrect, it should be <TARLROW> (same thing we did last year!) 

Resolution: This has been fixed. Providers will need to download another version from their dashboard to get thier fixed report.

Closed 2 November 2018 23 November 2018

Issue ID: 66037 - Credibility Reports

The Credibility report ITT3 is not populating correctly with the Undergraduate Opt-in students that it should be including. 

Closed 22 October 2018 30 October 2018

Issue ID: 64791 - Quality Rules

The QR.C17051.Student.TTPCODE.12 rule is triggering incorrectly, as the postcode lookup file has trailing spaces which is causing the lookup to fail on valid postcodes. 

Closed 19 September 2018 11 October 2018

Issue ID: 63906 - Credibility Reports

The Credibility reports download buttons are not working on the specific tables boxes, but the overall download is still working. 

Closed 7 September 2018 20 September 2018

Issue ID: 64006 - Quality Rules

The QR.C17051.Instance.YEARPRG.3 business rule is triggering incorrectly - where Instance.YEARPRG, Instance.UNITLGTH and Instance.SPLENGTH fields don't exist it shouldn't be triggering. 

Closed 12 September 2018 20 September 2018

Issue ID: 63726 - XTARIFF

The XTARIFF appendix has had the '+'s in the qualification grades (which is QUALTYPE ID 'IB Bonus points' that could have grades +1, +2 or +3 with Tariff scores - 40 80 and 120 respectively) has been accidentally removed. This will affect the XTARIFF derived field and also the QR.C17051.QualificationsOnEntry.QUALGRADE.2 error is now triggering incorrectly. Providers who are triggering the exception rule and want to progress further should contact [email protected]

Closed 30 August 2018 20 September 2018

Issue ID: 63673 - Quality Rules

The QR.C17051.Instance.FUNDCOMP.11 exception rule is triggering incorrectly - it is triggering for FUNDCOMP codes other than 9 (when the rule only specifies code 9). 

Closed 30 August 2018 12 September 2018

Issue ID: 62965 - Quality Rules

The QR.C17051.Instance.FEEWAIVETYPE.6 is triggering incorrectly - it is picking up instances where the sum of associated Module.CRDTPTS equals 10 exactly, and it shouldn't be. 

Closed 15 August 2018 30 August 2018

Issue ID: 62756 - Quality Rules

In the Continuity Report A  the rule QR.C17051.EntryProfile.QualificationsOnEntry.10 (CheckID 4.11.w) triggers but does not display the records when you click on the rule for more details. However, these records are displayed if you download the .csv file. 

Closed 3 August 2018 30 August 2018

Issue ID: 62376 - Quality Rules

The QR.C17051.QualificationsOnEntry.QUALTYPE.2 rule is triggering incorrectly, when a student holds both QUALTYPEs WE and WS - which should be allowed. 

Closed 31 July 2018 16 August 2018

Issue ID: 60680​ - static data

The cost Centre rules QR.C17051.ModuleSubject.COSTCN.4-9 were still looking at C15051 data for 'last year student FTE'. This should have been updated to C16051 this year.  

Closed 27 June 2018 5 July 2018

Issue ID: 60545​ - static data

The URN static data was missing some URNs in the list we downloaded. This is referenced in quality rule QR.C17051.ITTPlacement.PLMNTSCH.2 for example. 

Closed 26 June 2018 28 June 2018

Issue ID: 59449 - Quality Rules

The QR.C17051.Instance.AIMTYPE.6 and QR.C17051.Instance.AIMTYPE.7 exception rules are incorrectly triggering when a provider might not have ILRGEN=1 in their file. 

Closed 11 June 2018 5 July 2018

Issue ID: 58866 - Derived Fields

The XTPOINTS derived field doesn't seem to be calculating correctly. In one example it was not de-duping correctly for RE (reformed Alevel) and IE (Int bacc) QUALTYPEs. 

Closed 1 June 2018 21 June 2018

Issue ID: 57096 - Quality Rules

The QR.C17051.Instance.AIMTYPE.4 rule is incorrectly triggering for REDUCEDI = 04 students, when these are outside of the coverage of the AIMTYPE field. 

Closed 19 April 2018 24 May 2018

Issue ID: 56079 - QualificationsOnEntry.QUALGRADE field length to be increased

Currently any valud entries greater than 11 cannot be entered, for example 'No overall grade' and 'No known grade'.

Note: We are going to remove the two long character grades 'No overall grade' and 'No known grade' from the QUALGRADE field, so there will be no changes required to the data collection system. This will be fixed in the next coding manual release (version 1.5). 

Closed 28 March 2018 2 May 2018

Issue ID: 47737 - Quality Rules

Please note that the static data used to validate PREVINST.8 has not yet been updated for 2017/18. This is expected to happen around June.

Closed 28 March 2018 24 May 2018

Issue ID: 56023 - Quality Rules

Providers in Wales that trigger any of the Module.FRANIND.1-4 rules rules will experience a system error. We are currently working on this and will fix as a priority.

Closed 27 March 2018 12 April 2018

Issue ID: 56008 - Quality Rules

The Engagement.ApprenticeFinances.1 rule needs to be updated to cater for Non-funded apprenticeships.

Closed 26 March 2018 12 April 2018

Issue ID: 47710​ - static data

Please note that the static data that is used to validate the rules around FE Learning aims (LARS), has not yet been updated for 2017/18. For example the QR.C17051.Engagement.ENGAIM.1 rule. This is expected to happen around April. 

Closed 21 March 2018 26 April 2018

Issue ID: 55902​ - Schema valid files

The data collection system is not accepting self-closing tags in provider's files. For example "<APFINDATE/>". These files are running properly in the validation kit, so please use this in the meantime if you are experiencing this problem. 

Note: We have realised that the above description is not actuallyt the problem. APFINDATE is a mandatory field and should have a min occurence of 1 (it's currently 0). This is therefore falling over when a provider submits thier file, as it needs a value in there. This will be fixed by amending the XSD files in a future coding manual release. 

Closed 20 March 2018 2 May 2018

Issue ID: 55662​ - Quality Rules

The QR.C17051.QualificationsOnEntry.QUALSBJ.2 business rule error, is indicating that qualification type 'WS', should have a subject code of 'WBA'. However, this should actually be a subject code of 'SCC'. 

Closed 6 March 2018 29 March 2018

Issue ID: 55248​ - Schema changes

The changes to schema in ITTSCHMS field (adding codes 7 and 8 back in) was not fully taken throughout the system. This has caused a provider to fall over in the system, and may cause others to error. In the meantime, please don't submit any files with codes 7 and 8 in the ITTSCMS field. This will be fixed and released this week. 

Closed 13 March 2018 15 March 2018

Issue ID: 54841​ - Quality Rules

The new warning business rules QR.C17051.QualificationsAwarded.QUAL.17 was incorrectly triggering when no codes ending in '91' were returned in the QUAL field. 

Closed 2 March 2018 15 March 2018

Issue ID: 54823​ - Schema changes

The changes to schema in coding manual release 1.4 was not fully taken throughout the system. This caused a couple of providers to error in the derived field process. 

Closed 2 March 2018 2 March 2018

Issue ID: 53039 - ILR generation file

A provider has caused an error with their ILR file generation. If you don't supply a Learner FAM entity and the student is coded DISALL = 4, it falls over and can't create the ILR file. 
 

Closed 2 February 2018 5 February 2018

Release ID Release date Release summary
80A 30 October 2018 The sign-off email which goes out when providers are credible has had the date amended, following changes to deadlines recently. 
79B 25 October 2018 The sign-off form has been amended to remove the paragraph in section B, relating to English ITT provision. 
79A 16 October 2018

The sign-off form has been updated to amend the sign-off deadline.

The NSS report pdf has been update to correct the dates - it was incorrectly displaying the previous year. There is no impact to the data in the report, just the supporting documentation.

An update to the UKRLP look up table has been issued, affecting a number of quality rules including EntryProfile.PREVINST.4 and 8.

Instance.STULOAD.5 was triggering incorrectly but this has now been fixed.

78 11 October 2018

Drill-down functionality has been added to credibility tables SBJ1 and SBJF1.

The Unistats table 3 download is now available - a bug was preventing this from working.

QR.C17051.Instance.ENDDATE.15 and QR.C17051.Instance.ENDDATE.16 have been updated to only use data going back as far as 2013/14.

77B 27 September 2018 The PGR transfers in report wasn't generating correctly when providers pressed the commit button. This has now been fixed. 
77A 20 September 2018

Credibility report downloads have now been fixed - to fix bug 63906

QR.C17051.Instance.FEEWAIVETYPE.6 - fixing bug 62965 again 

QR.C17051.Instance.YEARPRG.3 - to fix bug 64006 

QR.C17051.QualificationsOnEntry.QUALGRADE.2 - the Tariff fix has now been applied, so this rule should now be triggering correctly and the XTPOINTS derived field is calculating correctly. 

The following exception rules have been added back into the system: QR.C17051.QualificationsOnEntry.QUALGRADE.6,  QR.C17051.QualificationsOnEntry.QUALGRADE.7 and QR.C17051.Entryprofile.POSTCODE.6 rules 

76 12 September 2018

The following bugs have been fixed in this release:

  • There was an error in the Research Council student numbers static data, which caused one provider to error in the system
  • QR.C17051.Instance.FUNDCOMP.11 exception rule - to fix bug 63673. 
  • QR.C17051.EntryProfile.PREVINST.4 exception rule had another update to the static data, to include some missing providers - please note this will be the last update made for C17051. Any further missing providers found will be added to the PIs but won't be fixed on the data collection system. 
  • QR.C17051.EntryProfile.PREVINST.8 business rule had another update to the UKPRN static data in include some missing providers. 
  • The QR.C17051.EntryProfile.QUALENT3.17 exception rule warning has now been added back into the system. 

Another version of the ONS post code static data has also been updated - this is likely to be the last update for C17051, so please contact Liaison if you have any further problems. 

75 30 August 2018

Commit button and Sign-off form are now available to providers. 

  • The IRIS report is now working for providers in England, Northern Ireland and Scotland as well.
  • XTPOINTS derived field has been amended to use the latest appendix file
  • Providers that have University of London degree awarding powers have been updated for quality rules Course.AWARDBOD.6 and Course.AWARDBOD.7
  • The list of providers who can see their FE continuity issues has been updated
  • The list of providers who have a veterinary school has been updated for use in quality rule QualificationsAwarded.QUAL.5

The following business rules have been amended:

  • EntryProfile.QUALENT3.28 - rule wording and plain English amended to avoid contradicting guidance
  • Instance.FEEWAIVETYPE.6 - Display issue fixed, to fix bug 62965

On the Continuity Report A - EntryProfile.QualificationsOnEntry.10 has been amended - to fix bug 62756 

 

74 16 August 2018

The FEQAIMC report is now available to providers. 

Update to the LARS static data - used in  QR.C17051.FEQAIMC.5 rule. 

Update to the schools lookup table - used in QR.C17051.EntryProfile.PREVINST.4 rule and checkdoc PIs. 

Amended 2 rules:

  • Exception rule: QR.C17051.QualificationsOnEntry.QUALTYPE.2 - to fix bug 62376
  • Business rule: QR.C17051.Course.AWARDBOD.4 - plain English corrected

The folllowing rules have had OWNQUAL added to the list of fields to display:

  • QR.C17051.QualificationsOnEntry.QUALGRADE.2 
  • QR.C17051.QualificationsOnEntry.QUALGRADE.3
  • QR.C17051.QualificationsOnEntry.QUALSBJ.2
  • QR.C17051.QualificationsOnEntry.QUALYEAR.19
  • QR.C17051.QualificationsOnEntry.QUALYEAR.20
72 18 July 2018

The following updates have been made to Credibility reports and tables:

  • RCUK1 - code 07 removed
  • APP2 , DOM1 , DOM1P, EXPL3, QUAL1, QUAL2, SIN1, SIN2 and SIN1P - COURSEAIM code D01 removed
  • ITT1, ITT2, QTS1 and SPECF2 - TTCID code F removed from current year and 8/G removed from historic year
  • DISAB1 - XSTUDIS01 codes E, L, M, and N removed (these stopped being used in C16051)
  • SIN1P - total total column removed
  • EYTS1 - ENTRYRTE replaced INITIATIVES codes
  • TAR1 and TAR1P - now use XTPOINTS instead of XTARIFF 
  • QUAL2 - COURSEAIM codes M73 added 
  • STAT1 - codes 98 and 99 added
  • EYTS1 and ITT3 - code 09 added
  • ETHNIC1 - codes 11 and 12 added
  • GO2 - amended shading rules
  • FTEN1, FTEN2, FTEN3, FTES1, FTES2 and FTES3 - additional notes amended only

The UKRI (previously RCUK) Look-up data has now been updated - this is used in validation rules. 

The C17041 Provider Profile data has now been loaded - this is used in validation rules (e.g. QR.C17051.Instance.CAMPID.1). 

The Checkdoc report is now available to providers. 

There is now a draft version of the NSS report available. Please be aware that this is an early version and therefore may not be correct. The final version will be released in the coming weeks, once any changes for this year have been agreed with OfS. 

71B 5 July 2018

The Credibility reports are now all rolled forward for 2017/18 - static data and year references have all been updated for this year, but none of the changes to the tables have been made yet. These will be in the coming sprint. 

The IRIS report is now working for providers in Wales only - just for the EYM report for the time being. Other reports, and IRIS for providers in England, Northern Ireland and Wales will be developed in future weeks. 

The Expected Instance report is now available for all providers. 

Amended 3 exception rules:

  • QoE.Qualgrade.3 - to cater for QUALGRADEs Q, X or U not being in the XTPOINTS appendix 
  • QR.C17051.Instance.AIMTYPE.6 - to fix bug 59449 
  • QR.C17051.Instance.AIMTYPE.7 - to fix bug 59449 
  • QR.C17051.ModuleSubject.COSTCN.4 - to fix bug 60680
  • QR.C17051.ModuleSubject.COSTCN.5 - to fix bug 60680
  • QR.C17051.ModuleSubject.COSTCN.6 - to fix bug 60680
  • QR.C17051.ModuleSubject.COSTCN.7 - to fix bug 60680
  • QR.C17051.ModuleSubject.COSTCN.8 - to fix bug 60680
  • QR.C17051.ModuleSubject.COSTCN.9 - to fix bug 60680
71A 28 June 2018 The URN static data was downloaded again and updated - to fix bug 60545. 
70 21 June 2018

XTPOINTS derived field has been amended to use the latest appendix file - to fix bug 58866. 

The following reports have been updated and are now available to providers:

  • PGR Transfers in
  • PGR Transfers Out
  • Frequency Counts
  • CCAnalyis 
  • Unistats 

The postcode static data has been updated. 

69 6 June 2018

Amended 1 business rules:

  • QR.C17051.QualsAwarded.OUTCOME.5 - due to changes in OUTCOME field

Amended 2 exception rules:

  • QR.C17051.Instance.ENDDATE.16 - to add a date restriction into the rule
  • QR.C17051.Student.CARER.3 - amended not to trigger when CARER.2 rule triggers 

A number of static data has been updated:

  • Degree awarding powers (used for AWARDBOD validation) 
  • Franchise partners data (used for TINST validation) 
  • OFFA financial support data (used in validation) 
  • URN data (used in ITTPLMNTSCH.2 validation) 
  • FEC lookup data (prep for Unistats report)
  • CCAnalysis static data (prep for CCANALYSIS report)
  • PI related static data (prep for checkdoc)
68 24 May 2018

Amended 1 exception rule:

  • QR.C17051.QualificationsOnEntry.QUALGRADE.2 - to cater for QUALGRADEs Q, X or U not being in the XTPOINTS appendix 

Amended 1 business rule:

  • QR.C17051.Instance.AIMTYPE.4 - to fix bug 57096 

Added 1 business rule:

  • QR.C17051.Instance.TREFNO.8 - new rule to validate TREFNO values being returned in Scotland 

All Continuity rules have now all been rolled forward. The following rules have been changed: 

  • QR.C16051.EntryProfile.WELBACC.2 - rule deleted
  • QR.C16051.Instance.NUMHUS.6 - rule deleted
  • QR.C16051.Instance.NUMHUS.8 - rule deleted
  • QR.C17051.EntryProfile.QualificationsOnEntry.10 - use XTPOINTS
  • QR.C17051.EntryProfile.QualificationsOnEntry.11 - use XTPOINTS
  • QR.C17051.EntryProfile.PGCECLSS.4 - add COURSEAIM M73
  • QR.C17051.EntryProfile.PGCESBJ.4 - COURSEAIM M73 added
  • QR.C17051.EntryProfile.MARSTAT.3 - new codes added
  • QR.C17051.Instance.PHDSUB.14 - COURSEAIM D01 removed
  • QR.C17051.Instance.NUMHUS.3 - amend for apprenticeships 
  • QR.C17051.EntryProfile.PARED.4 - REDUCEDI 7 removed
  • QR.C17051.EntryProfile.PREVINST.5  - REDUCEDI 7 removed  
  • QR.C17051.EntryProfile.SEC.4  - REDUCEDI 7 removed
  • QR.C17051.EntryProfile.SOC2000.4  - REDUCEDI 7 removed
  • QR.C17051.Student.SURNAME.2  - REDUCEDI 7 removed
  • QR.C17051.Student.SURNAME.3  - REDUCEDI 7 removed
  • QR.C17051.Instance.EntryProfile.3 - to show COLFROMPROV in display

The UKPRN static data has been updated - to fix bug 47737. This means PREVINST.8 rule will now be using the latest set of lookup data. 

The Data Supply report is now available. Changes that have been made this year are as follows:

  • SKEOS, SKEUNITS, SKEITT, WELBACC, XDLEV601, XTARIFF and XTARIFFGP01 fields have been removed; 
  • CARER, XAPPMK01, XQPREV01 and XTPOINTSGP01 field has been added;
  • for Graduate Outcomes XDLEV301 becomes XGOLEV301, XDLEV501 becomes XGOLEV501, and XOBTND01 becomes XOBTNG01; 
  • INITIATIVES and QUALGRADE have increased the field lengths. 
67B 10 May 2018

Added 1 exception rule: 

  • QualificationsAwarded.QUAL.18 - Qualification awarded being returned again (new)

Amended 4 business rules: 

  • QR.C17051.Instance.MSTUFEE.21 - add Course.COURSEAIM to display 
  • QR.C17051.Instance.FUNDCODE.36 - add Course.COURSEAIM to display
  • QR.C17051.Instance.PHDSUB.11 - it was incorrectly triggering 
  • QR.C17051.QualificationsOnEntry.QUALTYPE.4 - new QUALTYPE exceptions added into the rule

OFFA fees data has now been loaded - so the GROSSFEE rules will be working off the correct amounts for 2017/18. 

67A 2 May 2018

The Graduate Outcomes population report is now available - this is for the first cohort only December 2018, as an interim solution. Once the Graduates Outcomes collection site has been developed, the full functionality for reviewing the population information and returning contact details will become available on the Graduate Outcomes collection site. 

The latest coding manual changes (verson 1.5) have been applied, so the new QUALGRADES can now be submitted to the data collection system. 

66 26 April 2018

Added 2 new exception rules (these new rules are to highlight records that need to be returned and potentially closed off. These will both be warnings in C17051 and then made errors in C18051): 

  • QR.C17051.Instance.ENDDATE.15 
  • QR.C17051.Instance.ENDDATE.16 

Amended 1 exception rule (to use XTPOINTSGP01 derived field, instead of XTARIFFGP01):

  • QR.C17051.EntryProfile.QualificationsOnEntry.14 

The FE Learning Aims (LARS) static data has been updated - so bug 47710 is now closed. 

A whole number of derived fields have also been amended, including two new ones: XAPPMK01, XTPOINTSGP01. 

The Continuity Register has also been updated in this release, to add in some new fields and also remove some fields that are no longer needed. 

65 12 April 2018

Added 2 new exception rules: 

  • QR.C17051.Student.RELBLF.9 - new rule to monitor change of coding to 98/99.
  • QR.C17051.Student.RELBLF.10 - new rule to monitor change of religious belief

Amended 11 exception rules (mostly to use XTPOINTS or XTPOINTSGP01 derived field, instead of XTARIFF or XTARIFFGP01):

  • QR.C17051.Engagement.ApprenticeFinances.1 - amended to exclude non-funded apprenticeships
  • QR.C17051.Course.AWARDBOD.8 - related to bug 56023 
  • QR.C17051.Module.FRANIND.4 - to fix bug 56023
  • QR.C17051.EntryProfile.QUALENT3.13
  • QR.C17051.EntryProfile.QUALENT3.15
  • QR.C17051.EntryProfile.QUALENT3.16
  • QR.C17051.EntryProfile.QualificationsOnEntry.5
  • QR.C17051.QualificationsOnEntry.QUALGRADE.2
  • QR.C17051.QualificationsOnEntry.QUALGRADE.3
  • QR.C17051.QualificationsOnEntry.QUALGRADE.4
  • QR.C17051.QualificationsOnEntry.QUALGRADE.5

Business rules QR.C17051.Module.FRANIND(1-3) have also been updated - to fix bug 56023. 

The postcode static data has been updated. 

64 29 March 2018

Amended 2 business rules: 

  • QR.C17051.QualificationsOnEntry.QUALSBJ.2 - to fix a bug, the rule now caters for QUALTYPE WS (Welsh Bacc Skills cert) must be QUALTYPE SCC.
  • QR.C17051.Instance.FUNDLEV.7 - amend to add I71 to the exclusions of this rule.

Added 1 new exception rule:

  • QR.C17051.Instance.FUNDCOMP.11 - requested by HEFCW, to catch where there may be incorrect coding of funding

Amended 4 exception rules: 

  • QR.C17051.EntryProfile.POSTCODE.11 - to fix a bug from last year that incorrectly triggered for Channel Island postcodes
  • QR.C17051.Instance.COMDATE.5 - dates corrected
  • QR.C17051.Instance.COMDATE.6 - dates corrected
  • QR.C17051.Instance.COMDATE.7 - dates corrected

The 2016/17 Student fixed database is now open to providers who need to fix data from the C16051 collection. 

63B 14 March 2018

The exception rules have all been rolled forward now. Most of the amendments have also been made - though there are a few new rules to come in the next few weeks. 

Deleted 6 exception rules:

  • QR.C17051.Student.TTPCODE.16 
  • QR.C17051.Instance.INITIATIVES.16
  • QR.C17051.Instance.INITIATIVES.17
  • QR.C17051.Instance.INITIATIVES.21
  • QR.C17051.Instance.INITIATIVES.34
  • QR.C17051.EntryProfile.WELBACC.2

Amended 11 exception rules (mostly adding COURSEAIM M73 into the rules, or bugs from last year) :

  • QR.C17051.EntryProfile.PGCECLSS.5 
  • QR.C17051.EntryProfile.PGCESBJ.5 
  • QR.C17051.EntryProfile.POSTCODE.6 - amend display to include COMDATE
  • QR.C17051.EntryProfile.PREVINST.4 - amend display to include age and MODE
  • QR.C17051.Student.Instance.1 - bug with duplicated rows of data (bug from C16051)
  • QR.C17051.Student.ETHNIC.7 - remove REDUCEDI 07 
  • QR.C17051.Instance.FEEWAIVETYPE.2 
  • QR.C17051.Instance.HEAPESPOP.9 
  • QR.C17051.Instance.MODE.32 - to fix a bug with the boundaries of the rule 
  • QR.C17051.QualificationsAwarded.QUAL.17 - to fix bug 54841
  • QR.C17051.QualificationsOnEntry.QUALYEAR.28 - adding some Dance and Drama related qualifications into exclusions from the rule 

Added 8 exception rules (mostly to enforce changes in coverage and around new codes): 

  • QR.C17051.Instance.RSNEND.12 - to highlight previous completed instances being returned again
  • QR.C17051.Student.CARER.3
  • QR.C17051.Student.CARER.4
  • QR.C17051.Student.CARER.5 
  • QR.C17051.Student.CARER.6
  • QR.C17051.Student.RELBLF.7
  • QR.C17051.Student.RELBLF.8 
  • QR.C17051.QualificationsAwarded.QUAL.18 - to highlight the same qualifications awarded being returned year after year

The *J data for UCAS has been loaded into the system now - this is referenced in a number of rules. 

The system has been amended to fix bug 55248 (the schema error with ITTSCHMS field, codes 7 and 8). 

63A 2 March 2018 An interim release, to fix bug 54823 and the schema changes we made recently. As suspected, this was the derived field process causing the errors. 
62 1 March 2018

The changes in the recent coding manual have now been updated in the system - for example the new valid entries in QUALGRADES and QUALTYPES, TQSSUB and TQGSUB fields etc. See the revision history for full details. 

Amended 3 business rules:

  • QR.C17051.Instance.FUNDCODE.22 (to exclude providers in England)
  • QR.C17051.Instance.YEARPRG.3 - amend from warning to error 
  • QR.C17051.Instance.YEARPRG.5 – amend from warning to error

Added 9 new business rules (mostly around changes to funding for nursing, apprenticeship):

  • QR.C17051.Instance.FUNDCODE.36
  • QR.C17051.Instance.FUNDCODE.37
  • QR.C17051.Instance. INITIATIVES.40
  • QR.C17051.Instance. INITIATIVES.42
  • QR.C17051.Instance.ITTPlacement.4 (EntryRTE 09)
  • QR.C17051.Instance.MSTUFEE.21
  • QR.C17051.Student.RELBLF.6 
  • QR.C17051.Instance.RSNEND.13
  • QR.C17051.QualificationsAwarded.QUAL.17 (warning)

This completes all the business rules changes that we are currently aware of. Now we will move onto exception rules! 

61 15 February 2018

The web service for DfE to pick up ITT data for the Student record has now been opened. This is to allow the DfE plenty of testing time for their new data management system. 

Amended 6 business rules: 

  • QR.C17051.Instance.FEOUTCOME.4 - remove codes 6,7
  • QR.C17051.Instance.FEOUTCOME.5 - remove codes 6, 7
  • QR.C17051.Instance.ITTAIM.1 - remove TTCID Q
  • QR.C17051.Instance.ITTPHSC.1 - remove TTCID Q
  • QR.C16051.Instance.ITTPlacement.3 - allow ENTRYRTE 09 to return placements
  • QR.C17051.Engagement.OUTGRADE.1 - remove codes 6, 7

Added 5 new business rules:

  • QR.C17051.Instance.GROSSFEE.34 - fees in Wales
  • QR.C17051.Instance.INITIATIVES.41 - apprenticeships 
  • QR.C17051.Instance.PROGTYPE.6 - apprenticeships
  • QR.C17051.Student.CARER.1 - new carer field
  • QR.C17051.Student.CARER.2 - new carer field 

The FE static data has been updated to remove LDA from the LearnerFAM entity and SPP from the LearningDELFAM entity. These are used in the rules: LearnerFAM.LEARNFAMCODE.1 and LearningDeliveryFAM.LEARNDELFAMCODE.1. 

60 5 February 2018

The Entry Profile Match report is now available to providers. 

We have amended 26 business rules in total and 1 new business rule added. 

Amended 13 business rules to include COURSEAIM code M73:

  • QR.C17051.Course.COURSEAIM.20
  • QR.C17051.EntryProfile.PGCECLSS.1
  • QR.C17051.EntryProfile.PGCESBJ.1
  • QR.C17051.EntryProfile.CARELEAVER.8
  • QR.C17051.EntryProfile.CARELEAVER.9
  • QR.C17051.Instance.FEEREGIME.4
  • QR.C17051.Instance.FEEREGIME.14
  • QR.C17051.Instance.FEEREGIME.15
  • QR.C17051.Instance.FEEREGIME.17
  • QR.C17051.Instance.FEEWAIVETYPE.1
  • QR.C17051.Instance.HEAPESPOP.1
  • QR.C17051.Instance.SSELIG.2
  • QR.C17051.Instance.TREFNO.3
  • QR.C17051.Instance.TREFNO.5

Amended 6 business rules to removal REDUCEDI code 07: 

  • QR.C17051.EntryProfile.POSTCODE.1
  • QR.C17051.Instance.ENDDATE.10
  • QR.C17051.Instance.RSNEND.1
  • QR.C17051.Student.DISABLE.1
  • QR.C17051.Student.ETHNIC.4
  • QR.C17051.Student.TTPCODE.1

Amended 5 business rules due to changes in maximum fee chargeable:

  • QR.C17051.Instance.GROSSFEE.11
  • QR.C17051.Instance.GROSSFEE.12
  • QR.C17051.Instance.GROSSFEE.13
  • QR.C17051.Instance.GROSSFEE.26
  • QR.C17051.Instance.GROSSFEE.27

Amended 2 other business rules, for other reasons:

  • QR.C17051.Course.MSFUND.9 
  • QR.C17051.Instance.INITIATIVES.11 

1 new business rule: 

  • QR.C17051.Instance.ENTRYRTE.8 - to replace INITIATIVES.38

A fix for bug 53039, so the ILR generation will now be working correctly again. We have updated the file generation process to cater for this scenario. 

59 18 January 2018

The 7 QUALTYPEs that were fixed in coding manual version 1.3 are now able to be returned in the data collection system. 

Deleted 1 business rule: 

  • QR.C17051.EntryProfile.QUALENT3.4

Amended 14 business rules (mostly to remove TTCID code F): 

  • QR.C17051.Course.CourseSubject.2 
  • QR.C17051.Course.MSFUND.2 
  • QR.C17051.Instance.ENTRYRTE.2 
  • QR.C17051.Instance.FEEREGIME.1 
  • QR.C17051.Instance.FEEREGIME.12 
  • QR.C17051.Instance.FinancialSupport.3 
  • QR.C17051.Instance.FinancialSupport.4 
  • QR.C17051.Instance.FUNDCODE.6 (reviewed list of EU outermost regions) 
  • QR.C17051.Instance.FUNDCODE.13 
  • QR.C17051.Instance.FUNDCODE.25 
  • QR.C17051.Instance.FUNDCODE.27 
  • QR.C17051.Instance.INITIATIVES.31 (to include Wales in rule) 
  • QR.C17051.Instance.ITTPHSC.1 (also REDUCEDI 07 removed)
  • QR.C17051.Instance.MSTUFEE.16 

Also a number of quality rules have had plain English translations added. 

57 14 December 2017

Amended 12 business rules (mostly COURSEAIM D01 removed): 

  • QR.C17051.Instance.NUMHUSPREV.1
  • QR.C17051.Instance.PHDSUB.1
  • QR.C17051.Instance.PHDSUB.2
  • QR.C17051.Instance.PHDSUB.3
  • QR.C17051.Instance.PHDSUB.5
  • QR.C17051.Instance.PHDSUB.6
  • QR.C17051.Instance.PHDSUB.13
  • QR.C17051.Instance.REFData.1
  • QR.C17051.Instance.RSNEND.9
  • QR.C17051.Instance.SPECFEE.2
  • QR.C17051.QualificationsAwarded.QUAL.3
  • QR.C17051.Instance.ENTRYRTE.5 (added ENTRYRTE code 09)

Deleted 20 business rules: 

  • QR.C17051.Course.COURSEAIM.2
  • QR.C17051.Course.REDUCEDC.1
  • QR.C17051.Course.REDUCEDC.4
  • QR.C17051.Course.TTCID.3
  • QR.C17051.Course.TTCID.4
  • QR.C17051.CourseSubject.SBJCA.9 
  • QR.C17051.Instance.ENDDATE.3
  • QR.C17051.Instance.ITTPHSC.5
  • QR.C17051.Instance.INITIATIVES.12
  • QR.C17051.Instance.INITIATIVES.13
  • QR.C17051.Instance.INITIATIVES.22
  • QR.C17051.Instance.INITIATIVES.38
  • QR.C17051.Instance.MODE.12
  • QR.C17051.Instance.MSTUFEE.5 
  • QR.C17051.Instance.MSTUFEE.7 
  • QR.C17051.Instance.MSTUFEE.8
  • QR.C17051.Instance.REDUCEDI.1 
  • QR.C17051.Instance.REDUCEDI.2
  • QR.C17051.QualificationsAwarded.CLASS.2
  • QR.C17051.QualificationsAwarded.QUAL.1
56 8 December 2017

Our work to start rolling forward C17051 has started now. 

Schema updates have been made to reflect recent changes in the coding manual - for example the new QUALTYPE and QUALGRADE fields are now usable in the data collection system and validation kit. 

Rolled forward all derived fields from C16051. Please be aware that this means the changes for 2017/18 have not yet been made. 

Amended 18 business rules (many are due of removing COURSEAIM D01 or removing TTCID F):

  • QR.C17051.Course.COLLORG.1 
  • QR.C17051.Course.COURSEAIM.8 
  • QR.C17051.Course.TTCID.1 
  • QR.C17051.Course.TTCID.8
  • QR.C17051.Student.SSN.4 
  • QR.C17051.Instance.COLFROMDATE.1 
  • QR.C17051.Instance.COLFROMPROV.1 
  • QR.C17051.Instance.COLTODATE.1 
  • QR.C17051.Instance.COLTOPROV.1 
  • QR.C17051.Instance.COURSEID.2
  • QR.C17051.Instance.FUNDLEV.9 
  • QR.C16051.Instance.Mobility.3 
  • QR.C17051.Instance.MODE.10 (corrected the English version of this rule)
  • QR.C17051.Instance.REFData.3 (column heading display was incorrect) 
  • QR.C17051.Engagement.ApprenticeFinances.1
  • QR.C17051.EntryProfile.CARELEAVER.3 
  • QR.C17051.EntryProfile.CARELEAVER.4 
  • QR.C17051.EntryProfile.CARELEAVER.1 
54 9 November 2017

One new business rule has been added: 

  • QR.C17051.Instance.QualificationAwarded.4 - to stop qualifications awarded being returned on apprenticeship wrapper aims 
52 11 October 2017

Some minor bugs have been fixed in this release:

  • QR.C17051.CourseSubject.SBJCA.15 (noticed in C16051, bug 44060) 
  • QR.C17051.Instance.EXCHANGE.4 (noticed in C16051, bug 44068)
  • QR.C17051.Student.SSN.4 (noticed in C16051, bug 44088)

QR.C17051.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. 

50A 5 September 2017

Some minor changes have been to quality rules:

  • Switzerland have been added to business rule QR.C17051.Instance.FUNDCODE.6
  • Switzerland have been added to exception rule QR.C17051.Instance.FUNDCODE.28
  • Four business rules have been amended to speed up the processing time (but the meaning hasn't changed) 
49 30 August 2017

Dashboard page

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

  • 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. 
48 22 August 2017

The data collection system for the 2017/18 Student record is now open. 

The validation kit is now available. 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. This includes the rolled-on business rules from the 2016/17 record. 

The ILR file generation tool capability has also been introduced in this release. 

The terms and conditions for using the ILR generation tool have been reviewed this year (see www.hesa.ac.uk/collection/c17051/apprenticeship-data-processing-terms for more details). You will now be required to contact [email protected] to let us know if you would like to use the ILR generation tool. If you haven't informed us that you would like to opt-in, then the system will not allow you to send apprenticeship data and you will not be able to continue with your submission. 

Month Scheduled areas of work
2018

There are no planned upcoming releases. 

Stages of data submission

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.

How to obtain a switch

When errors are triggered in the Data Collection system but the data has been checked and is genuine, you need to request a switch. This is because your file will not pass the validation requirements of the collection deadlines if there are any remaining errors.

Please email your switch request to Liaison, stating which rule is causing the error to be triggered and for how many records, together with an explanation as to why the data is genuine.

This will then be forwarded to your funding council/regulator for them to review. They may agree the switch, ask for more information or state how they wish the data to be returned so that an error is no longer triggered.

This request should be sent well in advance of any deadline, to allow sufficient time for a decision to be made.

When a switch has been agreed, it will be applied to your data for the count specified and the data will be reprocessed. This will resolve the error.

If the count increases, the rule will be triggered again, and you will need to request that the count on the switch be increased. This will be forwarded to your funding council/regulator for approval.

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 388531

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

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

Access the Issue Management System data quality database

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.