Skip to main content

Back to C21051

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
XAGEA011.7.12022-08-24Technical specification amended for Cyy025 to derive 99 for records with birth date 1900-01-01
XINSTID011.66.12022-08-01Addition of provider Multiverse (0447). No change to technical specification
XINSTID011.65.12022-07-12Provider 1061 changed name from Peterborough Regional College to Inspire Education Group. No change to technical specification
XINSTID011.64.12022-06-23Provider 0230 changed name from Plymouth College of Art to Arts University Plymouth. No change to technical specification
XINSTID011.63.12022-06-23Addition of providers Rambert School (0443), The Place, London Contemporary Dance School (0444), National Centre for Circus Arts (0445) and Central School of Ballet (0446). No change to technical specification
XINSTID011.62.12022-06-09Provider 1019 name changed from Wakefield College to Heart of Yorkshire Education Group. No change to technical specification
XTPOINTS1.24.22022-05-05The appendix has been updated to correct the label for one qualification (QUALTYPE TN
XINSTID011.61.12022-05-03Providers 1196 Centre for Alternative Technology Charity Limited, 1197 St Padarn's Institute, 1198 Union Foundation / Union / Union School of Theology, 1199 Cardiff and Vale College, 1200 Coleg Gwent and 1201 College Cambria have been added to the valid entries. No change to technical specification
XINSTID011.60.12022-03-30Provider 1119 name updated from Grimsby Institute of Further and Higher Education to TEC Partnership
XPDEC013.19.12022-03-23Technical specification for Cyy051 student record section has been updated to include Instance.EXCHANGE valid entry O
XPGO011.6.12022-03-23Technical specification for Cyy051 student record section has been updated to include Instance.EXCHANGE valid entry O
XPQUAL012.23.12022-03-23Technical specification for Cyy051 student record section has been updated to include Instance.EXCHANGE valid entry O
XPSES013.18.12022-03-23Technical specification for Cyy051 student record section has been updated to include Instance.EXCHANGE valid entry O
XTPOINTS1.24.12022-03-23The specification has been updated to remove reference to UCAS tariff status as this is no longer required
XINSTID011.59.12022-03-11Provider 0441 Paris Dauphine International has been added to the valid entries. No change to technical specification
XNATGR011.9.12022-03-04Amendment made to label name for valid entry GRAU, changed from 'Geographic region - Australasia' to 'Geographic region - Oceania' to align with ONS
XPSR012.11.12022-03-04Technical specification tables have been updated for Cyy051 and Cyy054 to deal with the scenario when students are expected to study for 2 weeks or less and end up studying for more than two weeks and continue into the following academic year where they could be incorrectly counted in the XPSR01 population again, if they study for less than 1 year + 2 weeks
XTPOINTS1.23.12022-03-04The appendix has been updated to include new tariffable qualifications (QUALTYPEs 8X, 8Y, TM and TN). QUALTYPEs 8L and 8K have been amended as they now attracts tariff points and will be classified as HESA tariff status 1. The following qualifications were removed as identified as duplicate qualtypes GU, GZ, H4, H5, H6, H7, HB, HJ, HM, HN, HQ, HR, HT, HU, HV, HX, K8, K9, MB, MG, MK, N7, OJ, ON, OP, OV, OX, OY, OZ, P6, P7, P8, P9, PG, QP, QQ, QR, QU, QV, R7, RC, RD, RF, RK, RZ, SD, SH, SK, SU, SV, T6, T7, T8, T9, TG and TJ
XINSTID011.58.12021-10-15Provider 0440 Marine Learning Alliance Ltd has been added to the valid entries. No change to technical specification
XTPOINTS1.22.12021-08-20The appendix has been updated to include new tariffable qualifications (QUALTYPEs TS, TT, TU, TV, W5, W8, XB, XC, XD, XE, XF, XG). Qualification 'SE' has been back into tariff with a new qualification title of 'Scottish Foundation Apprenticeship in Accountancy'. QUALTYPEs ER, EX, EZ, FF, FG and FH have been amended as they now attracts tariff points and will be classified as HESA tariff status 1. Additionally the qualification name for Qualtypes 'FU' and 'FQ' have been amended to include 'International' as this was missed erroneously in a previous release
XTPOINTS1.21.12021-08-08The appendix has been updated to remove one qualification (QUALTYPE SE). The qualification is pending confirmation of the valid combinations of QUALTYPE and QUALGRADE for tariff
XTPOINTS1.20.12021-07-16The appendix has been updated to include new tariffable qualifications (QUALTYPEs GT, GU, GV, GW, GX, GY, GZ, H4, H5, H6, H7, H8, H9, HB, HE, HG, HH, HJ, HM, HN, HP, HQ, HR, HT, HU, HV, HW, HX, HY, HZ, K7, K8, K9, LC, MB, MF, MG, MH, MJ, MK, ML, MM, MN, MP, OF, OH, OJ, OK, OL, OM, ON, OP, OQ, OR, OS, OV, OW, OX, OY, OZ, P6, P7, P8, P9, PG, QP, QQ, QR, QS, QT, QU, QV, QW, QX, QY, QZ, R6, R7, R8, RA, RB, RC, RD, RF, RG, RH, RJ, RK, RL, RM, RZ, SD, SE, SF, SH, SJ, SK, SM, SQ, SR, SU, SV, T6, T7, T8, T9, TE, TF, TG, TH, TJ, TK, TP, TQ, and TR). Additionally Qualtype EW has been amended to 0 tariff points as it is to be treated the same as key skills HK, K3 and W3 and will be classified as HESA tariff status 2
XINSTID011.57.12021-06-23Provider 0439 Inchbald College of Design Limited has been added to the valid entries. No change to technical specification
XPQUAL012.22.12021-06-23The technical specification table for Cyy054 has been updated as the table headers where incorrect 'Instance' has been updated to 'Instance_End' and 'Instance.EXCHANGE' has been updated to 'Instance_End.EXCHIND'. Additionally the valid entries for Instance_End.EXCHIND have been updated to reflect the correct Cyy054 entries 2, 3 and 1 and QualificationsAwarded.QUAL has been updated to remove valid entries X and Z as they are not applicable to Cyy054
XPSR012.10.12021-06-23Technical specification and additional information has been updated for Cyy051 and Cyy054 to improve consistency and clarity: Students on courses expected to last for less than one year are only counted if they study for the expected amount of time or gain a qualification. Student on courses of at least 1 year in length are only counted at the point at which they are active on or after the anniversary of the commencement date plus 14 days, including the 14th day itself (Note: this date may fall in the following academic year). Students on any course with a non-standard year type who suspend their studies are excluded from the population (Cyy051 only). Mode of study is taken from the last active instance period (Cyy054 only
XTPOINTS1.19.12021-05-24The appendix has been updated to include new tariffable qualifications (QUALTYPEs 8I and TL) and will classified as HESA tariff status 1. (QUALTYPEs FJ, FK, FL, FN, FP, FQ, FU, FV, FW, FX, FZ, G1, G2, G3, G4, G5, G9, GJ, GK and GM) have also been added and will classified as HESA tariff status 2 as they do not attract tariff points. Additionally, QUALTYPE 9T has been amended as it now attracts tariff points and will be classified as HESA tariff status 1
XINSTID011.56.12021-05-18Description of field updated (referring to 'providers' rather than 'Higher Education Providers', since some may be 'Further Education Providers') and add a section to further clarify the criteria by which valid entries are listed. No change to technical specification
XINSTID011.55.12021-05-11Provider 0438 The Ashridge (Bonar Law Memorial) Trust has been added to the valid entries. No change to technical specification
XINSTID011.54.12021-05-07After a review of the valid entries a number of entries have been added where we are able to map a UKPRN to an INSTID. No change to technical specification
XMODE013.3.42021-03-31The Technical specification section has been updated to remove MODE valid entries 13 and 14 as they are no longer submitted to HESA
XINSTID011.53.12021-03-11Providers 0436 College of Legal Practice Limited and 0437 ThinkSpace Education Limited. There has also been a number of changes to provider names in reconcilation across systems. No change to technical specification
UNISTATS_XCAH031.3.52021-02-26The coding frame has been updated to Common Aggregation Hierarchy version 1.3.3, amendments were actioned on feedback received from DLSG, new codes created due to changes to the CAH grouping and old codes deprecated
XCAH011.1.42021-02-26The coding frame has been updated to Common Aggregation Hierarchy version 1.3.3, amendments were actioned on feedback received from DLSG, new codes created due to changes to the CAH grouping and old codes deprecated
XCAH021.1.42021-02-26The coding frame has been updated to Common Aggregation Hierarchy version 1.3.3, amendments were actioned on feedback received from DLSG, new codes created due to changes to the CAH grouping and old codes deprecated
XCAH031.1.42021-02-26The coding frame has been updated to Common Aggregation Hierarchy version 1.3.3, amendments were actioned on feedback received from DLSG, new codes created due to changes to the CAH grouping and old codes deprecated
XCLASS011.7.12021-02-26New valid entry '7 - Other HE level qualification' has been added. Technical specification amended to add XCLASSF01 entries 15 and 16, which derives to XCLASS01 valid entry 7. Additional new XCLASSF01 valid entries 91, 92, 93, 94 and 95 have been added and derive to XCLASS01 valid entry 5. Guidance amended to remove reference to the previous coverage of the QualificationsAwarded.CLASS field
XCLASSF011.3.12021-02-26Additional new valid entries 15, 16, 91, 92, 93, 94 and 95 have been added. Guidance amended to remove reference to the previous coverage of the QualificationsAwarded.CLASS field
XETHNIC011.6.32021-02-26The Technical specification section for the Student record has been updated to add a new ETHNIC valid entry 16 (White - Other British), deriving to XETHNIC01 valid entry 10
XETHNIC021.1.32021-02-26The Technical specification section for the Student record has been updated to add a new ETHNIC valid entry 16 (White - Other British), deriving to XETHNIC01 valid entry 10
XFPE014.2.12021-02-26Derived field XHECOS_XFPE01 technical specification has been split into two separate specifications (XHECOS & XFPE01) to align with data supply and deliveries
XHECOS4.2.12021-02-26Derived field XHECOS_XFPE01 technical specification has been split into two separate specifications (XHECOS & XFPE01) to align with data supply and deliveries
XINSTG013.17.12021-02-26The second paragraph within the technical specification has been updated, the last sentence 'It uses the value for main campus postcode from the HESA Contacts database' has been replaced with 'For providers in England the postcode is taken from the OfS Register, for other nations the primary contact address postcode from the UKRLP is used'
XLEV3011.17.12021-02-26The CYY051 Technical specification section has been updated to remove COURSEAIM valid entries X41-X46
XLEV5011.18.12021-02-26The CYY051 Technical specification section has been updated to remove COURSEAIM valid entries X41-X46
XLEV6011.17.12021-02-26The CYY051 Technical specification section has been updated to remove COURSEAIM valid entries X41-X46
XMODE013.3.32021-02-26The Technical specification section has been updated to remove MODE valid entries 12,33,34,35,36 and 65. Valid entry 7 - FE continuous delivery is derived from valid entry 65 in Instance.MODE, this is for FE students in Wales and has been removed as they are no longer submitted to HESA
XMODE3011.3.32021-02-26The Cyy051 Technical specification section updated to remove XMODE01 valid entry 7
XOBTNG011.4.12021-02-26Lookup table name changed from T_QUAL_RANK_LOOKUP_DLHE to T_QUAL_RANK_LOOKUP_GO, amended within additional information and technical specification
XPDEC013.18.12021-02-26Technical specification for Cyy051 Student record table amended to remove Instance.LOCSDY valid entries C,H,J and K and Instance.MODE valid entries 12-14 and 33-36
XPGO011.5.12021-02-26Technical specification for Cyy051 student record section has been amended to remove Instance.LOCSDY valid entries C,H,J and K
XPQUAL012.21.12021-02-26The Technical specification sections for Cyy051 and Cyy054 have been amended to remove Instance.LOCSDY valid entries C,H,J and K. Additionally the technical specification tables have been updated to include Instance.ENDDATE for Cyy051 and Instance_End.ENDDATE for Cyy054. The first paragraph within the standard definition has been updated to include 'It excludes awards to incoming visiting and exchange students, students primarily studying abroad, and qualifications awarded with an end date of more than 3 years prior to the reporting period'
XPSES013.17.12021-02-26Technical specification for Cyy051 student record section has been amended to remove Instance.LOCSDY valid entries C,H,J and K and Instance.MODE valid entries 12-14, 33-36 and 65
XPSR012.9.12021-02-26Technical specification has been updated for Cyy051 to remove valid entries 12-14, 33-36 and 65 from Instance.MODE
XPUBPOPG011.3.12021-02-26The Technical specification table for the Cyy051 Student record has been updated to remove valid entry 7 from XMODE01
XQLEV10031.13.12021-02-26The table within the technical specification for Cyy051 has been updated to remove valid entries X41-X46 from XQOBTN01
XQLEV3011.18.12021-02-26The table within the technical specification for Cyy051 has been updated to remove valid entries X41-X46 from XQOBTN01
XQLEV5011.18.12021-02-26The table within the technical specification for Cyy051 Student record has been updated to remove valid entries X41-X46 from XQOBTN01
XQLEV6011.18.12021-02-26The table within the technical specification for Cyy051 Student record has been updated to remove valid entries X41-X46 from XQOBTN01
XQMODE013.6.12021-02-26The Technical specification table for Cyy051 Student record has been amended to remove Instance.MODE valid entries 12-14, 33-36 and 65. Valid entry 3 (FE continuous delivery) has been removed from XQMODE01 to reflect the removal of new Instance.MODE code 65
XQOBTN019.8.12021-02-26Valid entries X41-X46 has been removed, as Welsh for adults is no longer collected
XQPREV011.1.32021-02-26Technical specification has been created for the Cyy054 Student Alternative record to identify if a qualification has already been sent by a provider in a previous submission. Additionally Technical specification table for Cyy051 has been updated to remove entry 91 as this is no longer a valid entry in XQOBTN01
XTPOINTS1.18.12021-02-26The appendix has been updated to include new tariffable qualifications (QUALTYPEs 6U, 6V, 6Y, 7Z, 8J, 8K, 8L, 8N, 8P, 8Q, 8R, 8S, 8T, 8U, 8V, 8W, 8Z, 9A, 9J, 9P, 9R, 9S, 9T, 9Z, ER, EW, EX, EZ, FF, FG, FH, I7, I8 and N7). Additionally Qualtype's 8F, 8G, 8H, and PK have been amended as they now attracts tariff points and will be classified as HESA tariff status 1
XINSTID011.52.12021-02-20Providers 0205 Heythrop College and 0233 West London College have been removed from the valid entries. There has also been a number of changes to provider names in reconcilation across systems. No change to technical specification
XINSTID011.51.12021-02-08Provider 0435 TEDI-London has been added to the valid entries. No change to technical specification
XDOMGR015.2.32021-01-26Amendment made to label name for valid entry GREU, changed from 'Geographic region - Other European Union' to 'Geographic region - European Union', amendment required due to the impact of Brexit
XDOMGR4011.1.32021-01-26Amendment made to label name for valid entry 2, changed from 'Other European Union' to 'European Union', amendment required due to the impact of Brexit
XDOMHM012.2.32021-01-26Amendment made to label name for valid entry 6, changed from 'Other European Union' to 'European Union', amendment required due to the impact of Brexit
XDOMREG012.1.32021-01-26Amendment made to label name for valid entry GREU, changed from 'Geographic region - Other European Union' to 'Geographic region - European Union', amendment required due to the impact of Brexit
XNATGR011.8.12021-01-26Amendment made to label name for valid entry GREU, changed from 'Geographic region - Other European Union' to 'Geographic region - European Union', amendment required due to the impact of Brexit
XPSR012.8.12021-01-22Technical specification has been updated for Cyy054 to derive activity during an instance period using NOTACT and STULOAD. Additional text; updated year references and examples
XINSTID011.50.12021-01-06Providers 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
XINSTID011.49.12020-11-09Provider 0430 The College of Health Ltd has been added to the valid entries. No change to technical specification
XINSTID011.48.12020-10-26Providers 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
XINSTID011.47.12020-10-13Providers 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
XDOMUC017.1.12020-09-22Technical specification revised with the updated process used to calculate an XDOMUC01 code allocated to each Outward postcode in STATIC_DATA.OUTPC_LOOKUP_(Y2)AUG added
XINSTID011.46.12020-09-08Providers 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
XINSTID011.45.12020-09-03Providers 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
XINSTID011.44.12020-08-25The 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
XTPOINTS1.17.12020-08-25Updated Qualtype 7V grade P tariff points from 32 to 48 to match UCAS for the 2019/20 cohort
XPSR012.7.12020-08-11Technical specification has been updated for Cyy054 to include Instance_Period_Active. PERIODEND. and extra guidance
XINSTID011.43.12020-07-27Provider 1195 Itchen College has been added to the valid entries. No change to technical specification
XINSTID011.42.12020-06-25Provider 0415 Dyson Technical Training Limited has been added to the valid entries. No change to technical specification
XINSTID011.41.12020-06-16Valid entry label 0104 The Robert Gordon University changed to Robert Gordon University following a name change. No change to technical specification
UNISTATS_XCAH031.3.42020-05-27Field length amended from 3 to 11 as previously entered erroneously
UNISTATS_COURSEAIM1.7.32020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
UNISTATS_XCAH031.3.32020-05-19Valid entries and technical specification updated to replace JACS with CAH version 1.2
UNISTATS_XQOBTN021.6.32020-05-19Valid 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
XCAH011.1.32020-05-19Additional valid entry 200001 added to CAH22, this has been added as referenced in XHECOS_XFPE01
XCAH021.1.32020-05-19Additional valid entry 200001 added to CAH22-01, this has been added as referenced in XHECOS_XFPE01
XCAH031.1.32020-05-19Additional valid entry 200001 added to CAH22-01-02, this has been added as referenced in XHECOS_XFPE01
XFPE014.1.12020-05-19Switch 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
XGLEV3011.1.32020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XGLEV5011.1.32020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XHECOS4.1.12020-05-19Switch 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
XLEV3011.16.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XLEV5011.17.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XLEV6011.16.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XOBTNG011.3.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XPDEC013.17.12020-05-19Additional 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
XPGO011.4.12020-05-19New 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
XPQUAL012.20.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XPSES013.16.12020-05-19Additional 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
XQLEV10031.12.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XQLEV3011.17.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XQLEV5011.17.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XQLEV6011.17.12020-05-19Valid entry I13 (Access course or pathway programme at level 5) amended and changed to J13 (Access course or pathway programme at level 5
XQOBTN019.7.12020-05-19Valid 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
XTPOINTS1.16.12020-05-19Updated name labels to match those found in Qualification.QUALTYPE
XTPOINTSGP011.1.22020-05-19Technical specification tables amended for CYY051 and CYY054, NA was moved over into the XTPOINTSGP01 column
ZWLSSBJCA021.3.12020-05-19Valid entry 100335 (Welsh Studies) added to additional information and technical specification
UNISTATS_COURSEAIM1.7.22020-03-26Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 07 and M13 & E13 into 03
UNISTATS_XQOBTN021.6.22020-03-26New valid entries added C13, I13 & H13 into 07 and M13 & E13 into 03
XCAH011.1.22020-03-26The coding frame has been updated to HECoS rather than JACS valid entries
XCAH021.1.22020-03-26The coding frame has been updated to HECoS rather than JACS valid entries
XCAH031.1.22020-03-26The coding frame has been updated to HECoS rather than JACS valid entries
XDOMGR015.2.22020-03-26Copyright information added
XDOMGR4011.1.22020-03-26Copyright information added
XDOMHM012.2.22020-03-26Copyright information added
XDOMREG012.1.22020-03-26Copyright information added
XDOMUC016.5.22020-03-26Copyright information added
XETHNIC011.6.22020-03-26The Technical specification section for the Student record has been updated to remove ETHNIC valid entries 11 and 12, deriving to XETHNIC01 valid entry 10
XETHNIC021.1.22020-03-26The Technical specification section for the Student record has been updated to remove ETHNIC valid entries 11 and 12, deriving to XETHNIC02 valid entry 10
XFTE013.4.12020-03-26Guidance 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
XGLEV3011.1.22020-03-26Technical specifications updated to add new valid entries added C13, I13 & H13 into 2 and M13 & E13 into 1
XGLEV5011.1.22020-03-26Technical specifications updated to add new valid entries C13, I13 & H13 into 4 and M13 & E13 into 2
XHOOS012.1.22020-03-26Copyright information added
XINSTC011.18.12020-03-26Technical 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
XINSTCOU011.1.32020-03-26Copyright information added
XINSTG013.16.12020-03-26Technical 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
XLEV3011.15.12020-03-26Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 02 and M13 & E13 into 01
XLEV5011.16.12020-03-26Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 04 and M13 & E13 into 02
XLEV6011.15.12020-03-26Valid entry Z99 removed from technical specification. New valid entries added C13, I13 & H13 into 05 and M13 & E13 into 03
XMODE013.3.22020-03-26Valid 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
XMODE3011.3.22020-03-26Technical specification section updated to remove XMODE01 valid entries 8 and 9 from the derivation in the Cyy051 Student record
XOBTNG011.2.12020-03-26Valid entries have been updated to include new entries C13, H13, I13, E13 and M13. CSV also updated to include the new entries
XPDEC013.16.12020-03-26Technical 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
XPGO011.3.12020-03-26Technical specifications updated to remove Instance.MODE valid entry 98
XPQUAL012.19.12020-03-26The 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
XPSES013.15.12020-03-26Technical 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
XPSR012.6.12020-03-26Technical 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
XQLEV10031.11.12020-03-26The 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
XQLEV3011.16.12020-03-26The 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
XQLEV5011.16.12020-03-26The 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
XQLEV6011.16.12020-03-26The 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
XQMODE013.5.12020-03-26Valid 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
XQOBTN019.6.12020-03-26Valid entries have been updated to include new entries C13, H13, I13, E13 and M13. CSV also updated to include the new entries
XQPREV011.1.22020-03-26Valid 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
XTPOINTS1.15.12020-03-26The 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'
ZFUNDCODE011.1.22020-03-26Valid 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
ZWLSSBJCA021.2.12020-03-26Valid entries and technical specification updated with HECoS codes
XINSTID011.40.12020-03-18The 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
XPROVCAT1.1.12020-03-03Created and copyright information has also been added to the additional information section
XINSTID011.39.12020-01-27A 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
XINSTID011.38.12020-01-16The following providers have been added to the valid entries: 0363 University Global Banking School Limited and 0401 Lamda Limited. No change to technical specification
XINSTID011.37.12019-12-13Valid entry label 0095 University of Abertay Dundee changed to Abertay University following a name change. No change to technical specification
XINSTID011.36.12019-10-09The 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
XDOMUC016.5.12019-09-19The 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
XINSTID011.35.12019-09-19The following provider 0322 The Sherwood Institute, has been merged with 0407 The Sherwood Psychotherapy Training Institute Limited
XTPOINTS1.14.12019-09-19Step 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
XINSTID011.34.12019-07-25The 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
XTPOINTS1.13.12019-07-09The 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
XINSTID011.33.12019-06-19The 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
XDOMUC016.4.12019-06-14Valid 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
XMSFUND012.3.12019-05-23The technical specification section has been amended to add valid entry 08 'Research England' in Course.MSFUND
UNISTATS_COURSEAIM1.7.12019-04-11Codes H24 have been removed
XPDEC013.15.12019-04-11Addition of section 'All Course. COURSEAIM codes beginning Z' to be derived to XPDEC01 0
XTPOINTS1.12.12019-04-11The 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
XETHNIC021.1.12019-03-11New derived field for ethnicity to split out 'Mixed' from 'Other'
XNATGR011.7.12019-03-11The field has been added to the CYY054 record
XPDEC013.14.12019-03-11Addition of 'Z' to the following section 'All Course. COURSEAIM codes beginning P, Q, R, S, X'
XPQUAL012.18.12019-03-11The Technical Specification sections has been updated to remove QUAL valid entries L91, M91, H91 and I91
XCAH011.1.12019-03-07New derived field to determine the Common Aggregation Hierarchy, first level grouping
XCAH021.1.12019-03-07New derived field to determine the Common Aggregation Hierarchy, first level grouping
XCAH031.1.12019-03-07New derived field to determine the Common Aggregation Hierarchy, first level grouping
XTPOINTS1.11.12019-03-07The 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_STAT1.1.42019-02-21Deriation amended to exclude Further Education students as well as where the highest qualification obtained is unknown
XPGO011.2.12019-02-21Technical specifications updated to remove QUALS L91, M91, H91 and I91
XQLEV10031.10.12019-02-21The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91
XQLEV3011.15.12019-02-21The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91
XQLEV5011.15.12019-02-21The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91
XQLEV6011.15.12019-02-21The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91
XQOBTN019.5.12019-02-21The Technical Specification section has been updated to remove XQOBTN01 valid entries L91, M91, H91 and I91
XINSTID011.32.12018-11-30The following providers have been added; 0342 Christ the Redeemer College, 0343 Waltham International College Limited, 0355 London College of International Business Studies Ltd
XQLEV7011.4.12018-11-30The Technical Specification section has been updated to add XQLEV501 valid entry 1 to the AP student derivations
XINSTID011.31.12018-11-05The 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
XTPOINTS1.10.12018-10-30Following confirmation from UCAS, the tariff points have been updated for QUALTYPEs LK, LV, LW, LX
XLEV3011.14.12018-10-02The 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
XTPOINTS1.9.12018-09-18A number of QUALGRADE percentages have been updated from "0.XX" format to "XX%" to align with the QUALGRADE field
XTPOINTS1.8.12018-09-07A 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
XLEV5011.15.12018-08-21The 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
XLEV6011.14.12018-08-21The 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
XPUBPOPG011.2.12018-08-21Reference to the AP Student record added for clarification
XTPOINTS1.7.12018-08-21The 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
XPQUAL012.17.12018-07-06The Cyy054 Technical Specification section has been updated to correct the Instance_End.EXCHIND codes
XTPOINTS1.6.12018-06-29A 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
XINSTID011.30.12018-05-11The 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
XPQUAL012.16.12018-05-10The 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
XQLEV10031.9.12018-05-10The 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
XQLEV3011.14.12018-05-10The 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
XQLEV5011.14.12018-05-10The 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
XQLEV6011.14.12018-05-10The 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
XTPOINTS1.5.12018-05-10The appendix has been updated to include new tariffable qualifications
UNISTATS_ITT1.4.12018-05-09Removed TTCID codes G and 8 to reflect their removal from C17054 and C17051
UNISTATS_COURSEAIM1.6.12018-04-26Code D01 has been removed
UNISTATS_XQOBTN021.6.12018-04-26Code D01 has been removed
XPQUAL012.15.12018-04-26The Technical Specification section has been updated to remove QUAL D01
XTPOINTS1.4.12018-04-26The appendix has been updated to include new tariffable qualifications
XGLEV3011.1.12018-04-05Field created
XGLEV5011.1.12018-04-05Field created
XOBTNG011.1.12018-04-05Created
XPGO011.1.12018-04-05Field Created
XPUBPOPG011.1.12018-04-05Field created
XQLEV10031.8.12018-02-22The Technical Specification section has been updated to remove XQOBTN01 valid entry D01
XQOBTN019.4.12018-02-22The Technical Specification section has been updated to remove XQOBTN01 valid entry D01
XQPREV011.1.12018-02-22New field for 2017/18
XTPOINTSGP011.1.12018-02-22Created for 2017/18
XTPOINTS1.3.12018-02-07The 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
XCLASS011.6.12018-01-31Technical specification amended to remove XCLASSF01 valid entries 04 and 06
XCLASSF011.2.12018-01-31Valid entries 04 'Undivided second class honours' and 06 'Fourth class honours' have been removed
XLEV3011.13.12018-01-31The CYY051 Technical Specification section has been updated to remove COURSEAIM valid entry D01
XLEV5011.14.12018-01-31The CYY051 Technical Specification section has been updated to remove COURSEAIM valid entry D01
XLEV6011.13.12018-01-31The CYY051 Technical Specification section has been updated to remove COURSEAIM valid entry D01
XMSTUFEE011.5.12018-01-31Technical Specification section updated to remove MSTUFEE valid entry 07. This change applies to both records
XQLEV3011.13.12018-01-31The Technical Specification section has been updated to remove XQOBTN01 valid entry D01
XQLEV5011.13.12018-01-31The Technical Specification section has been updated to remove XQOBTN01 valid entry D01
XQLEV6011.13.12018-01-31The Technical Specification section has been updated to remove XQOBTN01 valid entry D01
XINSTID011.29.12018-01-02The 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
XETHNIC011.6.12017-10-31The 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
XPSR012.5.12017-09-05Addition of Instance.MODE to the technical specification for the Cyy054 AP student record
XTPOINTS1.2.12017-09-05Appendix 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_ITT1.3.12017-08-25Updated TTCID codes for AP student to reflect schema additions for C15054 and C16054
XPSES013.14.12017-06-01Technical specification for the Cyy051 Student record updated to cater for instances where the Course.COURSEAIM is returned as Z99
UNISTATS_ITT1.2.52017-02-17Updated TTCID codes to reflect codes in place for 15/16
UNISTATS_XQOBTN021.5.12017-02-17Added in new codes I78 and M73
XETHNIC011.5.12017-02-10The 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
XSTUDIS011.4.12017-02-10The 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
XTPOINTS1.1.12017-01-31First 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
XTPOINTS0.52017-01-16Appendix 1 updated to remove duplicated entries for QUALTYPEs A3-A9 and AY, and revising the labels for the above
XFPE013.6.12016-11-03Technical 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
XHECOS3.6.12016-11-03Technical 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
XFPE013.5.22016-11-01Technical 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
XHECOS3.5.22016-11-01Technical 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
XINSTID011.28.12016-11-01Valid entries updated to include providers expected to return data to HESA for the 16/17 collections
XLEV3011.12.12016-11-01The 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
XLEV5011.13.12016-11-01The 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
XLEV6011.12.12016-11-01The 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
XMODE013.3.12016-11-01New 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
XMODE3011.3.12016-11-01Technical 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
XMSFUND012.2.12016-11-01The 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
XMSTUFEE011.4.12016-11-01Technical 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
XPDEC013.13.12016-11-01Addition 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
XPQUAL012.14.12016-11-01The 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
XPSES013.13.12016-11-01Addition 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
XPSR012.4.22016-11-01Text 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
XQLEV10031.7.12016-11-01The 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
XQLEV3011.12.12016-11-01The 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
XQLEV5011.12.12016-11-01The 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
XQLEV6011.12.12016-11-01The 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
XQLEV7011.3.12016-11-01The 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
XQMODE013.4.12016-11-01The 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
XQOBTN019.3.12016-11-01Valid 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
XQOBTN019.3.12016-11-01Valid entries revised to remove D01 associated with old valid entries in QualificationsAwarded.QUAL
XTPOINTS0.42016-11-01First 2016/17 version created of this specification, following drafting process in 2015/16
XAGEJ011.4.22016-10-15Technical specification corrected to replace an error in the table. The first row of the 'Otherwise' section should derive to 'DIFF'
XDOM012.4.12016-10-15The 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
XDOMUC016.3.12016-10-15The 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
XINSTID011.27.12016-09-28Valid 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
XDOMGR015.2.12016-09-12Technical specification revised to update references to T_OVERSEAS_LOOKUP_V8, which has been replaced with T_OVERSEAS_LOOKUP_V9
XNATGR011.6.12016-09-12Technical specification revised to update references to T_OVERSEAS_LOOKUP_V8, which has been replaced by T_OVERSEAS_LOOKUP_V9
ZFUNDCODE011.1.12016-07-11Created
ZLANGPCNT011.1.12016-07-11Created
ZWLSSBJCA021.1.12016-07-11Created
XUHN011.1.12016-07-04Created
XREG013.6.12016-03-31Technical 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
XINSTID011.26.12016-02-25Valid 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_COURSEAIM1.5.12016-02-20Added in codes I78, M73 and Z99
XQLEV10031.6.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XQLEV3011.11.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XQLEV5011.11.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XQLEV6011.11.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XQLEV7011.2.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XQMODE013.3.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XQOBTN019.2.12016-02-09Technical 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
XQUALENT011.5.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XSTUDIS011.3.12016-02-09The Technical Specification section has been revised to express the requirements separately for the Student and AP student collections. No change to function
XLEV3011.11.12016-02-08Technical 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
XLEV5011.12.12016-02-08Technical 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
XLEV6011.11.12016-02-08Technical 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
XMODE3011.2.12016-02-08Technical 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
XEPYEAR012.2.12016-01-12Technical specification updated to unambiguously express the value that should be created in this field. No change to function
XETHNIC011.4.12016-01-12The 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
XYEARM012.5.12016-01-12Technical specification updated to unambiguously express the value that should be created in this field. No change to function
XDOMHM012.2.12016-01-11XDOMGR01 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
XMSTUFEE011.3.12016-01-08Valid 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
XETHNIC011.3.12015-09-29Technical 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_STAT1.1.32015-08-20Added in derivation for AP student
UNISTATS_ITT1.2.42015-08-20Derivation table added for AP student
UNISTATS_MODE1.2.52015-08-20Additional information’ updated to include information on AP student derived field
UNISTATS_TPROV1.1.22015-08-20Updated to include derivation for AP student
UNISTATS_XCAH031.3.22015-08-20Included reference for AP student data 2014/15
UNISTATS_CONT_STAT1.1.22015-07-10Added in Unistats field to specification
UNISTATS_HIQUAL21.1.22015-07-10Added new Unistats field to specification
XFPE013.5.12015-07-07Technical 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
XHECOS3.5.12015-07-07Technical 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
ZNOTEND011.1.12015-07-01Created
XLEV6011.10.22015-06-18Minor 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'
ZSTARTMONTH011.1.12015-06-15Created
ZSTARTYEAR011.1.12015-06-15Created
XDOMUC016.2.12015-06-03Valid entries for Northern Ireland revised in line with changes to local government geographies. Valid entries C011 - C036 removed, C040 - C051 added
XINSTID011.25.12015-06-03Valid 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_XQOBTN021.4.12015-05-27Added in new codes H12, I12, I73
XINSTID011.24.12015-05-19Valid entry 0264 removed and replaced with 0327 following clarification of the structure of the Regents English Language Centre, International Bible Institute of London
XMSTUFEE011.2.12015-04-16Valid entry 30 added to Technical Specification. This valid entry is only available in the Cyy051 Student record
XINSTCOU011.1.22015-04-01Minor error correction to bottom row of Technical Specification table, correcting the cited UKPRN of '10007774' to '10007773'
XCLASSF011.1.22015-03-30Error 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
XCLASS011.5.12015-03-12Technical specification amended to add XCLASSF01 valid entry A to those which derive to XCLASS01 valid entry A
XHOOS012.1.12015-03-03Addition of valid entry 3 'Not known' to accommodate the addition of corresponding valid entry 8 in XDOMHM01
UNISTATS_COURSEAIM1.3.12015-02-20Added code M28 (note: H24 is no longer valid code in 2013/14, left in to make this spec backwards compatible
XINSTC011.17.32015-02-12Technical 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
XINSTG013.15.32015-02-12Technical 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
XINSTID011.23.22015-02-12Technical 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_COURSEAIM1.4.12015-02-10Added in codes H12, I12, I73
XDOMGR4011.1.12015-01-09Created for 2014/15
XMODE3011.1.12015-01-09Created for 2014/15
XQLEV7011.1.12015-01-09Created for 2014/15
XCLASS011.4.12015-01-08Technical 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
XCLASSF011.1.12015-01-08Created
XINSTCOU011.1.12014-12-09Created
XINSTID011.23.12014-11-18The 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
XINSTID011.22.12014-11-17Valid entry label 0113 Brunel University changed to Brunel University London following name change
XAGEA011.6.12014-10-16Technical specification amended to allow for the use of this field in the Cyy054 AP student record
XAGEJ011.4.12014-10-16Technical specification amended to allow for the use of this field in the Cyy054 AP student record
XDOM012.3.22014-10-16Additional 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
XDOMGR015.1.12014-10-16Technical 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
XDOMHM012.1.12014-10-16Valid entry 8 'Not known' added, to allow for new valid entry NOTK in XDOMGR01. Technical specification and Additional information sections adapted accordingly
XDOMREG012.1.12014-10-16Valid 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
XDOMUC016.1.12014-10-16Technical 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
XELSP011.4.22014-10-16Additional information text amended to allow for the use of this field in the Cyy054 AP Student record
XEPYEAR012.1.22014-10-16Long 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
XETHNIC011.2.22014-10-16Technical specification amended to allow for the use of this field in the Cyy054 AP student record
XFPE013.4.12014-10-16Technical 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
XFYEAR011.2.52014-10-16Technical specification text amended to allow for the use of this field in the Cyy054 AP student record
XFYRSR011.2.42014-10-16Technical specification text amended to allow for the use of this field in the Cyy054 AP student record
XHECOS3.4.12014-10-16Technical 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
XINSTC011.17.22014-10-16Additional 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
XINSTG013.15.22014-10-16Additional 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
XLEV3011.10.12014-10-16Addition of new Early Years Teacher Status (EYTS) COURSEAM codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XLEV5011.11.12014-10-16Addition of new Early Years Teacher Status (EYTS) COURSEAM codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XLEV6011.10.12014-10-16Addition of new Early Years Teacher Status (EYTS) COURSEAM codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XMODE013.2.12014-10-16'Definition' section within Additional Information removed as it duplicates the Technical Specification
XMSTUFEE011.1.32014-10-16Additional 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
XPDEC013.12.12014-10-16Addition 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
XPQUAL012.13.12014-10-16Addition 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
XPSES013.12.12014-10-16Addition 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
XPSR012.4.12014-10-16Addition 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
XQLEV10031.5.12014-10-16Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XQLEV3011.10.12014-10-16Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XQLEV5011.10.12014-10-16Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XQLEV6011.10.12014-10-16Addition of new Early Years Teacher Status (EYTS) QUAL codes H12, I12, and I73 to Technical Specification. Additional information adjusted accordingly
XQMODE013.2.12014-10-16Additional 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
XQOBTN019.1.12014-10-16Addition 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
XQUALENT011.4.12014-10-16Added 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
XREG013.5.12014-10-16Long 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
XSTUDIS011.2.12014-10-16Additional 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
XYEARM012.4.12014-10-16Long 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
XDOM012.3.12014-10-10Valid 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
XINSTID011.21.12014-09-22Valid 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
XINSTC011.17.12014-08-27Higher 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
XINSTG013.15.12014-08-27Higher education provider (HEP) name change applied to field. Subsequent long name change
UNISTATS_TPROV1.1.12014-08-20For student data from 2014/15, replaces UNISTATS_TINSTMERGE, this version highlights the difference
UNISTATS_XQOBTN021.3.12014-06-22Added in new code M28
XINSTID011.20.22014-06-06Valid entry label St Mary's University College, Twickenham changed to St Mary's University, Twickenham following name change. No change to technical specification
XDOMUC015.4.12014-05-09Valid 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
XYEARM012.3.12014-04-14Technical specification amended to reinstate Instance.MODE 61, which is present on the HIN register
XREG013.4.12014-04-02Technical Specification amended to reinstate Instance.MODE 61, which is present on the HIN register
XNATGR011.5.12014-02-22Technical 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_COURSEAIM1.2.12014-02-10Added in codes M44 and H62
XPDEC013.11.12014-01-23Addition 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
XINSTID011.20.12014-01-13Technical 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
XINSTID011.19.12013-12-05The 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
XINSTID011.18.12013-12-04The following name change has been applied: 0139 Queen Mary University of London
XINSTID011.17.12013-11-06The following name change has been applied: 0217 IFS School of Finance to IFS University College
XQOBTN018.1.12013-10-21New code M28 added to valid entries. Technical specification amended, adding this code to the ranking table
XREG013.3.12013-10-21Technical Specification amended to remove Instance.MODE 61, which no longer exists
XYEARM012.2.12013-10-21Technical specification amended to remove Instance.MODE 61, which no longer exists
XQMODE013.1.12013-10-18Additional 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
XFTE013.3.12013-10-03XFTE01 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
XPQUAL012.12.12013-10-02Addition 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
XPSES013.11.12013-10-02Addition 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
XPSR012.3.12013-10-02Addition 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
XQLEV10031.4.12013-10-02Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly
XQLEV3011.9.12013-10-02Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly
XQLEV5011.9.12013-10-02Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly
XQLEV6011.9.12013-10-02Addition of code M28 to the Technical specification due to a corresponding change in XQOBTN01. Additional information adjusted accordingly
XPDEC013.10.12013-10-01Addition 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
XELSP011.4.12013-09-30Technical 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
XFPE013.3.12013-09-30Minor 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
XHECOS3.3.12013-09-30Minor 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
XINSTC011.16.22013-09-30Table suffixes changed to be non-year specific, with explanatory sentence added
XINSTG013.14.22013-09-30Table suffixes changed to be non-year specific, with explanatory sentence added
XLEV3011.9.12013-09-30Addition of code M28 and removal of code H24 from the technical specification due to changes in Course.COURSEAIM. Additional information adjusted accordingly
XLEV5011.10.12013-09-30Addition of code M28 and removal of code H24 from the technical specification due to changes in Course.COURSEAIM. Additional information adjusted accordingly
XLEV6011.9.12013-09-30Addition of code M28 and removal of code H24 from the technical specification due to changes in Course.COURSEAIM. Additional information adjusted accordingly
XMODE013.1.12013-09-30Additional 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
XMSFUND012.1.12013-09-30Additional 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
XDOMGR014.10.12013-09-27Technical 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
XDOMREG011.1.32013-09-27Addition of a dependent field - XPUBPOP01 in the DLHE collection
XDOMUC015.3.12013-09-27Technical 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
XINSTID011.16.12013-09-24The following provider has been removed from the valid entries: 0213 AECC Chiropractic College. 0214 BPP University College has changed its name to BPP University
XINSTID011.15.12013-08-01The following provider has been added to the valid entries: 0227 London School of Science and Technology
XPSR012.2.92013-07-23Additional 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_XQOBTN021.2.12013-06-09Added in new codes M44, H62
XINSTID011.14.12013-05-02The 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
XAGRP6011.1.92013-04-08Correction of the format of derived field XAGEA01 in the technical specification from INT 2 to CHAR 2. No change to function
XAGRPA011.1.92013-04-08Correction of the format of derived field XAGEA01 in the technical specification from INT 2 to CHAR 2. No change to function
XAGRPJ011.1.102013-04-08Correction of the format of derived field XAGEJ01 in the technical specification from INT 2 to CHAR 2. No change to function
XFPE013.2.12013-04-08Technical 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
XHECOS3.2.12013-04-08Technical 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
XQEYEAR011.1.32013-03-15Removal of reference to this field being present on the HINEP register, which ceased from C11051 onwards
XDOM012.2.12013-03-14Valid 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
XINSTID011.13.12013-02-28The following name changes have been applied: 0014 University of St Mark and St John and 0028 Newman University
XINSTC011.16.12013-02-06Updated 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
XINSTG013.14.12013-02-06Updated 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
XQMODE012.3.32013-02-05Removal of reference to XPDLHE01 population in Additional Information. No change to technical specification
XQOBTN017.1.12013-02-05New codes M44 and H62 added to valid entries. Technical specification amended, adding these codes to the ranking table
XQUALENT011.3.12013-02-05Added new EntryProfile.QUALENT3 valid entries of P93 and P94 to Technical Specification
XPQUAL012.11.12013-02-01Added new QualificationsAwarded.QUAL codes of H62 and M44 to Technical Specification
XPSES013.10.12013-02-01Addition 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
XPSR012.2.82013-02-01References to the Training and Development Agency (TDA) updated to Teaching Agency (TA
XQLEV10031.3.12013-02-01Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly
XQLEV3011.8.12013-02-01Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly
XQLEV5011.8.12013-02-01Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly
XQLEV6011.8.12013-02-01Addition of codes M44 and H62 to Technical specification due to their addition in XQOBTN01. Additional information adjusted accordingly
XINSTID011.12.12013-01-31The 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
XLEV3011.8.12013-01-21Addition of codes M44 and H62 to technical specification due to their addition in Course.COURSEAIM. Additional information adjusted accordingly
XLEV5011.9.12013-01-21Addition of codes M44 and H62 to technical specification due to their addition in Course.COURSEAIM. Additional information adjusted accordingly
XLEV6011.8.12013-01-21Addition of codes M44 and H62 to technical specification due to their addition in Course.COURSEAIM. Additional information adjusted accordingly
XMSFUND011.2.12013-01-21Course.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
XAGEA011.5.12013-01-17Technical 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
XFPE013.1.12013-01-11Switch of JACS codes to the version 3.0 coding frame. Added XJACSLEV101, XJACSLEV201, and XJACSLEV301 to list of dependent fields
XHECOS3.1.12013-01-11Switch of JACS codes to the version 3.0 coding frame. Added XJACSLEV101, XJACSLEV201, and XJACSLEV301 to list of dependent fields
XDOMGR014.9.12013-01-09Updated 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
XDOMUC015.2.12013-01-09Updated 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
XELSP011.3.62013-01-09Minor 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'
XETHNIC011.2.12013-01-09New 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
XFTE013.2.12013-01-09Text 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
XAGRPJ011.1.92013-01-08Additional information text, second paragraph change from incorrect 'August' to 'July'. No change to function
XINSTID011.11.12012-12-20Removal 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
XINSTID011.10.12012-10-19Amended list to change 0175 Scottish Agricultural College to SRUC
XFTE013.1.22012-08-15Instance.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
XQOBTN016.2.32012-05-02Technical specification text clarified to aid creation of function and testing. No change to valid entries or ranking table
XDOMGR014.8.22012-04-12Field 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
XDOMUC015.1.22012-04-12Reference to 'Government Office Region' changed to 'Region' in the lookup table column descriptions following ONS policy change. No change to function or valid entries
XINSTC011.15.22012-04-12Reference to 'Government Office Region' changed to 'Region' in INSTHQPC column description following ONS policy change. No change to function or valid entries
XINSTG013.13.22012-04-12Field 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
XQOBTN016.2.22012-04-11Labels 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
XAGEJ011.3.22012-03-14Additional information BIRTHDTE example format changed to ISO 8601 yyyy-mm-dd
XSTUDIS011.1.22012-03-01Additional information paragraph added regarding the coding of valid entries L Information refused, N Information not sought or N Not known
UNISTATS_MODE1.2.42012-02-17UNISTATS_MODE to replace the existing version and UNISTATS_QMODE as these can be combined for full-time and part-time qualifiers
UNISTATS_PROGTYPE1.1.12012-02-17Same as TQI_PROGTYPE_1.2.1
UNISTATS_XLEV5011.1.12012-02-17New for 2011/12
UNISTATS_XPSR011.1.12012-02-17Same as TQI_XPSR01_1.1.1
UNISTATS_XQOBTN021.1.12012-02-17Same as TQI_XQOBTN02_1.1.1
XNATGR011.4.12012-02-17Technical 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
XPDEC013.9.12012-02-17Removal 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
XPQUAL012.10.22012-02-17Removal of reference in Additional Information to the Student Associates Scheme (SAS), as this has ceased to exist
XPSES013.9.12012-02-17Removal 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
XPSR012.2.72012-02-17Removal 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
XQMODE012.3.22012-02-17Addition of a reference to the XPDLHE02 population to Additional Information. No change to technical specification
XQOBTN016.2.12012-02-17Ranking number format changed to include leading zeroes up to three digits in length. No change to function
XDOM012.1.12012-02-09New 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
XDOMGR014.8.12012-02-09Technical 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
XDOMUC015.1.12012-02-09New 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
XELSP011.3.52012-02-09Valid 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'
XINSTC011.15.12012-02-09Updated for new version of lookup 12AUG
XINSTG013.13.12012-02-09Updated for new version of lookup table 12AUG. Reference to NSPD updated to ONSPD
XMSFUND011.1.22012-02-09Additional information: Funding bodies names updates 'Skills Funding Agency, Young People's Learning Agency, Welsh Government DCELLS and The Teaching Agency'
XAGRP6011.1.82012-02-06Additional information text, second paragraph updated for clarity
XAGRPA011.1.82012-02-06Additional information text, second paragraph updated for clarity
XAGRPJ011.1.82012-02-06Additional information text, second paragraph updated for clarity
XCLASS011.3.12012-02-06QualificationsAwarded.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
XINSTID011.9.12012-01-27Switch 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
XINSTID011.8.12011-10-27Amended list to change 0089 University of Wales Institute, Cardiff to Cardiff Metropolitan University
XINSTID011.7.12011-09-13Amended list to change name of The Royal Scottish Academy of Music and Drama (0101) to Royal Conservatoire of Scotland
XEPYEAR012.1.12011-09-07Valid 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
XINSTC011.14.22011-08-31Updated to clarify UKRPN for Cyy031
XNATGR011.3.12011-06-10Addition 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
XQLEV10031.2.32011-05-31Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___'
XQLEV3011.7.32011-05-31Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___'
XQLEV5011.7.32011-05-31Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___'
XQLEV6011.7.32011-05-31Correction to Technical specification XQOBTN01 (CHAR 3) '__' to '___'
XDOMGR014.7.12011-04-13Updated for new version of lookup 11AUG
XDOMUC014.4.12011-04-13Updated for new version of lookup 11AUG
XINSTC011.14.12011-04-13Updated for new version of lookup 11AUG
XINSTG013.12.22011-04-13Updated to clarify UKRPN for Cyy031
XINSTG013.12.12011-04-13Updated for new lookup table 11AUG
XINSTID011.6.12011-04-07Amended list to change name of Thames Valley University (0080) to The University of West London
XINSTID011.5.12011-03-18Amended list to change name of UHI Millennium Institute to University of the Highlands and Islands
XQUALENT011.2.12011-03-11Added EntryProfile.QUALENT2 value of 48 to accommodate historical instances in HIN register
UNISTATS_CONT_STAT1.1.12011-03-09From 2011/12 (same as TQI_CONT_STAT
UNISTATS_COURSEAIM1.1.12011-03-09From 2011/12 (same as TQI_COURSEAIM_1.1.1
XQUALENT011.1.22011-03-08To clarify processing required, added 'or' column in Technical Specification. Additional information text added regarding the return of null
XREG013.2.12011-03-03Technical Specification updated to match function and clarify allocation of last character
XNATGR011.2.12011-03-01Added Technical specification step - that function will fail if Student.NATION value cannnot be found in T_OVERSEAS_LOOKUP_V5.ISO_DOMICILE
XAGEJ011.3.12011-02-24Technical specification amended to account for future value in student collection. Removal of Cyy025.BIRTHDTE as not applicable to Staff
XAGEA011.4.12011-01-31Technical specifcation amended to account for potential future value in Student record
XAGRP6011.1.72011-01-31Amended label format for valid entry 1 and field name
XAGRPA011.1.72011-01-31Amended label format for valid entry 1 and field name
XAGRPJ011.1.72011-01-31Amended label format for valid entry 1 and field name
XDOMGR014.6.12011-01-31Updated for new version of lookup 11MAY
XDOMUC014.3.12011-01-31Updated for new version of lookup 11MAY
XFTE013.1.12011-01-31Length extended from 5 to 6, to accommodate change in stored format to 2 decimal places. Also rounding and not trimming specified in calculation
XINSTC011.13.12011-01-31Updated for new version of lookup 11MAY
XINSTG013.11.12011-01-31Updated for new lookup table 11MAY
XINSTID011.4.12011-01-31Amended list to remove 0092 Trinity University College, update names of 0176 to University of Wales Trinity Saint David and 0079 to Teesside University
XNATGR011.1.12011-01-31Created
XPDEC013.8.12011-01-31Added 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
XPQUAL012.10.12011-01-31Added 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
XPSES013.8.12011-01-31Added 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
XQLEV10031.2.22011-01-31Amended field name to 'Level of qualification'
XQLEV5011.7.22011-01-31Amended field name to 'Level of qualification'
XQLEV6011.7.22011-01-31Amended field name to 'Level of qualification'
XQUALENT011.1.12011-01-31Created
XSTUDIS011.1.12011-01-31Created
XQLEV3011.7.22011-01-30Amended field name to 'Level of qualification'
XAGEA011.3.42010-11-08Additional information for valid entry 99 added where validation is switched. No change to function
XAGEJ011.2.42010-11-08Additional information for valid entry 99 added where validation is switched. No change to function
XAGRP6011.1.62010-11-08Unknown added to 00 and 99 Additional information text. No change to function
XAGRPA011.1.62010-11-08Unknown added to 99 Additional information text. No change to function
XAGRPJ011.1.62010-11-08Unknown added to 99 Additional information text. No change to function
XINSTC011.12.32010-10-01yy042 added to technical specification header. No change to function
XINSTG013.10.22010-10-01yy042 added to technical specification header. No change to function
XINSTID011.3.22010-10-01yy042 added to technical specification header. No change to function
XPQUAL012.9.12010-09-03Added codes D01, M02, M79, M26, H79, I79, C77 and C78
XPSR012.2.62010-09-01Correct typo in technical specification to show that XPSR01 derives to 0 when Instance.TYPEYR is 5
XINSTID011.3.12010-07-14Valid entry change of Ravensbourne College of Design and Communication changed to Ravensbourne
XINSTC011.12.22010-06-24Error handling clarified for circumstances where value not found in lookup table (Note to technical specification
XINSTG013.10.12010-06-23Error handling clarified for circumstances where value not found in lookup table. Change to function required to handle
XINSTID011.2.22010-06-23Error handling clarified for circumstances where value not found in lookup table
XPDEC013.7.12010-06-23Added null value for Instance.LOCSDY
XPQUAL012.8.12010-06-23Added null value for Instance.LOCSDY
XPSES013.7.12010-06-23Updated for null values of Instance.LOCSDY and Course.TTCID added
XREG013.1.32010-06-07Technical 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
XDOMUC014.2.12010-05-14Otherwise 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
XDOMGR014.5.22010-05-13All references of 09MAY lookup updated to 10MAY
XFTE012.1.22010-05-13Note added to Additional information 'XFTE01 will normally be analysed after the application of the HESA session population (XPSES01)'
XLEV5011.8.12010-05-12Correction to technical specification - XLEV501=4 Course.COURSEAIM list 99 corrected to H99
XPQUAL012.7.12010-05-12Error correction - Instance.EXCHANGE code 0 removed from first row of Technical Specification
XPSR012.2.52010-05-12Note added beneath Technical specification to highlight Instance.COMDATE is mandatory enforced by a business rule
XINSTG013.9.22010-05-07Typo corrections to Technical specification (XINSTC01 column corrected to XINSTG01 and F_CTRY to F_GOR) - No change required to function
XAGEJ011.2.32010-04-16Valid entries listed in full. No change to function
XAGRP6011.1.52010-04-12Format amendments. No change to technical specification
XAGRPJ011.1.52010-04-12Minor text amendments. No change to function
XDOM011.1.52010-04-12Text amendments. No change to function
XINSTC011.12.12010-04-12Using new lookup table - 10MAY
XINSTG013.9.12010-04-12Using new lookup table - 10MAY
XQEYEAR011.1.22010-04-12Text amendments. No change to function
XQLEV5011.7.12010-04-12New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added
XFYEAR011.2.42010-04-10Minor text amendments. No change to function
XAGEA011.3.32010-04-09Minor text amendments. Valid entries listed in full. No change to function
XAGRPA011.1.52010-04-09Minor text amendments. No change to function
XDOMGR014.5.12010-04-09Updated for new version of lookup 10MAY
XDOMHM011.4.42010-04-09Minor text revision to Additional information. No change to Technical specification
XDOMUC014.1.12010-04-09New 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
XELSP011.3.42010-04-09Minor text amendments, with addition of text for reduced records 06 and 07. Technical specification text changes and re-ordering, but no change to function
XEPYEAR011.1.42010-04-09Technical specification updated to clarify that XEPYEAR is updated when an Entry Profile is supplied, regardless of whether elements have changed
XFPE012.1.12010-04-09Added XJACSA01, XJACS201 and new Instance.COURSEID to technical specification
XFTE012.1.12010-04-09Added XJACS201 and new Module.MODID to technical specification
XHECOS2.1.12010-04-09Added XJACSA01, XJACS201 and new Instance.COURSEID to technical specification
XLEV3011.7.12010-04-09New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added
XLEV5011.7.12010-04-09New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added
XMODE012.2.32010-04-09Additional Information amended to remove references to sandwich students
XMSTUFEE011.1.22010-04-09Descriptions for codes 6 and 7 clarified
XQLEV10031.2.12010-04-09New XQOBTN01 input values added to Technical specification: D01, M02, M79, M26, H79, I79, C77, C78, P77, P78. Minor text amendments
XQLEV6011.7.12010-04-09New XOBTN01 input values added to Technical specification: D01, M02, M79, M26, H79, I79, C77, C78, P77, P78. Minor text amendments
XQOBTN016.1.12010-04-09New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added
XREG013.1.22010-04-09Minor text amendments to tie up with HIN_Register table name. Removal of C07051 only processing notes
XLEV6011.7.12010-04-08Amended text and codes added to Course.COURSEAIM
XPDEC013.6.12010-04-08Added Instance.LOCSDY to technical specification, amended Instance.EXCHANGE for new values
XPQUAL012.6.12010-04-08Instance.EXCHANGE codes amended and Instance.LOCSDY added
XPSES013.6.12010-04-08Amended text, Instance.EXCHANGE codes updated and Instance.LOCSDY and Course.TTCID added
XPSR012.2.42010-04-08Amended 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
XQLEV3011.7.12010-04-08New codes D01, M02, M79, M26, H79, I79, C77, C78, P77 and P78 added
XINSTC011.11.12009-11-01Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09
XFPE011.2.22009-10-30Technical 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
XHECOS1.2.22009-10-30Technical 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
XREG013.1.12009-10-27Updated to reflect position at close of processing of 07051. Section added for preparation of HIN_Register and technical specification amended
XINSTG013.8.12009-10-01Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09
XINSTID011.2.12009-10-01Technical specification amended to reflect that Cyy031 uses UKPRN from 2008/09. Location of institution list specification changed to Data management
XQEYEAR011.1.12009-07-22Field abbreviation changed from PQEYEAR to XQEYEAR01 (prior to field use - hence no version increment) to bring into line with other derived field (processing) specifications
XQMODE012.3.12009-07-17Otherwise row in Technical specification removed, as it can never be executed
XQOBTN015.1.62009-07-17Clarification that Professional Graduate Certificate in Education is not included in the Postgraduate Certificate in Education highest qualification grouping
XDOMGR014.4.12009-07-16Footer moved to end of last page only
XDOMHM011.4.32009-07-16Minor text revisions to Additional information. No change to Technical specification
XDOMREG011.1.22009-07-16Minor text revisions to Additional Information
XELSP011.3.32009-07-16Minor text edits to Additional information
XEPYEAR011.1.32009-07-16Text amended in Technical specification - no change to function
XETHNIC011.1.22009-07-16Additional information text for White clarified
XINSTC011.10.22009-07-16Removed yy018 from XUKPRN01 list as XINSTC01 not created for DLHE. Note added to Additional information for analysis of country of institution from DLHE record
XINSTG013.7.22009-07-16Removed yy018 from XUKPRN01 list as XINSTG01 not created for DLHE. Note added to Additional information for analysis of GOR from DLHE record
XQLEV3011.6.22009-06-18Format amendments and change to valid entry text. Labels aligned to student volume. Field type added. No change to technical specification
XDOMGR014.4.12009-06-17Technical specification addition to clarify how to handle postcodes with a blank Geographic Office Region
XDOMUC013.1.32009-06-16Valid entry typo edits to Vale of Glamorgan, Isle of Anglesey, Newry and Mourne. No change to function
XDOM011.1.42009-06-11Valid entries clarified
XDOM011.1.32009-06-11Updated to clarify process for populating with either incoming or previously submitted data
XQEYEAR011.1.12009-06-11Created
XQOBTN015.1.52009-06-11Valid entry labels aligned with HESA writing standard. No change to function
XINSTG013.7.12009-06-10Valid entry label D changed to Yorkshire and The Humber, G to East of England to match ONS description
XDOMUC013.1.22009-05-05Field description - addition of unitary authority to make consistent with other fields
XFYEAR011.2.32009-05-05Field description changed from First year within 1st December population to First year identifier (to be used with XPDEC01 only
XFYRSR011.2.32009-05-05Field description changed from First year within Standard Registration population to First year identifier (to be used with XPSR01 only
XDOMGR014.3.32009-04-07Additional information clarifying the use of England region unknown label for code XF added
XQOBTN015.1.42009-04-06Valid entry labels to lower case A/AS level, P85 label to match 'at level 3' added
XDOMGR014.3.22009-03-25England region labels updated to East of England and Yorkshire and The Humber following confirmation from ONS
XFYRSR011.2.22009-03-23Format amended. Filed type added. No change to technical specification
XDOM011.1.22009-03-20Format amendments
XDOMREG011.1.12009-03-20Created
XEPYEAR011.1.22009-03-20Format amended
XFTE011.1.22009-03-20Format amends. Additional information added to
XREG012.1.22009-03-20Format amended. Colons removed from valid entries
XYEARM012.1.22009-03-20Format amended
XHOOS011.2.22009-03-19Format 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
XCLASS011.2.22009-03-18Format amended. Colons removed from valid entries. Field type added. No change to technical specification
XELSP011.3.22009-03-18Format amended. Colons removed from valid entries. Field type added. No change to technical specification
XETHNIC011.1.12009-03-18Created
XMODE012.2.22009-03-18Format amendment. Colons removed from valid entries. Field type added. No change to technical specification
XMSFUND011.1.12009-03-18Created
XMSTUFEE011.1.12009-03-18Created
XQMODE012.2.22009-03-18Format amended. Colons removed from valid entries. Field type added. No change to technical specification
XAGEA011.3.22009-03-17Format amended. Colons removed from valid entries. Field type added
XAGEJ011.2.22009-03-17Format amended. Colons removed from valid entries. Field type added. No change to technical specification
XAGRP6011.1.42009-03-17Format amendment. Colons removed from valid entries. Field type added. No change to technical specification
XAGRPA011.1.42009-03-17Format amended. Colons removed from valid entries. Ages 00 and 99 text clarified in Additional information. Field type added
XAGRPJ011.1.42009-03-17Format amended. Colons removed from valid entries. Field type added. No change to technical specification
XDOMGR014.3.12009-03-13Updated for new version of lookup 09MAY and overseas lookup v5, and refers only to F_DOMICILE_ISO
XDOMHM011.4.22009-03-13Format amended. Field type added. No change to Technical specification
XDOMUC013.1.12009-03-13New lookup table - 09 MAY and format amends, and new output codes with new valid domicile codes
XFYEAR011.2.22009-03-13Format amended. Text amend to additional information. Field type added. No change to technical specification
XLEV3011.6.22009-03-13PG, 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
XLEV6011.6.22009-03-13Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Notes updated to reflect current definitions
XPDEC013.5.22009-03-13Amended and simplified format. Field type added. No change to Technical specification
XPQUAL012.5.22009-03-13Format amendments only. Field type added. No change to Technical Specification
XPSES013.5.22009-03-13Format changes only. Field type added. No change to technical specification
XPSR012.2.32009-03-13Amended format. Field type added. No change to technical specification
XQLEV10031.1.12009-03-13Created
XQLEV5011.6.22009-03-13Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Notes updated to reflect current definitions;
XQLEV6011.6.22009-03-13Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification
XQOBTN015.1.32009-03-13Updated format. field type added. No change to technical specification
XINSTC011.10.12009-03-11Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added
XINSTG013.6.12009-03-11Using new lookup table - 09MAY. More comprehensive explanation of specification provided for return to institutions. Field type added
XINSTID011.1.52009-03-11More comprehensive explanation of specification provided. Field type added. No change to technical specification
XLEV5011.6.22009-03-10Format amendments. Labels aligned to Student volume. Field type added. No change to technical specification. Notes updated to reflect current definitions;
XPSES013.5.12008-11-15Amended spec to deal with changes for new Student record
XINSTG013.5.32008-10-15Remove superfluous semicolons from valid entry list
XINSTID011.1.42008-10-15Note added to clarify that field version applicable to a reporting period
XPSR012.2.22008-10-15Amended 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
XINSTG013.5.22008-10-14Clarification of reporting period updates – once per reporting year using yyMAY
XINSTC011.9.22008-10-13Clarification of reporting period updates - once per reporting year using yyMAY
XINSTID011.1.32008-10-13Update to text to make more generic. Valid entry reference to Data Management Institution list added, and Valid entries list removed
XELSP011.3.12008-10-10Amended to allow for only one of SPLENGTH or UNITLGTH to be supplied for reduced records 03 and 04
XDOMUC012.2.12008-07-26revised to account for null DOMICILE, amend UK code from GB to X, and to map '_826' codes in TEMP
XYEARM012.1.12008-07-21Added MODE 73 and 74
XPQUAL012.5.12008-06-26clarification that value 0 output where no QualificationsAwarded entity exists
XDOMGR014.2.12008-06-24Text 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
XFTE011.1.12008-03-20as per Cyy051 into Oracle specification, as a distinct derived field specification
XINSTC011.9.12008-03-01Using new lookup table - 08 MAY
XLEV5011.6.12008-02-26Amended for Cyy051
XAGRP6011.1.32008-01-28Text amendment to describe source of XAGEA01 00, 99
XINSTID011.1.12008-01-28Created
XAGRPJ011.1.32008-01-26Minor amendment to description to clarify origin of blank birth dates
XCLASS011.2.12008-01-26Amended to refer to QualificationsAwarded.CLASS, to confirm that input values are either valid values or blank and to clarify linking of XCLASS01 to XQOBTN01
XDOMUC012.1.12008-01-26Amended spec for New Student Record and new lookup table – 08MAY. New output codes to reflect change in coding frame for DOMICILE
XELSP011.2.12008-01-26Amends to for Cyy051
XLEV3011.6.12008-01-26QUALAIM replaced by Course.COURSEAIM, changed for Cyy051
XLEV6011.6.12008-01-26Revised for Cyy051
XQLEV6011.6.12008-01-26Revised for Cyy051
XQMODE012.2.12008-01-26New Instance.MODE codes of 73 and 74 codes added for Cyy051
XFYEAR011.2.12008-01-25Amended for Cyy051, labels amended to refer to instance
XFYRSR011.2.12008-01-25Amended to refer to Cyy0511 and labels amended to refer to year of instance
XPQUAL012.4.12008-01-25changes for Cyy051
XDOMHM011.4.12008-01-23Revised for changed XDOMHM01 values for Cyy051
XMODE012.2.12008-01-23Include new mode codes 73 and 74 from Cyy051
XAGEJ011.2.12008-01-09Changes for 07051 and clarification of origin of blank BIRTHDATE as reason for null
XQLEV5011.6.12008-01-08Revised for Cyy051
XQLEV3011.6.12008-01-01Changes for Cyy051
XQOBTN015.1.22008-01-01Amended typo in text to clarify that '___' is valid entry for no qualification
XQOBTN015.1.12007-12-20New Cyy051 codes added, field length 3
XPDEC013.5.12007-11-14Amended spec to deal with changes for Cyy051
XINSTC011.8.12007-03-01Using new lookup table - 07MAY
XDOMGR013.5.12007-01-17Using new lookup table – 07MAY
XAGEA011.2.12007-01-12Amended spec to deal with new default code 01/01/1901
XEPYEAR011.1.12007-01-01Created
XDOMGR013.4.12006-03-14Using new lookup table – 06MAY
XINSTC011.7.12006-03-01Using new lookup table - 06MAY
XINSTG013.3.12006-02-21Using new lookup table - May 2006. Table INSTHQPC_LOOKUP_06MAY not yet created as at 21 February 2006
XDOMGR013.2.12005-07-07Using new lookup table – May 2005
XDOMUC011.2.12005-07-07New lookup table - May 2005
XINSTC011.5.12005-07-07Using new lookup table - May 2005
XLEV3011.5.12005-02-21QUALAIM code 63 moved to FE level
XLEV5011.5.12005-02-21Code 63 moved to FE level
XLEV6011.5.12005-02-21Code 63 moved to FE level
XPDEC013.4.12005-02-21Move QUALAIM code 63 to FE level
XPSES013.4.12005-02-2104/05 move QUALAIM code 63 to FE level
XQLEV3011.5.12005-02-21code 63 moved to FE level
XQLEV5011.5.12005-02-21Code 63 moved to FE level
XDOMGR013.1.12005-01-25Different valid entry codes due to new lookup table sources
XDOMHM011.3.12005-01-25Spec change but valid entries remain the same
XINSTC011.4.12005-01-06Using new lookup table source
XINSTG013.1.12005-01-06Using new lookup table source and different valid entry codes
XINSTC011.3.12004-05-11Code modified to use updated lookup table (R36
XREG012004-03-25Updated for C03011 - code 2 added to NOTACT
XDOMGR012.3.12004-03-22use updated lookup table (R36
XPSR012.2.12004-03-18Amended spec to deal with changes for Cyy051, addition of Instance.MODE as input field
XPSR012.1.12004-03-18Valid entry changes
XINSTG012.2.12004-03-01Code modified to use updated lookup table (R36); 2004-02-25
XQMODE012.1.12004-02-25New valid entry 3 due to new mode of study codes in 2003-04
XLEV6011.4.12004-02-1303/04 codes included
XPDEC013.3.12004-02-1303/04 codes changes to SPCSTU, MODE, LOCSDY and QUALAIM
XPSES013.3.12004-02-1303/04 changes to SPCSTU, MODE, LOCSDY and QUALAIM
XQLEV3011.4.12004-02-1303/04 code changes
XQLEV5011.4.12004-02-1303/04 codeschanges
XQLEV6011.5.12004-02-13Code 63 moved to FE level
XQOBTN014.1.12004-02-13New 03/04 record codes added
XDOMGR012.2.12004-02-03Labelling changes
XDOMHM011.2.42004-02-03Labelling changes
XHOOS011.2.12004-02-03Labelling change
XLEV5011.4.12003-12-1603/04 codes included
XLEV3011.4.12003-11-1303/04 codes included
XPSR011.3.12003-08-12NOTACT code 2 included
XQLEV6011.4.12003-03-0103/04 codes changes
XMODE012.1.12003-02-25New valid entry 7 due to new mode of study codes in 2003-04
XLEV5011.3.12003-02-1302/03 codes included
XLEV6011.3.12003-02-1302/03 codes included
XQLEV3011.3.12003-02-1302/03 code changes
XQLEV5011.3.12003-02-1302/03 codes changes
XQLEV6011.3.12003-02-1302/03 codes changes
XQOBTN013.1.12003-02-12New 02/03 record codes added
XDOMGR012.1.12003-02-11Code modified to use updated lookup table (R34). Code 'MERS' not used
XINSTC011.2.12003-02-11Code modified to use updated lookup table (R34
XINSTG012.1.12003-02-11Code modified to use updated lookup table (R34). Code 4 not used
XLEV3011.3.12003-02-1102/03 codes included
XMODE011.2.12003-02-11Code modified due to deletion of old mode of study codes
XPDEC013.2.12003-02-1102/03 code changes to SPCSTU, MODE, LOCSDY and QUALAIM
XPQUAL012.3.12003-02-1102/03 qualification code changes
XPSES013.2.12003-02-1102/03 changes to SPCSTU, MODE, LOCSDY and QUALAIM
XQMODE011.2.12003-02-11Code amended to delete old mode of study codes
XINSTG011.2.22002-05-13Specification change – new column added to lookup table
XAGEA011.1.22002-04-30Clarification of reporting year in technical spec
XINSTC011.1.22002-04-18Specification change; use lookup table
XPDEC013.1.12002-03-25Valid entry changes
XPSES013.1.12002-03-25Valid entry changes
XQMODE011.1.12002-03-25Created
XAGEJ011.1.22002-03-08Clarification of reporting year in technical spec
XFYEAR011.1.42002-03-08Clarification of reporting year in technical spec
XFYRSR011.1.22002-03-08Clarification of reporting year in technical spec
XPDEC012.2.22002-03-08Clarification of reporting period in technical spec
XPQUAL012.2.12002-03-08Foundation degree, code 28, included
XPSES012.2.22002-03-08Foundation degree QUALAIM code 28 added and clarification of reporting period in technical spec
XQLEV3011.2.12002-03-08Foundation degree code 28 included
XQLEV5011.2.12002-03-08Foundation degree code 28 added
XQLEV6011.2.12002-03-08Foundation degree code 28 added
XQOBTN012.1.12002-03-08Foundation degree, code 28 added
XPSR011.2.12002-01-14Code amended to allow for course length
XLEV3011.2.12001-09-24Foundation degree (QUALAIM code 28) included
XLEV5011.2.12001-09-24Foundation degree (QUALAIM code 28) included in 'Other Undergraduate'
XLEV6011.2.12001-09-24Foundation degree (QUALAIM code 28) included in OUG
XPDEC012.2.12001-09-24Foundation degree QUALAIM code 28 added
XINSTG011.2.12001-09-20Code modified to use updated lookup table (R32
XPSR011.1.42001-07-19Code created
XFYRSR011.1.12001-05-04Created
XPDEC012.1.12001-02-27Incoming exchange students excluded from population
XPSES012.1.12001-02-27Incoming exchange students excluded from population
XCLASS011.1.12001-02-14Created
XPQUAL012.1.12001-02-13Dormant students exclusion removed and incoming exchange students excluded
XDOMGR011.2.12000-07-03Code modified to incorporate R30
XDOMHM011.1.42000-05-19XPFDS01 entered into Dependent fields section
XINSTG011.1.12000-03-16Created
XDOMGR011.1.12000-01-06Created
XDOMHM011.1.31999-03-15XDOMCT01 codes 6826 and 7826 swapped around to give correct results
XELSP011.1.21998-12-17Error in program code. Code modified
XDOMHM011.1.21998-12-14XDOMCT01 code GROE included in result 7
XFYEAR011.1.31998-12-04Error in program. Code modified
XAGRPA011.1.31998-12-03Code modified
XPSES011.1.21998-12-03Code modified due to QUALAIM codes 79 and 80 being deleted from program code
XELSP011.1.31998-12-01Error in program code. Code modified
XFYEAR011.1.21998-12-01Error in program. Code modified
XAGRP6011.1.21998-11-12Code modified
XAGRPA011.1.21998-11-12Code modified
XAGRPJ011.1.21998-11-12Code modified
XMODE011.1.21998-11-11Code modified due to spec change. Labelling change to show 'Sabbatical' separately
XHOOS011.1.11998-10-29Created
XAGEA011.1.11998-10-26Created
XAGEJ011.1.11998-10-26Created
XELSP011.1.11998-10-26Created
XFYEAR011.1.11998-10-26Created
XAGRP6011.1.11998-10-07Created
XAGRPA011.1.11998-10-07Created
XAGRPJ011.1.11998-10-07Created
XINSTC011.1.11998-10-07Created
XMODE011.1.11998-09-28Created
XPSES011.1.11998-09-28Replaces POPSES, POPSESFE, POPNOTSES
XLEV3011.1.11998-09-25Replaces FLGLEVEL
XLEV5011.1.11998-09-25Created 25 September 1998
XLEV6011.1.11998-09-25Created
XPDEC011.1.11998-09-25Replaces POPDEC, POPDECFE
XPQUAL011.1.11998-09-25Replaces POPHEMQ
XQLEV3011.1.11998-09-25Created
XQLEV5011.1.11998-09-25Created
XQLEV6011.1.11998-09-25Created
XQOBTN011.1.11998-09-07Created
XAGEA011.3.11994-01-01Amended to deal with changed reporting of unknown birth date between student and staff streams
XDOM011.1.11994-01-01Created
XDOMGR014.1.11994-01-01Revised for Cyy051 with new coding output codes and new versions of lookup tables
XDOMGR013.4.21994-01-01Text amended to clarity that function should error of valid domicile provided and not found in T_OVERSEAS_LOOKUP_V3
XDOMGR013.3.11994-01-01Using new lookup table – 05NOV
XDOMGR013.1.21994-01-01Using version 3 of overseas lookup table
XDOMUC011.5.11994-01-01New lookup table - 07MAY
XDOMUC011.4.11994-01-01New lookup table - 06MAY
XDOMUC011.3.11994-01-01New lookup table - 05NOV
XDOMUC011.1.11994-01-01Code created
XELSP011.1.41994-01-01Error in program code. Code modified
XINSTC011.9.31994-01-01Remove superfluous semicolons from valid entry list
XINSTC011.6.11994-01-01Using new lookup table - 05NOV
XINSTC011.5.21994-01-01Code simplified as country field is now one character length
XINSTG013.5.11994-01-01Using new lookup table - May 2008. Clarified source of lookup
XINSTG013.4.11994-01-01Using new lookup table - May 2007
XINSTG013.2.11994-01-01Using new lookup table - May 2005
XINSTID011.1.21994-01-01Amended field type from INTEGER to CHAR in document heading, and added text to technical specification to describe table in static data schema
XREG012.1.11994-01-01Updated in preparation for C07051 – to identify LOCSDY = 7, SAS students, and include MODE 73 & 74
XYEARM011.1.11994-01-01Created

Need help?

Contact Liaison by email or on +44 (0)1242 388 531.