Derived field specifications - Revisions
The table below contains the revisions for all specifications of derived fields created by HESA. They are provided to aid in understanding the onwards usage of data. They may be subject to updating during the collection year, until the database for the collection closes.
For the full list of specifications, please see the Derived field specifications - Contents page.
Search by element:
Field name | Version | Date | Revision notes |
---|---|---|---|
XPSR01 | 2.8.1 | 2021-01-22 | Technical specification has been updated for Cyy054 to derive activity during an instance period using NOTACT and STULOAD. Additional text; updated year references and examples |
XINSTID01 | 1.50.1 | 2021-01-06 | Providers 0431 CEG UFP Limited, 0432 Applied Business Academy Limited, 0433 Tavistock and Portman NHS Foundation Trust, 0434 University Academy 92 Limited have been added to the valid entries. No change to technical specification |
XINSTID01 | 1.49.1 | 2020-11-09 | Provider 0430 The College of Health Ltd has been added to the valid entries. No change to technical specification |
XINSTID01 | 1.48.1 | 2020-10-26 | Providers 0426 Backstage Academy (Training) Ltd, 0427 British Academy of Jewellery Limited, 0428 The London Interdisciplinary School Ltd and 0429 Raindance Educational Services Limited have been added to the valid entries. No change to technical specification |
XINSTID01 | 1.47.1 | 2020-10-13 | Providers 0423 INTO University Partnerships Limited, 0424 The College of Osteopaths and 0425 Regent's University London Limited have been added to the valid entries. No change to technical specification |
XINSTID01 | 1.46.1 | 2020-09-08 | Providers 0419 David Game College Ltd, 0420 The Dartington Hall Trust, 0421 New Model Institute for Technology and Engineering (NMITE) and 0422 Kaplan International Colleges U.K. Limited have been added to the valid entries. No change to technical specification |
XINSTID01 | 1.45.1 | 2020-09-03 | Providers 0416 Results Consortium Limited, 0417 JSA Education Group Ltd. and 0418 University Centre Quayside Limited have been added to the valid entries. No change to technical specification |
XINSTID01 | 1.44.1 | 2020-08-25 | The following valid entries labels have been updated: 0403 Bellerbys Education Services Limited changed to Study Group, 0351 Leeds College of Music to Leeds Conservatoire. No change to technical specification |
XTPOINTS | 1.17.1 | 2020-08-25 | Updated Qualtype 7V grade P tariff points from 32 to 48 to match UCAS for the 2019/20 cohort |
XPSR01 | 2.7.1 | 2020-08-11 | Technical specification has been updated for Cyy054 to include Instance_Period_Active. PERIODEND. and extra guidance |
XINSTID01 | 1.43.1 | 2020-07-27 | Provider 1195 Itchen College has been added to the valid entries. No change to technical specification |
XINSTID01 | 1.42.1 | 2020-06-25 | Provider 0415 Dyson Technical Training Limited has been added to the valid entries. No change to technical specification |
XINSTID01 | 1.41.1 | 2020-06-16 | Valid entry label 0104 The Robert Gordon University changed to Robert Gordon University following a name change. No change to technical specification |
UNISTATS_XCAH03 | 1.3.4 | 2020-05-27 | Field length amended from 3 to 11 as previously entered erroneously |
UNISTATS_COURSEAIM | 1.7.3 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
UNISTATS_XCAH03 | 1.3.3 | 2020-05-19 | Valid entries and technical specification updated to replace JACS with CAH version 1.2 |
UNISTATS_XQOBTN02 | 1.6.3 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5). Additionally valid entry H24 has been removed from the technical specification as it is no longer used |
XCAH01 | 1.1.3 | 2020-05-19 | Additional valid entry 200001 added to CAH22, this has been added as referenced in XHECOS_XFPE01 |
XCAH02 | 1.1.3 | 2020-05-19 | Additional valid entry 200001 added to CAH22-01, this has been added as referenced in XHECOS_XFPE01 |
XCAH03 | 1.1.3 | 2020-05-19 | Additional valid entry 200001 added to CAH22-01-02, this has been added as referenced in XHECOS_XFPE01 |
XGLEV301 | 1.1.3 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XGLEV501 | 1.1.3 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XHECOS_XFPE01 | 4.1.1 | 2020-05-19 | Switch of JACS to HECoS codes, dependent fields and technical specification updated to reflect the change to HECoS. Additonal section added to advise process when ITT is not returned |
XLEV301 | 1.16.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XLEV501 | 1.17.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XLEV601 | 1.16.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XOBTNG01 | 1.3.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XPDEC01 | 3.17.1 | 2020-05-19 | Additional Information section amended to remove reference to 'National College for Teaching and Leadership (NCTL) Subject Knowledge Enhancement (SKE) student instances'. Technical specification also amended to remove column Course.TTCID as this is no longer used |
XPGO01 | 1.4.1 | 2020-05-19 | New valid entries added to the technical specifications C13, J13 & H13, M13 & E13. Technical specifications also amended to include exclusion of under 18s and removal of duplicate records.Additionally the depend upon fields has been amended and XINSTID01 has been replaced by UKPRN |
XPQUAL01 | 2.20.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XPSES01 | 3.16.1 | 2020-05-19 | Additional Information section amended to remove reference to 'National College for Teaching and Leadership (NCTL) Subject Knowledge Enhancement (SKE) student instances'. Technical specification also amended to remove column Course.TTCID as this is no longer used |
XQLEV1003 | 1.12.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XQLEV301 | 1.17.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XQLEV501 | 1.17.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XQLEV601 | 1.17.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5 |
XQOBTN01 | 9.7.1 | 2020-05-19 | Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5). Additionally valid entry H24 'First degree with honours on the intercalated pattern' has been removed as it is no longer used |
XTPOINTS | 1.16.1 | 2020-05-19 | Updated name labels to match those found in Qualification.QUALTYPE |
XTPOINTSGP01 | 1.1.2 | 2020-05-19 | Technical specification tables amended for CYY051 and CYY054, NA was moved over into the XTPOINTSGP01 column |
ZWLSSBJCA02 | 1.3.1 | 2020-05-19 | Valid entry 100335 (Welsh Studies) added to additional information and technical specification |
UNISTATS_COURSEAIM | 1.7.2 | 2020-03-26 | Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 07 and M13 & E13 into 03 |
UNISTATS_XQOBTN02 | 1.6.2 | 2020-03-26 | New valid entries added C13, I13 & H13 into 07 and M13 & E13 into 03 |
XCAH01 | 1.1.2 | 2020-03-26 | The coding frame has been updated to HECoS rather than JACS valid entries |
XCAH02 | 1.1.2 | 2020-03-26 | The coding frame has been updated to HECoS rather than JACS valid entries |
XCAH03 | 1.1.2 | 2020-03-26 | The coding frame has been updated to HECoS rather than JACS valid entries |
XDOMGR01 | 5.2.2 | 2020-03-26 | Copyright information added |
XDOMGR401 | 1.1.2 | 2020-03-26 | Copyright information added |
XDOMHM01 | 2.2.2 | 2020-03-26 | Copyright information added |
XDOMREG01 | 2.1.2 | 2020-03-26 | Copyright information added |
XDOMUC01 | 6.5.2 | 2020-03-26 | Copyright information added |
XETHNIC01 | 1.6.2 | 2020-03-26 | The Technical specification section for the Student record has been updated to remove ETHNIC valid entries 11 and 12, deriving to XETHNIC01 valid entry 10 |
XETHNIC02 | 1.1.2 | 2020-03-26 | The Technical specification section for the Student record has been updated to remove ETHNIC valid entries 11 and 12, deriving to XETHNIC02 valid entry 10 |
XFTE01 | 3.4.1 | 2020-03-26 | Guidance added regarding ModuleSubject.MODSBJ within additional information to add clarification. XJACS201 has been replaced by XCAH03 and XJACS01 to XHECOS due to the change to HECoS codes |
XGLEV301 | 1.1.2 | 2020-03-26 | Technical specifications updated to add new valid entries added C13, I13 & H13 into 2 and M13 & E13 into 1 |
XGLEV501 | 1.1.2 | 2020-03-26 | Technical specifications updated to add new valid entries C13, I13 & H13 into 4 and M13 & E13 into 2 |
XHOOS01 | 2.1.2 | 2020-03-26 | Copyright information added |
XINSTC01 | 1.18.1 | 2020-03-26 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The F_XPROVTYPE01 and F_XPARTCAT01 fields has been replaced with F_XPROVCAT. These fields are not used in the derivation of XINSTC01. Copyright information has also been added to the additional information section |
XINSTCOU01 | 1.1.3 | 2020-03-26 | Copyright information added |
XINSTG01 | 3.16.1 | 2020-03-26 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The F_XPROVTYPE01 and F_XPARTCAT01 fields has been replaced with F_XPROVCAT. These fields are not used in the derivation of XINSTG01. Copyright information has also been added to the additional information section |
XLEV301 | 1.15.1 | 2020-03-26 | Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 02 and M13 & E13 into 01 |
XLEV501 | 1.16.1 | 2020-03-26 | Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 04 and M13 & E13 into 02 |
XLEV601 | 1.15.1 | 2020-03-26 | Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 05 and M13 & E13 into 03 |
XMODE01 | 3.3.2 | 2020-03-26 | Valid entry 8 'FE students in England' and 9 'Not applicable' have been removed. Valid entry 8 is derived from valid entry 99 in Instance.MODE, this is for FE students and has been removed following feedback from the sector. Valid entry 9 is derived from valid entry 98 in Instance.MODE, which is for the 'wrapper' programme aims of Apprenticeship Standards students, this has now been removed. Additional Information section amended accordingly |
XMODE301 | 1.3.2 | 2020-03-26 | Technical specification section updated to remove XMODE01 valid entries 8 and 9 from the derivation in the Cyy051 Student record |
XOBTNG01 | 1.2.1 | 2020-03-26 | Valid entries have been updated to include new entries C13, H13, I13, E13 and M13. CSV also updated to include the new entries |
XPDEC01 | 3.16.1 | 2020-03-26 | Technical specification section updated to remove Instance.MODE valid entries 98 and 99. All Course. COURSEAIM codes beginning Z has been removed from the technical specification as this was only for valid entry Z99 which has now been removed from Course.COURSEAIM. Additional Information section amended accordingly |
XPGO01 | 1.3.1 | 2020-03-26 | Technical specifications updated to remove Instance.MODE valid entry 98 |
XPQUAL01 | 2.19.1 | 2020-03-26 | The Technical Specification sections for Cyy051 and Cyy054 have been updated to add new QUAL valid entries C13, E13, H13, I13 and M13 into group code 1 |
XPSES01 | 3.15.1 | 2020-03-26 | Technical specifications updated to remove valid entries 98 and 99 from Instance.MODE, which is for the 'wrapper' programme aims of Apprenticeship Standards students, this has now been removed. Valid entry Z99 from Course.COURSEAIM also removed, additional Information section amended accordingly |
XPSR01 | 2.6.1 | 2020-03-26 | Technical specifications updated to remove valid entries 98 and 99 from Instance.MODE, which is for the 'wrapper' programme aims of Apprenticeship Standards students, this has now been removed. Additional Information section amended accordingly |
XQLEV1003 | 1.11.1 | 2020-03-26 | The Technical Specification sections for Cyy051 and Cyy054 have been updated to add new valid entries C13, H13 and I13 into group code 9 and E13 and M13 into group code 4 |
XQLEV301 | 1.16.1 | 2020-03-26 | The Technical Specification sections for Cyy051 and Cyy054 have been updated to add new valid entries C13, H13 and I13 into group code 2 and E13 and M13 into group code 1 |
XQLEV501 | 1.16.1 | 2020-03-26 | The Technical Specification sections for Cyy051 and Cyy054 have been updated to add new valid entries C13, H13 and I13 into group code 4 and E13 and M13 into group code 2 |
XQLEV601 | 1.16.1 | 2020-03-26 | The Technical Specification sections for Cyy051 and Cyy054 have been updated to add new valid entries C13, H13 and I13 into group code 5 and E13 and M13 into group code 3 |
XQMODE01 | 3.5.1 | 2020-03-26 | Valid entries 4 and 5 have been removed as they are derived from Instance.MODE valid entries 99 and 98. Technical specifications updated to remove valid entries 98 and 99 from Instance.MODE, which is for the 'wrapper' programme aims of Apprenticeship Standards students, this has now been removed. Additional Information section amended accordingly |
XQOBTN01 | 9.6.1 | 2020-03-26 | Valid entries have been updated to include new entries C13, H13, I13, E13 and M13. CSV also updated to include the new entries |
XQPREV01 | 1.1.2 | 2020-03-26 | Valid entry 2 label amended to 'Award identified as previously sent'. Valid entry 1 has been removed as this is derived from Instance.PROGTYPE which is no longer used. Technical specifications updated to remove Instance.PROGTYPE column from the table |
XTPOINTS | 1.15.1 | 2020-03-26 | The specification has been updated to remove reference to HESA Tariff stats 3, qualifications with this status have been re-assigned another HESA Tariff status where there was a confirmed grade structure (QUALTYPEs B8, B9, BG, BH, BP, BS, LD, GN, HS, MU, NR, and NS) or removed from the appendix (QUALTYPE PE). The appendix has been updated to include new tariffable qualifications (QUALTYPEs 4C, 4H, 4Q, 4S, 4T, 5C, 6X, 6Z, 7A, 7D, 7E, 7F, 7G, 7H, 7I, 7J, 7K, 7L, 7N, 7P, 7Q, 7R, 7S, 7T, 7U, 7V, 7W, 7Y, 8D, 8E, 8F, 8G, 8H, A, AB, AD, AE, AL, AO, AP, AT, B1, B2, BG, BW, BZ, C1, C3, C4, CB, CC, CE, CJ, CK, CR, CX, CZ, D2, D4, D5, D9, DA, DB, DC, DD, DE, DJ, DL, DM, DN, DO, DQ, DR, DT, DV, DW, DX, DY, DZ, E5, E6, E7, E8, E9, EA, EC, EG, EH, EI, EL, EM, EN, EV, FR, FY, GP, GR, HS, I5, I6, I9, IA, IB, IE, IF, IU, IV, KA, KB, KC, KD, KE, KF, KG, KH, KI, KJ, KK, KM, KN, KP, KQ, KR, KS, KT, KU, KV, KW, KX, KY, KZ, L1, L2, L3, L4, L5, L6, L7, L8, L9, LA, LB, LD, M5, M9, MA, MC, MD, ME, MU, N1, N2, N3, N4, NA, NB, NQ, NR, NS, NV, O6, OB, OE, P1, P2, P3, P4, P5, PK, PL, PP, PV, PW, Q4, Q5, Q6, Q7, Q8, Q9, QA, QB, QC, QD, QE, QF, QH, QN, R1, R2, R3, R4, R5, RE, RX, RY, SB, SI, SP, SX, SY, SZ, T1, T2, T3, T4, T5, TW, TX, TY, U1, U2, U3, U4, U5, U8, U9, UA, UB, UD, UH, UK, UR, UT, UU, UV, UW, UY, V4, V7, VA, VC, VE, VF, VG, VH, VI, VJ, VK, VM, VN, VP, VQ, VR, VS, VT, VU, VV, VW, VX, VY, W9, WH, WR, WU, WY, WZ, X8, Y1, Y7, YA, YE). The last sentence has been updated for points C and D within the technical specification to state 'only keep the score from the qualification which produces the highest tariff' |
ZFUNDCODE01 | 1.1.2 | 2020-03-26 | Valid entry label name changed to Fundable by funding council/body. Technical specification table created for CYY054 Student Alternative Record as only valid entries 2 for Instance.Fundcode is applicable |
ZWLSSBJCA02 | 1.2.1 | 2020-03-26 | Valid entries and technical specification updated with HECoS codes |
XINSTID01 | 1.40.1 | 2020-03-18 | The following providers have been added to the valid entries: 0412 The Council of the Inns of Court, 0413 Navitas UK Holdings Limited and 0414 The Prince's Foundation. Technical specification has been updated to remove references to XPROVTYPE01 and XPARTCAT01, this has been replaced by XPROVCAT. The Additional Information section has been added to to state where some of our data is sourced |
XPROVCAT | 1.1.1 | 2020-03-03 | Created and copyright information has also been added to the additional information section |
XINSTID01 | 1.39.1 | 2020-01-27 | A number of providers have been added, including all FECs that are submitting to Graduate Outcomes. Additional information has beeen amended to remove reference to the KIS collection. Technical specification has been updated to reference which lookup table is being used |
XINSTID01 | 1.38.1 | 2020-01-16 | The following providers have been added to the valid entries: 0363 University Global Banking School Limited and 0401 Lamda Limited. No change to technical specification |
XINSTID01 | 1.37.1 | 2019-12-13 | Valid entry label 0095 University of Abertay Dundee changed to Abertay University following a name change. No change to technical specification |
XINSTID01 | 1.36.1 | 2019-10-09 | The following providers have been added to the valid entries: 0255 London College of Business Studies, 0321 The Minster Centre, 0353 Amity Global Education, 0354 The London School of Architecture, and 0361 Newbold College. No change to technical specification |
XDOMUC01 | 6.5.1 | 2019-09-19 | The label for valid entry MM 'Burma [Myanmar]' has been updated to 'Myanmar (Burma) [The Republic of the Union of Myanmar]'. This follows a change in the labels used by the National Statistics Country Classification, which align with the labels used by ISO-3166 |
XINSTID01 | 1.35.1 | 2019-09-19 | The following provider 0322 The Sherwood Institute, has been merged with 0407 The Sherwood Psychotherapy Training Institute Limited |
XTPOINTS | 1.14.1 | 2019-09-19 | Step E – De-duplication has been updated to treat both Reformed A levels (QUALTYPEs RE, RN, RW) and A Level Double Awards (QUALTYPEs DA and D1) in the same manner as an A level (QUALTYPE A).The appendix has been updated to correct the tariff points for QUALTYPEs NT and X2, where these were erroneously recorded for QUALGRADEs D* and D |
XINSTID01 | 1.34.1 | 2019-07-25 | The following providers have been added; 0358 UK Business College Ltd, 0359 The Film Education Training Trust Limited. Removal of existing valid entries 0133 Institute of Education. No change to technical specification |
XTPOINTS | 1.13.1 | 2019-07-09 | The appendix has been updated to add new QUALTYPE and QUALGRADE combinations that result in 0 tariff points in order to aid validation. These are (QUALTYPE/QUALGRADE): IH/H7, IH/H8, IJ/O5, IJ/O6, IJ/O7, IJ/O8, UL/F |
XINSTID01 | 1.33.1 | 2019-06-19 | The following providers have been added; 0351 Leeds College of Music, 0357 ACM Guildford Limited. Removal of existing valid entries 0251 The Academy of Contemporary Music, 0235 EThames Graduate School, 0245 Grafton College, 0340 London College of Creative Media Limited |
XDOMUC01 | 6.4.1 | 2019-06-14 | Valid entries C837 'Bournemouth' and C836 'Poole' have been removed and replaced by C838 'Bournemouth, Poole and Christchurch'. Label changes for valid entries SW 'Swaziland' and MK 'Macedonia [Macedonia, The Former Yugoslav Republic of]' to Eswatini and North Macedonia respectively, this follows a change in the labels used by the National Statistics Country Classification, which now align with the labels used by ISO-3166 |
XMSFUND01 | 2.3.1 | 2019-05-23 | The technical specification section has been amended to add valid entry 08 'Research England' in Course.MSFUND |
UNISTATS_COURSEAIM | 1.7.1 | 2019-04-11 | Codes H24 have been removed |
XPDEC01 | 3.15.1 | 2019-04-11 | Addition of section 'All Course. COURSEAIM codes beginning Z' to be derived to XPDEC01 0 |
XTPOINTS | 1.12.1 | 2019-04-11 | The appendix has been updated to add new tariffable qualifications (QUALTYPES 8A, GH, GI). Qualification names have been updated for QUALTYPES X2, X4, X5, X6, X7, X9 and XA |
XETHNIC02 | 1.1.1 | 2019-03-11 | New derived field for ethnicity to split out 'Mixed' from 'Other' |
XNATGR01 | 1.7.1 | 2019-03-11 | The field has been added to the CYY054 record |
XPDEC01 | 3.14.1 | 2019-03-11 | Addition of 'Z' to the following section 'All Course. COURSEAIM codes beginning P, Q, R, S, X' |
XPQUAL01 | 2.18.1 | 2019-03-11 | The Technical Specification sections has been updated to remove QUAL valid entries L91, M91, H91 and I91 |
XCAH01 | 1.1.1 | 2019-03-07 | New derived field to determine the Common Aggregation Hierarchy, first level grouping |
XCAH02 | 1.1.1 | 2019-03-07 | New derived field to determine the Common Aggregation Hierarchy, first level grouping |
XCAH03 | 1.1.1 | 2019-03-07 | New derived field to determine the Common Aggregation Hierarchy, first level grouping |
XTPOINTS | 1.11.1 | 2019-03-07 | The appendix has been updated to add tariff points to QUALTYPES 6C, 6K, 6Z, 7A, 7D, 7W, 7X, EJ, EL, ET, EU, F5, F6, F7, F8, F9, K5, K6, NT, PM, PN, PX, PY, QJ, QK, QL, QM, RE, S9, T5, TW, TX, TY, V1, WE, WG, X2, X4, X5, X6, X7, X9 and XA |
UNISTATS_CONT_STAT | 1.1.4 | 2019-02-21 | Deriation amended to exclude Further Education students as well as where the highest qualification obtained is unknown |
XPGO01 | 1.2.1 | 2019-02-21 | Technical specifications updated to remove QUALS L91, M91, H91 and I91 |
XQLEV1003 | 1.10.1 | 2019-02-21 | The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91 |
XQLEV301 | 1.15.1 | 2019-02-21 | The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91 |
XQLEV501 | 1.15.1 | 2019-02-21 | The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91 |
XQLEV601 | 1.15.1 | 2019-02-21 | The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91 |
XQOBTN01 | 9.5.1 | 2019-02-21 | The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91 |
XINSTID01 | 1.32.1 | 2018-11-30 | The following providers have been added; 0342 Christ the Redeemer College, 0343 Waltham International College Limited, 0355 London College of International Business Studies Ltd |
XQLEV701 | 1.4.1 | 2018-11-30 | The Technical Specification section has been updated to add XQLEV501 valid entry 1 to the AP student derivations |
XINSTID01 | 1.31.1 | 2018-11-05 | The following providers have been added; 0321 The Minster Centre, 0328 London School of Commerce & IT Limited, 0352 Hartpury University and 0356 LCCM AU UK Limited. The following valid entry labels have been updated following legal name changes; 0030 Ravensboure to Ravensbourne University London, 0238 London School of Business and Management to Bloomsbury Institute. No change to technical specification |
XTPOINTS | 1.10.1 | 2018-10-30 | Following confirmation from UCAS, the tariff points have been updated for QUALTYPEs LK, LV, LW, LX |
XLEV301 | 1.14.1 | 2018-10-02 | The CYY054 Technical Specification section has been updated to add new COURSEAIM valid entries: D00, D90, L00, L80, L90, L91, L99, E00, E40, E43, E90, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, M99, H12, I12, I73 |
XTPOINTS | 1.9.1 | 2018-09-18 | A number of QUALGRADE percentages have been updated from "0.XX" format to "XX%" to align with the QUALGRADE field |
XTPOINTS | 1.8.1 | 2018-09-07 | A number of qualifications have been removed (QUALTYPES 4U, 4V, 4W, 4X, 4Y, 4Z, 5A) and replaced with QUALTYPEs RP, RQ, RR, RS, RT, RU and RV, respectively |
XLEV501 | 1.15.1 | 2018-08-21 | The CYY054 Technical Specification section has been updated to add new COURSEAIM valid entries: D00, D90, L00, L80, L90, L91, L99, E00, E40, E43, E90, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, M99, H12, I12, I73 |
XLEV601 | 1.14.1 | 2018-08-21 | The CYY054 Technical Specification section has been updated to add new COURSEAIM valid entries: D00, D90, L00, L80, L90, L91, L99, E00, E40, E43, E90, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, M99, H12, I12, I73 |
XPUBPOPG01 | 1.2.1 | 2018-08-21 | Reference to the AP Student record added for clarification |
XTPOINTS | 1.7.1 | 2018-08-21 | The qualification names have been updated to the latest versions, which now align with the names stored in QUALTYPE. A number of qualifications have been removed (QUALTYPES 6A, 5Z, 5Y, 6E, 6F, 5X, 6D) and replaced with QUALTYPEs T2, SZ, SY, T4, SX, T1 and T3, respectively |
XPQUAL01 | 2.17.1 | 2018-07-06 | The Cyy054 Technical Specification section has been updated to correct the Instance_End.EXCHIND codes |
XTPOINTS | 1.6.1 | 2018-06-29 | A number of tariffable qualifications have been added (QUALTYPEs IY, IZ, J1, J2, J3, J4, J5, J6, J7, J8, J9, JA, JB, JC, JD, JE, JF, JG, JH, JJ, JK, JL, JM, JN, JP, JQ, JR, JS, JT, JU, JV, JW, JX, JY, and JZ). Grade 'P' has been added to the Appendix for QUALTYPEs Y2 and Y5. The tariff scores for K3 Key Skills, W3 Essential Skills Wales and HK SQA Core Skill – Higher have all been updated to 0. A note has been added in the Additional information section to explain HESA's treatment of these qualifications. The number of tariff points whereby the data collection system check will warn for has been updated from greater than 1000 to greater than 400 |
XINSTID01 | 1.30.1 | 2018-05-11 | The following valid entries labels have been updated following legal name changes; 0037 Southampton Solent University changed to Solent University, 0184 The Queen's University of Belfast changed to Queen's University Belfast and 0185 University of Ulster changed to Ulster University. No change to technical specification |
XPQUAL01 | 2.16.1 | 2018-05-10 | The Technical Specification section has been updated to add QUAL valid entries D00, D90, E00, E40, E43, E90, L00, L80, L90, L91, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, H12, I12, I73 to the CYY054 section |
XQLEV1003 | 1.9.1 | 2018-05-10 | The Technical Specification section has been updated to add XQOBTN01 valid entries D00, D90, E00, E40, E43, E90, L00, L80, L90, L91, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, H12, I12, I73 |
XQLEV301 | 1.14.1 | 2018-05-10 | The Technical Specification section has been updated to add XQOBTN01 valid entries D00, D90, E00, E40, E43, E90, L00, L80, L90, L91, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, H12, I12, I73 to the CYY054 section |
XQLEV501 | 1.14.1 | 2018-05-10 | The Technical Specification section has been updated to add XQOBTN01 valid entries D00, D90, E00, E40, E43, E90, L00, L80, L90, L91, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, H12, I12, I73 to the CYY054 section |
XQLEV601 | 1.14.1 | 2018-05-10 | The Technical Specification section has been updated to add XQOBTN01 valid entries D00, D90, E00, E40, E43, E90, L00, L80, L90, L91, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, H12, I12, I73 to the CYY054 section |
XTPOINTS | 1.5.1 | 2018-05-10 | The appendix has been updated to include new tariffable qualifications |
UNISTATS_ITT | 1.4.1 | 2018-05-09 | Removed TTCID codes G and 8 to reflect their removal from C17054 and C17051 |
UNISTATS_COURSEAIM | 1.6.1 | 2018-04-26 | Code D01 has been removed |
UNISTATS_XQOBTN02 | 1.6.1 | 2018-04-26 | Code D01 has been removed |
XPQUAL01 | 2.15.1 | 2018-04-26 | The Technical Specification section has been updated to remove QUAL D01 |
XTPOINTS | 1.4.1 | 2018-04-26 | The appendix has been updated to include new tariffable qualifications |
XGLEV301 | 1.1.1 | 2018-04-05 | Field created |
XGLEV501 | 1.1.1 | 2018-04-05 | Field created |
XOBTNG01 | 1.1.1 | 2018-04-05 | Created |
XPGO01 | 1.1.1 | 2018-04-05 | Field Created |
XPUBPOPG01 | 1.1.1 | 2018-04-05 | Field created |
XQLEV1003 | 1.8.1 | 2018-02-22 | The Technical Specification section has been updated to remove XQOBTN01 valid entry D01 |
XQOBTN01 | 9.4.1 | 2018-02-22 | The Technical Specification section has been updated to remove XQOBTN01 valid entry D01 |
XQPREV01 | 1.1.1 | 2018-02-22 | New field for 2017/18 |
XTPOINTSGP01 | 1.1.1 | 2018-02-22 | Created for 2017/18 |
XTPOINTS | 1.3.1 | 2018-02-07 | The De-duplication section has been moved from Step B to Step E. Information within this section has also been updated to identify a second exception to the de-duping process (where an IB exists alongside an IC and/or an IX |
XCLASS01 | 1.6.1 | 2018-01-31 | Technical specification amended to remove XCLASSF01 valid entries 04 and 06 |
XCLASSF01 | 1.2.1 | 2018-01-31 | Valid entries 04 'Undivided second class honours' and 06 'Fourth class honours' have been removed |
XLEV301 | 1.13.1 | 2018-01-31 | The CYY051 Technical Specification section has been updated to remove COURSEAIM valid entry D01 |
XLEV501 | 1.14.1 | 2018-01-31 | The CYY051 Technical Specification section has been updated to remove COURSEAIM valid entry D01 |
XLEV601 | 1.13.1 | 2018-01-31 | The CYY051 Technical Specification section has been updated to remove COURSEAIM valid entry D01 |
XMSTUFEE01 | 1.5.1 | 2018-01-31 | Technical Specification section updated to remove MSTUFEE valid entry 07. This change applies to both records |
XQLEV301 | 1.13.1 | 2018-01-31 | The Technical Specification section has been updated to remove XQOBTN01 valid entry D01 |
XQLEV501 | 1.13.1 | 2018-01-31 | The Technical Specification section has been updated to remove XQOBTN01 valid entry D01 |
XQLEV601 | 1.13.1 | 2018-01-31 | The Technical Specification section has been updated to remove XQOBTN01 valid entry D01 |
XINSTID01 | 1.29.1 | 2018-01-02 | The following valid entries labels have been updated: 0032 Rose Bruford College changed to Rose Bruford College of Theatre and Performance, 0121 The University of Keele changed to Keele University, 0146 The School of Oriental and African Studies changed to SOAS University of London, 0211 Leeds College of Art changed to Leeds Arts University, 0213 AECC Chiropractic College changed to AECC University College, 0217 The London Institute of Banking and Finance changed to The London Institute of Banking & Finance, 0244 Arts Educational School changed to Arts Educational Schools, 0309 Point Blank Music College changed to Point Blank Music School, 0337 The British School of Osteopathy changed to The University College of Osteopathy, 0340 London Centre of Contemporary Music changed to London College of Creative Media Limited. No change to technical specification |
XETHNIC01 | 1.6.1 | 2017-10-31 | The Technical specification section for the AP student record has been updated to add new ETHNIC valid entries 13 and 19, deriving to XETHNIC01 valid entry 10 |
XPSR01 | 2.5.1 | 2017-09-05 | Addition of Instance.MODE to the technical specification for the Cyy054 AP student record |
XTPOINTS | 1.2.1 | 2017-09-05 | Appendix 1 updated to correct the tariff points of BTEC Specialist Diploma - QUALTYPE 1B - QUALGRADEs M, D / BTEC Specialist Certificate - QUALTYPE 2B - QUALGRADEs M, D / BTEC Specialist Award - QUALTYPE 3B - QUALGRADEs M, D / BTEC Lvl 3 National Certificate (NQF/CQF) - QUALTYPE 4C - QUALGRADEs PP, MP, MM, DM, DD / GCE Advanced level - QUALTYPE A - QUALGRADEs *, *d, *m, *p / GCE Advanced Level (with Advanced Subsidiary) - QUALTYPE AN - QUALGRADEs EE, DE, DD, CD, CC, BC, BB, AB, AA, A*A, *A / BTEC Lvl 3 National Award (NQF/CQF) - QUALTYPE BD - QUALGRADEs P, M, D / BTEC Lvl 3 National Diploma (NQF/CQF) - QUALTYPE BF - QUALGRADEs PPP, MPP, MMP, MMM, DMM, DDM, DDD / BTEC Lvl 3 Subsidiary Dip (was National Award 60+) (QCF/CQF) - QUALTYPE BU - QUALGRADEs S, P, M, D*, D / BTEC Lvl 3 Diploma (was National Certificate 120+) (QCF/CQF) - QUALTYPE BV - QUALGRADEs SS, SD, PP, MP, MM, DM, DD, D*D*, D*D / BTEC Lvl 3 Extended Dip (was National Dip. 180+) (QCF/CQF) - QUALTYPE BW - QUALGRADEs SSS, SSD, SDD, PPP, MPP, MMP, MMM, DMM, DDM, DDD, D*DD, D*D*D*, D*D*D / BTEC Lvl 3 Foundation Diploma (NQF/FAD) - QUALTYPE BX - QUALGRADEs P, M, D / NCFE CACHE Diploma in Childcare and Education (Early Years Educator) - QUALTYPE CF - QUALGRADEs D, C, B, A*, A / CACHE Level 3 Diploma in Childcare and Education (Early Years Educator) (VRQ) - QUALTYPE CJ - QUALGRADEs D, C, B, A*, A / Sports Leaders UK - Higher Sports Leader Award (QCF) - QUALTYPE HL - QUALGRADEs P, Pass / Pearson BTEC Level 3 Certificate in Understanding Sports Performance (QCF) - QUALTYPE PJ - QUALGRADEs P, Pass |
UNISTATS_ITT | 1.3.1 | 2017-08-25 | Updated TTCID codes for AP student to reflect schema additions for C15054 and C16054 |
XPSES01 | 3.14.1 | 2017-06-01 | Technical specification for the Cyy051 Student record updated to cater for instances where the Course.COURSEAIM is returned as Z99 |
UNISTATS_ITT | 1.2.5 | 2017-02-17 | Updated TTCID codes to reflect codes in place for 15/16 |
UNISTATS_XQOBTN02 | 1.5.1 | 2017-02-17 | Added in new codes I78 and M73 |
XETHNIC01 | 1.5.1 | 2017-02-10 | The Technical specification section for the Student record has been updated to add new ETHNIC valid entries 11 and 12, deriving to XETHNIC01 valid entry 10 |
XSTUDIS01 | 1.4.1 | 2017-02-10 | The Technical specification section for the Student record has been updated to remove discontinued DISABLE valid entries 02, 03, 04, 05, 06, 07, 10, 11, 97, 98, and 99. XSTUDIS01 valid entries E, L, M, and N removed, as no source valid entry can now derive to them |
XTPOINTS | 1.1.1 | 2017-01-31 | First production version of this specification. Appendix 1 updated for new combinations of QUALTYPEs and QUALGRADEs made available by UCAS for the 2016/17 academic year |
XTPOINTS | 0.5 | 2017-01-16 | Appendix 1 updated to remove duplicated entries for QUALTYPEs A3-A9 and AY, and revising the labels for the above |
XHECOS_XFPE01 | 3.6.1 | 2016-11-03 | Technical specification updated to revert the form of the Cyy054_SJ table to that of version 3.3.1 and before, requiring InstanceKEY to be present. Technical specification updated to reflect the deletion of Course.TTCID valid entries 8 and G in the list of codes that define ITT in sections i to iv |
XHECOS_XFPE01 | 3.5.2 | 2016-11-01 | Technical specification updated to add an instruction to the XFPE01 header column of scenarios 'iii' and 'iv', stating that where the calculation results in a value in excess of three decimal places, the results should be truncated. This step was not previously explicit |
XINSTID01 | 1.28.1 | 2016-11-01 | Valid entries updated to include providers expected to return data to HESA for the 16/17 collections |
XLEV301 | 1.12.1 | 2016-11-01 | The Technical Specification section has been updated to add new COURSEAIM valid entries to the Student and AP student derivations, which result from the additions of new valid entries in the respective records. M73, I78 and Z99 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M71, M73 and I78 have been added to the Cyy054 section. I73 has been removed from the Cyy054 section |
XLEV501 | 1.13.1 | 2016-11-01 | The Technical Specification section has been updated to add new COURSEAIM valid entries to the Student and AP student derivations, which result from the additions of new valid entries in the respective records. M73, I78 and Z99 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M71, M73 and I78 have been added to the Cyy054 section. I73 has been removed from the Cyy054 section |
XLEV601 | 1.12.1 | 2016-11-01 | The Technical Specification section has been updated to add new COURSEAIM valid entries to the Student and AP student derivations, which result from the additions of new valid entries in the respective records. M73, I78 and Z99 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M71, M73 and I78 have been added to the Cyy054 section. I73 has been removed from the Cyy054 section |
XMODE01 | 3.3.1 | 2016-11-01 | New valid entry 9 'Not applicable' added to the field. This is derived from new valid entry 98 in Instance.MODE, which is only available for the 'wrapper' programme aims of Apprenticeship Standards students. Additional Information section amended accordingly |
XMODE301 | 1.3.1 | 2016-11-01 | Technical specification section updated to add new XMODE01 valid entry 9 to the derivation in the Cyy051 Student record. New XMODE02 valid entry 4 added to the derivation in the Cyy054 AP student record |
XMSFUND01 | 2.2.1 | 2016-11-01 | The technical specification section has been amended to remove valid entry 12 'BIS' in Course.MSFUND, as it has been removed for 2016/17, and add code 39 'Skills Funding Agency', which is new. The additional information section has been amended to update the name of the former Department for Employment and Learning Northern Ireland (DEL(NI)) to Department for the Economy Northern Ireland (DfE(NI |
XMSTUFEE01 | 1.4.1 | 2016-11-01 | Technical Specification section updated to remove MSTUFEE valid entry 05, replacing it with 91, and removing MSTUFEE valid entry 33. These changes apply in both records |
XPDEC01 | 3.13.1 | 2016-11-01 | Addition of new Instance.MODE code 98 to Cyy051 Student record technical specification, with associated text regarding Apprenticeship Standards added to the exclusions in the standard definition section. Deletion of Course.TTCID valid entries 8 and G. In the Cyy054 student record an additional column has been added to enfore the exclusion of new Instance_End.MODE valid entries 43 and 44 |
XPQUAL01 | 2.14.1 | 2016-11-01 | The Technical Specification section has been updated to add new QUAL valid entries to the Student and AP student derivations, which result from the additions of new valid entries in the respective records. M73, I78 have been added to the Cyy051 section, with Z-series codes added as an exclusion; M00, M01, M02, M10, M11, M16, M41, M42, M44, M71, M73 and I78 have been added to the Cyy054 section |
XPSES01 | 3.13.1 | 2016-11-01 | Addition of new Instance.MODE code 98 to the technical specification for the Cyy051 Student record, with associated text regarding Apprenticeship Standards added to the exclusions in the standard definition section. Deletion of Course.TTCID valid entries 8 and G |
XPSR01 | 2.4.2 | 2016-11-01 | Text regarding Apprenticeship Standards added to the exclusions in the standard definition section, with a note explaining the pre-exclusion of new Instance.MODE code 98 in XPSES01 added below the technical specification for the Cyy051 Student record |
XQLEV1003 | 1.7.1 | 2016-11-01 | The Technical Specification section has been updated to add new XQOBTN01 valid entries to the Student and AP student derivations, which result from the additions of new valid entries for the XQOBTN01 field for the respective records in 16/17. M73 and I78 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M41, M42, M44, M73 and I78 have been added to the Cyy054 section. M71 added to Cyy054 as it had been omitted in error |
XQLEV301 | 1.12.1 | 2016-11-01 | The Technical Specification section has been updated to add new XQOBTN01 valid entries to the Student and AP student derivations, which result from the additions of new valid entries for the XQOBTN01 field for the respective records in 16/17. M73 and I78 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M41, M42, M44, M73 and I78 have been added to the Cyy054 section. M71 added to Cyy054 as it had been omitted in error |
XQLEV501 | 1.12.1 | 2016-11-01 | The Technical Specification section has been updated to add new XQOBTN01 valid entries to the Student and AP student derivations, which result from the additions of new valid entries for the XQOBTN01 field for the respective records in 16/17. M73 and I78 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M41, M42, M44, M73 and I78 have been added to the Cyy054 section. M71 added to Cyy054 as it had been omitted in error |
XQLEV601 | 1.12.1 | 2016-11-01 | The Technical Specification section has been updated to add new XQOBTN01 valid entries to the Student and AP student derivations, which result from the additions of new valid entries for the XQOBTN01 field for the respective records in 16/17. M73 and I78 have been added to the Cyy051 section; M00, M01, M02, M10, M11, M16, M41, M42, M44, M73 and I78 have been added to the Cyy054 section. M71 added to Cyy054 as it had been omitted in error |
XQLEV701 | 1.3.1 | 2016-11-01 | The Technical Specification section has been updated to add newly available XQLEV501 valid entry 2 to the AP student derivations, which result from the additions of new valid entries for the XQOBTN01 field for that record |
XQMODE01 | 3.4.1 | 2016-11-01 | The Technical Specification section has been revised to add a derivation in the Student record section, with a consequent new valid entry. A new Instance.MODE code (98) has been added, deriving to new XQMODE01 valid entry 5. In the AP student record section, new Instance_End.MODE codes 43 and 44 have been added, deriving to existing XQMODE01 valid entries 1 and 2 respectively |
XQOBTN01 | 9.3.1 | 2016-11-01 | Valid entries revised to add codes associated with new valid entries in QualificationsAwarded.QUAL: M73 and I78. These entries have been added to T_QUAL_RANK_LOOKUP |
XQOBTN01 | 9.3.1 | 2016-11-01 | Valid entries revised to remove D01 associated with old valid entries in QualificationsAwarded.QUAL |
XTPOINTS | 0.4 | 2016-11-01 | First 2016/17 version created of this specification, following drafting process in 2015/16 |
XAGEJ01 | 1.4.2 | 2016-10-15 | Technical specification corrected to replace an error in the table. The first row of the 'Otherwise' section should derive to 'DIFF' |
XDOM01 | 2.4.1 | 2016-10-15 | The labels for valid entries BF 'Burkina [Burkina Faso]' and SR 'Surinam [Suriname]' have been updated to 'Burkina Faso' and 'Suriname' respectively. This follows a change in the labels used by the National Statistics Country Classification, which now align with the labels used by ISO-3166 |
XDOMUC01 | 6.3.1 | 2016-10-15 | The labels for valid entries BF 'Burkina [Burkina Faso]' and SR 'Surinam [Suriname]' have been updated to 'Burkina Faso' and 'Suriname' respectively. This follows a change in the labels used by the National Statistics Country Classification, which now align with the labels used by ISO-3166 |
XINSTID01 | 1.27.1 | 2016-09-28 | Valid entries updated to include Alternative providers (APs) contracted to return data to HESA for the 15/16 collections: ranges 0214 - 0227, 0231 - 0333 and 0338 - 0339. Removal of existing valid entry 0133 Institute of Education, which has merged with 0149 University College London. Label updates to existing valid entries 0145 St. George's, University of London; 0154 Newcastle University; 0189 Writtle University College; and 0210 University of Suffolk. No change to technical specification |
XDOMGR01 | 5.2.1 | 2016-09-12 | Technical specification revised to update references to T_OVERSEAS_LOOKUP_V8, which has been replaced with T_OVERSEAS_LOOKUP_V9 |
XNATGR01 | 1.6.1 | 2016-09-12 | Technical specification revised to update references to T_OVERSEAS_LOOKUP_V8, which has been replaced by T_OVERSEAS_LOOKUP_V9 |
ZFUNDCODE01 | 1.1.1 | 2016-07-11 | Created |
ZLANGPCNT01 | 1.1.1 | 2016-07-11 | Created |
ZWLSSBJCA02 | 1.1.1 | 2016-07-11 | Created |
XUHN01 | 1.1.1 | 2016-07-04 | Created |
UNISTATS_CLASS | 3.3.1 | 2016-04-26 | Codes 04 and 06 have been removed following their removal from CLASS |
XREG01 | 3.6.1 | 2016-03-31 | Technical Specification Step 2 updated to use RSNEND values in assigning collaborative provision instances, and updated to state the treatment of records on the Continuity register for which no corresponding instance is submitted in the reporting period |
UNISTATS_CLASS | 3.2.1 | 2016-03-09 | Added new valid entries for Pass, Merit and Distinction |
XINSTID01 | 1.26.1 | 2016-02-25 | Valid entries aligned with those providers contractually agreed to return data to HESA for the 15/16 collections, which currently excludes Alternative providers (APs). No change to technical specification |
UNISTATS_COURSEAIM | 1.5.1 | 2016-02-20 | Added in codes I78, M73 and Z99 |
XQLEV1003 | 1.6.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XQLEV301 | 1.11.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XQLEV501 | 1.11.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XQLEV601 | 1.11.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XQLEV701 | 1.2.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XQMODE01 | 3.3.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XQOBTN01 | 9.2.1 | 2016-02-09 | Technical Specification revised to delete the existing specification table, and insert references to a new centralised lookup table to be provided by Data Management - T_QUAL_RANK_LOOKUP |
XQUALENT01 | 1.5.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XSTUDIS01 | 1.3.1 | 2016-02-09 | The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function |
XLEV301 | 1.11.1 | 2016-02-08 | Technical specification section updated to split out the Student and AP student collection derivations, as the AP student collection only uses a subset of the codes available to Student. No change to function |
XLEV501 | 1.12.1 | 2016-02-08 | Technical specification section updated to split out the Student and AP student collection derivations, as the AP student collection only uses a subset of the codes available to Student. No change to function |
XLEV601 | 1.11.1 | 2016-02-08 | Technical specification section updated to split out the Student and AP student collection derivations, as the AP student collection only uses a subset of the codes available to Student. No change to function |
XMODE301 | 1.2.1 | 2016-02-08 | Technical specification section updated to split out the Student and AP student collection derivations, as the AP student collection uses a different derived field with a different set of codes. No change to function |
XEPYEAR01 | 2.2.1 | 2016-01-12 | Technical specification updated to unambiguously express the value that should be created in this field. No change to function |
XETHNIC01 | 1.4.1 | 2016-01-12 | The Technical specification section has been updated to separate out the Student and AP student derivations, which have different cohorts of potential ETHNIC valid entries. No change to function |
XYEARM01 | 2.5.1 | 2016-01-12 | Technical specification updated to unambiguously express the value that should be created in this field. No change to function |
XDOMHM01 | 2.2.1 | 2016-01-11 | XDOMGR01 valid entry GROO removed from Technical Specification section. This valid entry is no longer derived in XDOMGR01, and does not need to be accounted for in XDOMHM01 |
XMSTUFEE01 | 1.3.1 | 2016-01-08 | Valid entry 03 relabelled from 'Institutional waiver/award' to 'Provider waiver/award' for consistency across HESA output. Technical specification section updated to split out the Student and AP student collection derivations, as the AP student collection only uses a subset of the codes available to Student. No change to function |
XETHNIC01 | 1.3.1 | 2015-09-29 | Technical specification amended to derive those for whom a domicile cannot be established to a new valid entry, 'UN'. Previously an assumption was made within derived field XHOOS01 which is no longer the case, and the resulting amendment to that field needs to be dealt with in XETHNIC01 |
UNISTATS_CONT_STAT | 1.1.3 | 2015-08-20 | Added in derivation for AP student |
UNISTATS_ITT | 1.2.4 | 2015-08-20 | Derivation table added for AP student |
UNISTATS_MODE | 1.2.5 | 2015-08-20 | Additional information’ updated to include information on AP student derived field |
UNISTATS_TPROV | 1.1.2 | 2015-08-20 | Updated to include derivation for AP student |
UNISTATS_XCAH03 | 1.3.2 | 2015-08-20 | Included reference for AP student data 2014/15 |
UNISTATS_CONT_STAT | 1.1.2 | 2015-07-10 | Added in Unistats field to specification |
UNISTATS_HIQUAL2 | 1.1.2 | 2015-07-10 | Added new Unistats field to specification |
XHECOS_XFPE01 | 3.5.1 | 2015-07-07 | Technical specification updated to split the creation of the Cyy054_SJ table out from that of the Cyy051_SJ table, as the Cyy054_SJ table need not be created on a per-InstanceKEY basis, and the method for creation is now correspondingly different |
ZNOTEND01 | 1.1.1 | 2015-07-01 | Created |
XLEV601 | 1.10.2 | 2015-06-18 | Minor error correction to Technical Specification: an instance of 'I9' in the listed Course.COURSEAIMs which derive to valid entry 5 in this derived field has been corrected to read 'I99' |
ZSTARTMONTH01 | 1.1.1 | 2015-06-15 | Created |
ZSTARTYEAR01 | 1.1.1 | 2015-06-15 | Created |
XDOMUC01 | 6.2.1 | 2015-06-03 | Valid entries for Northern Ireland revised in line with changes to local government geographies. Valid entries C011 - C036 removed, C040 - C051 added |
XINSTID01 | 1.25.1 | 2015-06-03 | Valid entry label 0010 Royal Central School of Speech and Drama changed to The Royal Central School of Speech and Drama following a name change. No change to technical specification |
UNISTATS_XQOBTN02 | 1.4.1 | 2015-05-27 | Added in new codes H12, I12, I73 |
XINSTID01 | 1.24.1 | 2015-05-19 | Valid entry 0264 removed and replaced with 0327 following clarification of the structure of the Regents English Language Centre, International Bible Institute of London |
XMSTUFEE01 | 1.2.1 | 2015-04-16 | Valid entry 30 added to Technical Specification. This valid entry is only available in the Cyy051 Student record |
XINSTCOU01 | 1.1.2 | 2015-04-01 | Minor error correction to bottom row of Technical Specification table, correcting the cited UKPRN of '10007774' to '10007773' |
XCLASSF01 | 1.1.2 | 2015-03-30 | Error corrected in Technical Specification table: the values for the 'Number of these qualifications ranked highest using associated CLASS values nearest 01' column changed from 1 and 2 to 1 and >1 in line with the text |
XCLASS01 | 1.5.1 | 2015-03-12 | Technical specification amended to add XCLASSF01 valid entry A to those which derive to XCLASS01 valid entry A |
XHOOS01 | 2.1.1 | 2015-03-03 | Addition of valid entry 3 'Not known' to accommodate the addition of corresponding valid entry 8 in XDOMHM01 |
UNISTATS_COURSEAIM | 1.3.1 | 2015-02-20 | Added code M28 (note: H24 is no longer valid code in 2013/14, left in to make this spec backwards compatible |
XINSTC01 | 1.17.3 | 2015-02-12 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTC01 |
XINSTG01 | 3.15.3 | 2015-02-12 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTG01 |
XINSTID01 | 1.23.2 | 2015-02-12 | Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly due to further changes made to the contents. The 'F_PROVIDER' field has been replaced with F_XPROVTYPE01 and F_XPARTCAT01. These fields are not used in the derivation of XINSTID01. Additional information text updated to refer to the change in lookup table use for 2014/15 |
UNISTATS_COURSEAIM | 1.4.1 | 2015-02-10 | Added in codes H12, I12, I73 |
XDOMGR401 | 1.1.1 | 2015-01-09 | Created for 2014/15 |
XMODE301 | 1.1.1 | 2015-01-09 | Created for 2014/15 |
XQLEV701 | 1.1.1 | 2015-01-09 | Created for 2014/15 |
XCLASS01 | 1.4.1 | 2015-01-08 | Technical specification text amended slightly to make record references generic, in light of the intention to use this field in the Cyy054 AP student record. Function amended to aggregate the data derived in new derived field XCLASSF01 |
XCLASSF01 | 1.1.1 | 2015-01-08 | Created |
XINSTCOU01 | 1.1.1 | 2014-12-09 | Created |
XINSTID01 | 1.23.1 | 2014-11-18 | The following providers have been added to the valid entries: 0229 The National Film and Television School and 0230 Plymouth College of Art, plus providers constituent of the AP student collection. Technical specification amended to replace the lookup table used to obtain the HESA identifier value with static_data.insthqpc_lookup_(Y2)aug |
XINSTID01 | 1.22.1 | 2014-11-17 | Valid entry label 0113 Brunel University changed to Brunel University London following name change |
XAGEA01 | 1.6.1 | 2014-10-16 | Technical specification amended to allow for the use of this field in the Cyy054 AP student record |
XAGEJ01 | 1.4.1 | 2014-10-16 | Technical specification amended to allow for the use of this field in the Cyy054 AP student record |
XDOM01 | 2.3.2 | 2014-10-16 | Additional information section updated to make record references generic, in light of the use this field in the Cyy054 AP student record. Long name of the field changed to 'Domicile (Processing)' for the same reason |
XDOMGR01 | 5.1.1 | 2014-10-16 | Technical specification revised to remove the stage which referred to the FEEELIG field. Null entries in POSTCODE in combination with null or 'ZZ' in DOMICILE will now derive directly to new valid entry NOTK 'Not known'. Removal of valid entry GROO 'Non-European Union unknown' as a consequence |
XDOMHM01 | 2.1.1 | 2014-10-16 | Valid entry 8 'Not known' added, to allow for new valid entry NOTK in XDOMGR01. Technical specification and Additional information sections adapted accordingly |
XDOMREG01 | 2.1.1 | 2014-10-16 | Valid entry NOTK 'Not known' added, to allow for new valid entry NOTK in XDOMGR01, with the removal of valid entry GROO for the same reason. Technical specification and Additional information sections adapted accordingly |
XDOMUC01 | 6.1.1 | 2014-10-16 | Technical specification revised to remove the stage which referred to the FEEELIG field. Null entries in POSTCODE in combination with null or 'ZZ' in DOMICILE will now derive directly to new valid entry NOTK 'Not known'. Removal of valid entry FSOS 'Overseas - determined by fee eligibility' as a consequence |
XELSP01 | 1.4.2 | 2014-10-16 | Additional information text amended to allow for the use of this field in the Cyy054 AP Student record |
XEPYEAR01 | 2.1.2 | 2014-10-16 | Long name of field changed to refer to 'UHN' rather than 'HIN', with reference made in the Additional information section to what this is. Reference in this section to the 'HIN_EP register' changed to 'Continuity register' to reflect a change in name from 2014/15 onwards |
XETHNIC01 | 1.2.2 | 2014-10-16 | Technical specification amended to allow for the use of this field in the Cyy054 AP student record |
XFYEAR01 | 1.2.5 | 2014-10-16 | Technical specification text amended to allow for the use of this field in the Cyy054 AP student record |
XFYRSR01 | 1.2.4 | 2014-10-16 | Technical specification text amended to allow for the use of this field in the Cyy054 AP student record |
XHECOS_XFPE01 | 3.4.1 | 2014-10-16 | Technical specification updated to reflect the addition of Course.TTCID valid entry Q, and the deletion of valid entries L, M, N and P, in the list of codes that define ITT in sections i) to iv). Change to function. Additional information section amended to allow for the use of this field in the Cyy054 AP student record |
XINSTC01 | 1.17.2 | 2014-10-16 | Additional information section amended to allow for the use of this field in the Cyy054 AP student record. Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly in light of changes made to the contents |
XINSTG01 | 3.15.2 | 2014-10-16 | Additional information section amended to allow for the use of this field in the Cyy054 AP student record. Technical specification updated to describe the STATIC_DATA.INSTHQPC_LOOKUP_(Y2)AUG lookup table correctly in light of changes made to the contents |
XLEV301 | 1.10.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) COURSEAM codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XLEV501 | 1.11.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) COURSEAM codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XLEV601 | 1.10.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) COURSEAM codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XMODE01 | 3.2.1 | 2014-10-16 | 'Definition' section within Additional Information removed as it duplicates the Technical Specification |
XMSTUFEE01 | 1.1.3 | 2014-10-16 | Additional Information section amended to allow for the use of this field in the Cyy054 AP student record. Technical Specification field header adjusted for the same reason |
XPDEC01 | 3.12.1 | 2014-10-16 | Addition of new section in the Technical Specification to allow for processing in the AP student record, with a corresponding update to the Additional Information section text to describe the derivation of this derived field on that record. The Course.TTCID codes used in the Student record derivation have been revised in line with changes to the valid entries in that field |
XPQUAL01 | 2.13.1 | 2014-10-16 | Addition of new section in the Technical Specification to allow for processing in the AP student record, with a corresponding update to the Additional Information section text to describe the derivation of this derived field on that record. Addition of new QualificationsAwarded.QUAL valid entry H12, I12 and I73 to Technical Specification, Student record, with the removal of valid entry H24 as it has been removed from the field for 2014/15 |
XPSES01 | 3.12.1 | 2014-10-16 | Addition of new section in the Technical Specification to allow for processing in the AP student record, with a corresponding update to the Additional Information section text to describe the derivation of this derived field on that record. The Course.TTCID codes used in the Student record derivation have been revised in line with changes to the valid entries in that field |
XPSR01 | 2.4.1 | 2014-10-16 | Addition of new section in the Technical Specification to allow for processing in the AP student record, with a corresponding update to the Additional Information section text to describe the derivation of this derived field on that record |
XQLEV1003 | 1.5.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XQLEV301 | 1.10.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XQLEV501 | 1.10.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XQLEV601 | 1.10.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly |
XQMODE01 | 3.2.1 | 2014-10-16 | Additional Information section amended to allow for the use of this field in the Cyy054 AP student record. Technical Specification field header adjusted for the same reason. 'Definition' section within Additional Information removed as it duplicates the Technical Specification |
XQOBTN01 | 9.1.1 | 2014-10-16 | Addition of new Early Years Teacher Status (EYTS) codes H12, I12, and I73 to valid entries and Technical Specification ranking table, due to their addition in QualificationsAwarded.QUAL. Technical specification amended to account for the use of this field in the AP student record, and the possibility that many QualificationsAwarded entities may be returned instead of the maximum of two permitted under Student |
XQUALENT01 | 1.4.1 | 2014-10-16 | Added new EntryProfile.QUALENT3 valid entry P54 to Technical Specification, and removed sections which dealt with EntryProfile.QUALENT2 field, which has now been removed from the record. Additional Information section amended to allow for the use of this field in the Cyy054 AP student record |
XREG01 | 3.5.1 | 2014-10-16 | Long name of field changed to refer to 'Continuity register' rather than 'HIN register', to reflect a change in name of this register from 2014/15 onwards. References within text likewise updated. The associated table name for this register updated from 'HINEP_Register' to 'Continuity_Register'. Field locations referenced in the Technical Specification section amended to allow for the use of this field in the Cyy054 AP student record |
XSTUDIS01 | 1.2.1 | 2014-10-16 | Additional Information section amended to allow for the use of this field in the Cyy054 AP student record. Technical Specification field header adjusted for the same reason |
XYEARM01 | 2.4.1 | 2014-10-16 | Long name of field changed to refer to 'UHN' rather than 'HIN', with reference made in the Additional Information section to what this is. References in this section to the 'Register_static' changed to 'Continuity register' to reflect a change in name from 2014/15 onwards. Technical Specification section amended to allow for the use of this field in the Cyy054 AP student record, adding a separate specification section for this record |
XDOM01 | 2.3.1 | 2014-10-10 | Valid entry BO relabelled to 'Bolivia [Bolivia, Plurinational State of]', LY to 'Libya' and VE 'Venezuela [Venezuela, Bolivarian Republic of]' to reflect the ISO-3166-1 and the National Statistics Country Classification (NSCC) standards |
XINSTID01 | 1.21.1 | 2014-09-22 | Valid entry label 0064 Leeds Metropolitan University changed to Leeds Beckett University following name change. References to the static data lookup table 'static_data.ukprn_lookup_2013_14' have been made generic with regards to the year reference it uses, with associated guidance added to explain the naming protocol. Higher education provider (HEP) name change applied to field. Subsequent long name change |
XINSTC01 | 1.17.1 | 2014-08-27 | Higher education provider (HEP) name change applied to field. Subsequent long name change. Valid entries changed to 'England', 'Wales', 'Scotland' and 'Northern Ireland' from 'English institution', 'Scottish institution' etc |
XINSTG01 | 3.15.1 | 2014-08-27 | Higher education provider (HEP) name change applied to field. Subsequent long name change |
UNISTATS_TPROV | 1.1.1 | 2014-08-20 | For student data from 2014/15, replaces UNISTATS_TINSTMERGE, this version highlights the difference |
UNISTATS_XQOBTN02 | 1.3.1 | 2014-06-22 | Added in new code M28 |
XINSTID01 | 1.20.2 | 2014-06-06 | Valid entry label St Mary's University College, Twickenham changed to St Mary's University, Twickenham following name change. No change to technical specification |
XDOMUC01 | 5.4.1 | 2014-05-09 | Valid entry BO relabelled to 'Bolivia [Bolivia, Plurinational State of]', LY to 'Libya' and and VE 'Venezuela [Venezuela, Bolivarian Republic of]' to reflect the ISO-3166-1 and the National Statistics Country Classification (NSCC) standards |
XYEARM01 | 2.3.1 | 2014-04-14 | Technical specification amended to reinstate Instance.MODE 61, which is present on the HIN register |
XREG01 | 3.4.1 | 2014-04-02 | Technical Specification amended to reinstate Instance.MODE 61, which is present on the HIN register |
XNATGR01 | 1.5.1 | 2014-02-22 | Technical specification updated for new version of the overseas lookup table - T_OVERSEAS_LOOKUP_V6 replaced with T_OVERSEAS_LOOKUP_V8. This revision reallocates the region associated with Croatia from GROE to GREU. Technical specification amended to output Null in the event of no entry being found in T_OVERSEAS_LOOKUP_V8. This is consistent with behaviour in other derived fields, and prevents the function from failing |
UNISTATS_COURSEAIM | 1.2.1 | 2014-02-10 | Added in codes M44 and H62 |
XPDEC01 | 3.11.1 | 2014-01-23 | Addition of new Course.TTCID codes L, M, N and P to technical specification, with removal of deleted codes J and K. Addition of new Instance.LOCSDY codes T, U, and Z to technical specification, with removal of deleted codes A, B, F, G, M, N, P, Q, R and X. Addition of new Instance.EXCHANGE codes G and N to technical specification, with removal of deleted codes 0, 2, 7, 8, 9, A, B, C, D and E. Addition of new Instance.MODE code 99 to technical specification, with removal of deleted codes 32, 37, 52, 53, 66, 67, 68 and 69. Change of name from 'Teaching Agency' to 'National College for Teaching and Leadership' in exclusion 5. Further information on the reason for the exclusion of incoming visiting and exchange students added to the 'Standard Definition' section |
XINSTID01 | 1.20.1 | 2014-01-13 | Technical specification updated referencing static_data.ukprn_lookup_2013_14 for 2013/14 XINSTID01. Update to legal names, removing 'The' from University of 0069 Northumbria at Newcastle, 0046 University of Worcester, 0155 University of Nottingham, 0154 University of Newcastle-upon-Tyne and 0073 University of Plymouth. Name change of 0090 University of Glamorgan to University of South Wales. Removal of the following KIS only subscribers from XINSTID01; 0216 Regent's University London, 0220 Institute of Contemporary Music Performance, 0221 Moorlands College, 0223 Redcliffe College, 0225 Mattersey Hall and 0227 London School of Science and Technology - with explanatory note added to the Additional information section |
XINSTID01 | 1.19.1 | 2013-12-05 | The following provider has been removed from the valid entries: 0086 The University of Wales Newport. The following provider has been added to the list of valid entries: 0228 Liverpool School of Tropical Medicine |
XINSTID01 | 1.18.1 | 2013-12-04 | The following name change has been applied: 0139 Queen Mary University of London |
XINSTID01 | 1.17.1 | 2013-11-06 | The following name change has been applied: 0217 IFS School of Finance to IFS University College |
XQOBTN01 | 8.1.1 | 2013-10-21 | New code M28 added to valid entries. Technical specification amended, adding this code to the ranking table |
XREG01 | 3.3.1 | 2013-10-21 | Technical Specification amended to remove Instance.MODE 61, which no longer exists |
XYEARM01 | 2.2.1 | 2013-10-21 | Technical specification amended to remove Instance.MODE 61, which no longer exists |
XQMODE01 | 3.1.1 | 2013-10-18 | Additional information and technical specification amended to remove valid entries in Instance.MODE that have been removed for 2013/14: 32, 37, 52, 53, 66, 67, 68. Valid entry 4 has been added to XQMODE01 to reflect the addition of new Instance.MODE code 99 for FE students in England, who can no longer use any other Instance.MODE valid entry |
XFTE01 | 3.3.1 | 2013-10-03 | XFTE01 definition text revised to express that modules where either StudentOnModule.MODSTAT = 4 or StudentOnModule.APEL = 1 or 2 are excluded from the sum of FTE that forms the second denominator. Change to function |
XPQUAL01 | 2.12.1 | 2013-10-02 | Addition of new Instance.LOCSDY codes T, U, and Z to Technical Specification, with removal of deleted codes A, B, F, G, M, N, P, Q, R and X. Addition of new Instance.EXCHANGE codes G and N to technical specification, with removal of deleted codes 0, 2, 7, 8, 9, A, B, C, D and E. Addition of new QualificationsAwarded.QUAL valid entry M28 to Technical Specification |
XPSES01 | 3.11.1 | 2013-10-02 | Addition of new Course.TTCID codes L, M, N and P to technical specification, with removal of deleted codes J and K. Addition of new Instance.LOCSDY codes T, U, and Z to technical specification, with removal of deleted codes A, B, F, G, M, N, P, Q, R and X. Addition of new Instance.EXCHANGE codes G and N to technical specification, with removal of deleted codes 0, 2, 7, 8, 9, A, B, C, D and E. Addition of new Instance.MODE code 99 to technical specification, with removal of deleted codes 32, 37, 52, 53, 66, 67, 68 and 69. Change of name from 'Teaching Agency' to 'National College for Teaching and Leadership' in exclusion 5 |
XPSR01 | 2.3.1 | 2013-10-02 | Addition of new Instance.MODE code 99 to Technical Specification, with removal of deleted codes 32, 37. 52, 53, 66, 67, 68 and 69. Change of name from 'Teaching Agency' to 'National College for Teaching and Leadership' in exclusion 5 |
XQLEV1003 | 1.4.1 | 2013-10-02 | Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly |
XQLEV301 | 1.9.1 | 2013-10-02 | Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly |
XQLEV501 | 1.9.1 | 2013-10-02 | Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly |
XQLEV601 | 1.9.1 | 2013-10-02 | Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly |
XPDEC01 | 3.10.1 | 2013-10-01 | Addition of new Course.TTCID codes G, H, J and K to technical specification. Change of name from 'Training and Development Agency' to 'Teaching Agency' in exclusion 5 |
XELSP01 | 1.4.1 | 2013-09-30 | Technical specification amended to state that where Instance.UNITLGTH is either null or '9', the associated XELSP01 value derives to A, regardless of the value in Instance.SPLENGTH. This aligns the specification with the function |
XHECOS_XFPE01 | 3.3.1 | 2013-09-30 | Minor typographical edits to two valid entry labels for consistency with other labels. C900 and I900 now use lower case throughout. Technical specification updated to reflect the addition of Course.TTCID valid entries L, M, N and P, and the deletion of J and K, in the list of codes that define ITT in sections i) to iv). Change to function |
XINSTC01 | 1.16.2 | 2013-09-30 | Table suffixes changed to be non-year specific, with explanatory sentence added |
XINSTG01 | 3.14.2 | 2013-09-30 | Table suffixes changed to be non-year specific, with explanatory sentence added |
XLEV301 | 1.9.1 | 2013-09-30 | Addition of code M28 and removal of code H24 from the technical specification due to changes in Course.COURSEAIM. Additional information adjusted accordingly |
XLEV501 | 1.10.1 | 2013-09-30 | Addition of code M28 and removal of code H24 from the technical specification due to changes in Course.COURSEAIM. Additional information adjusted accordingly |
XLEV601 | 1.9.1 | 2013-09-30 | Addition of code M28 and removal of code H24 from the technical specification due to changes in Course.COURSEAIM. Additional information adjusted accordingly |
XMODE01 | 3.1.1 | 2013-09-30 | Additional Information and Technical Specification amended to remove valid entries in Instance.MODE that have been removed for 2013/14: 32, 37, 52, 53, 66, 67, 68, 69. Valid entry 8 has been added to XMODE01 to reflect the addition of new Instance.MODE code 99 for FE students in England, who can no longer use any other Instance.MODE valid entry |
XMSFUND01 | 2.1.1 | 2013-09-30 | Additional information and technical specification amended to remove valid entries in Course.MSFUND that have been removed for 2013/14, and add codes 37 and 38, which are new. Valid entry 11 has been removed, as no MSFUND codes remain to derive to it |
XDOMGR01 | 4.10.1 | 2013-09-27 | Technical specification revised to remove the TEMP processing stage, which is no longer required with the complete move of the source data tables to ISO-3166-1 and the consequent removal of old-style HESA country codes in the postcode lookup tables for F_REGION; and W, X and Y region codes in F_GOR. Table suffixes changed to be non-year specific, with explanatory sentence added |
XDOMREG01 | 1.1.3 | 2013-09-27 | Addition of a dependent field - XPUBPOP01 in the DLHE collection |
XDOMUC01 | 5.3.1 | 2013-09-27 | Technical specification revised to remove the TEMP processing stage, which is no longer required with the complete move of the source data tables to ISO-3166-1 and the consequent removal of old-style HESA country codes in the postcode lookup tables. Table suffixes changed to be non-year specific, with explanatory sentence added |
XINSTID01 | 1.16.1 | 2013-09-24 | The following provider has been removed from the valid entries: 0213 AECC Chiropractic College. 0214 BPP University College has changed its name to BPP University |
XINSTID01 | 1.15.1 | 2013-08-01 | The following provider has been added to the valid entries: 0227 London School of Science and Technology |
XPSR01 | 2.2.9 | 2013-07-23 | Additional sentence added to Technical Specification, clarifying that where a programme of study is entirely within the current reporting period, Instance.COMDATE is used as the anniversary date. This is correctly coded in the existing function, but this addition removes ambiguity in the specification |
UNISTATS_XQOBTN02 | 1.2.1 | 2013-06-09 | Added in new codes M44, H62 |
XINSTID01 | 1.14.1 | 2013-05-02 | The following name changes have been applied: 0195 Royal Agricultural College changed to Royal Agricultural University. The following providers have been added to the valid entries: 0213 AECC Chiropractic College; 0214 BPP University College; 0215 GSM London; 0216 Regent's University London; 0217 IFS School of Finance; 0218 The University of Law; 0219 Richmond, The American International University in London; 0220 Institute of Contemporary Music Performance; 0221 Moorlands College; 0223 Redcliffe College; 0225 Mattersey Hall |
XAGRP601 | 1.1.9 | 2013-04-08 | Correction of the format of derived field XAGEA01 in the technical specification from INT 2 to CHAR 2. No change to function |
XAGRPA01 | 1.1.9 | 2013-04-08 | Correction of the format of derived field XAGEA01 in the technical specification from INT 2 to CHAR 2. No change to function |
XAGRPJ01 | 1.1.10 | 2013-04-08 | Correction of the format of derived field XAGEJ01 in the technical specification from INT 2 to CHAR 2. No change to function |
XHECOS_XFPE01 | 3.2.1 | 2013-04-08 | Technical specification change to include Course.TTCID codes G, H, J and K in the list of codes that define ITT in sections i) to iv). Change to function |
XQEYEAR01 | 1.1.3 | 2013-03-15 | Removal of reference to this field being present on the HINEP register, which ceased from C11051 onwards |
XDOM01 | 2.2.1 | 2013-03-14 | Valid entry PS relabelled from 'Occupied Palestinian Territories [Palestinian Territory, Occupied] {formerly West Bank (including East Jerusalem) and Gaza Strip}' to 'Occupied Palestinian Territories [Palestine, State of] {formerly West Bank (including East Jerusalem) and Gaza Strip}' to align with ISO 3166-1 |
XINSTID01 | 1.13.1 | 2013-02-28 | The following name changes have been applied: 0014 University of St Mark and St John and 0028 Newman University |
XINSTC01 | 1.16.1 | 2013-02-06 | Updated for new version of lookup 13AUG. Reference to XUKPRN01 in yy025 changed to UKRPN, as this field is now collected rather than derived. Second row added to Technical specification: Where the UKPRN value is not found in INSTHQPC_LOOKUP_13AUG F_UKPRN column, return Null as XINSTC01 as an error - rather than allowing the function to fail |
XINSTG01 | 3.14.1 | 2013-02-06 | Updated for new version of lookup 13AUG. Reference to XUKPRN01 in yy025 changed to UKRPN, as this field is now collected rather than derived. Second row added to Technical specification: Where the UKPRN value is not found in INSTHQPC_LOOKUP_yyAUG F_UKPRN column, return Null as XINSTG01 as an error - rather than allowing the function to fail |
XQMODE01 | 2.3.3 | 2013-02-05 | Removal of reference to XPDLHE01 population in Additional Information. No change to technical specification |
XQOBTN01 | 7.1.1 | 2013-02-05 | New codes M44 and H62 added to valid entries. Technical specification amended, adding these codes to the ranking table |
XQUALENT01 | 1.3.1 | 2013-02-05 | Added new EntryProfile.QUALENT3 valid entries of P93 and P94 to Technical Specification |
XPQUAL01 | 2.11.1 | 2013-02-01 | Added new QualificationsAwarded.QUAL codes of H62 and M44 to Technical Specification |
XPSES01 | 3.10.1 | 2013-02-01 | Addition of new Course.TTCID codes G, H, J and K to technical specification. References to the Training and Development Agency (TDA) updated to Teaching Agency (TA). Note added to Additional Information regarding the treatment of records submitted as reduced return type 08 |
XPSR01 | 2.2.8 | 2013-02-01 | References to the Training and Development Agency (TDA) updated to Teaching Agency (TA |
XQLEV1003 | 1.3.1 | 2013-02-01 | Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly |
XQLEV301 | 1.8.1 | 2013-02-01 | Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly |
XQLEV501 | 1.8.1 | 2013-02-01 | Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly |
XQLEV601 | 1.8.1 | 2013-02-01 | Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly |
XINSTID01 | 1.12.1 | 2013-01-31 | The following name changes have been applied: 0007 Bishop Grosseteste University; 0017 Falmouth University; 0018 Harper Adams University; 0040 Leeds Trinity University; 0190 Norwich University of the Arts; 0197 The Arts University Bournemouth. Reference to independent higher education provider changed to alternative provider |
XLEV301 | 1.8.1 | 2013-01-21 | Addition of codes M44 and H62 to technical specification due to their addition in Course.COURSEAIM. Additional information adjusted accordingly |
XLEV501 | 1.9.1 | 2013-01-21 | Addition of codes M44 and H62 to technical specification due to their addition in Course.COURSEAIM. Additional information adjusted accordingly |
XLEV601 | 1.8.1 | 2013-01-21 | Addition of codes M44 and H62 to technical specification due to their addition in Course.COURSEAIM. Additional information adjusted accordingly |
XMSFUND01 | 1.2.1 | 2013-01-21 | Course.MSFUND code 05 removed from technical specification as this valid entry has been removed from the field. Additional information: Funding bodies updated to remove 'Skills Funding Agency, Young People's Learning Agency' due to code 05 removal, 'Welsh Government DCELLS' renamed to 'Welsh Government DfES' in line with the new name for that department |
XAGEA01 | 1.5.1 | 2013-01-17 | Technical specification amended to account for switch to XML format in Staff record for 2012/13. Additional information BIRTHDTE example format changed to ISO 8601 yyyy-mm-dd |
XHECOS_XFPE01 | 3.1.1 | 2013-01-11 | Switch of JACS codes to the version 3.0 coding frame. Added XJACSLEV101, XJACSLEV201, and XJACSLEV301 to list of dependent fields |
XDOMGR01 | 4.9.1 | 2013-01-09 | Updated for new version of lookup 13AUG. Additional row added to Technical specification: where the DOMICILE value is not found in F_DOMICILE_ISO column of T_OVERSEAS_LOOKUP_V7, return Null as TEMP, and therefore XDOMGR01, as an error - rather than allowing the function to fail |
XDOMUC01 | 5.2.1 | 2013-01-09 | Updated for new version of lookup 13AUG. Valid entry PS relabelled from 'Occupied Palestinian Territories [Palestinian Territory, Occupied] {formerly West Bank (including East Jerusalem) and Gaza Strip}' to 'Occupied Palestinian Territories [Palestine, State of] {formerly West Bank (including East Jerusalem) and Gaza Strip}' to align with ISO 3166-1 |
XELSP01 | 1.3.6 | 2013-01-09 | Minor amendment to Additional information in order to clarify the circumstances and reduced records for which null values in SPLENGTH and UNITLGTH derive to 'Not known' |
XETHNIC01 | 1.2.1 | 2013-01-09 | New valid entries in Student.ETHNIC added to Technical specification, as a result of the implementation of Census 2011 codes. Text added to Additional information describing the grouping categories with these new entries |
XFTE01 | 3.2.1 | 2013-01-09 | Text added to Technical specification requiring the exclusion of modules where StudentOnModule.APEL is 1 or 2, in order to exclude prior learning from FTE apportionment. Condition added to table join accordingly. Change to function |
XAGRPJ01 | 1.1.9 | 2013-01-08 | Additional information text, second paragraph change from incorrect 'August' to 'July'. No change to function |
XINSTID01 | 1.11.1 | 2012-12-20 | Removal of Swansea Metropolitan University (0091) and The School of Pharmacy (0147) for 2012/13 and Switch to Static_data.UKPRN_lookup_v3 to allow for the inclusion of the additional independent higher education providers (IHEPS) - which are yet to be confirmed |
XINSTID01 | 1.10.1 | 2012-10-19 | Amended list to change 0175 Scottish Agricultural College to SRUC |
XFTE01 | 3.1.2 | 2012-08-15 | Instance.STULOAD is null has been added to the condition to create XFTE01 as zero. This is to align the specification with existing Software Development function. No change to function required |
XQOBTN01 | 6.2.3 | 2012-05-02 | Technical specification text clarified to aid creation of function and testing. No change to valid entries or ranking table |
XDOMGR01 | 4.8.2 | 2012-04-12 | Field description changed to 'Region of student domicile' and reference to 'Government Office Region' changed to 'Region' following ONS policy change. No change to function or valid entries |
XDOMUC01 | 5.1.2 | 2012-04-12 | Reference to 'Government Office Region' changed to 'Region' in the lookup table column descriptions following ONS policy change. No change to function or valid entries |
XINSTC01 | 1.15.2 | 2012-04-12 | Reference to 'Government Office Region' changed to 'Region' in INSTHQPC column description following ONS policy change. No change to function or valid entries |
XINSTG01 | 3.13.2 | 2012-04-12 | Field description changed to 'Region of institution location' and reference to 'Government Office Region' changed to 'Region' following ONS policy change. No change to function or valid entries |
XQOBTN01 | 6.2.2 | 2012-04-11 | Labels for valid entries D00, D01, E00, L00, L80, M00 and M50 revised to align with the guidance for research-based higher degrees. No change to meaning, nor to function |
XAGEJ01 | 1.3.2 | 2012-03-14 | Additional information BIRTHDTE example format changed to ISO 8601 yyyy-mm-dd |
XSTUDIS01 | 1.1.2 | 2012-03-01 | Additional information paragraph added regarding the coding of valid entries L Information refused, N Information not sought or N Not known |
UNISTATS_MODE | 1.2.4 | 2012-02-17 | UNISTATS_MODE to replace the existing version and UNISTATS_QMODE as these can be combined for full-time and part-time qualifiers |
UNISTATS_PROGTYPE | 1.1.1 | 2012-02-17 | Same as TQI_PROGTYPE_1.2.1 |
UNISTATS_XLEV501 | 1.1.1 | 2012-02-17 | New for 2011/12 |
UNISTATS_XPSR01 | 1.1.1 | 2012-02-17 | Same as TQI_XPSR01_1.1.1 |
UNISTATS_XQOBTN02 | 1.1.1 | 2012-02-17 | Same as TQI_XQOBTN02_1.1.1 |
XNATGR01 | 1.4.1 | 2012-02-17 | Technical specification: Updated for new version of the overseas lookup table - T_OVERSEAS_LOOKUP_V5 replaced with T_OVERSEAS_LOOKUP_V6. Minor spelling errors corrected in Additional Information and Technical Specification with no change to either meaning or function |
XPDEC01 | 3.9.1 | 2012-02-17 | Removal of reference to the Student Associates Scheme (SAS) from exclusion 5, due to the ending of this scheme. Corresponding TTCID entry of E removed from Technical Specification |
XPQUAL01 | 2.10.2 | 2012-02-17 | Removal of reference in Additional Information to the Student Associates Scheme (SAS), as this has ceased to exist |
XPSES01 | 3.9.1 | 2012-02-17 | Removal of references to the Student Associates Scheme (SAS) from exclusion 5 and Additional Information, due to the ending of this scheme. Corresponding TTCID entry of E removed from Technical Specification |
XPSR01 | 2.2.7 | 2012-02-17 | Removal of reference to the Student Associates Scheme from exclusion 5, due to the ending of this scheme. No change to technical specification as such students were derived in XPSES01 beforehand |
XQMODE01 | 2.3.2 | 2012-02-17 | Addition of a reference to the XPDLHE02 population to Additional Information. No change to technical specification |
XQOBTN01 | 6.2.1 | 2012-02-17 | Ranking number format changed to include leading zeroes up to three digits in length. No change to function |
XDOM01 | 2.1.1 | 2012-02-09 | New valid entries (CW) Curaçao, (SX) Sint Maarten (Dutch part), (BQ) Bonaire, Sint Eustatius and Saba, and (SS) South Sudan added. Relabeling of valid entry SH from St Helena to St Helena, Ascension and Tristan da Cunha |
XDOMGR01 | 4.8.1 | 2012-02-09 | Technical specification: Instruction added to convert incoming postcode data to upper case before performing lookup. Updated for new version of lookup 12AUG, T_OVERSEAS_LOOKUP_V5 replaced with T_OVERSEAS_LOOKUP_V7. Dependent fields: Removal of XDOMCT01 dependency and added XDOMREG01. Additional information: text referring to National Statistics Postcode Directory (NSPD) to ONS Postcode Directory (ONSPD |
XDOMUC01 | 5.1.1 | 2012-02-09 | New valid entries (CW) Curaçao, (SX) Sint Maarten (Dutch part), (BQ) Bonaire, Sint Eustatius and Saba, and (SS) South Sudan added. Relabeling of valid entry SH from St Helena to St Helena, Ascension and Tristan da Cunha. Minor text updates to existing valid entry labels: City of Kingston-upon-Hull to City of Kingston upon Hull; Medway Towns to Medway; Rhondda Cynon Taff to Rhondda, Cynon, Taff; Vale of Glamorgan to The Vale of Glamorgan. Technical specification: Updated for new version of lookup 12AUG. Additional information text: Reference to National Statistics Postcode Directory (NSPD) replaced by Office for National Statistics Postcode Directory ONSPD |
XELSP01 | 1.3.5 | 2012-02-09 | Valid entry: Minor text amendment: 'years' added to Valid entry A label 'Not known or expected length of study programme is greater or equal to 20 years' |
XINSTC01 | 1.15.1 | 2012-02-09 | Updated for new version of lookup 12AUG |
XINSTG01 | 3.13.1 | 2012-02-09 | Updated for new version of lookup table 12AUG. Reference to NSPD updated to ONSPD |
XMSFUND01 | 1.1.2 | 2012-02-09 | Additional information: Funding bodies names updates 'Skills Funding Agency, Young People's Learning Agency, Welsh Government DCELLS and The Teaching Agency' |
XAGRP601 | 1.1.8 | 2012-02-06 | Additional information text, second paragraph updated for clarity |
XAGRPA01 | 1.1.8 | 2012-02-06 | Additional information text, second paragraph updated for clarity |
XAGRPJ01 | 1.1.8 | 2012-02-06 | Additional information text, second paragraph updated for clarity |
XCLASS01 | 1.3.1 | 2012-02-06 | QualificationsAwarded.CLASS codes 12, 13 and 14 added to Technical specification to group to XCLASS01 valid entry 5 'Unclassified'. Additional information text added to highlight this addition |
XINSTID01 | 1.9.1 | 2012-01-27 | Switch to Static_data.UKPRN_lookup_v2 for valid entries. This includes the new HE institution Leeds College of Art (0211). (0096) Edinburgh College of Art and (0207) Leeds College of Music removed. Technical specification updated accordingly. Second row added to Technical specification: Where the INSTID value is not found in static_data lookup table f_instid, return Null as XUKPRN01. This to match XUKPRN01 technical specification error handling |
XINSTID01 | 1.8.1 | 2011-10-27 | Amended list to change 0089 University of Wales Institute, Cardiff to Cardiff Metropolitan University |
XINSTID01 | 1.7.1 | 2011-09-13 | Amended list to change name of The Royal Scottish Academy of Music and Drama (0101) to Royal Conservatoire of Scotland |
XEPYEAR01 | 2.1.1 | 2011-09-07 | Valid entry 9999 Not known - legacy dormant record added, as this is a valid code on the HIN_EP register for legacy dormant records. Also noted in Additional information |
XINSTC01 | 1.14.2 | 2011-08-31 | Updated to clarify UKRPN for Cyy031 |
XNATGR01 | 1.3.1 | 2011-06-10 | Addition to Technical specification. As Student.NATION has a minimum occurrence of 0, null added to Student.NATION values to derive to GRZZ. Added 'Not applicable' to valid entry label for GRZZ |
XQLEV1003 | 1.2.3 | 2011-05-31 | Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___' |
XQLEV301 | 1.7.3 | 2011-05-31 | Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___' |
XQLEV501 | 1.7.3 | 2011-05-31 | Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___' |
XQLEV601 | 1.7.3 | 2011-05-31 | Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___' |
XDOMGR01 | 4.7.1 | 2011-04-13 | Updated for new version of lookup 11AUG |
XDOMUC01 | 4.4.1 | 2011-04-13 | Updated for new version of lookup 11AUG |
XINSTC01 | 1.14.1 | 2011-04-13 | Updated for new version of lookup 11AUG |
XINSTG01 | 3.12.2 | 2011-04-13 | Updated to clarify UKRPN for Cyy031 |
XINSTG01 | 3.12.1 | 2011-04-13 | Updated for new lookup table 11AUG |
XINSTID01 | 1.6.1 | 2011-04-07 | Amended list to change name of Thames Valley University (0080) to The University of West London |
XINSTID01 | 1.5.1 | 2011-03-18 | Amended list to change name of UHI Millennium Institute to University of the Highlands and Islands |
XQUALENT01 | 1.2.1 | 2011-03-11 | Added EntryProfile.QUALENT2 value of 48 to accommodate historical instances in HIN register |
UNISTATS_CONT_STAT | 1.1.1 | 2011-03-09 | From 2011/12 (same as TQI_CONT_STAT |
UNISTATS_COURSEAIM | 1.1.1 | 2011-03-09 | From 2011/12 (same as TQI_COURSEAIM_1.1.1 |
XQUALENT01 | 1.1.2 | 2011-03-08 | To clarify processing required, added 'or' column in Technical Specification. Additional information text added regarding the return of null |
XREG01 | 3.2.1 | 2011-03-03 | Technical Specification updated to match function and clarify allocation of last character |
XNATGR01 | 1.2.1 | 2011-03-01 | Added Technical specification step - that function will fail if Student.NATION value cannnot be found in T_OVERSEAS_LOOKUP_V5.ISO_DOMICILE |
XAGEJ01 | 1.3.1 | 2011-02-24 | Technical specification amended to account for future value in student collection. Removal of Cyy025.BIRTHDTE as not applicable to Staff |
XAGEA01 | 1.4.1 | 2011-01-31 | Technical specifcation amended to account for potential future value in Student record |
XAGRP601 | 1.1.7 | 2011-01-31 | Amended label format for valid entry 1 and field name |
XAGRPA01 | 1.1.7 | 2011-01-31 | Amended label format for valid entry 1 and field name |
XAGRPJ01 | 1.1.7 | 2011-01-31 | Amended label format for valid entry 1 and field name |
XDOMGR01 | 4.6.1 | 2011-01-31 | Updated for new version of lookup 11MAY |
XDOMUC01 | 4.3.1 | 2011-01-31 | Updated for new version of lookup 11MAY |
XFTE01 | 3.1.1 | 2011-01-31 | Length extended from 5 to 6, to accommodate change in stored format to 2 decimal places. Also rounding and not trimming specified in calculation |
XINSTC01 | 1.13.1 | 2011-01-31 | Updated for new version of lookup 11MAY |
XINSTG01 | 3.11.1 | 2011-01-31 | Updated for new lookup table 11MAY |
XINSTID01 | 1.4.1 | 2011-01-31 | Amended list to remove 0092 Trinity University College, update names of 0176 to University of Wales Trinity Saint David and 0079 to Teesside University |
XNATGR01 | 1.1.1 | 2011-01-31 | Created |
XPDEC01 | 3.8.1 | 2011-01-31 | Added new codes for Instance.EXCHANGE of Y and Z, and added note to indicate that students studying primarily outside the UK are identified through their location of study. Also excluded TTCID E and F from population |
XPQUAL01 | 2.10.1 | 2011-01-31 | Added new codes for Instance.EXCHANGE of Y and Z, added note to indicate that students studying primarily abroad are identified through their location of study, and added note on SAS and SKE instances |
XPSES01 | 3.8.1 | 2011-01-31 | Added new codes for Instance.EXCHANGE of Y and Z, and note added to indicate that students studying primarily abroad are identified through their location of study |
XQLEV1003 | 1.2.2 | 2011-01-31 | Amended field name to 'Level of qualification' |
XQLEV501 | 1.7.2 | 2011-01-31 | Amended field name to 'Level of qualification' |
XQLEV601 | 1.7.2 | 2011-01-31 | Amended field name to 'Level of qualification' |
XQUALENT01 | 1.1.1 | 2011-01-31 | Created |
XSTUDIS01 | 1.1.1 | 2011-01-31 | Created |
XQLEV301 | 1.7.2 | 2011-01-30 | Amended field name to 'Level of qualification' |
XAGEA01 | 1.3.4 | 2010-11-08 | Additional information for valid entry 99 added where validation is switched. No change to function |
XAGEJ01 | 1.2.4 | 2010-11-08 | Additional information for valid entry 99 added where validation is switched. No change to function |
XAGRP601 | 1.1.6 | 2010-11-08 | Unknown added to 00 and 99 Additional information text. No change to function |
XAGRPA01 | 1.1.6 | 2010-11-08 | Unknown added to 99 Additional information text. No change to function |
XAGRPJ01 | 1.1.6 | 2010-11-08 | Unknown added to 99 Additional information text. No change to function |
XINSTC01 | 1.12.3 | 2010-10-01 | yy042 added to technical specification header. No change to function |
XINSTG01 | 3.10.2 | 2010-10-01 | yy042 added to technical specification header. No change to function |
XINSTID01 | 1.3.2 | 2010-10-01 | yy042 added to technical specification header. No change to function |
XPQUAL01 | 2.9.1 | 2010-09-03 | Added codes D01, M02, M79, M26, H79, I79, C77 and C78 |
XPSR01 | 2.2.6 | 2010-09-01 | Correct typo in technical specification to show that XPSR01 derives to 0 when Instance.TYPEYR is 5 |
XINSTID01 | 1.3.1 | 2010-07-14 | Valid entry change of Ravensbourne College of Design and Communication changed to Ravensbourne |
XINSTC01 | 1.12.2 | 2010-06-24 | Error handling clarified for circumstances where value not found in lookup table (Note to technical specification |
XINSTG01 | 3.10.1 | 2010-06-23 | Error handling clarified for circumstances where value not found in lookup table. Change to function required to handle |
XINSTID01 | 1.2.2 | 2010-06-23 | Error handling clarified for circumstances where value not found in lookup table |
XPDEC01 | 3.7.1 | 2010-06-23 | Added null value for Instance.LOCSDY |
XPQUAL01 | 2.8.1 | 2010-06-23 | Added null value for Instance.LOCSDY |
XPSES01 | 3.7.1 | 2010-06-23 | Updated for null values of Instance.LOCSDY and Course.TTCID added |
XREG01 | 3.1.3 | 2010-06-07 | Technical Specification updated to tie in with code (PART2 will be 1 for instances that have left). Also note added to clarify that SAS-related codes are historical |
XDOMUC01 | 4.2.1 | 2010-05-14 | Otherwise XK row added to bottom of Technical specification to deal with any postcodes (not in pc lookup tables) allowed via an agreed exception switch - to prevent this function failing. No change to valid entries |
XDOMGR01 | 4.5.2 | 2010-05-13 | All references of 09MAY lookup updated to 10MAY |
XFTE01 | 2.1.2 | 2010-05-13 | Note added to Additional information 'XFTE01 will normally be analysed after the application of the HESA session population (XPSES01)' |
XLEV501 | 1.8.1 | 2010-05-12 | Correction to technical specification - XLEV501=4 Course.COURSEAIM list 99 corrected to H99 |
XPQUAL01 | 2.7.1 | 2010-05-12 | Error correction - Instance.EXCHANGE code 0 removed from first row of Technical Specification |
XPSR01 | 2.2.5 | 2010-05-12 | Note added beneath Technical specification to highlight Instance.COMDATE is mandatory enforced by a business rule |
XINSTG01 | 3.9.2 | 2010-05-07 | Typo corrections to Technical specification (XINSTC01 column corrected to XINSTG01 and F_CTRY to F_GOR) - No change required to function |
XAGEJ01 | 1.2.3 | 2010-04-16 | Valid entries listed in full. No change to function |
XAGRP601 | 1.1.5 | 2010-04-12 | Format amendments. No change to technical specification |
XAGRPJ01 | 1.1.5 | 2010-04-12 | Minor text amendments. No change to function |
XDOM01 | 1.1.5 | 2010-04-12 | Text amendments. No change to function |
XINSTC01 | 1.12.1 | 2010-04-12 | Using new lookup table - 10MAY |
XINSTG01 | 3.9.1 | 2010-04-12 | Using new lookup table - 10MAY |
XQEYEAR01 | 1.1.2 | 2010-04-12 | Text amendments. No change to function |
XQLEV501 | 1.7.1 | 2010-04-12 | New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added |
XFYEAR01 | 1.2.4 | 2010-04-10 | Minor text amendments. No change to function |
XAGEA01 | 1.3.3 | 2010-04-09 | Minor text amendments. Valid entries listed in full. No change to function |
XAGRPA01 | 1.1.5 | 2010-04-09 | Minor text amendments. No change to function |
XDOMGR01 | 4.5.1 | 2010-04-09 | Updated for new version of lookup 10MAY |
XDOMHM01 | 1.4.4 | 2010-04-09 | Minor text revision to Additional information. No change to Technical specification |
XDOMUC01 | 4.1.1 | 2010-04-09 | New output values - C820 Bedfordshire replaced with C822 Bedford and C823 Central Bedfordshire, C875 Cheshire replaced with C895 Cheshire East and C896 Cheshire West and Chester, C840 Durham renamed County Durham to reflect new unitary authority name; new lookup table 10MAY |
XELSP01 | 1.3.4 | 2010-04-09 | Minor text amendments, with addition of text for reduced records 06 and 07. Technical specification text changes and re-ordering, but no change to function |
XEPYEAR01 | 1.1.4 | 2010-04-09 | Technical specification updated to clarify that XEPYEAR is updated when an Entry Profile is supplied, regardless of whether elements have changed |
XFTE01 | 2.1.1 | 2010-04-09 | Added XJACS201 and new Module.MODID to technical specification |
XHECOS_XFPE01 | 2.1.1 | 2010-04-09 | Added XJACSA01, XJACS201 and new Instance.COURSEID to technical specification |
XLEV301 | 1.7.1 | 2010-04-09 | New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added |
XLEV501 | 1.7.1 | 2010-04-09 | New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added |
XMODE01 | 2.2.3 | 2010-04-09 | Additional Information amended to remove references to sandwich students |
XMSTUFEE01 | 1.1.2 | 2010-04-09 | Descriptions for codes 6 and 7 clarified |
XQLEV1003 | 1.2.1 | 2010-04-09 | New XQOBTN01 input values added to Technical specification: D01, M02, M79, M26, H79, I79, C77, C78, P77, P78. Minor text amendments |
XQLEV601 | 1.7.1 | 2010-04-09 | New XOBTN01 input values added to Technical specification: D01, M02, M79, M26, H79, I79, C77, C78, P77, P78. Minor text amendments |
XQOBTN01 | 6.1.1 | 2010-04-09 | New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added |
XREG01 | 3.1.2 | 2010-04-09 | Minor text amendments to tie up with HIN_Register table name. Removal of C07051 only processing notes |
XLEV601 | 1.7.1 | 2010-04-08 | Amended text and codes added to Course.COURSEAIM |
XPDEC01 | 3.6.1 | 2010-04-08 | Added Instance.LOCSDY to technical specification, amended Instance.EXCHANGE for new values |
XPQUAL01 | 2.6.1 | 2010-04-08 | Instance.EXCHANGE codes amended and Instance.LOCSDY added |
XPSES01 | 3.6.1 | 2010-04-08 | Amended text, Instance.EXCHANGE codes updated and Instance.LOCSDY and Course.TTCID added |
XPSR01 | 2.2.4 | 2010-04-08 | Amended format. Updated year derivation in Additional information and removed reference to null Instance.COMDATE as this is now required for all instances. No change to technical specification |
XQLEV301 | 1.7.1 | 2010-04-08 | New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added |
XINSTC01 | 1.11.1 | 2009-11-01 | Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09 |
XHECOS_XFPE01 | 1.2.2 | 2009-10-30 | Technical specification text clarified for PGCE courses where more than one subject is returned in SBJCA. This matches the existing function. No change to function required |
XREG01 | 3.1.1 | 2009-10-27 | Updated to reflect position at close of processing of 07051. Section added for preparation of HIN_Register and technical specification amended |
XINSTG01 | 3.8.1 | 2009-10-01 | Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09 |
XINSTID01 | 1.2.1 | 2009-10-01 | Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09. Location of institution list specification changed to Data management |
XQEYEAR01 | 1.1.1 | 2009-07-22 | Field abbreviation changed from PQEYEAR to XQEYEAR01 (prior to field use - hence no version increment) to bring into line with other derived field (processing) specifications |
XQMODE01 | 2.3.1 | 2009-07-17 | Otherwise row in Technical specification removed, as it can never be executed |
XQOBTN01 | 5.1.6 | 2009-07-17 | Clarification that Professional Graduate Certificate in Education is not included in the Postgraduate Certificate in Education highest qualification grouping |
XDOMGR01 | 4.4.1 | 2009-07-16 | Footer moved to end of last page only |
XDOMHM01 | 1.4.3 | 2009-07-16 | Minor text revisions to Additional information. No change to Technical specification |
XDOMREG01 | 1.1.2 | 2009-07-16 | Minor text revisions to Additional Information |
XELSP01 | 1.3.3 | 2009-07-16 | Minor text edits to Additional information |
XEPYEAR01 | 1.1.3 | 2009-07-16 | Text amended in Technical specification - no change to function |
XETHNIC01 | 1.1.2 | 2009-07-16 | Additional information text for White clarified |
XINSTC01 | 1.10.2 | 2009-07-16 | Removed yy018 from XUKPRN01 list as XINSTC01 not created for DLHE. Note added to Additional information for analysis of country of institution from DLHE record |
XINSTG01 | 3.7.2 | 2009-07-16 | Removed yy018 from XUKPRN01 list as XINSTG01 not created for DLHE. Note added to Additional information for analysis of GOR from DLHE record |
XQLEV301 | 1.6.2 | 2009-06-18 | Format amendments and change to valid entry text. Labels aligned to student volume. Field type added. No change to technical specification |
XDOMGR01 | 4.4.1 | 2009-06-17 | Technical specification addition to clarify how to handle postcodes with a blank Geographic Office Region |
XDOMUC01 | 3.1.3 | 2009-06-16 | Valid entry typo edits to Vale of Glamorgan, Isle of Anglesey, Newry and Mourne. No change to function |
XDOM01 | 1.1.4 | 2009-06-11 | Valid entries clarified |
XDOM01 | 1.1.3 | 2009-06-11 | Updated to clarify process for populating with either incoming or previously submitted data |
XQEYEAR01 | 1.1.1 | 2009-06-11 | Created |
XQOBTN01 | 5.1.5 | 2009-06-11 | Valid entry labels aligned with HESA writing standard. No change to function |
XINSTG01 | 3.7.1 | 2009-06-10 | Valid entry label D changed to Yorkshire and The Humber, G to East of England to match ONS description |
XDOMUC01 | 3.1.2 | 2009-05-05 | Field description - addition of unitary authority to make consistent with other fields |
XFYEAR01 | 1.2.3 | 2009-05-05 | Field description changed from First year within 1st December population to First year identifier (to be used with XPDEC01 only |
XFYRSR01 | 1.2.3 | 2009-05-05 | Field description changed from First year within Standard Registration population to First year identifier (to be used with XPSR01 only |
XDOMGR01 | 4.3.3 | 2009-04-07 | Additional information clarifying the use of England region unknown label for code XF added |
XQOBTN01 | 5.1.4 | 2009-04-06 | Valid entry labels to lower case A/AS level, P85 label to match 'at level 3' added |
XDOMGR01 | 4.3.2 | 2009-03-25 | England region labels updated to East of England and Yorkshire and The Humber following confirmation from ONS |
XFYRSR01 | 1.2.2 | 2009-03-23 | Format amended. Filed type added. No change to technical specification |
XDOM01 | 1.1.2 | 2009-03-20 | Format amendments |
XDOMREG01 | 1.1.1 | 2009-03-20 | Created |
XEPYEAR01 | 1.1.2 | 2009-03-20 | Format amended |
XFTE01 | 1.1.2 | 2009-03-20 | Format amends. Additional information added to |
XREG01 | 2.1.2 | 2009-03-20 | Format amended. Colons removed from valid entries |
XYEARM01 | 2.1.2 | 2009-03-20 | Format amended |
XHOOS01 | 1.2.2 | 2009-03-19 | Format amendment. Colons removed from valid entries. Field type added. Additional information updated for Guernsey, Jersey and Isle of Man grouping. No change to technical specification |
XCLASS01 | 1.2.2 | 2009-03-18 | Format amended. Colons removed from valid entries. Field type added. No change to technical specification |
XELSP01 | 1.3.2 | 2009-03-18 | Format amended. Colons removed from valid entries. Field type added. No change to technical specification |
XETHNIC01 | 1.1.1 | 2009-03-18 | Created |
XMODE01 | 2.2.2 | 2009-03-18 | Format amendment. Colons removed from valid entries. Field type added. No change to technical specification |
XMSFUND01 | 1.1.1 | 2009-03-18 | Created |
XMSTUFEE01 | 1.1.1 | 2009-03-18 | Created |
XQMODE01 | 2.2.2 | 2009-03-18 | Format amended. Colons removed from valid entries. Field type added. No change to technical specification |
XAGEA01 | 1.3.2 | 2009-03-17 | Format amended. Colons removed from valid entries. Field type added |
XAGEJ01 | 1.2.2 | 2009-03-17 | Format amended. Colons removed from valid entries. Field type added. No change to technical specification |
XAGRP601 | 1.1.4 | 2009-03-17 | Format amendment. Colons removed from valid entries. Field type added. No change to technical specification |
XAGRPA01 | 1.1.4 | 2009-03-17 | Format amended. Colons removed from valid entries. Ages 00 and 99 text clarified in Additional information. Field type added |
XAGRPJ01 | 1.1.4 | 2009-03-17 | Format amended. Colons removed from valid entries. Field type added. No change to technical specification |
XDOMGR01 | 4.3.1 | 2009-03-13 | Updated for new version of lookup 09MAY and overseas lookup v5, and refers only to F_DOMICILE_ISO |
XDOMHM01 | 1.4.2 | 2009-03-13 | Format amended. Field type added. No change to Technical specification |
XDOMUC01 | 3.1.1 | 2009-03-13 | New lookup table - 09 MAY and format amends, and new output codes with new valid domicile codes |
XFYEAR01 | 1.2.2 | 2009-03-13 | Format amended. Text amend to additional information. Field type added. No change to technical specification |
XLEV301 | 1.6.2 | 2009-03-13 | PG, UG FE valid entry labels removed to match all other level fields. Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Additional information updated to reflect definitions |
XLEV601 | 1.6.2 | 2009-03-13 | Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Notes updated to reflect current definitions |
XPDEC01 | 3.5.2 | 2009-03-13 | Amended and simplified format. Field type added. No change to Technical specification |
XPQUAL01 | 2.5.2 | 2009-03-13 | Format amendments only. Field type added. No change to Technical Specification |
XPSES01 | 3.5.2 | 2009-03-13 | Format changes only. Field type added. No change to technical specification |
XPSR01 | 2.2.3 | 2009-03-13 | Amended format. Field type added. No change to technical specification |
XQLEV1003 | 1.1.1 | 2009-03-13 | Created |
XQLEV501 | 1.6.2 | 2009-03-13 | Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Notes updated to reflect current definitions; |
XQLEV601 | 1.6.2 | 2009-03-13 | Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification |
XQOBTN01 | 5.1.3 | 2009-03-13 | Updated format. field type added. No change to technical specification |
XINSTC01 | 1.10.1 | 2009-03-11 | Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added |
XINSTG01 | 3.6.1 | 2009-03-11 | Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added |
XINSTID01 | 1.1.5 | 2009-03-11 | More comprehensive explanation of specification provided. Field type added. No change to technical specification |
XLEV501 | 1.6.2 | 2009-03-10 | Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Notes updated to reflect current definitions; |
XPSES01 | 3.5.1 | 2008-11-15 | Amended spec to deal with changes for new Student record |
XINSTG01 | 3.5.3 | 2008-10-15 | Remove superfluous semicolons from valid entry list |
XINSTID01 | 1.1.4 | 2008-10-15 | Note added to clarify that field version applicable to a reporting period |
XPSR01 | 2.2.2 | 2008-10-15 | Amended technical specification to reflect derivation as performed where Instance.MODE is 51, 63 or 64 and added note after to clarify treatment of dormant records and COMDATE |
XINSTG01 | 3.5.2 | 2008-10-14 | Clarification of reporting period updates – once per reporting year using yyMAY |
XINSTC01 | 1.9.2 | 2008-10-13 | Clarification of reporting period updates - once per reporting year using yyMAY |
XINSTID01 | 1.1.3 | 2008-10-13 | Update to text to make more generic. Valid entry reference to Data Management Institution list added, and Valid entries list removed |
XELSP01 | 1.3.1 | 2008-10-10 | Amended to allow for only one of SPLENGTH or UNITLGTH to be supplied for reduced records 03 and 04 |
XDOMUC01 | 2.2.1 | 2008-07-26 | revised to account for null DOMICILE, amend UK code from GB to X, and to map '_826' codes in TEMP |
XYEARM01 | 2.1.1 | 2008-07-21 | Added MODE 73 and 74 |
XPQUAL01 | 2.5.1 | 2008-06-26 | clarification that value 0 output where no QualificationsAwarded entity exists |
XDOMGR01 | 4.2.1 | 2008-06-24 | Text changes to the description of t_overseas_lookup for 2007/08 and clarification of ownership of table changing from DQA to DM. Clarification of additional processing to TEMP and correction of mapping in TEMP from F_REGION input |
XFTE01 | 1.1.1 | 2008-03-20 | as per Cyy051 into Oracle specification, as a distinct derived field specification |
XINSTC01 | 1.9.1 | 2008-03-01 | Using new lookup table - 08 MAY |
XLEV501 | 1.6.1 | 2008-02-26 | Amended for Cyy051 |
XAGRP601 | 1.1.3 | 2008-01-28 | Text amendment to describe source of XAGEA01 00, 99 |
XINSTID01 | 1.1.1 | 2008-01-28 | Created |
XAGRPJ01 | 1.1.3 | 2008-01-26 | Minor amendment to description to clarify origin of blank birth dates |
XCLASS01 | 1.2.1 | 2008-01-26 | Amended to refer to QualificationsAwarded.CLASS, to confirm that input values are either valid values or blank and to clarify linking of XCLASS01 to XQOBTN01 |
XDOMUC01 | 2.1.1 | 2008-01-26 | Amended spec for New Student Record and new lookup table – 08MAY. New output codes to reflect change in coding frame for DOMICILE |
XELSP01 | 1.2.1 | 2008-01-26 | Amends to for Cyy051 |
XLEV301 | 1.6.1 | 2008-01-26 | QUALAIM replaced by Course.COURSEAIM, changed for Cyy051 |
XLEV601 | 1.6.1 | 2008-01-26 | Revised for Cyy051 |
XQLEV601 | 1.6.1 | 2008-01-26 | Revised for Cyy051 |
XQMODE01 | 2.2.1 | 2008-01-26 | New Instance.MODE codes of 73 and 74 codes added for Cyy051 |
XFYEAR01 | 1.2.1 | 2008-01-25 | Amended for Cyy051, labels amended to refer to instance |
XFYRSR01 | 1.2.1 | 2008-01-25 | Amended to refer to Cyy0511 and labels amended to refer to year of instance |
XPQUAL01 | 2.4.1 | 2008-01-25 | changes for Cyy051 |
XDOMHM01 | 1.4.1 | 2008-01-23 | Revised for changed XDOMHM01 values for Cyy051 |
XMODE01 | 2.2.1 | 2008-01-23 | Include new mode codes 73 and 74 from Cyy051 |
XAGEJ01 | 1.2.1 | 2008-01-09 | Changes for 07051 and clarification of origin of blank BIRTHDATE as reason for null |
XQLEV501 | 1.6.1 | 2008-01-08 | Revised for Cyy051 |
XQLEV301 | 1.6.1 | 2008-01-01 | Changes for Cyy051 |
XQOBTN01 | 5.1.2 | 2008-01-01 | Amended typo in text to clarify that '___' is valid entry for no qualification |
XQOBTN01 | 5.1.1 | 2007-12-20 | New Cyy051 codes added, field length 3 |
XPDEC01 | 3.5.1 | 2007-11-14 | Amended spec to deal with changes for Cyy051 |
XINSTC01 | 1.8.1 | 2007-03-01 | Using new lookup table - 07MAY |
XDOMGR01 | 3.5.1 | 2007-01-17 | Using new lookup table – 07MAY |
XAGEA01 | 1.2.1 | 2007-01-12 | Amended spec to deal with new default code 01/01/1901 |
XEPYEAR01 | 1.1.1 | 2007-01-01 | Created |
XDOMGR01 | 3.4.1 | 2006-03-14 | Using new lookup table – 06MAY |
XINSTC01 | 1.7.1 | 2006-03-01 | Using new lookup table - 06MAY |
XINSTG01 | 3.3.1 | 2006-02-21 | Using new lookup table - May 2006. Table INSTHQPC_LOOKUP_06MAY not yet created as at 21 February 2006 |
XDOMGR01 | 3.2.1 | 2005-07-07 | Using new lookup table – May 2005 |
XDOMUC01 | 1.2.1 | 2005-07-07 | New lookup table - May 2005 |
XINSTC01 | 1.5.1 | 2005-07-07 | Using new lookup table - May 2005 |
XLEV301 | 1.5.1 | 2005-02-21 | QUALAIM code 63 moved to FE level |
XLEV501 | 1.5.1 | 2005-02-21 | Code 63 moved to FE level |
XLEV601 | 1.5.1 | 2005-02-21 | Code 63 moved to FE level |
XPDEC01 | 3.4.1 | 2005-02-21 | Move QUALAIM code 63 to FE level |
XPSES01 | 3.4.1 | 2005-02-21 | 04/05 move QUALAIM code 63 to FE level |
XQLEV301 | 1.5.1 | 2005-02-21 | code 63 moved to FE level |
XQLEV501 | 1.5.1 | 2005-02-21 | Code 63 moved to FE level |
XDOMGR01 | 3.1.1 | 2005-01-25 | Different valid entry codes due to new lookup table sources |
XDOMHM01 | 1.3.1 | 2005-01-25 | Spec change but valid entries remain the same |
XINSTC01 | 1.4.1 | 2005-01-06 | Using new lookup table source |
XINSTG01 | 3.1.1 | 2005-01-06 | Using new lookup table source and different valid entry codes |
XINSTC01 | 1.3.1 | 2004-05-11 | Code modified to use updated lookup table (R36 |
XREG01 | 2004-03-25 | Updated for C03011 - code 2 added to NOTACT | |
XDOMGR01 | 2.3.1 | 2004-03-22 | use updated lookup table (R36 |
XPSR01 | 2.2.1 | 2004-03-18 | Amended spec to deal with changes for Cyy051, addition of Instance.MODE as input field |
XPSR01 | 2.1.1 | 2004-03-18 | Valid entry changes |
XINSTG01 | 2.2.1 | 2004-03-01 | Code modified to use updated lookup table (R36); 2004-02-25 |
XQMODE01 | 2.1.1 | 2004-02-25 | New valid entry 3 due to new mode of study codes in 2003-04 |
XLEV601 | 1.4.1 | 2004-02-13 | 03/04 codes included |
XPDEC01 | 3.3.1 | 2004-02-13 | 03/04 codes changes to SPCSTU, MODE, LOCSDY and QUALAIM |
XPSES01 | 3.3.1 | 2004-02-13 | 03/04 changes to SPCSTU, MODE, LOCSDY and QUALAIM |
XQLEV301 | 1.4.1 | 2004-02-13 | 03/04 code changes |
XQLEV501 | 1.4.1 | 2004-02-13 | 03/04 codeschanges |
XQLEV601 | 1.5.1 | 2004-02-13 | Code 63 moved to FE level |
XQOBTN01 | 4.1.1 | 2004-02-13 | New 03/04 record codes added |
XDOMGR01 | 2.2.1 | 2004-02-03 | Labelling changes |
XDOMHM01 | 1.2.4 | 2004-02-03 | Labelling changes |
XHOOS01 | 1.2.1 | 2004-02-03 | Labelling change |
XLEV501 | 1.4.1 | 2003-12-16 | 03/04 codes included |
XLEV301 | 1.4.1 | 2003-11-13 | 03/04 codes included |
XPSR01 | 1.3.1 | 2003-08-12 | NOTACT code 2 included |
XQLEV601 | 1.4.1 | 2003-03-01 | 03/04 codes changes |
XMODE01 | 2.1.1 | 2003-02-25 | New valid entry 7 due to new mode of study codes in 2003-04 |
XLEV501 | 1.3.1 | 2003-02-13 | 02/03 codes included |
XLEV601 | 1.3.1 | 2003-02-13 | 02/03 codes included |
XQLEV301 | 1.3.1 | 2003-02-13 | 02/03 code changes |
XQLEV501 | 1.3.1 | 2003-02-13 | 02/03 codes changes |
XQLEV601 | 1.3.1 | 2003-02-13 | 02/03 codes changes |
XQOBTN01 | 3.1.1 | 2003-02-12 | New 02/03 record codes added |
XDOMGR01 | 2.1.1 | 2003-02-11 | Code modified to use updated lookup table (R34). Code 'MERS' not used |
XINSTC01 | 1.2.1 | 2003-02-11 | Code modified to use updated lookup table (R34 |
XINSTG01 | 2.1.1 | 2003-02-11 | Code modified to use updated lookup table (R34). Code 4 not used |
XLEV301 | 1.3.1 | 2003-02-11 | 02/03 codes included |
XMODE01 | 1.2.1 | 2003-02-11 | Code modified due to deletion of old mode of study codes |
XPDEC01 | 3.2.1 | 2003-02-11 | 02/03 code changes to SPCSTU, MODE, LOCSDY and QUALAIM |
XPQUAL01 | 2.3.1 | 2003-02-11 | 02/03 qualification code changes |
XPSES01 | 3.2.1 | 2003-02-11 | 02/03 changes to SPCSTU, MODE, LOCSDY and QUALAIM |
XQMODE01 | 1.2.1 | 2003-02-11 | Code amended to delete old mode of study codes |
XINSTG01 | 1.2.2 | 2002-05-13 | Specification change – new column added to lookup table |
XAGEA01 | 1.1.2 | 2002-04-30 | Clarification of reporting year in technical spec |
XINSTC01 | 1.1.2 | 2002-04-18 | Specification change; use lookup table |
XPDEC01 | 3.1.1 | 2002-03-25 | Valid entry changes |
XPSES01 | 3.1.1 | 2002-03-25 | Valid entry changes |
XQMODE01 | 1.1.1 | 2002-03-25 | Created |
XAGEJ01 | 1.1.2 | 2002-03-08 | Clarification of reporting year in technical spec |
XFYEAR01 | 1.1.4 | 2002-03-08 | Clarification of reporting year in technical spec |
XFYRSR01 | 1.1.2 | 2002-03-08 | Clarification of reporting year in technical spec |
XPDEC01 | 2.2.2 | 2002-03-08 | Clarification of reporting period in technical spec |
XPQUAL01 | 2.2.1 | 2002-03-08 | Foundation degree, code 28, included |
XPSES01 | 2.2.2 | 2002-03-08 | Foundation degree QUALAIM code 28 added and clarification of reporting period in technical spec |
XQLEV301 | 1.2.1 | 2002-03-08 | Foundation degree code 28 included |
XQLEV501 | 1.2.1 | 2002-03-08 | Foundation degree code 28 added |
XQLEV601 | 1.2.1 | 2002-03-08 | Foundation degree code 28 added |
XQOBTN01 | 2.1.1 | 2002-03-08 | Foundation degree, code 28 added |
XPSR01 | 1.2.1 | 2002-01-14 | Code amended to allow for course length |
XLEV301 | 1.2.1 | 2001-09-24 | Foundation degree (QUALAIM code 28) included |
XLEV501 | 1.2.1 | 2001-09-24 | Foundation degree (QUALAIM code 28) included in 'Other Undergraduate' |
XLEV601 | 1.2.1 | 2001-09-24 | Foundation degree (QUALAIM code 28) included in OUG |
XPDEC01 | 2.2.1 | 2001-09-24 | Foundation degree QUALAIM code 28 added |
XINSTG01 | 1.2.1 | 2001-09-20 | Code modified to use updated lookup table (R32 |
XPSR01 | 1.1.4 | 2001-07-19 | Code created |
XFYRSR01 | 1.1.1 | 2001-05-04 | Created |
XPDEC01 | 2.1.1 | 2001-02-27 | Incoming exchange students excluded from population |
XPSES01 | 2.1.1 | 2001-02-27 | Incoming exchange students excluded from population |
XCLASS01 | 1.1.1 | 2001-02-14 | Created |
XPQUAL01 | 2.1.1 | 2001-02-13 | Dormant students exclusion removed and incoming exchange students excluded |
XDOMGR01 | 1.2.1 | 2000-07-03 | Code modified to incorporate R30 |
XDOMHM01 | 1.1.4 | 2000-05-19 | XPFDS01 entered into Dependent fields section |
XINSTG01 | 1.1.1 | 2000-03-16 | Created |
XDOMGR01 | 1.1.1 | 2000-01-06 | Created |
XDOMHM01 | 1.1.3 | 1999-03-15 | XDOMCT01 codes 6826 and 7826 swapped around to give correct results |
XELSP01 | 1.1.2 | 1998-12-17 | Error in program code. Code modified |
XDOMHM01 | 1.1.2 | 1998-12-14 | XDOMCT01 code GROE included in result 7 |
XFYEAR01 | 1.1.3 | 1998-12-04 | Error in program. Code modified |
XAGRPA01 | 1.1.3 | 1998-12-03 | Code modified |
XPSES01 | 1.1.2 | 1998-12-03 | Code modified due to QUALAIM codes 79 and 80 being deleted from program code |
XELSP01 | 1.1.3 | 1998-12-01 | Error in program code. Code modified |
XFYEAR01 | 1.1.2 | 1998-12-01 | Error in program. Code modified |
XAGRP601 | 1.1.2 | 1998-11-12 | Code modified |
XAGRPA01 | 1.1.2 | 1998-11-12 | Code modified |
XAGRPJ01 | 1.1.2 | 1998-11-12 | Code modified |
XMODE01 | 1.1.2 | 1998-11-11 | Code modified due to spec change. Labelling change to show 'Sabbatical' separately |
XHOOS01 | 1.1.1 | 1998-10-29 | Created |
XAGEA01 | 1.1.1 | 1998-10-26 | Created |
XAGEJ01 | 1.1.1 | 1998-10-26 | Created |
XELSP01 | 1.1.1 | 1998-10-26 | Created |
XFYEAR01 | 1.1.1 | 1998-10-26 | Created |
XAGRP601 | 1.1.1 | 1998-10-07 | Created |
XAGRPA01 | 1.1.1 | 1998-10-07 | Created |
XAGRPJ01 | 1.1.1 | 1998-10-07 | Created |
XINSTC01 | 1.1.1 | 1998-10-07 | Created |
XMODE01 | 1.1.1 | 1998-09-28 | Created |
XPSES01 | 1.1.1 | 1998-09-28 | Replaces POPSES, POPSESFE, POPNOTSES |
XLEV301 | 1.1.1 | 1998-09-25 | Replaces FLGLEVEL |
XLEV501 | 1.1.1 | 1998-09-25 | Created 25 September 1998 |
XLEV601 | 1.1.1 | 1998-09-25 | Created |
XPDEC01 | 1.1.1 | 1998-09-25 | Replaces POPDEC, POPDECFE |
XPQUAL01 | 1.1.1 | 1998-09-25 | Replaces POPHEMQ |
XQLEV301 | 1.1.1 | 1998-09-25 | Created |
XQLEV501 | 1.1.1 | 1998-09-25 | Created |
XQLEV601 | 1.1.1 | 1998-09-25 | Created |
XQOBTN01 | 1.1.1 | 1998-09-07 | Created |
XAGEA01 | 1.3.1 | 1994-01-01 | Amended to deal with changed reporting of unknown birth date between student and staff streams |
XDOM01 | 1.1.1 | 1994-01-01 | Created |
XDOMGR01 | 4.1.1 | 1994-01-01 | Revised for Cyy051 with new coding output codes and new versions of lookup tables |
XDOMGR01 | 3.4.2 | 1994-01-01 | Text amended to clarity that function should error of valid domicile provided and not found in T_OVERSEAS_LOOKUP_V3 |
XDOMGR01 | 3.3.1 | 1994-01-01 | Using new lookup table – 05NOV |
XDOMGR01 | 3.1.2 | 1994-01-01 | Using version 3 of overseas lookup table |
XDOMUC01 | 1.5.1 | 1994-01-01 | New lookup table - 07MAY |
XDOMUC01 | 1.4.1 | 1994-01-01 | New lookup table - 06MAY |
XDOMUC01 | 1.3.1 | 1994-01-01 | New lookup table - 05NOV |
XDOMUC01 | 1.1.1 | 1994-01-01 | Code created |
XELSP01 | 1.1.4 | 1994-01-01 | Error in program code. Code modified |
XINSTC01 | 1.9.3 | 1994-01-01 | Remove superfluous semicolons from valid entry list |
XINSTC01 | 1.6.1 | 1994-01-01 | Using new lookup table - 05NOV |
XINSTC01 | 1.5.2 | 1994-01-01 | Code simplified as country field is now one character length |
XINSTG01 | 3.5.1 | 1994-01-01 | Using new lookup table - May 2008. Clarified source of lookup |
XINSTG01 | 3.4.1 | 1994-01-01 | Using new lookup table - May 2007 |
XINSTG01 | 3.2.1 | 1994-01-01 | Using new lookup table - May 2005 |
XINSTID01 | 1.1.2 | 1994-01-01 | Amended field type from INTEGER to CHAR in document heading, and added text to technical specification to describe table in static data schema |
XREG01 | 2.1.1 | 1994-01-01 | Updated in preparation for C07051 – to identify LOCSDY = 7, SAS students, and include MODE 73 & 74 |
XYEARM01 | 1.1.1 | 1994-01-01 | Created |
Need help?
Contact Liaison by email or on +44 (0)1242 388 531.