Home

Welcome to the QAN Website

This website has been set up by the DfE to enable schools, Local Authorities and Software Suppliers to access to up-to-date qualifications data (tailored from the more generic data DfE receives from QCA) for populating their Management Information Systems (MIS). From September 2007, Secondary schools with sixth forms must record on their MIS Post-16 learning aims being pursued by learners in their sixth form. This data must then be provided to the DfE twice a year through the established School Census collection.

Schools, and their suppliers, can access the latest tables of qualification data in two ways; Web Services and Downloadable Files.

Web Services

The QAN data can be accessed on a real-time basis through a set of SOAP 1.2 Web Services which could be retrieved programmatically by school MIS. Web Services also provides the functionality to search the QAN data. For information on how to access Web Services please download and read the following System Integration Guide.

Downloadable Files

On this website you can access the latest tables of qualification data in XML or CSV format along with XSD and text files that describe the structure of the XML or CSV data respectively.

Generic QAN data | Additional Documentation

 

Latest News

IMPORTANT INFORMATION ABOUT DISCOUNT CODES: PLEASE BRING THIS UPDATE TO THE ATTENTION OF THOSE WHO ARE WORKING WITH KS4 AND POST 16 QUALIFICATIONS – INCLUDING EXAMS OFFICERS
Last September, Raise Online published a new set of Key Stage 4 discount codes. As mentioned in the QWS Latest News articles in advance of School Census 2013, some of these codes are not the same as listed on QWS. This is correct since Post 16 codes have not changed. We appreciate that these differences complicate some of the work within management information systems and we are sorry that this is the case. However, we cannot amend Post 16 (i.e. QWS) discount codes since they are currently correct. This note is to ensure that exams officers and those working with management information systems in schools are aware that QWS discount codes will not always match the codes for pre 16.
It must be emphasised that QWS is provided by the Department to make the download of Post 16 School Census data more manageable. It only contains data on Post 16 qualifications that are funded for teaching in England. We are aware that management information systems may use QWS for wider purposes. Thus, we have sent system suppliers a look up file detailing the codes in question in the hope that if QWS is used for other purposes, the changes may be easily managed. We have also discussed this with them and will continue to do so. This article is to ensure that all officers in schools are aware of this situation – including exams officers even if there is no Post 16 provision in the school (as they need to be aware that in some cases Key Stage 4 discount codes are not those downloaded through QWS). We advise checking with management information suppliers to see how this situation should be managed. Other QWS queries may of course be sent through the EDD Helpdesk.


Last Updated: 31/03/2014 14:21:04

Discount Code Update for F1 codes
The following discount codes have now been added into QWS as mentioned in the previous Latest News message. Please read the previous message (2 October 2013) to find out important information about these codes. Codes are as follows: F1H – Hebrew Language F1K – Greek (Classic) F1L - Latin F1P – Persian Language F1Z – Other ClassicalLang. With apologies for the delay in adding these codes.

Last Updated: 09/10/2013 12:57:32

Discount Codes - Important Update
This is an update to previous advice:

Schools may be aware that a file of new Discount Codes has been published on Raiseonline for the 2014 KS4 performance tables, These Discount Codes apply only to KS4, not to Post-16. Therefore QWS retains the older discount codes.

It appears that some awarding bodies have used the new codes in the data files they send schools to assist in processing qualifications (these files are often called basedata) and some school Management Information Systems (MIS) use these files to link the school census learning aims data to the awarding body entrance and results data. This discrepancy between QWS discount codes and those used by some awarding organisations is causing some confusion and can interfere with the matching of records. The Department is providing MIS suppliers with a file containing both sets of discount codes in order to help them in overcoming these problems.

The Department would prefer if the Discount Codes listed in the QWS system were returned. However, if this proves overly burdensome the new Discount Codes that may appear in basedata (as described above) will be acceptable. Discounting will work as if there were only one set of codes and the Department will use internal systems to match qualifications which use the new codes.

There five new discount codes which cannot currently be loaded on to QWS until w/c 7 October 2013 due to technical issues. These are:

