Skip to main content

XPQUAL01_2.17.1

Back to C17051

Field description Field abbreviation Field version Field length Field type
Qualifications obtained population XPQUAL01 2.16.1 1 Char

Valid entries

Code Label
0 The instance is NOT counted within the qualifications obtained population
1 The instance is counted within the qualifications obtained population

Dependent fields

    Depend upon fields

    • LOCSDY
    • EXCHANGE
    • QUAL

    Additional information

    Standard definition:
    The HESA qualifications obtained population is a count of student instances associated with the award of an HE qualification (excluding HE institutional credits) during the HESA reporting period 1 August to 31 July. This includes qualifications awarded from suspended study (e.g. dormancy) and writing-up status. It excludes awards to incoming visiting and exchange students, and students primarily studying abroad.

    The HESA qualifications obtained population is a count of all student instances associated with the award of a HE qualification (excluding HE credits) during the reporting period.

    This derived field is created in both the Student record (Cyy051) and the AP student record (Cyy054). The AP student record makes use of fields from a rolled-up Instance_End analysis table which reflects the position of the student in the last active instance period.

    If there are multiple QualificationsAwarded.QUAL fields associated with the instance, and at least one (but not all) would qualify for inclusion in the qualifications awarded population, then the instance is included in the population.

    Students studying primarily abroad are identified through their location of study (i.e. LOCSDY = 'S'). For the purposes of the Student record, Instance.EXCHANGE valid entries Y and Z are not used in determining location of study.

    Note that validation for Subject Knowledge Enhancement (SKE) instances will ensure that any qualifications reported are not included in this population (or the Graduate Outcomes population).

    Technical Specification

    In the Cyy051 Student record:
    Complete top-down, i.e, the value of XPQUAL01 is set once the criteria nearest the top of the table has been met.

    Instance. LOCSDY Instance. EXCHANGE QualificationsAwarded.QUAL (either of occurrences 1-2 as linked by INSTANCEKEY) XPQUAL01
    6, 9, C, D, E, H, J, K, T, U, Z, null N, Y, Z, null D00, E00, E40, E43, L00, L80, M00, M01, M02, M10, M11, M16, M22, M26, M28, M40, M41, M42, M43, M44, M45, M50, M70, M71, M72, M73, M76, M78, M79, M80, M86, M88, H00, H11, H12, H16, H18, H22, H23, H41, H42, H43, H50, H60, H61, H62, H70, H71, H72, H76, H78, H79, H80, H81, H88, I00, I11, I12, I16, I60, I61, I70, I71, I72, I73, I74, I76, I78, I79, I80, I81, J10, J16, J20, J26, J30, J41, J42, J43, J45, J76, J80, C20, C30, C41, C42, C43, C77, C78, C80 1
    D90, E90, L90, L91, M90, M91, H90, H91, I90, I91, J90, C90, All qualifications beginning P, Q, R, S, X, Z 0
    Otherwise (no QualificationsAwarded entity) 0
    4, G 0
    S 0

    In the Cyy054 AP student record:
    Complete top-down, i.e, the value of XPQUAL01 is set once the criteria nearest the top of the table has been met.

    Instance_End. LOCSDY Instance_End. EXCHIND QualificationsAwarded.QUAL (any present occurrences as linked by INSTANCEKEY) XPQUAL01
    6, 9, C, D, E, H, J, K, T, U, Z, null 2, 3, null D00, E00, E40, E43, L00, L80, M00, M01, M02, M10, M11, M16, M22, M26, M28, M40, M41, M42, M43, M44, M45, M50, M70, M71, M72, M73, M76, M78, M79, M80, M86, M88, H00, H11, H12, H16, H18, H22, H23, H41, H42, H43, H50, H60, H61, H62, H70, H71, H72, H76, H78, H79, H80, H81, H88, I00, I11, I12, I16, I60, I61, I70, I71, I72, I73, I74, I76, I78, I79, I80, I81, J10, J16, J20, J26, J30, J41, J42, J43, J45, J76, J80, C20, C30, C41, C42, C43, C77, C78, C80 1
    D90, E90, L90, L91, M90, M91, H90, H91, I90, I91, J90, C90, All qualifications beginning P, Q, R, S 0
    Otherwise (no QualificationsAwarded entity) 0
    1 0
    S 0

    Revision history

    Date Version Notes
    2018-07-06 2.17.1 The Cyy054 Technical Specification section has been updated to correct the Instance_End.EXCHIND codes.
    2018-05-10 2.16.1 The Technical Specification section has been updated to add QUAL valid entries D00, D90, E00, E40, E43, E90, L00, L80, L90, L91, M40, M41, M42, M43, M44, M45, M50, M70, M72, M76, M78, M79, M80, M86, M88, M90, M91, H12, I12, I73 to the CYY054 section.
    2018-04-26 2.15.1 The Technical Specification section has been updated to remove QUAL D01.
    2016-11-01 2.14.1 The Technical Specification section has been updated to add new QUAL valid entries to the Student and AP student derivations, which result from the additions of new valid entries in the respective records. M73, I78 have been added to the Cyy051 section, with Z-series codes added as an exclusion; M00, M01, M02, M10, M11, M16, M41, M42, M44, M71, M73 and I78 have been added to the Cyy054 section.
    2014-10-16 2.13.1 Addition of new section in the Technical Specification to allow for processing in the AP student record, with a corresponding update to the Additional Information section text to describe the derivation of this derived field on that record. Addition of new QualificationsAwarded.QUAL valid entry H12, I12 and I73 to Technical Specification, Student record, with the removal of valid entry H24 as it has been removed from the field for 2014/15.
    2013-10-02 2.12.1 Addition of new Instance.LOCSDY codes T, U, and Z to Technical Specification, with removal of deleted codes A, B, F, G, M, N, P, Q, R and X. Addition of new Instance.EXCHANGE codes G and N to technical specification, with removal of deleted codes 0, 2, 7, 8, 9, A, B, C, D and E. Addition of new QualificationsAwarded.QUAL valid entry M28 to Technical Specification.
    2013-02-01 2.11.1 Added new QualificationsAwarded.QUAL codes of H62 and M44 to Technical Specification.
    2012-02-17 2.10.2 Removal of reference in Additional Information to the Student Associates Scheme (SAS), as this has ceased to exist.
    2011-01-31 2.10.1 Added new codes for Instance.EXCHANGE of Y and Z, added note to indicate that students studying primarily abroad are identified through their location of study, and added note on SAS and SKE instances
    2010-09-03 2.9.1 Added codes D01, M02, M79, M26, H79, I79, C77 and C78
    2010-06-23 2.8.1 Added null value for Instance.LOCSDY
    2010-05-12 2.7.1 Error correction - Instance.EXCHANGE code 0 removed from first row of Technical Specification
    2010-04-08 2.6.1 Instance.EXCHANGE codes amended and Instance.LOCSDY added
    2009-03-13 2.5.2 Format amendments only. Field type added. No change to Technical Specification
    2008-06-26 2.5.1 clarification that value 0 output where no QualificationsAwarded entity exists)
    2008-01-25 2.4.1 changes for Cyy051)
    2003-02-11 2.3.1 02/03 qualification code changes)
    2002-03-08 2.2.1 Foundation degree, code 28, included)
    2001-02-13 2.1.1 Dormant students exclusion removed and incoming exchange students excluded)
    1998-09-25 1.1.1 Replaces POPHEMQ)

    Contact Liaison by email or on 01242 211144.