Skip to main content

XPDEC01_3.15.1

Back to C18054

Field description Field abbreviation Field version Field length Field type
Population at 1 December XPDEC01 3.15.1 1 Char

Valid entries

Code Label
0 The instance is NOT counted within the 1 December population
1 The instance is counted within the 1 December HE population
2 The instance is counted within the 1 December FE population

Dependent fields

  • None

Depend upon fields

  • TTCID
  • LOCSDY
  • EXCHANGE
  • MODE
  • ENDDATE
  • COMDATE
  • COURSEAIM
  • EXCHIND
  • XINACT01

Additional information

Standard Definition

The HESA population at 1 December is a headcount of all active student instances as at 1 December of the reporting period.

The 1 December HE population includes all higher education student instances as at 1 December except:

1. dormant student instances (those who have suspended studying but have not formally de-registered)

2. incoming visiting and exchange student instances, and students whose location of study is primarily outside the UK, but student has spent or will spend more than 8 weeks in the UK

3. postdoctoral student instances

4. instances where the whole of the programme of study is outside of the UK

5. National College for Teaching and Leadership (NCTL) Subject Knowledge Enhancement (SKE) student instances

6. students on sabbatical

7. writing-up students

8. students who left their instance prior to 1 December, or who commenced a programme of study after this date, and

9. the 'wrapper' programme aim of Apprenticeship Standards students.

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.

As the AP student record is collected for a smaller subset of those collected in the Student record, the Technical Specification is less complex and requires fewer exclusions.

HE levels are defined as first letter of Course.COURSEAIM = D, E, L, M, H, I, J, C.
FE levels are defined as first letter of Course.COURSEAIM = P, Q, R, S, X

Incoming visiting and exchange students are excluded from the population in order to avoid an element of double-counting that would occur with both outgoing and incoming students being included in the same population. Students studying primarily abroad (LOCSDY code S, 'Studying abroad and included in the Student record as student has spent or will spend more than 8 weeks in the UK') are excluded on the basis that they are 'incoming'.

For the purposes of the Student record, Instance.EXCHANGE valid entries Y and Z are classed as 'outgoing'.

Technical Specification

(Y1 is obtained by concatenating the first two digits of year from the system date with the first two digits of Institution.RECID, e.g. Y1 = 2001 for 2001/02.)

In the Cyy051 Student record:

Course. TTCID Instance. LOCSDY Instance. EXCHANGE Instance. MODE Instance. ENDDATE Instance. COMDATE Course. COURSEAIM XPDEC01
0, 1, 2, 5, 9, D, Q, null 6, 9, C, D, E, H, J, K, T, U, Z, null N, Y, Z, null 01, 02, 12, 13, 14, 23, 24, 25, 31, 33-36, 38, 39, 65, 73, 74, 99 >=1 DEC Y1 or null <=1 DEC Y1 or null All Course. COURSEAIM codes beginning D, E, L, M, H, I, J, C 1
All Course. COURSEAIM codes beginning P, Q, R, S, X 2
All Course. COURSEAIM codes beginning Z 0
> 1 DEC Y1 0
< 1 DEC Y1 0
43, 44, 51, 63, 64, 98 0
4, G 0
S 0
F 0

In the Cyy054 AP student record:

Instance_End. LOCSDY Instance_End. EXCHIND Instance_End. MODE Instance. XINACT01 Instance. ENDDATE Instance. COMDATE XPDEC01
6, 9, D, E, T, U, Z 2, 3 01, 02, 23, 24, 25, 31 0 >=1 DEC Y1 or null <=1 DEC Y1 or null 1
> 1 DEC Y1 0
< 1 DEC Y1 0
1 0
43, 44 0
1 0
S 0

Revision history

Date Version Notes
2019-04-11 3.15.1 Addition of section 'All Course. COURSEAIM codes beginning Z' to be derived to XPDEC01 0
2019-03-11 3.14.1 Addition of 'Z' to the following section 'All Course. COURSEAIM codes beginning P, Q, R, S, X'
2016-11-01 3.13.1 Addition of new Instance.MODE code 98 to Cyy051 Student record technical specification, with associated text regarding Apprenticeship Standards added to the exclusions in the standard definition section. Deletion of Course.TTCID valid entries 8 and G. In the Cyy054 AP student record an additional column has been added to enfore the exclusion of new Instance_End.MODE valid entries 43 and 44
2014-10-16 3.12.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. The Course.TTCID codes used in the Student record derivation have been revised in line with changes to the valid entries in that field
2014-01-23 3.11.1 Addition of new Course.TTCID codes L, M, N and P to technical specification, with removal of deleted codes J and K. Addition of new Instance.LOCSDY codes T, U, and Z to technical specification, with removal of deleted codes A, B, F, G, M, N, P, Q, R and X. Addition of new Instance.EXCHANGE codes G and N to technical specification, with removal of deleted codes 0, 2, 7, 8, 9, A, B, C, D and E. Addition of new Instance.MODE code 99 to technical specification, with removal of deleted codes 32, 37, 52, 53, 66, 67, 68 and 69. Change of name from 'Teaching Agency' to 'National College for Teaching and Leadership' in exclusion 5. Further information on the reason for the exclusion of incoming visiting and exchange students added to the 'Standard Definition' section
2013-10-01 3.10.1 Addition of new Course.TTCID codes G, H, J and K to technical specification. Change of name from 'Training and Development Agency' to 'Teaching Agency' in exclusion 5
2012-02-17 3.9.1 Removal of reference to the Student Associates Scheme (SAS) from exclusion 5, due to the ending of this scheme. Corresponding TTCID entry of E removed from Technical Specification
2011-01-31 3.8.1 Added new codes for Instance.EXCHANGE of Y and Z, and added note to indicate that students studying primarily outside the UK are identified through their location of study. Also excluded TTCID E and F from population
2010-06-23 3.7.1 Added null value for Instance.LOCSDY
2010-04-08 3.6.1 Added Instance.LOCSDY to technical specification, amended Instance.EXCHANGE for new values
2009-03-13 3.5.2 Amended and simplified format. Field type added. No change to Technical specification
2007-11-14 3.5.1 Amended spec to deal with changes for Cyy051
2005-02-21 3.4.1 Move QUALAIM code 63 to FE level
2004-02-13 3.3.1 03/04 codes changes to SPCSTU, MODE, LOCSDY and QUALAIM
2003-02-11 3.2.1 02/03 code changes to SPCSTU, MODE, LOCSDY and QUALAIM
2002-03-25 3.1.1 Valid entry changes
2002-03-08 2.2.2 Clarification of reporting period in technical spec
2001-09-24 2.2.1 Foundation degree QUALAIM code 28 added
2001-02-27 2.1.1 Incoming exchange students excluded from population
1998-09-25 1.1.1 Replaces POPDEC, POPDECFE

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