F1H – Hebrew Language
F1K – Greek (Classic)
F1L - Latin
F1P – Persian Language
F1Z – Other ClassicalLang

If the above Discount Codes are relevant to a school’s census return there are currently two options:

1 Use the existing QWS discount code for the QAN

2 If QWS codes cannot be used, please wait until QWS Latest News advises that the new codes may be used.

May we again apologise for inconvenience caused by the above issue.


Last Updated: 02/10/2013 10:55:55

Discount Codes
RaiseOnline has published a file of new Discount Codes but these apply only to KS4, not to Post-16. Therefore QWS retains the older discount codes. It appears that some awarding bodies have used the new codes in the data files they send schools to assist in processing qualifications (these files are often called basedata) and some MISs use these files to link the school census learning aims data to the awarding body entrance and results data.

This discrepancy between discount codes is causing some confusion in schools. The Department is providing MIS suppliers with a file containing both sets of discount codes in order to help them in overcoming these problems.


Last Updated: 26/09/2013 13:12:57

Discount Code change to QAN 60064821
With apologies - a further discount code amendment has been made this morning. QAN 60064821 has been amended to HL to be consistent with other sources.

Last Updated: 20/09/2013 12:21:04

Change to Discount Code for QAN 60061789
Following a query received, an incorrect discount code was identified on QWS. With apologies for inconvenience this may cause, the discount code for QAN 60061789 has been changed from KJ2 to the correct code PA1.

Last Updated: 20/09/2013 11:05:40

Work Placement/Experience QANs have changed
With apologies for any inconvenience this may cause, the QANs used for Work Placement/Experience have changed. The new QANs will need to be used for the autumn 2013 School Census return. The original codes that the Information Authority set up for work experience have been changed as there was a decision to shift the bands’ boundaries because of the traineeship programme. Below are the details of the changes:

New QAN references: Z0007834, Z0007835, Z0007836, Z0007837, Z0002348

Old QAN references: Z0002341, Z0002342, Z0002343, Z0002344, Z0002345, Z0002346

Last Updated: 03/09/2013 11:38:24

INTERNATIONAL BACCALAUREATE OVERALL QAN
In response to queries received, the guidance provided about the return of the overall IB QAN and the components has been re examined. The revised guidance is as follows:

QANs are available for the overall International Baccalaureate (IB) and for each component (or subject) qualification. For those students taking the full IB, it is essential that the overall IB QAN is recorded in school MIS and returned in the School Census. QANs for the individual components need not be returned if the full IB is being undertaken. Students who are only taking components of the IB, but not going for the overall qualification, should return the QANs for those components. If the full IB is not being undertaken the overall QAN should not be returned.

If the components have already been input alongside the overall QAN there is no need to remove them.

Last Updated: 03/10/2012 12:22:52

Discount Code changes May/June 2012 update
The changes to Discount Codes noted in the previous Latest News bulletin have now been completed, aside from a small number of tidy up tasks. We will update Latest News when these final changes have been completed. We apologise once again for any inconvenience this exercise may have caused. A list of the QANs that have been amended can be found on the DfE website at the address below.

http://www.education.gov.uk/schools/adminandfinance/schooladmin/ims/datacollections/schoolcensus/b00208370/sc2012

Last Updated: 19/06/2012 15:21:10

Discount Code changes May/ June 2012
In preparation for the autumn 2012 School Census the Department is about to conduct a major revision of Discount Codes on QWS. This revision is necessary to eliminate discrepancies between QWS and the discount codes used in the Performance Tables, where they define when the performance points and threshold contribution of qualifications discount against each other. It is our hope that this co-ordination of Discount Codes will help to make matching of learning aims to exam results easier for the autumn 2012 School Census and beyond.

The co-ordination will involve changing the Discount Codes for about a quarter of the QANs on QWS. Schools are advised not to download QWS files or use these to assign learning aims to students until the co-ordination work has been concluded. Schools may also need to re-examine their learning aims data after 15 June in case these have been affected by the changes.

