Skip to main content

HESA Student Record 2009/10 - End date of instance

Back to C09051

HESA Student Record 2009/10

All fields

End date of instance

return to field list
Short nameENDDATE

This field records the date the student left the student instance detailed in this return.

Applicable toEngland Northern Ireland Scotland Wales

All instances

Base data typeDateWithNullStructure9
Field length10
Part of
Minimum occurrences1
Maximum occurrences1
Related fields
Reason required

To determine whether to include a student in any particular population definition.


All date fields in the Student Record must be completed using the ISO8601 format of YYYY-MM-DD. The specification of this field falls within the scope of the Aligned Data Definitions and follows the Data Standards in the HESA student record.

If the instance has not ended, an empty element should be returned with the ReasonForNull attribute set to 9 (not applicable), i.e:

           <ENDDATE ReasonForNull="9"></ENDDATE>

A date is not required in cases where a student transfers from one course to another within the same student instance. Guidance on when a new student instance is required is given in Instance.NUMHUS. Normally where a student progresses from one course directly onto another at the same level (e.g. HND to Degree, MPhil to PhD) a new student instance is not required and hence this field would not be completed

An entry in this field means that an entry in Instance.RSNEND will also be expected.

Sometimes there will be a delay in knowing whether or not a student has left a course. Where the precise date of the student leaving is not known, the date of the end of the month, term or semester in which the student last attended should be given.

Where Y0/Y1/Y2 appear in business rules, these refer to the reporting period Y1-Y2 (e.g. for the 2007-08 reporting period, Y0 is 2006, Y1 is 2007 and Y2 is 2008).

Taught students

For the purpose of HESA returns, completing an instance is defined as being the point at which the taught or structured part of the instance, including any formal writing-up period, is completed, ie. once the student is no longer actively following the course, and not any later stage such as, for example, final confirmation of award. This may mean that Instance.RSNEND is completed using code 98 'Completion of course - result unknown'.

Resit Exams and/or Results from Late Exam Boards

Students who complete their instance by 31 July but who have resit examinations to take and/or whose final confirmation of award by exam boards may be after this date should be returned to HESA as leavers, with an end date in the reporting period ending 31 July. If their results are known before the Student Record data collection closes, these results should be included in the return. Records for such students will be included in the POPDLHE (assuming that they meet all other criteria). However, if the results are not known before the Student Record data collection closes, a record should be submitted with an end date in the reporting period ending 31 July completed and code 98 'Completion of course - result unknown' in Instance.RSNEND. Once known, these results should be returned in the next reporting period by submitting a record with the appropriate dormant code in Instance.MODE. The date returned in Instance.ENDDATE must be the original end date and not be up-dated. Records returned in this way will not be included in the POPDLHE.

Institutions may wish to decommit their return late in the data collection period in order to include results from late exam or re-sit boards.

This same guidance applies to ITT TDA students where the award of QTS may be delayed.

ITT TDA students may finish their course in June/July of the HESA reporting year. This date should be date recorded in Instance.ENDDATE. However the institution may not know whether the student has been awarded QTS until later. If award information is known before the HESA data collection closes at the end of November, then this should be included in QUAL and OUTCOME. TDA have confirmed that trainees who obtain a successful award up until 1 November, and are shown as such in the main HESA return, will be counted in the profiles publication. Award dates after 31 October should be included in the following HESA data collection. In neither case should ENDDATE be up-dated.

It is expected that students coded other than 1 or 4 in OUTCOME who are subsequently awarded QTS should have this recorded in QualificationsAwarded.QUAL and QualificationsAwarded.OUTCOME in a subsequent return to HESA as an award from dormant status.

Research students

For research students the award should be recorded when the institution's Senate, or other body or person empowered, formally approves the award. For such students this field should be completed with the same date.

Dormant students

This field should reflect the date the student was last active on the instance and should not be updated.

FE learners at institutions in Wales

The guidance below applies at institutions in Wales where Instance.FESTUMK = 1 or 3.

Learners should generally be regarded as leaving prior to completion if they have not attended classes/activities for a continuous period of four weeks or more, unless there is auditable evidence that they intend to rejoin the learning activity without increasing the overall length of the learning activity. The end date for a learner leaving prior to completion should be the last day of attendance plus four weeks.

OwnerInformation Standards Board - Aligned Data Definitions
Date modified2010-06-30
Change management notesBusiness rule 11 added. New guidance added for FE learners at institutions in Wales.
Business rules

Instance.ENDDATE must not be null where Instance.RSNEND exists.


Instance.ENDDATE must not be null where Instance.CSTAT = 2, 3 or 4.


Instance.ENDDATE must be null where Instance.CSTAT = 1.


Where exists Instance.ENDDATE must be less than Y2-08-01.


If Instance.MODE is not equal to 63 or 64, then Instance.ENDDATE (where exists) must be greater than Y1-07-31.


If Instance.MODE = 63 or 64, then Instance.ENDDATE (where exists) must be greater than (Y2-6)-07-31.


Instance.ENDDATE (where exists) must be greater than or equal to Instance.COMDATE (where exists) unless (Instance.MODE = 63 or 64 and Instance.ENDDATE = Y0-08-01).


Instance.ENDDATE must be null with ReasonForNull=9 where Instance.RSNEND does not exist and Instance.REDUCEDI = 00, 01, 02, 04, 06 or 07.


Instance.ENDDATE must not be null except when ReasonForNull=9.


Instance.ENDDATE must not be null where Instance.MODE = 63 or 64 and Course.TTCID = E or F.

Schema components
Element: ENDDATE

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