XPSR01_2.11.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Standard registration population | XPSR01 | 2.11.1 | 1 | Char |
Valid entries
Dependent fields
- None
Depend upon fields
- Instance.XPSES01
- Instance.XQLEV301
- Instance.MODE
- InstancePeriod.MODE
- Instance.ENDDATE
- Instance.COMDATE
- Instance.TYPEYR
- Instance.NOTACT
- InstancePeriod.NOTACT
- Instance.UNITLGTH
- Instance.SPLENGTH
- InstancePeriod.STULOAD
- InstancePeriod.PERIODEND
- InstancePeriod.INSTANCEPERIODKEY
Additional information
Summary
To generate a population for a 'whole year' count of active student instances, which counts each instance once and once only for each year of programme of study.
Standard definition
The HESA standard registration population is derived from the HESA Student or Student Alternative records and ensures that similar activity is counted in a similar way irrespective of when it occurs.
The population splits the student experience into 'years of programme of study'; the first year of which is deemed to start on the commencement date of the programme with second, and subsequent years, starting on, or near, the anniversary of that date.
Registrations are counted once for each 'year of programme of study'. Students who leave within two weeks of their start date, or anniversary of their start date, and are on a course of more than two weeks duration, are not included in the standard registration population. Students who have suspended study (e.g. dormant students), incoming visiting and exchange students from overseas, writing-up students and students on sabbatical are also excluded from this population.
Note that the starting point of the standard registration population is the session population, and so will exclude (where applicable):
1. dormant student instances (those who have suspended studying but have not formally de-registered)
2. incoming visiting and exchange student instances
3. postdoctoral student instances, and students primarily studying outside the UK
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
This derived field is created in both the Student record (Cyy051) and the Student Alternative record (Cyy054). The Student Alternative record makes use of the PERIODENDDATE field from the last active instance period, where there is one. NOTACT, STULOAD and ENDDATE are used to determine whether or not an instance period is active. If there are multiple active instance periods with the same PERIODSTART, take the one with the latest PERIODEND, or if these are the same, the one with the highest InstancePeriodKEY. Where there are no active instance period returned, the student is excluded from the standard registration population.
To ensure that students are treated consistently, regardless of their commencement date, students who start within two weeks of the end of the standard academic year are not included in the population until they have passed the two-week point. Therefore, these students would not be counted in the standard registration population for the first part of each year of their course (the part which runs to the end of the academic year).
This also applies to courses of duration of two weeks or less which have not ended within the academic year, students are not counted until the end part of their course. Furthermore, students on courses of duration of two weeks or less which end within the academic year are only counted if the student studies for the expected duration or gains a qualification.
Students on courses which are non-standard (courses which do not align with the standard academic year) are excluded from the population if they have suspended their studies.
Technical Specification
In the Cyy051 Student record:
To be counted in the population, the student needs to get past the first two weeks after the anniversary of their commencement date and get to the fifteenth day (anniversary of commencement date + 14 days).
Y1 is obtained by concatenating the first two digits from year in the system date with the first two digits of Institution.RECID (in Cyy51) or Provider.RECID (in Cyy54), e.g. Y1 = 20 for 2020/21.
For each student, ANNDATE is the anniversary of the commencement date + 14 days which falls within the academic year 1 August Y1 to 31 July Y2. ANNDATE is the anniversary + 14 days such that:
• ANNDATE >= 1 August Y1
• ANNDATE <= 31 July Y2
Note that in the first year of study, ANNDATE may be equal to COMDATE + 14 days.
When adding 14 days to the COMDATE (or subsequent anniversaries of), the anniversary date itself is counted. For example, if a student starts a 3-year course on 1 Sept 2020, ANNDATE in 2020/21 would be 15 Sept 2020, ANNDATE in 2021/22 would be 15 Sept 2021 etc.
Examples:
• if Instance.COMDATE is 1 March 2019, ANNDATE in 2020/21 would be 15 March 2021.
• if Instance.COMDATE is 1 October 2019, ANNDATE in 2020/21 would be 15 October 2020.
• if Instance.COMDATE is 26 July 2021, ANNDATE in 2020/21 would be 9 August 2020.
The last example illustrates what happens when the student’s start date is within two weeks of the end of the academic year (between 18 Jul Y2 and 31 Jul Y2), ANNDATE would fall before the commencement date itself. This scenario is dealt with separately in the specification below.
This population refers to the student's mode of study to exclude sabbatical, writing-up and dormant students where relevant to the collection. Modes 73 and 74, if available, are treated as active modes.
Instance. XPSES01 | Instance. MODE | Instance. UNITLGTH | Instance. SPLENGTH | Instance. XQLEV301 | Instance. ENDDATE | Instance. TYPEYR | Instance. NOTACT | Instance. COMDATE | Instance. XPSR01 |
---|---|---|---|---|---|---|---|---|---|
0 | 0 | ||||||||
1,2 | 43, 44 | 0 | |||||||
01, 02, 23, 24, 25, 31, 38, 39, 73, 74 | 3 | 1-2 | Not NULL and >= COMDATE + (SPLENGTH)*7 - 3 days | >= 1 AUG Y1 | XPSES01 | ||||
4 | 1-14 | Not NULL and >= COMDATE + SPLENGTH | >= 1 AUG Y1 | XPSES01 | |||||
5 | 1-42 | Not NULL | >= 1 AUG Y1 | XPSES01 | |||||
3 | 1-2 | 1, 2, 3 | >= 1 AUG Y1 | XPSES01 | |||||
4 | 1-14 | 1, 2, 3 | >= 1 AUG Y1 | XPSES01 | |||||
5 | 1-42 | 1, 2, 3 | >= 1 AUG Y1 | XPSES01 | |||||
NULL | 2, 3, 4, 5 | 1, 2 | 0 | ||||||
>= 18 JUL Y2 | 0 | ||||||||
NULL | XPSES01 | ||||||||
Not NULL and >= ANNDATE | XPSES01 | ||||||||
Otherwise | 0 |
Note: Instance.MODE 51, 63 and 64 in the Student record can only derive to an XPSES01 output of zero and hence an XPSR01 output of zero.
In the Cyy054 Student Alternative record:
To be considered inactive for the entirety of an instance period, the reporting period must be recorded as having no activity (InstancePeriod.STULOAD = 0), although it is not sufficient, to assess inactivity of an instance period on the basis of STULOAD alone.
Incoming visiting and exchange students, and those students who are studying abroad but spend more than 8 weeks in the UK, are permitted to return zero in the STULOAD field and consequently InstancePeriod.NOTACT must be also be considered.
Students who have no activity in the InstancePeriod in which their instance ends (usually due to the provider ending an instance retrospectively) will have a STULOAD of zero, but no NOTACT value. These are accommodated by using the presence of an ENDDATE to set their value to 'inactive', as otherwise they would be considered to be active in the absence of a NOTACT value stating otherwise.
Please note: in the following specification, the date reference '(Y1)' refers to a year-specific reference derived from the reporting year. For 2019/20, Y1 is 2019, thus for 2019/20 the year reference would be in the form 2019-08-01.
For each InstancePeriod in the collection, create a TEMP value as follows:
InstancePeriod. STULOAD | Instance. ENDDATE | InstancePeriod. NOTACT | TEMP |
---|---|---|---|
0, null | Not null, and < (Y1)-08-01 | 1 | |
Null, or not null and >= (Y1)-08-01 | 1, 2 | 1 | |
Null | 0 | ||
> 0 | 0 |
For each instance, let Instance.ACTIVEPERIODEND be the date of the last active InstancePeriod (that is, the PERIODEND of the InstancePeriod with the latest PERIODSTART where TEMP = 0) or ENDATE (where this is not NULL), whichever is the earliest:
• Where there are no active Instance_Periods, set XPSR01 = 0.
• Where two or more Instance_Period have the same PERIODSTART, take the one with the latest PERIODEND.
• Where two or more Instance_Period have the same PERIODEND, take the one with the highest InstancePeriodKEY.
Let Instance.ACTIVEMODE be the mode of study (InstancePeriod.Mode) from the last active instance period as defined above.
Instance. XPSES01 | Instance. ACTIVEMODE | Instance. UNITLGTH | Instance. SPLENGTH | Instance. XQLEV301 | Instance. ACTIVEPERIODEND | Instance. COMDATE | Instance. XPSR01 |
---|---|---|---|---|---|---|---|
0 | 0 | ||||||
1 | 43, 44 | 0 | |||||
01, 02, 23, 24, 25, 31 | 3 | 1-2 | Not NULL and >= COMDATE + (SPLENGTH)*7 - 3 days | >= 1 AUG Y1 | 1 | ||
4 | 1-14 | Not NULL and >= COMDATE + SPLENGTH | >= 1 AUG Y1 | 1 | |||
5 | 1-42 | Not NULL | >= 1 AUG Y1 | 1 | |||
3 | 1-2 | 1, 2, 3 | >= 1 AUG Y1 | 1 | |||
4 | 1-14 | 1, 2, 3 | >= 1 AUG Y1 | 1 | |||
5 | 1-42 | 1, 2, 3 | >= 1 AUG Y1 | 1 | |||
>= 18 JUL Y2 | 0 | ||||||
NULL | 1 | ||||||
Not NULL and >= ANNDATE | 1 | ||||||
Otherwise | 0 |
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.