To enable this work to be carried out, QWS will be unavailable between 9am and 10am on Thursday 24 May. Further checking and testing as well as manual revisions will follow and the Department aims to complete this work by 15 June 2012.

A further note will appear on QWS Latest News when this work has been completed. A list of the affected QANs will be provided as well.


Last Updated: 23/05/2012 15:18:53

Temporary Discount Codes for new QANs
QWS managers are currently reviewing the process by which Discount Codes are allocated to QANs. In the meantime, so that new qualifications may be added to QWS, a discount code of `0000’ is being used for new QANs on a temporary basis. Discount Codes will be updated as soon as possible, and this will also be notified on Latest News. We apologise for any inconvenience this may cause.

Last Updated: 12/04/2012 13:12:35

Qualifications removed from QWS
Seven qualifications have been removed from QWS today. These qualifications were added to QWS due to a procedural error for which we very much apologise. If you have NOT selected these qualifications for your Census return there is no need to make any changes to your data. The qualifications affected are all Level 5 qualifications from the Institute of Leadership and Management (ILM). The QAN references are as follows:

50036075, 50036233, 5003716X, 50037626, 50038795, 50055665, 50084653


Last Updated: 03/10/2011 13:51:18

The QWS QAN Support Team link
The QWS QAN Support Team link is now working. We apologise for any inconvenience caused while this link was temporarily unavailable.

Last Updated: 03/10/2011 12:48:42

Helpdesk Link Update
As notified on 29 September, the QWS QAN Support Team link is currently not working. This link is planned to be restored by Monday 3 October. If trying to use the link before then, please be aware that work may be under way. The address given in the Latest News item on 29 September is correct in any case i.e. DSD.Helpdesk@education.gsi.gov.uk

Last Updated: 30/09/2011 12:00:06

QAN Support Team email link unavailability
With apologies, the link on the QWS Generic QAN Data page, to register a request for help - is currently unavailable. The following email address should be used to request help about QWS:

DSD.Helpdesk@education.gsi.gov.uk

We apologise for inconvenience caused, and will notify you when the link has been restored.


Last Updated: 29/09/2011 10:52:40

Further Information on End Dates
As advised on Latest News in advance of the May 2011 Census, OFQUAL now “Regulate” (rather than “Accredit”) qualifications; and End Dates are used only when Awarding Body advise. For Autumn 2011 Census, we are retaining current QWS End Date fields, as we did for Summer 2011 Census. These dates should be used as they have been in the past. Changes in the nature of Date fields will not make a difference to the QANs selected for the Autumn Census but, as advised in Post 16 Guidance, a check of QANs that are nearing their expiry date is advisable (e.g. to check for a successor qualification).

Given time available, and future changes in the way Post 16 data will be collected, it was decided that any development work to update QWS would be planned for after the Autumn Census.

To confirm, fields are as follows:

Accreditation Start Date: Now the Regulation Start Date (i.e. date from which the QAN was notified to OFQUAL). Same date as Accreditation Start Date.
Accreditation End Date: Now the Review Date (i.e. date from which Awarding Bodies should extend the qualification; or provide End Dates).
Certification Date*: Same meaning as previously – but may appear as 31/12/2050 if the Awarding Body has not provided End Dates.
Approval Start Date: This date will either be the Operational Start Date; or the date a qualification was loaded onto the Register.
Approval End Date*: Still the critical date to consider for funding purposes. Will be the Operational End Date where Awarding Body has provided one.

*NB: After DfE Section 96 database update, fields holding 31/12/2099 will be blank on S96. QWS will continue to use dummy dates (31/12/2050) until development work is carried out to allow a blank value. Some End Date fields will continue to hold original End Dates for Autumn Census.


Last Updated: 14/09/2011 13:36:41

QWS address change
This message is to provide notification that the address for the QWS site has changed. The old address will continue to work for the time being, but the new address is as follows:

https://collectdata.education.gov.uk/qwsweb/default.aspx


Last Updated: 27/04/2011 09:51:15

Further Information on End Dates
On 16 February we notified, via Latest News, that we were investigating how QWS would work in response to changes to the use of Qualification End Dates. The change means that OFQUAL now Regulate (rather than Accredit) qualifications; and End Dates are only used only on Awarding Body advice. For Summer Census, we are retaining current QWS End Date fields. They should be used as they have been in the past. Changes in the nature of Date fields will not make a difference to the QANs selected for Summer Census, but a check of QANs that are nearing their expiry date is advisable (e.g. to check for a successor qualification). Fields are as follows:

Accreditation Start Date: Now the Regulation Start Date (i.e. date from which the QAN was notified to OFQUAL). Same date as Accreditation Start Date.
Accreditation End Date: Now the Review Date (i.e. date from which Awarding Bodies should extend the qualification; or provide End Dates).
Certification Date*: Same meaning as previously – but may appear as 31/12/2050 if the Awarding Body has not provided End Dates.
Approval Start Date: This date will either be the Operational Start Date; or the date a qualification was loaded onto the Register.
Approval End Date*: Still the critical date to consider for funding purposes. Will be the Operational End Date where Awarding Body has provided one.

*NB: After DfE Section 96 database update, fields holding 31/12/2099 will be blank on S96. QWS will continue to use dummy dates (31/12/2050) until development work is carried out to allow a blank value. Some End Date fields will continue to hold original End Dates for Summer Census.


Last Updated: 20/04/2011 13:47:53

Discount Code amendments
With apologies, in response to a query received, the Discount Codes for two QANs have been amended on QWS. We make every effort to minimise changes of this nature, and fully apologise for any extra work this may cause. However, it was felt that in this instance, these changes would increase the quality of coding, and were a reasonable period of time in advance of Census.

QANs 50022684 and 50023275 (Edexcel PE) were coded MA2, but now have the Discount Code 7210.


Last Updated: 15/04/2011 11:14:06

Discount Code Changes
With many apologies, it has been necessary to amend some Discount Codes in advance of the Summer Census. We continue to look at how we can improve Discount coding overall, but these specific changes were thought necessary due to queries raised with us. Some changes are as a result of source code changes. We appreciate changes of this nature cause great inconvenience, but will help to make matching more accurate and effective in the long term. QAN references are as follows: 50023408; 50023512; 50026732; 50026549; 5004560X; 10008500; 50024619; 50024723; 50024747; 50027591; 50030814; 1005554X; 10055538; 50022313; 50048685; 50021904.

Last Updated: 25/02/2011 07:52:36

Amendment to Default Dates
On 16 February we notified you that due to implications arising from a European directive, we would need to use default dates where End Dates had not yet been provided. The default date used will now be 31/12/2050 rather than 31/12/2099, as the original date caused problems for some users of QWS. We apologise for any inconvenience caused - and changes to dates should be completed early on 18 February.

Last Updated: 17/02/2011 15:42:40

Notification of removal of QANs
We apologise for any inconvenience this may cause you, but it has been necessary to withdraw six QANs from QWS. This is because they will not attract public funding, since they are employer based qualifications. These QANs were added to QWS in November/December 2010 as part of a general update. Due to the their nature it is most likely that this change will not affect schools - but for information the references are as follows: 50103064; 50103088; 5010309X; 50122939; 50122940; 50111486.

Last Updated: 17/02/2011 11:53:42

End Dates
New qualifications (and updates to existing qualifications) continue to be loaded onto QWS as soon as possible after they are notified to us. Following an examination of the implications of a European Directive, the use of End Date fields is under review. Certification End Dates can now not be presented until notification is received from Awarding Bodies. Where an Awarding Body has not yet provided End Dates for new qualifications, a default date of 31/12/2099 has been placed in the Certification End Date field. How QWS will present End Dates in the future is currently being considered. For the time being, please continue to use the Approval End Date field as the indication that a qualification is nearing its expiry date (although only qualifications added or amended from February 2011 onwards are affected at time of writing). Further information on the use of End Dates will be provided as soon as possible.



Last Updated: 16/02/2011 13:32:53

Three Discount Code Changes
Following a query received by DfE, and subsequent analysis, it has been necessary to amend three QAN/Discount Code combinations. We very much apologise for the inconvenience this change may cause, but this action was necessary and will improve the effectiveness of the database.

The following QANs have had their Discount Codes amended to:

QAN 10055629 now has a Discount Code of 1320
QAN 10055630 now has a Discount Code of 0028
QAN 10055617 now has a Discount Code of 1310

Last Updated: 11/02/2011 07:37:57

Discount Code Correction - QAN 50015898
With many apologies, it has been necessary to correct a Discount Code. The QAN concerned (50015898) is a Multiple Pathway QAN, and it was identified that two pathways shared the same Discount Code. The Physical Theatre Discount Code has now been amended from LC11 to LCDO. All other pathways have their original codes. We are very sorry for any inconvenience this change may cause.

Last Updated: 26/01/2011 13:38:53

QAN 50045362: Converted to a Multiple Pathway QAN
QAN 50045362 has been converted into a QAN with multiple pathways. We are very sorry that this correction was necessary. This will allow distinct QAN/Discount Code combinations to be used.

Last Updated: 25/01/2011 11:40:33

QAN made into a Multiple
15/10/2010: QAN 50018097 has been made into a multiple QAN. This change will not affect those who have already downloaded data. This change was made in response to a query received. We apologise for the change – but this should not impact on other users.

Last Updated: 15/10/2010 16:21:20

XML FILES SAFE TO USE
14/10/2010: XML files have been checked and they are safe to use. This includes both the zipped and individual files. We are sorry for any delay this checking has caused you - but wanted to ensure any potential issue was notified and corrected as soon as possible. No technical issues with the files were identified - so schools which have already downloaded their data do not need to repeat the process.

Last Updated: 14/10/2010 10:50:54

IMPORTANT FURTHER UPDATE: XML FILES
13/10/2010: A technical problem is causing the XML files generated by the QWS web site to be truncated. The following advice updates the message previously posted about zipped XML files, since the truncation now appears to affect individual files also. As a result of this issue, the most recently added QANs are missing from the XML files. If you have already downloaded QWS files and allocated Learning Aims to students, this problem will not affect you and there is no need to alter your School Census return. Schools currently seeking to download the most recent list of Learning Aims are advised to use the CSV files until further notice. This issue will be resolved as soon as possible, but we apologise again for the inconvenience this may cause you.

Last Updated: 13/10/2010 17:08:18

Potential problem concerning QWS Zipped XML Files
We are currently investigating a potential problem with the zipped version of the XML Current QAN. We are advising use of the individual XML files, rather than the zipped versions, until further notice. With apologies for inconvenience caused.



Last Updated: 13/10/2010 16:21:44

Headline: QAN added to QWS
11 October 2010: QAN 50056530 has been added to the QWS database (Cambridge International Level 1/Level 2 Certificate in English as a Second Language). We apologise for the need for this addition, but it was necessary to assist those who need to select this QAN.

Last Updated: 11/10/2010 11:40:30

Young Applicants in Schools Scheme Higher Level Modules
8 October 2010: With many apologies for the amendment, the end dates on QANs for Young Applicants in Schools Scheme Higher Level Modules, have been extended on QWS. This will allow these units to be selected safely by those who need to - but should not affect those not selecting these units.

Last Updated: 08/10/2010 07:29:58

QAN: 50078884 ameded to a Multiple
This is to notify an amendment to a QAN on QWS. QAN 50078884 has been ameded to a `multiple pathway' QAN following a query received.

