Skip to main content

Staff Record 2014/15 - End date of contract

Back to C14025

Staff Record 2014/15

All fields

End date of contract

return to field list
Short nameENDCON

This field records the date on which the contract ended

Applicable toEngland Northern Ireland Scotland Wales

All contracts where Contract.TERMS is coded 1 or 2


All date fields in the Staff 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 Staff record.

Only dates within the HESA reporting period should be returned. Dates that are after 31 July should be returned in the following year. For example, a contract end date of 20 September 2013 should be reported in the 2013/14 academic year.

If a member of staff works in one department and then moves to another and this is not a new contract then do not close the record, just return an additional cost centre.

If the Contract has not ended an empty element should be returned e.g.


Business rules

Contract.ENDCON must exist where Contract.TERMS = 1 or 2. If the Contract has not ended an empty element must be returned.


Where exists Contract.ENDCON must be less than Y2-08-01


Where exists Contract.ENDCON must be equal to or after the date returned in Contract.STARTCON.


Contract.ENDCON must be before or equal to Person.DATELEFT where all Contract.TERMS = 1 or 2

Reason required

To identify contracts that have ended

Part of
Field length10
Minimum occurrences0
Maximum occurrences1
Schema components
Element: ENDCON
Data type: DateType
Date modified2015-04-30
Change management notesBusiness stage rule 1 updated to remove references to the ReasonForNull attribute. Business stage rules 2 and 3 deleted following the removal of the ReasonForNull attribute.

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