4
4 - Electronic Data Interchange (EDI)
4 - Electronic Data Interchange (EDI)
4
4
Electronic Data Interchange (EDI)
1
Introduction
53
1.1 Edexcel EDI
53
1.2 The Edexcel EDI teams
53
1.3 Terminology used in this document
53
EDI developments
54
2.1 DIDA qualifications and GCE in Applied Subjects
54
2.2 JCQ format support for Edexcel GNVQ and Skills for Life
54
2.3 BTEC
54
2
3
4
5 6
52
2.4 Results in CSV format
54
Electronic Data Interchange — JCQ format
55
3.1 Support
55
3.2 Basedata
55
3.3 Board codes
55
3.4 Series codes
55
3.5 Formats version
55
3.6 Software version
56
3.7 Sending the data
56
3.8 Submission of other data types
56
3.9 File receipt and acknowledgements processing
56
3.10 Release of results via EDI
56
Electronic data interchange — EDIFACT
57
4.1 Support
57
4.2 Basedata
57
4.3 Board codes
57
4.4 Series codes
57
4.5 Formats version
57
4.6 Software version
58
4.7 File naming conventions
58
4.8 Sending the data
58
4.9 File receipt and acknowledgements processing
58
Frequently asked questions
58
5.1 Common problems
58
EDI application form
60
Edexcel Information Manual 2007—2008: September 2007
4 - Electronic Data Interchange (EDI)
4
Electronic Data Interchange (EDI)
1
Introduction
1.1
Edexcel EDI
4
The following notes give some guidance on using EDI. Specific queries concerning the software or the centre management information system (centre MIS) that you are using to generate files should be directed to your centre MIS supplier or internal helpdesk. Edexcel is unable to offer support on non-Edexcel products. Note: All Edexcel EDI centres should be aware of the EDI tracking facility at Edexcel Online. Please contact us on 0870 240 9819 if you do not have Edexcel Online set up at your centre. If you have particular concerns regarding the confidentiality of any candidate undertaking Edexcel examinations at your centre, please contact us prior to the entry date. Be aware that the details of all candidates entered with Edexcel are maintained securely and confidentially according to the requirements of the Data Protection Act.
1.2
The Edexcel EDI teams
The Edexcel BTEC RACS and Entries and Certification teams have dedicated EDI staff. All enquiries must be directed to: www.edexcel.org.uk/ask . Edexcel cannot advise on the use of any centre MIS or EDI VAN application. All systems queries must go in the first instance to the relevant provider. Notices are placed on the EDI section of the website regarding results and basedata releases.
1.3
Terminology used in this document
JCQ
Joint Council for Qualifications (www.jcq.org.uk)
JCQ format
Used by Edexcel for GCE/GCSE/GNVQ/Skills for Life/ BTEC/DIDA/GCE in Applied Subjects/ELC and ESOL
EDIFACT
The Edexcel EDI format, currently used for GNVQ/BTEC/NVQ, Skills for Life and ESOL
Trading partner
An individual or organisation that wishes to transmit data electronically (an Edexcel centre)
EDI
Electronic data interchange: the exchange of electronic data between trading partners
Message
A term to describe an electronic file containing a specific type of computerised data (eg, entries, registrations, basedata, etc.)
Centre MIS
Centre management information system: a computerised information system that is capable of generating and uploading EDI messages
ISP
Internet service provider: an organisation that provides connectivity to the internet (including email accounts, search facilities, etc.)
VAN provider
Value added network provider: a third party, responsible for the secure transmission of electronic data from one trading partner to another (AVCO, webXchange and RM)
Centre identifier
A five- or six-digit centre number allocated to all approved examination centres
Edexcel Information Manual 2007—2008: September 2007
53
4 - Electronic Data Interchange (EDI)
Internet email
4
Electronic mail that enables messages to be sent over the internet
2
EDI developments
2.1
DIDA qualifications and GCE in Applied Subjects
These Edexcel qualifications remain available for administration via the latest version (only) of the JCQ EDI format. Basedata will be made available at www.edexcel.org.uk/basedata . Note: These qualifications require that a registration (board code 13) is made before test or portfolio entries. If no registration is submitted, candidates will be auto-registered.
2.2
JCQ format support for Edexcel GNVQ and Skills for Life
We are pleased to be able to continue to offer all EDI centres the opportunity to make GNVQ and Key Skills registrations and entries in the familiar JCQ format (as used for GCE and GCSE).
2.3
BTEC
Please see the BTEC section of this manual for further details. If your centre’s software package does not support the EDIFACT formats, you may use the JCQ formats to register learners for BTEC qualifications. JCQ formats do not support individual unit or NVQ programme registrations. The JCQ format is only suitable for registration of candidates on programmes that follow the academic year (ie, enrolment in September and completion in June). As the format does not allow for a planned completion date, we will enter a default completion date based on the normal duration of the programme. If the default date that we use is incorrect, you will have an opportunity to correct this when we send you the registration listing as confirmation that the registration has been processed. Amendment files — following the initial registration of candidates, you can send an amendment file to amend a learner’s personal details or to transfer the learner to another qualification or to add an additional registration. BTEC results provision in summer 2008 Centres should send a registration entry file by the registration deadline of 1 November 2007. In order to obtain results via EDI for students completing courses in 2008, centres should make an entry for the summer session by 30 April 2008. Please see the BTEC section of this manual for further details. BTEC EDIFACT and JCQ basedata BTEC EDI basedata is available through Edexcel Online. For further details, see part 12 of the BTEC section of this manual. BTEC EDIFACT results files Currently, we only issue results files to those centres which have reported results to us by EDI. We are developing a facility, through Edexcel Online, which will allow all centres to download results files. We will contact all EDIFACT centres when this facility is available. Please see the BTEC section of this manual for further details.
2.4
Results in CSV format
GVQ results are no longer issued in this format. All centres that wish to receive EDI results for GVQ must make entries via EDI, using either the JCQ or EDIFACT formats.
54
Edexcel Information Manual 2007—2008: September 2007
4 - Electronic Data Interchange (EDI)
3
Electronic Data Interchange — JCQ format
3.1
Support
JCQ format-supported programmes with Edexcel are:
GCE (including AEA) GCE in Applied Subjects GCSE (including GCSE awards in vocational subjects) GNVQ ELC(A) Skills for Life BTEC (see part 2.3) DIDA ESOL
4
Details of the JCQ EDI formats can be obtained by downloading ‘Formats for the Exchange of Examination Related Data’ from www.jcq.org.uk . The JCQ formats booklet is usually only required by centres which use their own in-house centre MIS to generate EDI files. Centres using software supplied by a specific centre MIS provider (such as Pearson Phoenix or SIMS) should contact the provider directly to ensure that the latest formats are supported. Edexcel issues basedata and results in the latest JCQ format only — centres are advised to ensure that their MIS is compliant with the latest format.
3.2
Basedata
JCQ basedata (except BTEC) files are available to download from www.edexcel.org.uk/basedata from September 2006. To request JCQ BTEC basedata, see part 2.3 of this section. For EDIFACT basedata, please see part 4 of this section. Basedata disks have not been available since September 2002.
3.3
Board codes
The correct board codes are clearly marked on the Edexcel basedata webpages at www.edexcel.org.uk/edi .
3.4
Series codes
Please see the Edexcel website for series codes: www.edexcel.org.uk/edi . Important! Using incorrect series codes, board codes, year indicators or sending units and cash-in codes separately can cause serious disruption to your entries. Centres are reminded that amendment files should confirm all entries: failure to confirm all the subjects the candidate is taking can lead to late fees being incurred and queries about results being raised. Edexcel cannot be held responsible for changes to entries caused by incorrect data submitted via EDI.
3.5
Formats version
Edexcel will continue to support the data formats defined in the JCQ booklet Formats for the Exchange of Examination Related Data. To view this document, please go to www.jcq.org.uk .
Edexcel Information Manual 2007—2008: September 2007
55
4 - Electronic Data Interchange (EDI)
The supported revisions of this standard are:
September 2004 (version 10) September 2002 (black book)
Edexcel will only issue basedata and results in the latest format.
4
3.6
Software version
In most cases, centres should be using the latest version of their centre MIS. Contact your supplier for details and advice.
3.7
Sending the data
EDI files may be sent to Edexcel via the VAN providers or by email. VAN provider name
Contact telephone number
Internet address
webXchange
0845 2000 150
www.webxchange.co.uk
AVCO ExamService
01784 430 996
www.avcosystems.co.uk
RM SecureNet
0870 9086868 (sales)
www.rm.com
Emails should be addressed to @edidata.edexcel.org.uk , eg,
[email protected] .This is an automated email transfer system. Please do not include any text in the body of the mail (it will be ignored). Disks Disks will only be accepted in emergency and by prior arrangement with the relevant entries section. Contact us via the usual customer contact route to arrange this (see the Contact Information section of this manual). Any unauthorised disks will be returned unprocessed.
3.8
Submission of other data types
Coursework marks and estimated grades may be sent via EDI as an alternative to the use of paper optically mark-read (OMR) forms. Please note that, for DIDA and for ICT in GCE in Applied Subjects, coursework marks may be submitted via Edexcel Online only. For queries relating to the use of your centre MIS system to generate these files, please contact your provider directly. Please note that coursework marks can now be submitted via Edexcel Online. Visit www.edexcelonline.co.uk for details.
3.9
File receipt and acknowledgements processing
On receipt of an EDI file, Edexcel will automatically generate an email acknowledgement. An email is also generated to confirm that the file has been processed. If you wish to receive these acknowledgements, it is essential that you provide Edexcel with a valid internet email address. Contact us at www.edexcel.org.uk/ask to update your address. Alternatively, use the Edexcel Online EDI file tracking facility — visit www.edexcelonline.co.uk for details.
3.10 Release of results via EDI Results data is normally available for downloading at 00:01 hours on the day before the paper release date for those centres which use the services of a VAN provider (AVCO, webXchange and RM). At present, we are unable to release results via email before 09:00 hours on the day of paper release. Centres who wish results to be sent via email on this day should contact us at www.edexcel.org.uk/ask .
56
Edexcel Information Manual 2007—2008: September 2007
4 - Electronic Data Interchange (EDI)
Edexcel issues EDI results in the latest version of the JCQ formats. For further information, please visit the JCQ website (www.jcq.org.uk). All unit/module results are issued as Uniform Mark Scales (UMS). Grades will only be issued against linear results or cash-in codes (eg, 8371/9371). Unit/module UMS may be converted to notional grades by using the information on the reverse of the Candidate Statement of Results. It is the responsibility of centre MIS providers to ensure that centres can process UMS issued by the awarding bodies.
4
For further details of BTEC results issue, please see the BTEC section of this manual.
4
Electronic data interchange — EDIFACT
4.1
Support
EDIFACT format supported programmes with Edexcel are:
BTEC NVQ GNVQ Skills for Life ESOL
Details of the EDIFACT formats can be obtained by downloading ‘The Centre MIS Providers Manual’ from www.edexcel.org.uk/edi . This EDIFACT formats publication is usually only required by centres which use their own in-house centre MIS to generate EDI files. Centres using software supplied by a specific centre MIS provider (such as Tribal Technology — see part 5.1 of this section) should contact the provider directly to ensure that the latest formats are supported.
4.2
Basedata
EDIFACT basedata for BTEC, NVQ, Skills for Life or GNVQ may be downloaded from Edexcel Online www.edexcelonline.org.uk .
4.3
Board codes
Board codes are not used in the EDIFACT format. Centre MIS suppliers will be able to issue instructions on how to proceed.
4.4
Series codes
As with board codes, these are not used in the EDIFACT format.
4.5
Formats version
Edexcel will continue to support all EDIFACT formats versions. However, the full range of functionality can only be obtained by users of the latest EDIFACT formats:
Registration and first test entry Registration listing (from Edexcel to centre) GNVQ test ordering Skills for Life test entry GNVQ and Skills for Life test outcomes (from Edexcel to centre) GNVQ and Skills for Life timetables (from Edexcel to centre) Awards confirmation (from Edexcel to centre) Portfolio grade reporting for internally assessed programmes (BTEC/NVQ, etc).
Edexcel Information Manual 2007—2008: September 2007
57
4 - Electronic Data Interchange (EDI)
4.6
Software version
All centres should be using the latest version of the centre MIS. Contact your supplier for details and advice.
4.7 4
File naming conventions
The correct EDI filenames must be used: Name
Size
Description
Centre identifier
5 or 6
Centre or sub-centre for a centre or for a sub-centre
Data format
1
Must be E — EDIFACT data format
Data type
2
Can be any of the following: CD Edexcel programmes basedata RA candidate results RD registration and entry data RN registration numbers acknowledgement ND NVQ/GNVQ qualifications basedata MA Modern Apprenticeship basedata GT timetable basedata TO test ordering RI request basedata TR test results acknowledgement RE candidate results acknowledgement
4.8
Sending the data
As with the JCQ format, the only acceptable transfer methods are VAN or email. See part 3.7 for details or contact us at www.edexcel.org.uk/ask . Disks Disks will only be accepted in an emergency and by prior arrangement with the relevant section. Contact us via the usual customer contact route to arrange this (see the Contact Information section of this manual). Any unauthorised disks will be returned unprocessed.
4.9
File receipt and acknowledgements processing
On receipt of an EDI file, Edexcel will automatically generate an email acknowledgement. An email is also generated to confirm that the file has been processed. If you wish to receive these acknowledgements, it is essential that you provide Edexcel with a valid internet email address. To update your address, contact us via www.edexcel.org.uk/ask . Alternatively, use the Edexcel Online EDI file tracking facility — visit www.edexcelonline.co.uk for details.
5
Frequently asked questions
5.1
Common problems
How do I start using EDI? Contact your centre MIS provider to verify which EDI facilities are available from your software. Choose a communication method and ensure you have the correct hardware and software in place.
58
Edexcel Information Manual 2007—2008: September 2007
4 - Electronic Data Interchange (EDI)
If a third party writes your centre MIS, and you are unsure which EDI facilities they offer, please contact them directly. Before calling your centre MIS provider, please ensure you have the name and version of your software available. The following list of centre MIS providers is provided for information purposes only. Centre MIS provider name
Contact telephone number
Internet address
Tribal
01482 647220
www.tribalgroup.co.uk
Civica Services
020 7760 2802
www.civica.co.uk
Distinction Systems
01792 524 524
www.distinction-systems.co.uk
Eclipse Learner Systems
01527 570888
www.elsl.co.uk
Capita Education Services
01234 838080 or 01285 647500
www.capitaes.co.uk
Pearson Phoenix
01722 344 800
www.pearsonphoenix.com
Capita F&HE
01285 647500
Hebron
01935 403000
www.hebron.co.uk
West Country Business Systems (WCBS)
01458 833344 (sales) 01458 833055 (helpdesk)
www.wcbs.co.uk
4
www.capitafhe.co.uk
How do I know that you have received my EDI file? When you send Edexcel an EDI file using an approved transmission method, you will automatically receive an email acknowledgement indicating that Edexcel has received the file. A further acknowledgement will be generated when the file has been processed. Alternatively, use the Edexcel Online EDI file tracking facility — visit www.edexcelonline.co.uk for details. I sent my GCE/GCSE entries via Edexcel Online. Can I still receive my results by EDI? Yes, as long as you have a VAN provider. Please check with your centre MIS provider that your software is able to upload the results file. Can I send a disk of data? No. We are unable to support disk submissions. You will need to review the alternative transfer methods that are now available. Incorrect format Files submitted in an incorrect format will be deleted and the relevant entries section will contact you. Multiple entry/amendment files Only one entry file should be sent for each qualification (GCE, GCSE, GNVQ, etc). All subsequent additional information or changes to data, including late entries, should be sent as amendments. Edexcel is able to process multiple entry files sent by centres, but this may result in the unnecessary reprinting of statements of entry for candidates whose details have not changed. Edexcel recommends that centres send fewer amendment files containing larger batches of amendments, rather than multiple files containing very small numbers of amendments. If centres
Edexcel Information Manual 2007—2008: September 2007
59
4 - Electronic Data Interchange (EDI)
do send a large number of amendment files, it is vital that they are sent in the correct sequence. Edexcel processes EDI files in amendment file order. If there are any problems, the relevant entries team will seek a solution and advise you as soon as possible.
4
Duplicate files and files for past examination series Edexcel will automatically delete as duplicates any files received which have identical sequence numbers and preparation dates to files already received and processed. Files sent coded for examination series for which the entry/amendment period has elapsed will not normally be processed. Entry and amendment files will not generally be processed if they are received more than 10 working days after the last written exam of an examination series, unless specifically requested by a centre. This is to avoid the erroneous withdrawal of entries. Use of printouts If you are experiencing problems with EDI, please contact Edexcel for assistance. Please do not send disks or printouts without contacting the relevant entries team. The submission of printouts without prior agreement is not permitted and may result in late fees being incurred. Erroneous entries As EDI is a bulk-processing medium, it is highly advisable that you check all entry confirmation documentation. Queries are commonly received about the non-receipt of entry files, one candidate entry opposed to full centre entries, mass entry subtraction and duplicate entries on files with different option codes.
6
EDI application form
Please submit the details requested below (cut and paste as necessary) by contacting us via www.edexcel.org.uk/ask .
centre number centre management information system (centre MIS) centre MIS version (if known) name* job title email address.
The formats we use to submit EDI files are (JCQ/EDIFACT). We submit our EDI files via (AVCO ExamService/webXchange/RM SecureNet/Edexcel Online/Email). * By submitting this information, responsibility for all EDI output from the centre is accepted.
60
Edexcel Information Manual 2007—2008: September 2007