This change does not mean that those using the original structure need to make an amendment to their data, unless the new structure is more helpful.

We apologise for this change to QWS data.

Last Updated: 27/09/2010 12:50:56

QWS Certificate Change - 15 September 2010
On 15 September 2010, the security certificate for COLLECT will be changing from `DCSF' to `Education'. This change will mean that when accessing the QWS site, a message will appear saying that the certificate is no longer valid.

QWS users may continue to use the site as normal, but to avoid recieving the warning message, may wish to amend the QWS address they use from `DCSF' to `Education'.

QWS should not be unavailable while this change takes place, but may be a little temperamental between 8am and 12pm.

We apologise for any inconveniance this may cause.

Last Updated: 14/09/2010 10:59:25

Advice concerning IGCSE and Qualification Catalogue
New IGCSE qualifications have been received - and added to QWS. It was necessary to create a new Qualification Type for these qualifications (OGO). It may be beneficial to ensure the most up to date Qualification Catalogue is used (i.e. download the latest). This advice is dependent on how individual software systems operate.

Last Updated: 25/06/2010 16:50:51

Changes to QWS w/c 7 June 2010
11/06/2010: With many apologies, we have this afternoon received a similar query to that shown below for 09/07/2010. Again, we felt this change was necessary to make. Therefore, QAN 10053797 is now a `multiple'.

09/07/2010: As a result of a query received this afternoon, we have had to amend a qualification on QWS. We very much appreciate that this is change is within the Census collection period, but felt that amendment in this case was unavoidable. Therefore, QAN 50015898 is now a `multiple' qualification. We apologise that this late change was necessary.

