Staff record 2012/13

Back to C12025

All fields

Date left HEI


return to field list
Short nameDATELEFT
Typefield
Description

This field records the date on which staff left the higher education institution (HEI)

Applicable toEngland Northern Ireland Scotland Wales
Coverage

All staff where any Contract.TERMS is coded 1 or 2 and all Contract.ENDCON are not null, unless any Contract.RESCON are coded 1.

Base data typexs:date
Field length10
Part of
Minimum occurrences0
Maximum occurrences1
Reason required

To terminate an individual's inclusion in the HESA Staff record

Notes

All date fields in the HESA Staff record must be completed using the ISO8601 format of YYYY-MM-DD.

Only staff who have left all contracts of employment with the HEI should be returned in this field.

OwnerInformation Standards Board - Aligned Data Definitions
Version1.2
Based onC11025 DATELEFT
Date modified2012-05-14
Change management notesCoverage updated for consistency in terminology across the manual in how atypical staff are specified.
Business rules
1(Error)

Person.DATELEFT must exist where any (Contract.TERMS = 1 or 2) and (all Contract.ENDCON are not null) and all Contract.RESCON not equal to 1.

2(Error)

Person.DATELEFT must not exist where any Contract.ENDCON are null.

3(Error)

Where exists Person.DATELEFT must be equal to or after Person.DATEFHEI.

4(Error)

Person.DATELEFT must be between (Y1)-07-31 and (Y2)-07-31 (inclusive)

Schema components
Element: DATELEFT
 
Contact Institutional Liaison: liaison@hesa.ac.uk, tel 01242 211144