Home

QWS Data User Manual - Department for Education

1. content simple roperties on nillable false minLength 1 race maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs string gt xs whiteSpace value preserve gt xs minLength value 1 gt xs maxLength value 255 gt lt xs restriction gt lt xs simpleType gt lt xs element gt element Header diagram E aFileContent Header Version A DateTime content complex children source lt xs element name Header lt xs complexType gt lt xs sequence gt xs element ref FileContent gt lt xs element ref Version gt lt xs element ref DateTime gt lt xs sequence gt lt xs complexType gt xs element element LastUpdated diagram FLastUpdated ne content simple nillable false used by element Qualification source lt xs element name LastUpdated type xs date nillable false properties element JE diagram ape restriction of xs restriction ofxssstring 000 Reference QWS_Data_User_Manual_V1 0 rtf 17 17 department for education and skills content simple roperties nillable false element Qualification length 4 a whiteSpace collapse enumeration LDCS enumeration LEAP enumeration Idcs source xs element name Map nillable false gt lt xs simpleType gt xs restriction base xs string gt xs length value
2. lt xs simpleType gt lt xs element gt element Map ID diagram Liege content simple roperties labe falso element MapData xs element name Map ID type xs integer nillable false element MapData diagram MapDescription EffectiveFrom gt LastUpdated content complex MapDescription EffectiveFrom EffectiveTo LastUpdated element I documentation annotation source lt xs element name MapData lt 5 2 annoctac Lon lt xs documentation gt Map Data lt xs documentation gt xs annotation xs complexType lt xs sequence gt MapData Map Data Reference QWS Data User Manual V1 0 rtf 58 58 department for education and skills ae xs element ref Map ID xs element ref Map gt xs element ref MapDescription xs element ref EffectiveFrom dxs element refs rffectiveTor j gt lt xs element ref LastUpdated gt lt xs sequence gt lt xs complexType gt lt xs element gt element MapDescription diagram MapDescription restriction of xs string content simple t element MapData minLength 1 ideis maxLength 40 whiteSpace preserve enumeration LearnDirect Classification System Coding enumeration SCAAT General Qualifications Coding enumeration Temporary LDCS Coding source lt xs element name MapDescription nillable false lt xs simpleType gt XS annotat Lon gt lt xs documentation g
3. Notes Pattern gt 1 Numeric NUM Any number including decimal places _CCYY MM DD en DATE CCYY MM DD TIME MM 2 2 Data Patterns Standard XML pattern notation will be used to describe patterns applicable to particular data items Some commonly used notations are Notation Example Any number or any uppercase letter or an asterisk Quantifier Zero or more Zero or more uppercase or lowercase letters Quantifier One or more A Za z One or more uppercase or lowercase letters Quantifier One or none One or no uppercase letter AB CD Either AB or CD 0 9 4 A Z 4 Either four numbers or four uppercase letters Note An escape character instructs the XML processor to take the next character literally Reference QWS Data User Manual V1 0 rtf 6 6 department for education and skills An example of the use of a pattern is for the QAN The pattern for a QAN is O 9A Z 0 91 6 0 9A Za z This indicates that a QAN a must start with either a number an uppercase letter or a hash character a b must then have six numbers and C must end with a number or letter 2 3 Data Enumerations Some data items have a restricted list of allowable values These are termed enumerations Enumerations are listed in the appropriate schema file 2 4 Date Fields All dates within QWS are in ISO date format i e CCYY MM DD Some database systems and some
4. Reference QWS_Data_User_Manual_V1 0 rtf 30 30 department for education and skills element EffectiveFrom diagram type content simple nillable false element QualificationType source lt xs element name EffectiveFrom type xs date nillable false gt element EffectiveTo diagram type content simple roperties nillable false QualificationType xesclement nmamee Erfectlvelo type xs date nillavles false gt element FileContent diagram FileContent restriction of xs string content simple roperties U minLength 1 men maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs string gt xs whiteSpace value preserve gt xs minLength value 1 gt xs maxLength value 255 gt lt xs restriction gt lt xs simpleType gt lt xs element gt element Header diagram FileContent Header Version A DateTime content complex source lt xs element name Header gt lt xs complexType gt lt xs sequence gt lt xs element ref FileContent gt lt xs element ref Version gt lt xs element ref DateTime gt lt xs sequence gt Reference QWS_Data_User_Manual_V1 0 rtf 31 31 department for education and skills lt xs complexType gt xs element element LastUpdated diagram Lastipdated content simple
5. xs pattern value 0 9 1 2 gt lt xs enumeration value 1 gt lt xs enumeration value 2 gt lt xs enumeration value 3 gt lt xs enumeration value 4 xs enumeration value 5 gt lt xs enumeration value 6 gt xs enumeration value 7 gt lt xs enumeration value 8 lt xs enumeration value 9 gt lt xs enumeration value 10 gt xs enumeration value 11 gt lt xs enumeration value 12 gt Reference QWS Data User Manual V1 0 rtf 22 22 department for education and skills lt xs enumeration value 13 xs enumeration value 14 gt lt xs enumeration value 15 gt lt xs enumeration value 0 gt lt i xa restriction lt xs simpleType gt lt xs element gt element SSFT2 an type restriction of xs string content simple roperties I nillable false element Qualification minLength 3 ES maxLength 4 whiteSpace collapse pattern O 9 1 2 0 9 1 2 source xs element name SSFT2 nillable false lt xs simpleType gt xs restriction base xs string xs minLength value 3 gt xs maxLength value 4 xs whiteSpace value collapse gt xs pattern value O 9 1 2 N 0 9 1 2 Jxsirestriotion lt xs simpleType gt lt xs element gt element Version Version restriction of xs string content simple roperties pattern 0 9 1 2 L 0 9 0 9a 2 0 2 source xs element name Version nillable
6. AB Acronym upon 05 Effectiverrom Jo 06 EfedveTo DATE 07 tastUpdated DATE Heference QWS Data User Manual V1 0 rtf 8 8 department for education and skills 3 1 3 Qualification Type NEN QualType ID MH 0 9A Z 1 3 NEN 03 QualificationDescription VARCHAR 75 fo E 123 0 9 E 0 9 ss 05 DiscountFamiy VARCHAR 06 QuaCode VARCHAR ban L 07 EfedweFrom DATE o 08 EfedweTo DATE 09 LastUpdated Ing 3 1 4 Discount Code Feld Tpe X jPatem Enum DiscCode ID INT 0 9 4 A Z 2 0 9A Za z 0 2 03 DiscCodeDescripion VARCHAR 60 A 0 9 1 2 0 9 1 2 NEN 05 SSFT JVARCHAR 2 j 09412 CT 06 Map J CHAR IL 07 EffectiveFrom DATE IL 08 EffectiveTO DATE 09 LastUpdated DATE f A 3 1 5 Sector Subject Framework Tier 2 Fed Type X Pattern Enum 01 SSFT2 ID INT O 02 SSFT2 VARCHAR 4 0 9 t 2M 0 9 1 2 0 VARCHAR 55 05 SSFT1Description VARCHAR 50 06 EffectiveFrom DATE J gt o 0 O 07 EffectiveTo ID 08 LastUpdated DATE 3 1 6 Sector Subject Framework Tier 1 Field Typpe X Patem
7. false gt lt xs simpleType gt lt xs restriction base xs string gt xs pattern value 0 9 1 2 0 9 0 9a z 0 2 gt lt xs restriction gt lt xs simpleType gt lt xs element gt Reference QWS_Data_User_Manual_V1 0 rtf 23 23 4 2 QAN AB V1 0 xsd Figure 2 QAN AB V1 0 Message Structure FileContent n Version DateTime WI Message DwardingBodylata Awardingiody department for education and skills AwardingBodyHame A 1 00 Awarding Body Data aEffectiveFrom zFffectiveTo 5 LastUpdated Generated by XmlSpy www altova com Elements AR AB Acronym AB ID AwardingBody Message AwardingBodyData element AB ndi type restriction of xs string content simple roperties nillable false element AwardingBody length 3 a whiteSpace collapse pattern O 9Z 0 9 2 source xs element name AB nillable false gt lt xs simpleType gt xs restriction base xs string xs length value 3 gt xs whiteSpace value collapse xs pattern value 0 9Z 0 9 2 lt xs restriction gt lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 24 24 department for education and skills element AB_Acronym diagram AB Acronym type restriction of xs string content simple roperties nillable false element AwardingBod minLength 1 sour
8. nillable false QualificationType xs element name LastUpdated type xs date abildblschrs sus element Message diagram Message a Qualification TypeData content complex QualificationTypeData source lt xs element name Message gt lt xs complexType gt lt xs sequence gt lt xs element ref Header gt lt xs element ref QualificationTypeData gt lt xs sequence gt lt xs complexType gt lt xs element gt element NQF restriction of xs string content simple nillable false QualificationType minLength 1 EE maxLength 8 whiteSpace collapse pattern E 123 0 9 GE 0 9 properties source xs element name NQF nillable false lt xs simpleType gt xs restriction base xs string gt xs minLength value 1 gt lt xs maxLength value 8 gt xs whiteSpace value collapse gt xs pattern value E 123 0 9 E 0 9 lt xs restriction gt lt xs simpleType gt lt xs element gt element QualCode diagram Quallode restriction of xs string content simple nillable false QualificationType minLengih 1 Reference QWS Data User Manual V1 0 rtf 32 32 department for education and skills maxLength 3 whiteSpace collapse pattern 0 9 1 3 source lt xs element name QualCode nillable false lt xs simpleType gt lt xs restriction base xs string gt xs minLength value 1 gt lt xs maxLength value 3 gt xs w
9. xs element gt Reference QWS Data User Manual V1 0 rtf 64 64 department for education and skills 5 Text Files In addition to the XML data files the data are also provided in a series of comma separated value CSV files These files have no associated schema files Users should refer to the appropriate XML schema files for field validation information Note The CSV files should not be opened or processed using a spreadsheet program as they will not treat code values containing zeros correctly the files should either be opened in a dedicated text editor or imported into a database The following sections provide field order information for each of the CSV data files Section Data CSV Data Filename mm 5 1 QAN Main V1 1 csv Field FieldName pe QAN ID CHAR 4 06 DiscGode VARCHAR 08 QualShoriTitle VARCHAR S 09 AcoStanDate DIE Heference QWS Data User Manual V1 0 rtf 65 65 5 2 QAN AB V1 0 csv 0t AB ID 02 AB CHAR 3 VARCHAR 130 VARCHAR 20 05 EffectiveFrom DATE EffectiveTo DATE LastUpdated DATE 5 3 QAN QualType V1 0 csv Field FieldName Type VARCHAR 8 DiscountFamily 06 QualCode 1 VARCHAR 3 08 EfectiveTo DATE 09 LastUpdated DATE 5 4 QAN DiscCode V1 1 csv Field FieldName Type VARCHAR 4 VARCHAR 2 06 Maop CS CHAR 4 08 EffectiveTo DATE 09 LastUpdated DAT
10. xs string lt xs whiteSpace value collapse gt lt xs length value 8 gt xs pattern value O 9A Z 0 9 6 0 9A Za z gt e xsiresLtrioction lt xs simpleType gt lt xs element gt element QAN_ID Ei Me sine ooo content simple roperties U nillable false element Qualification source xs element name QAN ID type xs integer nillable false Reference QWS Data User Manual V1 0 rtf 19 19 department for education and skills element Qualification diagram gt QualType il D Je d i I i H DiscCode u QualificationTitle Ill E E L I ech m AccStartDate n Qualification E Me AccEndDate CertEndDate App5tartDate A u IH WI AppEndDate S5FT2 Ilj S5FT1 Ilj i i EffectiveFrom EffectiveTo ll ll LastUpdated properties ow used by source xs element name Qualification xs complexType lt xs sequence gt lt xs element ref QAN_ID gt Si ent ref 0AN gt s ent ref AB gt lt xs ent ref QualType gt SKS nent ref Map uS nent ref DiscCode xe t ref QualificationTitle gt xS t ref QualShortTitle aa ref AccStartDate 252 ref AccEndDate gt lt xs ref CertEndDate gt sa ref AppStartDate gt lt xs t ref AppEndDate xe E ref SSFT2 l 0 D a o0 000000000000 Heference Q
11. xs string lt xs whiteSpace value preserve gt lt xs minLength value 1 gt lt xs maxLength value 255 gt lt xs restriction gt lt xs simpleType gt lt xs element gt element Header diagram afileContent a Version DateTime content complex source xs element name Header lt xs complexType gt lt xs sequence gt xs element ref FileContent gt lt xs element ref Version gt lt xs element ref DateTime gt lt xs sequence gt lt xs complexType gt xs element element LastUpdated diagram Lastipdated content simple roperties nillable false Reference QWS Data User Manual V1 0 rtf 44 44 department for education and skills SectorSubjectTier2 lt xs element name LastUpdated type xs date nillable false gt element Message diagram Message asectorSubjectTier20Data content complex SectorSubjectTier2Data source lt xs element name Message gt lt xs complexType gt lt xs sequence gt lt xs element ref Header gt xs element ref SectorSubjectTier2Data lt xs sequence gt lt xs complexType gt lt xs element gt element SectorSubjectTier2 diagram 55FT2 ID SSFT2 SSFT20escription SSFT41 SectorSubjectTier2 EI Ge Sector Subject Framework SSFTI Description Tier 2 Base Data EffectiveFrom f EffectiueTo LastUpdated content complex SSFT2 ID SSFT2 SSFT2Description SSFT1 SSFT1Description Effec
12. 01 0 9 0123 0 9 fxstrostrloction xs simpleType xs element element AppEndDate diagram AppEndDate type restriction of xs date content simple roperties I nillable false used by element Qualification pattern 12 90 0 9 2 01 0 9 0123 0 9 source lt xs element name AppEndDate nillable false gt lt xs simpleType gt xs restriction base xs date gt xs pattern value 12 90 0 9 2 01 0 9 0123 0 9 asir estriction lt xs simpleType gt lt xs element gt element AppStartDate diagram App5tartDate type restriction of xs date content simple roperties nillable false element Qualification pattern 12 90 0 9 2 01 0 9 0123 0 9 source lt xs element name AppStartDate nillable false gt lt xs simpleType gt lt xs restriction base xs date gt xs p ttern valu s 12 90 0 9 2 01 0 9 0123 0 9 f xs restriction lt xs simpleType gt lt xs element gt element CertEndDate diagram CertEndDate type restriction of xs date content simple roperties nillable false Heference QWS Data User Manual V1 0 rtf 15 15 department for education and skills element Qualification pattern 12 90 0 9 2 0 1 O 9 0123 0 9 source lt xs element name CertEndDate nillable false gt lt xs simpleType gt xs restriction base xs date gt lt xs patte
13. 4 gt xs whiteSpace value collapse gt xs enumeration value LDCS gt xs enumeration value LEAP xs enumeration value 1dcs gt xs restriction lt xs simpleType gt lt xs element gt element Message diagram Message a dualifications content complex Qualifications source lt xs element name Message gt lt xs complexType gt lt xs sequence gt lt xs element ref Header gt lt xs element ref Qualifications gt lt xs sequence gt lt xs complexType gt lt xs element gt element NQF type restriction of xs string content simple roperties nillable false element Qualification minLength 1 SR maxLength 8 whiteSpace collapse pattern E 123 0 9 E 0 9 source xs element name NQF nillable false lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt lt xs maxLength value 8 gt xs whiteSpace value collapse gt xs pattern value E 123 0 9 E 0 9 lt xs restriction gt lt xs simpleType gt lt xs element gt element QAN restriction of xs string content simple Reference QWS Data User Manual V1 0 rtf 18 18 department for education and skills J milable false used by element Qualification length 8 whiteSpace collapse pattern _ 0 9A Z 0 9 6 0 9A Za z source lt xs element name QAN nillable false gt lt xs simpleType gt xs restriction base
14. Body Data content complex children AwardingBod source lt xs element name AwardingBodyData gt lt xs complexType gt lt xs sequence gt xs element ref AwardingBody maxOccurs unbounded lt xs sequence gt lt xs complexType gt lt xs element gt element AwardingBodyName diagram AwardingBodyHame restriction of xs string content simple able fate element AwardingBody minLength 1 idees maxLength 130 whiteSpace preserve source lt xs element name AwardingBodyName nillable false gt lt xs simpleType gt xs restriction base xs string lt xs whiteSpace value preserve gt lt xs minLength value 1 gt lt xs maxLength value 130 gt lt xs restriction gt lt xs simpleType gt lt xs element gt element DateTime diagram I Date Time content simple roperties labo fees element Header xs element name DateTime type xs dateTime nillable false element EffectiveFrom diagram content simple roperties nillable false Heference QWS Data User Manual V1 0 rtf 26 26 department for education and skills element AwardingBod source lt xs element name EffectiveFrom type xs date nillable false element EffectiveTo diagram i content simple nillable false element AwardingBod source lt xs element name EffectiveTo type xs date nillable false element FileContent diagram F
15. QualificationTypePoints gt lt xs annotation gt Reference QWS_Data_User_Manual_V1 0 rtf 63 63 department for education and skills lt xs documentation gt Qualification Type Points Data lt xs documentation gt xs annotation xs complexType xs sequence lt xs element ref QualType ID xs element ref GradePoints maxOccurs unbounded lt xs sequence gt lt xs complexType gt xs element element QualType ID diagram QualType ID we xsamteger OOO content simple roperties i nillable false QualificationTypePoints lt xs element name QualType ID type xs integer nillable false element UCAS Plts diagram UCAS Pis type restriction of xs integer content simple roperties nillable false element GradePoints Pcie mininclusive 0 maxlnclusive 800 source lt xs element name UCAS Pts nillable false gt lt xs simpleType gt xs restriction base xs integer s minInclusiv valuss 0 rs xs maxlInolusive valuese g00 lt xs restriction gt lt xs simpleType gt xs element element Version Version restriction of xs string content simple roperties l pattern 0 9 1 2 L 0 9 0 9a 2 0 2 source lt xs element name Version nillable false gt lt xs simpleType gt lt xs restriction base xs string gt xs pattern value 0 9 1 2 0 9 0 9a z 0 2 gt lt xs restriction gt lt xs simpleType gt lt
16. Web Services available and the mechanisms for accessing them may be found on the QWS web site at http data dfes gov uk gwsweb Documentation aspx The following documents are available System Integration Guide http data dfes gov uK qwsweb XSDs QWS SI Guide v1 01 doc Public Web Services WSDL file http data dfes gov uk qws qwswebservice asmx WSDL Private Web Services WSDL file http data dfes gov uk qws qwswebserviceschool asmx WSDL 1 3 Web Site Downloads QAN data may be downloaded from the QWS web site at http data dfes gov uk gwsweb Main aspx 1 A Web Services Description Language WSDL file is an XML formatted file for describing Web services See http www w3 org 2002 ws desc Reference QWS Data User Manual V1 0 rtf 4 4 department for education and skills 1 4 Scope This document provides information on the data contained in the following data tables Current QAN Data Expired QAN Data Awarding Body Qualification Type Discount Code Sector Subject Framework Tier 2 Sector Subject Framework Tier 1 Discount Code Mapping Qualification Type Points This document does not provide any information on the School QAN list files which will be provided during the first year of QWS operation Reference QWS Data User Manual V1 0 rtf 5 5 department for education and skills 2 General 2 1 Data Types The following general data types are used to describe data items Data Type gt Notation
17. base xs string gt xs whiteSpace value preserve xs minLength value 1 gt xs maxLength value 50 gt xs enumeration value Health Public Services and Care xs enumeration value Science and Mathematics gt xs enumeration value Agriculture Horticulture and Animal Care xs enumeration value Engineering and Manufacturing Technologies xs enumeration value Construction Planning and the Built Environment gt xs enumeration value Information and Communication Technology gt tion value Retail and Commercial Enterprise lt xs enumerat lt xs enumeration value Leisure Travel and Tourism gt lt xs enumeration value Arts Media and Publishing gt lt xs enumeration value History Philosophy and Theology gt lt xs enumeration value Social Sciences gt lt xs enumeration value Languages Literature and Culture gt lt xs enumeration value Education and Training gt lt xs enumeration value Preparation for Life and Work gt lt xs enumeration value Business Administration and Law gt lt xs enumeration value Unknown gt sasi restriction lt xs simpleType gt Reference QWS Data User Manual V1 0 rtf 47 47 department for education and skills V element SSFT2 diagram restriction of xs string i content simple nillable false SectorSubjectTier2 3 4 minLength ner maxLength whiteSpace collapse pattern 0 9 1 2 0 9 1 2 source
18. lt xs element name SSFT2 nillable false gt lt xs simpleType gt lt xSirestriction base xs string gt xs minLength value 3 gt lt xs maxLength value 4 gt xs whiteSpace value collapse gt xs pattern value O 9 1 2 N 0 9 1 2 lt xs restriction gt lt xs simpleType gt lt xs element gt element SSFT2_ID diagram 55FT2 ID ype xi n content simple roperties nillable false SectorSubjectTier2 xs element name SSFT2 ID type xs integer nillable false element SSFT2Description diagram SE SSFT 2 Description restriction of xs string content simple nillable false SectorSubjectTier2 f minLength 1 whiteSpace preserve source lt xs element name SSFT2Description nillable false gt lt xs simpleType gt xs restriction base xs string gt lt xs whiteSpace value preserve gt lt xs minLength value 1 gt lt xs maxLength value 55 gt lt xs restrictions lt xs simpleType gt lt xs element gt element Version Version type restriction of xs string content simple roperties nillable false Reference QWS Data User Manual V1 0 rtf 48 48 department for education and skills n pattern 0 9 1 2 0 9 0 9a z 0 2 source xs element name Version nillable false gt lt xs simpleType gt xs restriction base xs string xetpattern value 0 9 1 2 N 0 9 0 9a z 0 2 gt sfustrrostrlction lt xs
19. simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 49 49 department for education and skills 4 6 QAN SSFT1 V1 1 xsd Figure 6 QAN SSFT1 V1 1 Message Structure FileContent A header Version DateTime A as FT1 ID Message 55FT1 MA 55FT1Description A 1 Sector Subject Framework Tier 1 Base Data gt LastUpdated Generated by AmlSpy www altova com element DateTime diagram m DateTime content simple roperties labe false element Header lt xs element name DateTime type xs dateTime nillable false gt element EffectiveFrom diagram i im i content simple roperties nillable false element SectorSubjectTier1 xs element name EffectiveFrom type xs date nillable false Reference QWS Data User Manual V1 0 rtf 50 50 department for education and skills element EffectiveTo diagram type properties content simple roperties p nilable false element SectorSubjectTier1 source lt xs element name EffectiveTo type xs date nillable false gt element FileContent diagram FileContent type restriction of xs string content simple roperties nillable false used by element Header minLength 1 SES maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs s
20. source xs element name Version nillable false gt lt xs simpleType gt xs restriction base xs string xs pattern value 0 9 1 2 0 9 0 9a z 0 2 e XS restriction lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 55 55 department for education and skills 4 7 QAN Map V1 0 xsd Figure 7 QAN Map V1 0 Message Structure gt FileContent Version Ilj Date Time ll Map ID gt MapDescription 1 00 Map Data LastUpdated Generated by XmlSpy www altova com Map Map ID MapDescription element DateTime diagram DateTime content simple roperties labo fees element Header xs element name DateTime type xs dateTime nillable false element EffectiveFrom diagram i dopo asiaate O Aass content simple roperties labe false element MapData xs element name EffectiveFrom type xs date nillable false Reference QWS Data User Manual V1 0 rtf 56 56 department for education and skills element EffectiveTo diagram type properties content simple roperties p nilable false element source lt xs element name EffectiveTo type xs date nillable false element FileContent diagram FileContent type restriction of xs string content simple roperties nillable false used by element Header minLength 1 SES maxLength 25
21. spreadsheet programs will not always support this format In these cases where a DATE data type has been indicated the system may need to be set to CHAR 10 Reference QWS Data User Manual V1 0 rtf 7 7 department for education and skills 3 Data Tables 3 1 Table Structures The following sections give structure information for each of the QWS database tables 3 1 1 QAN Main Table Note This structure applies to both the Current QAN Data and Expired QAN Data Feld Tpe J Paten Enum Ol QANID INT n regen ss 03 AB CHAR S ZO 04 QualType A VARCHARQ X A amp ZO 9u3 CHAR 4 E a 06 DiscCode VARCHAR 4 O 9W4DITA ZI2HO 9A Za zf0 2 o7 QualfieatonTile VARGHARIN6 o QualshonTile VARGHAR 55 L 09 AccStartDate DATE ri2 e0 0 9 2 01 0 9 0123 0 9 10 AccEndDate DATE t2j90JO 9 2HO1 0 9H0123 0 9 11 CerEndDate DATE riz eop 0 9y2 o1 0 9 01231 0 9 12 AppStartDate DATE 12 1 90 0 9 2 01 0 9 0123 0 9 13 AppEndDate DATE riz e0p 0 9 2 01 0 9 0123 0 9 0 9 1 2 0 9 1 2 NEN 16 NQF O VARCHARQ X E IPSO 9 CE 9 17 Effeciverom DATE 18 EffectiveTo DATE J j _ o 19 LastUpdated DATE TI 3 1 2 Awarding Body Lied Type Patten Enum AB_ID INT 0 9Z 0 9 2 n 03 AwardingBodyName VARCHAR 130 fo 04
22. xs restriction base xs string gt lt xs minLength value 1 gt lt xs maxLength value 55 gt lt xs whiteSpace value preserve gt xsirestriotion lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 21 21 department for education and skills element QualType mE type restriction of xs string content simple roperties nillable false element Qualification f minLength 1 SECR maxLength 3 whiteSpace collapse pattern A Z0 9 1 3 source xs element name QualType nillable false gt lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt lt xs maxLength value 3 gt xs whiteSpace value collapse gt xs pattern value A ZzO 9 1 3 lt xs restriction gt lt xs simpleType gt lt xs element gt element SSFT1 mE restriction of xs string topo s content simple nillable false element Qualification jasle minLength 1 maxLength 2 whiteSpace collapse pattern 0 9 1 2 enumeration enumeration 2 enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration source lt xs element name SSFTI nillable false gt lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt xs maxLength value 2 gt xs whiteSpace value collapse gt
23. xs string content simple roperties nillable false element Qualification minLength 0O Se maxLength 3 whiteSpace collapse pattern Z0 9 source xs element name AB nillable false gt lt xs simpleType gt xs restriction base xs string xs whiteSpace value collapse gt xs minLength value 0 gt lt xs maxLength value 3 gt xs pattern value Z0 9 gt x amp Strestriliotiono lt xs simpleType gt lt xs element gt element AccEndDate diagram AccEndDate type restriction of xs date content simple roperties nillable false element Qualification Qualification pattern 12 90 0 9 2 01 0 9 0123 0 9 source lt xs element name AccEndDate nillable false gt lt xs simpleType gt lt xs restriction base xs date gt lt xs pattern value 12 90 0 9 2 01 0 9 0123 0 9 gt C ixscrestrictlon lt xs simpleType gt Reference QWS Data User Manual V1 0 rtf 14 14 department for education and skills w element AccStartDate diagram AccStartDate type restriction of xs date content simple roperties l nillable false used by element Qualification whiteSpace collapse pattern 12 90 0 9 21 01 0 9 0123 0 9 source lt xs element name AccStartDate nillable false gt lt xs simpleType gt xs restriction base xs date gt xs whiteSpace value collapse gt xs pattern value 12 90 0 9 2
24. xs whiteSpace value collapse gt xs enumeration value LDCS gt lt xs enumeration value LEAP gt xs enumeration value 1dcs gt cfxatre estriction lt xs simpleType gt lt xs element gt element Message diagram properties zHeader aDiscountCodeData content complex children Header DiscountCodeData source lt xs element name Message xs complexType lt xs sequence gt lt xs element ref Header gt lt xs element ref DiscountCodeData gt lt xs sequence gt lt xs complexType gt lt xs element gt Message element SSFT1 diagram type restriction of xs string properties content simple nilable false Reference QWS Data User Manual V1 0 rtf 40 40 department for education and skills ia gale minLength 1 maxLength 2 whiteSpace collapse pattern 0 9 1 2 enumeration enumeration 2 enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration source xs element name SSFTI nillable false lt xs simpleType gt lt xs restriction base xs string gt xs minLength value 1 gt xs maxLength value 2 gt xs whiteSpace value collapse gt xs pattern value 0 9 1 2 gt lt xs enumeration value 1 gt lt xs enumeration value 2 gt lt xs enumeration value 3 gt lt xs enumeration v
25. 5 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs string gt xs whiteSpace value preserve xs minLength value 1 gt xs maxLength value 255 gt ixsitrestri tiron lt xs simpleType gt lt xs element gt element Header diagram FileContent A Header Version A DateTime content complex source lt xs element name Header gt xs complexType lt xs sequence gt xs element ref FileContent gt lt xs element ref Version gt xs element ref DateTime gt lt xs sequence gt lt xs complexType gt xs element element LastUpdated diagram type content simple roperties nillable false used by element MapData Reference QWS Data User Manual V1 0 rtf 57 57 department for s a education and skills lt xs element name LastUpdated type xs date nillable false gt element Map restriction of xs string content simple t lable fale element MapData length 4 aes whiteSpace collapse enumeration LDCS enumeration LEAP enumeration Idcs source lt xs element name Map nillable false gt lt xs simpleType gt lt xs restriction base xs string gt lt xs length value 4 gt lt xs whiteSpace value collapse gt lt xs enumeration value LDCS gt lt xs enumeration value LEAP gt xs enumeration value ldcs xs restriction
26. AMEWORK TIER TL 9 3 1 7 DISCOUNT CODE MAPPING dan rove kd asid ak kd ka a ki ka ale kk bk 10 3 1 8 QUALIFICATION TYPE POINTS aaa tee anna nana aaa aa aaa aa aaa aa aaa aaa aaa aaa aa aaa aa aaa erre i race aaa 10 3 2 FIELD RELATIONSHIPS aaa ana ua aaa na aaa nana ana aaa na kaa aa aa ua ana aa ana aa aaa nana anna aa nana aaa 11 4 XML SCHEMAS EE 12 41 QAN MAIN E E l ate oi n 13 42 QAN AB VILO SD es uuu cence tc dad ye kata okt is u uu n e a n e a e ok a e 24 4 3 QAN QUALTYPE_V1 0 XSD 29 44 QAN DISCCODE V1 1 XSD U aa aan aaa aa aan u u Q 36 45 QAN SSET2 VI XOD oint lon a a sin aie ian pr e ae ni ae Ku UR n an oi a e im 43 46 QAN SSFT1 V1 1 X9D EEN 50 4 7 QAN MAP VT 0 XSD Q 56 48 QAN QUALTYPEPOINTS_V1 2 xXSD 61 5 TEAT EILES jo 65 5 1 QAN WEIER er 65 52 GAN AB _ V1 0 C9V eebe 66 5 3 QAN QUALTYPE e 66 5 4 QAN DISCCODE _ V1 1 CSV T 66 55 QAN SSFT2 RT Di De 66 5 6 QAN SSFT1_V1 1 CSV 67 br GAN M
27. AP VIO TE 67 5 8 QAN QUALTYPEPOINTS V1 2 CSV Q Q 67 Reference QWS Data User Manual V1 0 rtf 2 2 department for department for education and skills Document Version History CHANGE HISTORY REVIEW AND APPROVAL ORGANISATION DATE IGNATURE DfES DSG 2007 03 28 DfES DSG Roy Hicks 2007 03 29 DISTRIBUTION ORGANISATION NAME DfES DSG Gwen Baulch Mike Kelly Reference QWS Data User Manual V1 0 rtf 3 9 department for education and skills 1 Introduction 1 1 Background Qualification Accreditation Number QAN data is being supplied to support the collection of Post 16 Learning Aims PLA data from secondary schools with sixth forms From the 2007 2008 academic year these data will be collected using the School Census The QAN Web Services QWS project has been developed to provide a system for delivering QAN data to schools and other interested parties The data provided has been tailored specifically from the more generic data received from QCA to support school teaching and learning activities and to improve the data quality from future School Census collections The QWS system has been designed to provide data in two ways e Web Services an interactive system which allows dynamic access to the QAN data files and e Web Site download facilities allowing users to obtain data by standard file downloads 1 2 Web Services Details of the
28. E 5 9 QAN_SSFT2_V1 1 csv Field FieldName Type 06 EffectiveFrom DATE n 08 LastUpdated DATE Reference QWS Data User Manual V1 0 rtf department for education and skills 66 66 department for education and skills 5 6 QAN SSFT1_V1 1 csv Field FieldName jupe 02 SSFT1 VARCHAR 2 04 05 Effective To DATE 06 LasiUpdated DATE 5 7 QAN Map V1 0 csv Type NT CHAR 4 VARCHAR 40 06 LastUpdated DATE 5 8 QAN QualTypePoints V1 2 csv Field Field Name QualType ID QualGrade VARCHAR 3 UCAS Pts QCA Pts Heference QWS Data User Manual V1 0 rtf 67 67
29. Enm SSFT1 ID PINT _ SSFT1 VARCHAR 2 0 9 1 2 SSFTiDescipion VARCHAR 50 04 EfedweFrom DATE 05 EfedweTo DATE 06 LastUpdated DATE ua Reference QWS Data User Manual V1 0 rtf 9 9 department for education and skills 3 1 7 Discount Code Mapping Feld Type sd Patterm Enum_ Map ID INT n n 02 Map Loan PY 08 MapDesoription VARCHAR 40 n 04 EfedweFrm DATE Il 05 Effectveto DE Il 06 LastUpdated DATE 3 1 8 Qualification Type Points Fed Type X jPaten Enm 01 QualType_ID INT 0 n QualGrade VARCHAR 3 0 9A Z 1 3 EE UCAS Pts PINT QCA PIs Wu Reference QWS Data User Manual V1 0 rtf 10 10 department for education and skills 3 2 Field Relationships The following table shows field relationship information for the QWS database tables Primary Keys are O O Q Q gt gt E c c o o s G G o o m m G G o me E O D Framework Tier 1 N 0 O oF O xX 20 oz 0 O E o S 0 L Sector Subject Discount Code Fie a QAN_ID QualType DiscCode QualificationTitle QualShortTitle AccStartDate AccEndDate CertEndDate AppStartDate AppEndDate SSFT2 SSFT1 EffectiveFrom Effective To LastUpdated AB ID AwardingBodyName AB Acronym QualType ID Qualifi
30. WS Data User Manual V1 0 rtf 20 20 department for education and skills xs element ref SSFTI gt xs element ref NQF xs element ref EffectiveFrom gt xs element ref EffectiveTo gt xs element ref LastUpdated lt xs sequence gt lt xs complexType gt lt xs element gt element Qualifications 77977 Quatifications E a E oustncaton E 1 ca children Qualification source xs element name Qualifications gt xs complexType xs sequence xs element ref Qualification maxOccurs unbounded lt xs sequence gt lt xs complexType gt xs element element QualificationTitle diagram QualificationTitle type restriction of xs string content simple roperties nilable false element Qualification minLength 1 maxLength 165 whiteSpace preserve facets source lt xs element name QualificationTitle nillable false gt lt xs simpleType gt lt xs restriction base xs string xs minLength value 1 gt xs maxLength value 165 xs whiteSpace value preserve lt xs restrictions gt lt xs simpleType gt lt xs element gt element QualShortTitle diagram QualShortTitle type restriction of xs string content simple roperties nillable false element T Qualification f minLength 1 whiteSpace preserve source lt xs element name QualShortTitle nillable false gt lt xs simpleType gt
31. alue 4 gt lt xs enumeration value 5 gt xs enumeration value 6 gt lt xs enumeration value 7 gt lt xs enumeration value 8 gt lt xs enumeration value 9 gt lt xs enumeration value 10 gt lt xs enumeration value 11 gt lt xs enumeration value 12 gt lt xs enumeration value 13 gt lt xs enumeration value 14 gt lt xs enumeration value 15 gt lt xs enumeration value 0 gt e xs restriction lt xs simpleType gt lt xs element gt element SSFT2 bu type restriction of xs string content simple roperties nillable false element DiscountCode minLength 3 SE maxLength 4 whiteSpace collapse pattern O 9 1 2 0 9 1 2 source xs element name SSFT2 nillable false gt xs simpleType xs restriction base xs string xs minLength value 3 gt xs maxLength value 4 xs whiteSpace value collapse gt xs pattern value O 9 1 2 N 0 9 1 2 xSTEOBLEIOLIODO lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 41 41 department for education and skills element Version diagram restriction of xs string content simple nillable false pattern 0 9 1 2 0 9 0 9a zK0 2 source lt xs element name Version nillable false lt xs simpleType gt xs restriction base xs string lt xs pattern value 0 9 11 2 X 0 9 0 9a z 10 2 xs restriction lt xs simp
32. athematics enumeration Agriculture Horticulture and Animal Care enumeration Engineering and Manufacturing Technologies enumeration Construction Planning and the Built Environment enumeration Information and Communication Technology enumeration Retail and Commercial Enterprise enumeration Leisure Travel and Tourism enumeration Arts Media and Publishing enumeration History Philosophy and Theology enumeration Social Sciences enumeration Languages Literature and Culture enumeration Education and Training enumeration Preparation for Life and Work enumeration Business Administration and Law enumeration Unknown source xs element name SSFTIDescription nillable false gt lt xs simpleType gt lt xs annotation gt lt xs documentation gt Sob Li SST1Description wi Health Public Services and Care 2 Science and Mathematics 3 Agriculture Horticulture and Animal Care 4 Engineering and Manufacturing Technologies 5 Construction Planning and the Built Environment 6 Information and Communication Technology J Retail and Commercial Enterprise 8 Leisure Travel and Tourism Oo Arts Media and Publishing LO History Philosophy and Theology lil Social Sciences 12 Languages Literature and Culture 13 Education and Training 14 Preparation for Life and Work 15 Business Administration and Law 0 Unknown lt xs documentation gt xs annotation xs restriction base xs
33. cationDescription DiscountFamily QualCode DiscCode ID DiscCodeDescription SSFT2 ID ooFT2Description SSFT1 Description SSFT1_ID Map ID MapDescription QualGrade UCAS Pts ss QCA Pts x I j j Y Z gt 6 S ODE TI e Z z z 3 D Heference QWS Data User Manual V1 0 rtf 11 11 department for education and skills 4 XML Schemas The following sections provide detailed information on the contents of each of the XML schemas including message structure diagrams nm a lt jan ann NM Awarding Body QAN AB V1 0 xsd DEE 2 XML Schema documentation generated by XMLSpy Reference QWS Data User Manual V1 0 rtf 12 12 department for education and skills 4 1 QAN Main V1 1 xsd Figure 1 QAN Main V1 1 Message Structure FileContent Aa Version WI Header E re l Date Time Aa aGualT E Message ea DizcCode QualificationTitle WI WI WI E a E E un I 4 E 5 2 m AccStartDate WI AccEndDate WI Qualifications FH FH Qualification FH E TI o gt CertEndDate a AppS5taniDate a AppEndDate CIE WI SFT WI gt EffectiveFrom 5 EffectiveTo i i i L astlipdated Generated by XmlSpy www altova com Heference QWS Data User Manual V1 0 rtf 13 13 department for education and skills LAB n Map Message NQF QAN VV _QANID SSFT2 Version element AB type restriction of
34. ce lt xs element name AB Acronym nillable false lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt xs maxLength value 20 gt amp ixSitestri ction gt lt xs simpleType gt lt xs element gt element AB_ID diagram ype xm ooo content simple roperties nillable false element AwardingBody source xs element name AB ID type xs integer nillable false element AwardingBody diagram AwardingBodytHame AwardingBody AB Acronym Awarding Body Data EffectiveFrom LastUpdated content complex AB ID AB AwardingBodyName AB_Acronym EffectiveFrom EffectiveTo LastUpdated AwardingBodyData documentation Awarding Body Data source lt xs element name AwardingBody gt amp xs annotation xs documentation Awarding Body Data lt xs documentation gt lt xs annotation gt lt xs complexType gt lt xs sequence gt xs element ref AB ID xs element ref AB xs element ref AwardingBodyName xs element ref AB Acronym xs element ref EffectiveFrom gt Heference QWS Data User Manual V1 0 rtf 25 25 department for education and skills lt xs element ref EffectiveTo gt lt xs element ref LastUpdated gt lt xs sequence gt lt xs complexType gt xs element element AwardingBodyData an AwardingBodyData EH E AwardingBody Wardin 1 Wardin oO g x 1 Awarding
35. department for education and skills QWS Data User Manual Department for Education and Skills Reference QWS Data User Manual V1 0 rtf Status Final Version 1 0 Date 30 March 2007 Author Roy Hicks Reference QWS Data User Manual V1 0 rtf 1 1 education and skills CONTENTS 1 INTRODUCTION mr rr a n ek n e lk a ee n w ik e n inn et 4 1 1 BOK C ROUND EE 4 T2 WEBSERVICES RE 4 1 3 WEB SITE DOWNLOADS 4 LA SCOP EE 5 2 cio i EE 6 2 1 DATATYPES uuu uuu ati it pt ki ti aa kt aulas a a kk e ae a ad a do a lida ikad 6 2 2 DATA PATTERNS 6 2 3 DATA ENUMERATIONS taka na aaa aaa aaa aa kaka aaa na aa aaa aaa aaa na U aaa aa ana aaa aaa na aaa aa aa aaa nana 7 24 DAIEFIEEDS uuu e etat tite tot ti tat u u ee ka ki iste 7 SEENEN 8 St TABLE SIRUCIURES RE 8 3 1 1 QAN MAIN TABLE aaa nana aaa aa aaa aaa aa aaa aaa aa eee a aaa anna 8 3 1 2 AWARDING BODY aaa aaa aaa aa aaa aaa aaa enne aaa aa aaa aa aaa aaa aaa aaa aa aaa aa aaa aa aaa aa aaa kaaa aaa aa aaa aaa aa aa kaaa 8 3 1 3 QUALIFICATION TwptE nana aaa aaa aaa aa aaa aaa aa aa aaa aa aaa aaa aa aaa aaa aa aaa aaa aaa aaa aa aaa aaa iiri 9 3 1 4 DISCOUNT CODE 9 3 1 5 SECTOR SUBJECT FRAMEWORK TIER 2 aaa aaa aaa aaa aaa kakaa aaa aa kaaa aaa aaa rarae 9 3 1 6 SECTOR SUBJECT FR
36. documentation tat s Sector Subject Framework Tier 1 Base Data source lt xs element name SectorSubjectTieri gt xS annotatrlon xs documentation Sector Subject Framework Tier 1 Base Data xs documentation lt xs annotation gt xs complexType lt xs sequence gt lt xs element ref SSFTI_ID gt xs element ref SSFTI gt xs element ref SSFTiDescription gt xs element ref EffectiveFrom gt xs element ref EffectiveTo gt xs element ref LastUpdated lt xs sequence gt lt xs complexType gt lt xs element gt element SectorSubjectTieriData diagram SectorSubjectTieriData Ge asectorS5ubjectTierl p T o Sector Subject Framework Tier 1 Base Data content complex Heference QWS Data User Manual V1 0 rtf 52 52 department for education and skills SectorSubjectTier1 source lt xs element name SectorSubjectTieriData lt xs complexType gt lt xs sequence gt xs element ref SectorSubjectTieri maxOccurs unbounded xs sequence xs complexType lt xs element gt element SSFT1 og restriction of xs string roperti content simple nillable false SectorSubjectTier1 facete minLength 1 maxLength 2 whiteSpace collapse pattern 0 9 1 2 enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumera
37. hematics enumeration Agriculture Horticulture and Animal Care enumeration Engineering and Manufacturing Technologies enumeration Construction Planning and the Built Environment enumeration Information and Communication Technology enumeration Retail and Commercial Enterprise enumeration Leisure Travel and Tourism enumeration Arts Media and Publishing enumeration History Philosophy and Theology enumeration Social Sciences enumeration Languages Literature and Culture enumeration Education and Training enumeration Preparation for Life and Work enumeration Business Administration and Law enumeration Unknown source lt xs element name SSFTIDescription nillable false gt lt xs simpleType gt amp xstannotstliorn lt xs documentation gt SBETI SST1Description I Health Public Services and Care 2 Science and Mathematics 3 Agriculture Horticulture and Animal Care 4 Engineering and Manufacturing Technologies 5 Construction Planning and the Built Environment 6 Information and Communication Technology 7 Retail and Commercial Enterprise 8 Leisure Travel and Tourism 9 Arts Media and Publishing 10 History Philosophy and Theology lil Social Sciences 12 Languages Literature and Culture 13 Education and Training 14 Preparation for Life and Work 15 Business Administration and Law W Q Unknown W lt xs documentation gt lt xs annotation gt lt xs restriction
38. hiteSpace value collapse gt xs pattern value 0 9 1 3 xstiresrtriotiono lt xs simpleType gt lt xs element gt element QualificationDescription diagram i nm QualificationDescription restriction of xs string content simple nillable false QualificationType minLength 1 a maxLength 75 whiteSpace preserve source lt xs element name QualificationDescription nillable false gt lt xs simpleType gt xs restriction base xs string lt xs whiteSpace value preserve gt lt xs minLength value 1 gt xs maxLength value 75 gt xs r striction lt xs simpleType gt lt xs element gt element QualificationType diagram aualType_ID gt QualType gt QualificationDescription QualificationType DI a ES DiscountFamily Qualification Type Data a GualCode gt EffectiveFrom Effective To LastUpdated content complex DiscountFamily QualCode EffectiveFrom QualificationTypeData I documentation annotation c a annotation Qualification Type Data source xs element name QualificationType gt lt xs annotation lt xs documentation gt Qualification Type Data lt xs documentation gt Reference QWS Data User Manual V1 0 rtf 33 33 department for education and skills lt xs annotation gt xs complexType lt xs sequence gt xs element ref QualType_ID gt xs element ref QualType gt xs element ref QualificationDescri
39. ileContent restriction of xs string content simple roperties i minLength 1 maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs string xs whiteSpace value preserve gt xs minLength value 1 gt xs maxLength value 255 gt Ki xS restr fiction lt xs simpleType gt lt xs element gt element Header diagram properties gt FileContent a Version Date Time content complex source lt xs element name Header lt xs complexType gt lt xs sequence gt xs element ref FileContent gt lt xs element ref Version gt xs element ref DateTime gt lt xs sequence gt lt xs complexType gt xs element element LastUpdated diagram LastUpdated Reference QWS Data User Manual V1 0 rtf 27 27 department for education and skills content simple roperties nillable false element AwardingBod xs element name LastUpdated type xs date nillable false element Message diagram Message a wardingBodyData content complex Header AwardingBodyData source lt xs element name Message xs complexType lt xs sequence gt xs element ref Header gt xs element ref AwardingBodyData gt lt xs sequence gt lt xs complexType gt lt xs element gt element Version diagram restriction of xs string content simple
40. leType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 42 42 department for education and skills 4 5 QAN SSFT2 V1 1 xsd Figure 5 QAN SSFT2 V1 1 Message Structure FileContent A header Version DateTime A 55FT2 ID A Message 55FT2Description A asectors5ubject Tier2Data gt SSFTA Description LastUpdated Sector Subject Framework Tier 2 Basa Data A Generated by AmlSpy www altova com element DateTime diagram E DateTime content simple roperties labo fees element Header xs element name DateTime type xs dateTime nillable false element EffectiveFrom diagram EffectiveFrom x we Co OOOO content simple roperties nillable false element SectorSubjectTier2 Heference QWS Data User Manual V1 0 rtf 43 43 department for education and skills source lt xs element name EffectiveFrom type xs date nillable false element EffectiveTo diagram S content simple roperties I nillable false SectorSubjectTier2 xs element name EffectiveTo type xs date nillable false element FileContent diagram FileContent restriction of xs string content simple roperties minLength 1 ER maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base
41. lls element Version diagram Version restriction of xs string properties content simple roperties PIE nilable false pattern 0 9 1 2 0 9 0 9a zK0 2 source lt xs element name Version nillable false lt xs simpleType gt xs restriction base xs string lt xs pattern value 0 9 11 2 X 0 9 0 9a z 10 2 xs restriction lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 35 35 department for education and skills 4 4 QAN DiscCode V1 1 xsd Figure 4 QAN DiscCode V1 1 Message Structure FileContent A a Version aHeader DateTime DiscCode_ID DiscCode UiscCodeDescription Message aDiscountCodeData aDiscountCode ST 1 00 Discount Code Data LastUpdated Generated by XmlSpy www altova com Map element DateTime diagram DateTime content simple roperties l able fees element Header xs element name DateTime type xs dateTime nillable false element DiscCode diagram Reference QWS_Data_User_Manual_V1 0 rtf 36 36 department for education and skills iype restriction of xs string content simple roperties j nillable false element DiscountCode minLength 2 ER maxLength 4 whiteSpace collapse pattern _ 0 9 4 A Z 2 0 9A Za z 0 2 source lt xs element name DiscCode nillable false gt
42. lt xs simpleType gt xs restriction base xs string xs minLength value 2 gt lt xs maxLength value 4 gt xs whiteSpace value collapse gt xs pattern value 0 9 4 A Z 2 O 9A Za z 0 27 lt xs restriction gt lt xs simpleType gt lt xs element gt element DiscCode ID diagram DiscCode ID content simple roperties nillable false element DiscountCode source lt xs element name DiscCode ID type xs integer nillable false element DiscCodeDescription diagram DiscCodeDescription restriction of xs string content simple nillable false element DiscountCode f minLength 1 ae maxLength 60 whiteSpace preserve source lt xs element name DiscCodeDescription nillable false gt lt xs simpleType gt xs restriction base xs string lt xs whiteSpace value preserve gt lt xs minLength value 1 gt lt xs maxLength value 60 gt g izairestriction lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 37 37 department for education and skills element DiscountCode diagram ZL aDiscCode ID s DiseCode gt DiseCodeDescription SSFT2 DiscountCode EH E SET Discount Code Data ectiveFrom ectiveTo LastUpdated content complex Il L I DiscCode ID DiscCodeDescription SSFT2 SSFT1 EffectiveFrom EffectiveTo LastUpdated used by DiscountCodeData documentation tat EMI Discoun
43. ment GradePoints diagram QualGrade GradePoints Qualiication Grade Paints Lata content complex children QualGrade UCAS Pts QCA Pts element QualificationTypePoints pePoints documentation annotation annotation Qualification Grade Points Data source xs element name GradePoints lt xs annotation gt lt xs documentation gt Qualification Grade Points Data lt xs documentation gt xs annotetion xs complexType lt xs sequence gt xs element ref QualGrade gt xs element ref UCAS_Pts gt xs element reft OCA_Pts gt lt xs sequence gt lt xs complexType gt xs element element Header diagram m FileContent Header Version Date Time content complex children source lt xs element name Header lt xs complexType gt lt xs sequence gt xs element ref FileContent gt lt xs element ref Version gt xs element ref DateTime gt lt xs sequence gt lt xs complexType gt xs element element Message diagram Header QualificationTypePoints H 2m Qualification Type Points Data content complex QualificationTypePoints source xs element name Message xs complexType Reference QWS Data User Manual V1 0 rtf 62 62 department for education and skills lt xs sequence gt lt xs element ref Header gt lt xs element ref QualificationTypePoints maxOccurs unbounded gt lt x
44. ption gt lt xs element ref NQF gt xs element ref DiscountFamily gt lt xs element ref QualCode gt lt xs element ref EffectiveFrom gt xs element ref EffectiveTo gt xs element ref LastUpdated lt xs sequence gt lt xs complexType gt lt xs element gt element QualificationTypeData eae QualificationTypeData EH Qualification LaifICaTION i ype A Uaimim atr pe ud n 1 00 Qualification Type Data content complex QualificationType source lt xs element name QualificationTypeData gt lt xs complexType gt lt xs sequence gt lt xs element ref QualificationType maxOccurs unbounded gt lt xs sequence gt lt xs complexType gt lt xs element gt element QualType al restriction of xs string content simple nillable false QualificationType minLength SECH maxLength whiteSpace collapse pattern 0 9A Z 1 3 source lt xs element name QualType nillable false gt lt xs simpleType gt xs restriction base xs string lt xs minLength value 1 gt xs maxLength value 3 gt xs whiteSpace value collapse gt xs pattern value O 9A Z 1 3 fxairestrictiornm lt xs simpleType gt lt xs element gt element QualType_ID diagram we xiege O Lsa content simple roperties nilable false QualificationType Reference QWS Data User Manual V1 0 rtf 34 34 department for education and ski
45. rn value 12 90 0 9 2 01 0 9 0123 0 9 sIwatcrestriction lt xs simpleType gt lt xs element gt Element DateTime diagram DateTime content simple roperties i labo fees element Header xs element name DateTime type xs dateTime nillable false element DiscCode diagram DizcCode iype restriction of xs string content simple roperties nillable false element Qualification minLength 2 sed maxLength 4 whiteSpace collapse pattern O 9K4 A Z 2 O 9A Za z 0 2 source lt xs element name DiscCode nillable false gt lt xs simpleType gt xs restriction base xs string xs minLength value 2 xs maxLength value 4 xs whiteSpace value collapse gt xs pattern value 0 9 4 A Z 2 O 9A Za z 0 2 lt xs restriction gt lt xs simpleType gt lt xs element gt element EffectiveFrom diagram content simple roperties nillable false element Qualification source xs element name EffectiveFrom type xs date nillable false element EffectiveTo diagram type content simple roperties i nillable false Reference QWS Data User Manual V1 0 rtf 16 16 department for education and skills element Qualification source lt xs element name EffectiveTo type xs date nillable false element FileContent diagram FileContent restriction of xs string
46. roperties I nillable false used by element Header pattern 0 9 1 2 0 9 0 9a z 0 2 source xs element name Version nillable false lt xs simpleType gt xs restriction base xs string xs pattern value 0 9 1 2 0 9 0 9a z 0 2 lt xs restriction gt lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 28 28 department for education and skills 4 3 QAN QualType V1 0 xsd Figure 3 GAN QualType V1 0 Message Structure FileContent A x Version Date Time a Header A UualType ID Message QualificationDescription De Generated by XmlSpy www altova com a Gualification TypeData 1 00 Qualification Type Data NQF EffectiveTo element DateTime diagram DateTime content simple roperties labo fees element Header xs element name DateTime type xs dateTime nillable false element DiscountFamily diagram DiscountFamily restriction of xs string content simple Reference QWS Data User Manual V1 0 rtf 29 29 department for education and skills nn QualificationType facete minLength maxLength enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration so
47. s sequence gt lt xs complexType gt lt xs element gt element QCA Pts diagram type restriction of xs float content simple nillable false used by element GradePoints mininclusive 0 maxlnclusive 1500 properties facets source xs element name OCA Pts nillable false gt lt xs simpleType gt xs restriction base xs float gt xs minInclusiv value 0 5 xs maxInclusive value 1500 xstrestriction lt xs simpleType gt lt xs element gt element QualGrade diagram QualGrade type restriction of xs string content simple nillable false used by element GradePoints minLength maxLength 3 whiteSpace collapse pattern 0 9A Z 1 3 source xs element name QualGrade nillable false gt lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt lt xs maxLength value 3 gt xs whiteSpace value collapse gt xs pattern value 0 9A Z 1 3 gt efxstresrriotion lt xs simpleType gt lt xs element gt properties facets element QualificationTypePoints diagram QualificationTypePoints Qualification Type Points Data A f QualType ID GradePoints 1 00 Qualification Grade Points Lata content complex children QualType_ID GradePoints used by element Message documentation annotation ML e annotation Qualification Type Points Data source lt xs element name
48. string gt xs whiteSpace value preserve gt xs minLength value 1 gt lt xs maxLength value 50 gt lt xs enumeration value Health Public Services and Care gt lt xs enumeration value Science and Mathematics gt lt xs enumeration value Agriculture Horticulture and Animal Care gt lt xs enumeration value Engineering and Manufacturing Technologies gt lt xs enumeration value Construction Planning and the Built Environment gt lt xs enumeration value Information and Communication Technology gt lt xs enumeration value Retail and Commercial Enterprise gt lt xs enumeration value Leisure Travel and Tourism gt lt xs enumeration value Arts Media and Publishing gt lt xs enumeration value History Philosophy and Theology gt lt xs enumeration value Social Sciences gt lt xs enumeration value Languages Literature and Culture gt lt xs enumeration value Education and Training gt lt xs enumeration value Preparation for Life and Work gt lt xs enumeration value Business Administration and Law gt Reference QWS_Data_User_Manual_V1 0 rtf 54 54 department for education and skills xs renumeraction value Unknown gt fw irosiricitans lt xs simpleType gt lt xs element gt element Version diagram i type restriction of xs string properties content simple roperties RE nillable false pattern 0 9 1 2 L 0 9 0 9a 2 0 2
49. t Map MapDescription LDCS L arnDit ct Classification System Coding LEAP SCAAT General Qualifications Coding ldcs SCAAT General Qualifications Coding lt xs documentation gt lt xs annotation gt xs restriction base xs string lt xs whiteSpace value preserve gt lt xs minLength value 1 gt xs maxLength value 40 gt lt xs enumeration value LearnDirect Classification System Coding gt lt xs enumeration value SCAAT General Qualifications Coding gt lt xs enumeration value Temporary LDCS Coding gt lt xs restriction gt lt xs simpleType gt lt xs element gt element MappingData diagram i d MappingData N Me MapData 1 on Map Data content complex source xs element name MappingData xs complexType lt xs sequence gt lt xs element ref MapData maxOccurs unbounded gt lt xs sequence gt lt xs complexType gt lt xs element gt Reference QWS_Data_User_Manual_V1 0 rtf 59 59 department for education and skills element Message diagram a MappingData content complex Header MappingData source lt xs element name Message gt xs complexType lt xs sequence gt xs element ref Header gt xs element ref MappingData gt lt xs sequence gt lt xs complexType gt lt xs element gt element Version Version restriction of xs string content simple nillable false pattern 0 9 1 2 0 9 0 9a
50. t Code Data source xs element name DiscountCode xsrannotatlorn xs documentation Discount Code Data lt xs documentation gt Zxs annotation xs complexType lt xs sequence gt xs element ref DiscCode_ID gt lt xs element xers DiscCode J xs element ref DiscCodeDescription xs element ref SSFT2 xs element ref SSFTI gt xs element ref Map lt xs element ref EffectiveFrom xs element ref EffectiveTo xs element ref LastUpdated lt xs sequence gt lt xs complexType gt xs element element DiscountCodeData 77977 DiseountCodeData E DiscountCodeData liscountCode W 7 n 1 ca Discount Code Data content complex DiscountCode source xs element name DiscountCodeData gt lt xs complexType gt lt xs sequence gt lt xs element ref DiscountCode maxOccurs unbounded gt lt xs sequence gt lt xs complexType gt xs element Reference QWS Data User Manual V1 0 rtf 38 38 department for education and skills element EffectiveFrom diagram type content simple nillable false element DiscountCode source xs element name EffectiveFrom type xs date nillable false element EffectiveTo diagram type content simple roperties l nillable false element DiscountCode source lt xs element name EffectiveTo type xs date nillable false element FileCon
51. tent diagram FileContent restriction of xs string content simple roperties U minLength 1 men maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs string gt xs whiteSpace value preserve gt xs minLength value 1 gt xs maxLength value 255 gt lt xs restriction gt lt xs simpleType gt lt xs element gt element Header diagram FileContent Header Version A DateTime content complex source lt xs element name Header gt lt xs complexType gt lt xs sequence gt lt xs element ref FileContent gt lt xs element ref Version gt lt xs element ref DateTime gt lt xs sequence gt Reference QWS_Data_User_Manual_V1 0 rtf 39 39 department for education and skills lt xs complexType gt xs element element LastUpdated diagram Lastipdated content simple nillable false element DiscountCode xs element name LastUpdated type xs date nillable false element Map kh type restriction of xs restriction ofxssstring a content simple roperties nillable false element DiscountCode length 4 ra whiteSpace collapse enumeration LDCS enumeration LEAP enumeration ldcs source xs element name Map nillable false gt lt xs simpleType gt xs restriction base xs string xs length value 4 gt
52. tion enumeration enumeration source xs element name SSFTI nillable false gt lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt xs maxLength value 2 gt xs whiteSpace value collapse gt xs pattern value O 9 1 2 lt xs enumeration value 1 gt lt xs enumeration value 2 gt lt xs enumeration value 3 gt lt xs enumeration value 4 gt lt xs enumeration value 5 gt xs enumerat tion value 6 xs enumeration value 7 gt lt xs enumeration value 8 lt xs enumeration value 9 gt xstenumetacioti valusee lo0 J lt xs enumeration value 11 gt xa enumeration value 12 7 gt ze jenimeratio n value 13 gt lt xs enumeration value 14 gt xs enummeratlon value 15 gt lt xs enumeration value 0 gt ixa restrictilon lt xs simpleType gt lt xs element gt element SSFT1_ID diagram 55FT1 ID x o Reference QWS Data User Manual V1 0 rtf 53 53 department for education and skills content simple roperties nillable false SectorSubjectTier1 lt xs element name SSFT1 ID type xs integer nillable false gt element SSFT1Description diagram SSFT1Description restriction of xs string content simple nillable false SectorSubjectTier1 minLength ER maxLength B whiteSpace preserve enumeration Health Public Services and Care enumeration Science and M
53. tiveFrom EffectiveToj LastUpdated used by SectorSubjectTier2Data documentation tat Ze Sector Subject Framework Tier 2 Base Data source xs element name SectorSubjectTier2 gt xsS annotatrlonm xs documentation Sector Subject Framework Tier 2 Base Data xs documentation xs annotation xs complexType lt xs sequence gt xs element ref SSFT2 ID xs element ref SSFT2 xs element ref SSFT2Description lt xs element ref SSFT1 gt lt xs element ref SSFTiDescription gt lt xs element ref EffectiveFrom gt lt xs element ref EffectiveTo gt lt xs element ref LastUpdated gt lt xs sequence gt lt xs complexType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 45 45 department for education and skills element SectorSubjectTier2Data diagram SectorSubjectTier2Data EH F SectorSubjectTier2 s n z amp _o 5P yan 1 00 Sector Subject Framework Tier 2 Base Data content complex SectorSubjectTier2 source lt xs element name SectorSubjectTier2Data xs complexType xs sequence xs element ref SectorSubjectTier2 maxOccurs unbounded lt xs sequence gt lt xs complexType gt lt xs element gt element SSFT1 mE restriction of xs string ti content simple nillable false SectorSubjectTier2 adeis minLength 1 maxLength 2 whiteSpace collapse pattern 0 9 1 2 en
54. tring gt xs whiteSpace value preserve xs minLength value 1 gt xs maxLength value 255 gt ixsitrestri tiron lt xs simpleType gt lt xs element gt element Header diagram FileContent A Header Version A DateTime content complex source lt xs element name Header gt xs complexType lt xs sequence gt xs element ref FileContent gt lt xs element ref Version gt xs element ref DateTime gt lt xs sequence gt lt xs complexType gt xs element element LastUpdated diagram type content simple nilable false SectorSubjectTier1 Reference QWS Data User Manual V1 0 rtf 51 51 department for LI a education and skills lt xs element name LastUpdated type xs date nillable false gt element Message diagram i a rector Subject TreriData content complex SectorSubjectTier1Data source lt xs element name Message gt lt xs complexType gt lt xs sequence gt lt xs element ref Header gt lt xs element ref SectorSubjectTieriData gt lt xs sequence gt lt xs complexType gt lt xs element gt element SectorSubjectTier1 diagram a75FT1_iD 5SFT1Description SectorSubjectTier1 _ Sector Subject Framework akffectiveFrom Tier 1 Base Data EffectiveTo LastUpdated content complex SSFT1 ID SSFT1 SSFT1 Description EffectiveFrom EffectiveToj LastUpdated used by SectorSubjectTier1 Data
55. umeration 1 enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration enumeration source lt xs element name SSFT1 nillable false gt lt xs simpleType gt xs restriction base xs string xs minLength value 1 gt xs maxLength value 2 gt xs whiteSpace value collapse gt xs pattern value 0 9 1 2 gt lt xs enumeration value 1 gt lt xs enumeration value 2 lt xs enumeration value 3 gt lt xs enumeration value 4 gt xs enumeration value 5 gt xs enumeration value 6 gt lt xs enumeration value 7 gt lt xs enumeration value 8 lt xs enumeration value 9 lt xs enumeration value 10 gt lt xs enumeration value 11 gt xs enumeration value 12 lt xs enumeration value 13 gt xs enumeration value 14 gt lt xs enumeration value 15 gt lt xs enumeration value 0 gt Reference QWS_Data_User_Manual_V1 0 rtf 46 46 department for education and skills lt xs restriction gt lt xs simpleType gt x xs element element SSFT1Description diagram ar TiDescription type restriction of xs string content simple roperties prop nillable false used by SectorSubjectTier2 1 minLength E maxLength 50 whiteSpace preserve enumeration Health Public Services and Care enumeration Science and Mat
56. urce lt xs element name DiscountFamily nillable false lt xs simpleType gt lt xs annotation lt xs documentation gt DiscountFamily Description AEA Advanced Extension BAS Basic Skills FSM Free standing Mathematics GEN General GRA Graded Examination GVO General Vocational HLQ Higher Level KEY Key Skills KSI Key Stage 1 UKS2 Key Stage 2 KS3 Key Stage 3 LAN Language Unit NRI No recorded information NVO National Vocational OG Other General OQ Other UNK National Curriculum VRQ Vocational relateq XXX Unknown xs documentation e xs annotation xs restriction base xs string xs minLength value 2 gt xs maxLength value 3 xs enumeration value AEA gt xs enumeration value BAS gt xs enumeration value FSM xs enumeration value GEN xs enumeration value GRA xs enumeration value GVO xs enumeration value HLQ gt xs enumeration value KEY xs enumeration value KS1 gt xs enumeration value KS2 gt xs enumeration value KS3 xs enumeration value LAN xs enumeration value NRI xs enumeration value NVQ gt xs enumeration value 0G gt xs enumeration value 0Q gt xs enumeration value UNK xs enumeration value VRO gt lt xs enumeration value XXX gt amp xs restriction gt lt xs simpleType gt lt xs element gt
57. z 0 2 source lt xs element name Version nillable false gt lt xs simpleType gt xs restriction base xs string lt xaipattern value 0 9 111 2 0 9 0 97a4 2110 2 gt amp xsirestrictilon gt lt xs simpleType gt lt xs element gt Reference QWS Data User Manual V1 0 rtf 60 60 department for education and skills 4 8 QAN QualTypePoints V1 2 xsd Figure 8 QAN QualTypePoints V1 2 Message Structure FileContent n Version DateTime WI Message 5 QualType ID 5 QualGrade ualification TypePoints 1 00 GradePoints RS gll 1 00 Qualification Type Points Data Qualification Grade Points Data Generated by XmlSpy www altova com element DateTime diagram DateTime content simple roperties labe tale element Header xs element name DateTime type xs dateTime nillable false element FileContent diagram FileContent restriction of xs string content simple roperties U minLength 1 do maxLength 255 whiteSpace preserve source lt xs element name FileContent nillable false gt lt xs simpleType gt xs restriction base xs string lt xs whiteSpace value preserve gt lt xs minLength value 1 gt lt xs maxLength value 255 gt lt xs restriction gt lt xs simpleType gt Reference QWS Data User Manual V1 0 rtf 61 61 department for education and skills w ele

QWS Data User Manual - Department for Education

Contents

Download Pdf Manuals

Related Search

Related Contents