Last Updated: 11/06/2010 15:55:02

Further changes to QANs on QWS - w/c 24 May 2010
28.5.2010: As stated in previous Latest News messages, as a result of queries received, an investigation was carried out to see why some QANs had not been correctly extended. The outcome was that there were a set of QANs that had not updated correctly - which have now been identified and corrected. With many apologies for inconvenience caused.

26.5.10: A QAN has had its Approval and Certification End Dates extended, as a result of a query received. As stated below, an investigation is underway to assess why, in a small number of cases, QANs have not been updated.

Details of this QAN are:

QAN 10058229 (1st 4 Sport Level 3 Certificate in Coaching). Approval End Date now 31/12/2010; Certification End Date now 31/12/1013.

25.5.10: Three QANs have had their Approval End Date and Certification End Date extended on QWS. With apologies, these changes were made following analyses as a result of queries received. A further investigation to see why this was necessary has begun. Details are as follows:

QAN 10029473 (City & Guilds Level 2 NVQ in Sport, Recreation and Allied Occupations: Activity Leadership). Approval End Date now 31/12/2010; Certification End Date now 31/12/2012.

QAN 10029333 (City & Guilds Level 2 NVQ in Sport, Recreation and Allied Occupations: Operational Services). Approval End Date now 31/12/2010; Certification End Date now 31/12/2012.

