Skip to main content

HESA Collections

Back to C17051

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
XTPOINTS 1.10.1 2018-10-30 Following confirmation from UCAS, the tariff points have been updated for QUALTYPEs LK, LV, LW, LX.
XTPOINTS 1.9.1 2018-09-18 A number of QUALGRADE percentages have been updated from "0.XX" format to "XX%" to align with the QUALGRADE field.
XTPOINTS1.8.12018-09-05 A number of qualifications have been removed (QUALTYPES 4U, 4V, 4W, 4X, 4Y, 4Z, 5A) and replaced with QUALTYPEs RR, RQ, RR, RS, RT, RU and RV, respectively.
XTPOINTS1.7.12018-08-21 The qualification names have been updated to the latest versions, which now align with the names stored in QUALTYPE. A number of qualifications have been removed (QUALTYPES 6A, 5Z, 5Y, 6E, 6F, 5X, 6D) and replaced with QUALTYPEs T2, SZ, SY, T4, SX, T1 and T3, respectively.
XPUBPOPG011.2.12018-08-21Reference to the AP Student record added for clarification
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.
XPQUAL012.17.12018-07-06The Cyy054 Technical Specification section has been updated to correct the Instance_End.EXCHIND codes
XTPOINTS1.6.12018-06-29 A number of tariffable qualifications have been added (QUALTYPEs IY, IZ, J1, J2, J3, J4, J5, J6, J7, J8, J9, JA, JB, JC, JD, JE, JF, JG, JH, JJ, JK, JL, JM, JN, JP, JQ, JR, JS, JT, JU, JV, JW, JX, JY, and JZ). Grade 'P' has been added to the Appendix for QUALTYPEs Y2 and Y5. The tariff scores for K3 Key Skills, W3 Essential Skills Wales and HK SQA Core Skill – Higher have all been updated to 0. A note has been added in the Additional information section to explain HESA's treatment of these qualifications. The number of tariff points whereby the data collection system check will warn for has been updated from greater than 1000 to greater than 400
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
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-05Field created
XPGO011.1.12018-04-05Field Created
XPUBPOPG011.1.12018-04-05Field created
XAPPMK011.1.12018-02-22New field for 2017/18
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
XAPP011.1.12017-06-01Created
XPSES013.14.12017-06-01Technical specification for the Cyy051 Student record updated to cater for instances where the Course.COURSEAIM is returned as Z99
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
XJACS01_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
XINSTID011.28.12016-11-01Valid entries updated to include providers expected to return data to HESA for the 16/17 collections
XJACS01_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
XJACSLEV1011.6.12016-11-01Technical specification updated to reflect the deletion of Course.TTCID valid entries 8 and G in the list of codes that define ITT. Change to function
XJACSLEV2011.6.12016-11-01Technical specification updated to reflect the deletion of Course.TTCID valid entries 8 and G in the list of codes that define ITT. Change to function
XJACSLEV3011.6.12016-11-01Technical specification updated to reflect the deletion of Course.TTCID valid entries 8 and G in the list of codes that define ITT. Change to function
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 AP 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
XPROVTYPE011.2.22016-11-01The 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
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
XUHN011.1.12016-07-04Created
XJACS2014.2.12016-06-16Field length reduced from three characters to two, which aligns with the format required for the output. No change to function
XPROVTYPE011.2.12016-06-14Additional valid entry '3' added to account for Further education colleges. No change to function, as this entry is obtained from reference data
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
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
XJACSLEV3011.5.22016-02-02Minor typographic correction to the label for valid entry 080, correcting the spelling of 'Scandinavian'
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
XJACS01_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
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'
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
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
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
XPROVTYPE011.1.12015-01-20Created
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
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
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
XJACS01_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
XJACS2014.1.32014-10-16Additional information section amended to allow for the use of this field in the Cyy054 AP student record
XJACSA011.4.22014-10-16Additional information section amended to allow for the use of this field in the Cyy054 AP student record
XJACSLEV1011.5.12014-10-16Technical specification updated to reflect the addition of Course.TTCID valid entry Q, and the deletion of valid entries H, L, M, N and P, in the list of codes that define ITT. Change to function. Additional information section amended to allow for the use of this field in the Cyy054 AP student record
XJACSLEV2011.5.12014-10-16Technical specification updated to reflect the addition of Course.TTCID valid entry Q, and the deletion of valid entries H, L, M, N and P, in the list of codes that define ITT. Change to function. Additional information section amended to allow for the use of this field in the Cyy054 AP student record
XJACSLEV3011.5.12014-10-16Technical specification updated to reflect the addition of Course.TTCID valid entry Q, and the deletion of valid entries H, L, M, N and P, in the list of codes that define ITT. Change to function. Additional information section amended to allow for the use of this field in the Cyy054 AP student record
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
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
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
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
XJACS01_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
XJACSLEV1011.4.12013-09-30Technical specification change to include Course.TTCID codes L, M, N and P, and the deletion of J and K, in the list of codes that derive valid entry K 'Initial teacher training'. Corresponding update to text in this section. Change to function
XJACSLEV2011.4.12013-09-30Technical specification change to include Course.TTCID codes L, M, N and P, and the deletion of J and K, in the list of codes that derive valid entry 42 'Initial teacher training'. Corresponding update to text in this section. Change to function
XJACSLEV3011.4.12013-09-30Technical specification change to include Course.TTCID codes L, M, N and P, and the deletion of J and K, in the list of codes that derive valid entry 108 'Initial teacher training'. Corresponding update to text in this section. Change to function
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
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
XJACS01_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.)
XJACSLEV1011.3.12013-04-08Technical specification change to include Course.TTCID codes G, H, J, and K in the list of codes that derive valid entry K 'Initial teacher training'. Corresponding update to text in this section. Change to function
XJACSLEV2011.3.12013-04-08Technical specification change to include Course.TTCID codes G, H, J, and K in the list of codes that derive valid entry 42 'Initial teacher training'. Corresponding update to text in this section. Change to function
XJACSLEV3011.3.12013-04-08Technical specification change to include Course.TTCID codes G, H, J, and K in the list of codes that derive valid entry 108 'Initial teacher training'. Corresponding update to text in this section. 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
XJACSLEV1011.2.12013-01-21Change of lookup table in technical specification to XJACSLEV_lookup_V2 in Oracle with the move to using JACS 3.0. References to NSS and TQI in additional information changed to Unistats
XJACSLEV2011.2.12013-01-21Change of lookup table in technical specification to XJACSLEV_lookup_V2 in Oracle with the move to using JACS 3.0. References to NSS and TQI in additional information changed to UNISTATS
XJACSLEV3011.2.12013-01-21Change of lookup table in technical specification to XJACSLEV_lookup_V2 in Oracle with the move to using JACS 3.0. Valid entry 034 'Others in mathematical & computer sciences' removed as this is no longer derivable from JACS 3.0. References to NSS and TQI in additional information changed to Unistats
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
XJACSA011.4.12013-01-18Lookup table changed to STATIC_DATA.XJACSA01_LOOKUP_3, a version for JACS3. Technical specification amended to refer to JACS3
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
XJACS2014.1.22013-01-17Minor typographical edits to four valid entry labels for consistency with other labels. P0 and V0 now use an ampersand rather than 'and'. C9 and I9 now use lower case throughout. D0 label amended to include 'veterinary sciences' to more accurately reflect the content. No change to meaning
XJACS2014.1.12013-01-17Amended to reflect changed codes and labels in JACS3. Deletion of technical specification stage that specified the remapping of G010, G020, G910 and G920 as these codes are not included in JACS3. ZZ is no longer a valid entry in this field
XJACS01_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.)
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
XJACSLEV1011.1.12012-03-12Created
XJACSLEV2011.1.12012-03-12Created
XJACSLEV3011.1.12012-03-12Created
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
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
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.)
XJACSA011.3.42010-04-13Reference to XJACSA01_appendix.pdf added in Technical specification
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
XFTE012.1.12010-04-09Added XJACS201 and new Module.MODID to technical specification
XJACS01_XFPE012.1.12010-04-09Added XJACSA01, XJACS201 and new Instance.COURSEID to technical specification)
XJACS2013.1.32010-04-09Additional information updated to describe where this field exists, and to make explicit reference to mapping in 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
XJACS01_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
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
XJACS2013.1.22009-07-17Clarification of use of 'G0' and 'G9' in Additional information
XJACSA011.3.32009-07-17Minor typo edits to Additional information
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
XJACS2013.1.12009-03-13New output values of G91 and G92 added. Format changes. Field type added
XJACSA011.3.22009-03-13Format amendments. Field type added. No change in 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
XJACS2012.1.22008-07-26Typographic error corrected - amend reference in technical specification from _FTE table to _CO table
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
XJACSA011.3.12008-05-15Addition of STATIC_DATA.XJACSA01_LOOKUP_2, a version for JACS2
XJACS2012.1.12008-05-14Amended to reflect changed codes and labels in JACS2, including new output values of G01 and G02
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
XJACS2011.2.12008-01-01Amended to reflect 2007/08 record structure – now refers to Cyy051_FTE table. Added R8 – European Studies, remove G9
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
XJACS2011.1.22007-02-06Changed to allow XJACS201 to also be calculated from SBJ on the _CO table
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
XJACSA011.1.12003-04-25Created
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 < 3 weeks
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
XJACS2011.1.11994-01-01Created
XJACSA011.2.11994-01-01Clarification of source of data as SBJCA and addition of schema to lookup table
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.