QAN 10064515 (AQA Level 1/Level 2 GCSE in Use of Mathematics (Pilot)). Approval End Date now 31/08/2010; Certification End Date now 31/08/2011.

Last Updated: 28/05/2010 11:57:31

Amended Discount Codes for four QANs
With apologies, this news item advises of changes to the Discount Codes for four QANs. As previously advised, changes to Discount Codes are being kept to an absolute minimum, but these amendments are as a result of investigations in response to a query received:

50022271 AQA Level 3 Advanced Subsidiary GCE in History of Art: Changed from 3820 to 3830
50022246 AQA Level 3 Advanced GCE in History of Art: Changed from 3820 to 3830

50022532 AQA Level 3 Advanced Subsidiary GCE in Design and Technology: Product Design (Textiles): Changed from 9080 to 9050
50022416 AQA Level 3 Advanced GCE in Design and Technology: Product Design (Textiles): Changed from 9080 to 9050

Last Updated: 24/05/2010 14:44:25

School Census Summer 2010
QWS was updated with the latest information on QANs on 14 May 2010. Any subsequent changes that need to be made to existing QANs on QWS before the Census window closes will be flagged on QWS latest news.

Please note that QWS contains some expired QANs. Users are advised to either check the Approval End Date on QWS for the QAN they are using or to consult the section 96 database (http://www.dcsf.gov.uk/section96/).

Last Updated: 18/05/2010 16:34:32

The new QWS News Facility is LIVE!
Welcome to the new QWS News Facility. Catch all the latest news here!

Last Updated: 18/05/2010 09:51:32