Combined student/module record 06/07

Back to field list for 06011

06011: Date left institution or completed the programme of study

Field Information

Number: 035
Name: Date left institution or completed the programme of study
Abbreviation: DATELEFT
Length: 10
Status: Compulsory for all students who have left the institution or completed their programme of study during the reporting period.
Description: The date the student left the reporting institution or completed the programme of study.
Notes: Sometimes there will be a delay in knowing whether or not a student has left a programme of study or the institution. Where the precise date of the student's leaving is not known, the date of the end of the month, term or semester in which the student last attended should be given.

A date is not required in cases where a student transfers from one programme of study to another within the same student instance.

If an institution returns the date left institution or completed programme of study in the format YYYYMMDD then this date must be left justified.

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

An entry in this field means that an entry in Field 33, Reason for leaving institution/completing programme, will also be expected.

In most cases qualifications are obtained at the end of a programme of study. Therefore typically where there is a qualification obtained in field(s) 37/38, a reason for leaving the programme of study and a date left the programme of study would be expected. It is recognised, however, that there are a few programmes of study where interim qualifications are actually awarded and so fields 33 and 35 would not be completed.

For the purpose of HESA returns, completing a programme of study is defined as being the point at which the taught or structured part of the programme of study, including any formal writing-up period, is completed, i.e. once the student is no longer actively following the programme of study, and not any later stage such as, for example, final confirmation of award.

The date returned in DATELEFT should therefore be the date of completing the programme and not the date of final confirmation of award.

PhD students

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

Dormant students

The DATELEFT field should reflect the date the student completed their programme of study and should not be updated.
Reason Required: To determine whether to include a student in any particular population definition.

Valid Entries

Valid entry patterns are: DD/MM/YYYY, DD-MM-YYYY or YYYYMMDD.

Validation Rules

029463
This field must contain a valid date in one of these formats: DD/MM/YYYY, DD-MM-YYYY or YYYYMMDD; or be blank. (Severity: 99)
M_VALIDDATE || M_EMPTY
029636
This field must be completed where RSNLEAVE is coded 01 to 11, 98 or 99. Otherwise this field may be completed or blank. (Severity: 99)
M_REQUIRED(_RSNLEAVE_) &&(IsValidInteger(_RSNLEAVE_,01L,11L) ||IsValidInteger(_RSNLEAVE_,98L,99L)) ?
M_NOTEMPTY :
M_TRUE
029637
If CSTAT = 2 or 3 then this field must not be blank. (Severity: 99)
M_REQUIRED(_CSTAT_) && (M_ISFIELD(_CSTAT_,"2")||M_ISFIELD(_CSTAT_,"3"))?
M_NOTEMPTY :
M_TRUE
029638
If CSTAT = 1 then this field must be blank. (Severity: 99)
M_REQUIRED(_CSTAT_) && M_ISFIELD(_CSTAT_,"1")?
M_EMPTY :
M_TRUE
029639
DATELEFT cannot be after 31 July of the reporting period. (Severity: 99)
M_NOTEMPTY ?
_DateDiff(DAY,GetFieldNoDate(uiCurFieldNo),August1Year2) < 0L :
M_TRUE
029640
If MODE = 63 or 64, then this field must be after 31 July of the reporting period minus 6 years. (Severity: 99)
M_REQUIRED(_MODE_) && M_NOTEMPTY && (M_ISFIELD(_MODE_,"63") || M_ISFIELD(_MODE_,"64")) ?
_DateDiff(DAY,GetFieldNoDate(uiCurFieldNo),"31/07/2001") > 0L :
M_TRUE
029641
If MODE not equal to 63 or 64, then this field must be after 31 July of the reporting period minus one year. (Severity: 99)
M_REQUIRED(_MODE_) && (!M_EMPTY) && (!(M_ISFIELD(_MODE_,"63") ||M_ISFIELD(_MODE_,"64"))) ?
(_DateDiff(DAY,GetFieldNoDate(uiCurFieldNo), August1Year1) >= 0L) :
M_TRUE
029642
If this field is not blank this field must contain a date after that given in COMDATE, unless the course is less or equal to 1 day in length in which case DATELEFT must be after or equal to COMDATE. (Severity: 99)
M_NOTEMPTY && !IsEmpty(_COMDATE_) && !IsEmpty(_SPLENGTH_) && !IsEmpty(_UNITLGTH_) ?
(DateDiff(DAY,uiCurFieldNo,_COMDATE_ ) >0L ) || (DateDiff(DAY,uiCurFieldNo,_COMDATE_) >= 0L && ( (M_ISFIELD(_SPLENGTH_,"01") && M_ISFIELD(_UNITLGTH_,"4")) || (GetFieldNoInteger(_SPLENGTH_)< 24 && M_ISFIELD(_UNITLGTH_,"5")) )):
M_TRUE
029687
If QUAL1 or QUAL2 are coded 02, 03, 04, 05, 06, 07, 08, 12, 13, 14, 18, 20, 21, 22, 23, 28, 29, 30, 33, 41 or 42, then DATELEFT should be completed with a date equal to or before 31 July of the reporting period. (Severity: 9)
(M_ISFIELD(_QUAL1_,"02") || M_ISFIELD(_QUAL1_,"03") || M_ISFIELD(_QUAL1_,"04") || M_ISFIELD(_QUAL1_,"05") || M_ISFIELD(_QUAL1_,"06") || M_ISFIELD(_QUAL1_,"07") || M_ISFIELD(_QUAL1_,"08") || M_ISFIELD(_QUAL1_,"12") || M_ISFIELD(_QUAL1_,"13") || M_ISFIELD(_QUAL1_,"14") || M_ISFIELD(_QUAL1_,"18") || M_ISFIELD(_QUAL1_,"20") || M_ISFIELD(_QUAL1_,"21") || M_ISFIELD(_QUAL1_,"22") || M_ISFIELD(_QUAL1_,"23") || M_ISFIELD(_QUAL1_,"28") || M_ISFIELD(_QUAL1_,"29") || M_ISFIELD(_QUAL1_,"30") || M_ISFIELD(_QUAL1_,"33") || M_ISFIELD(_QUAL1_,"41") || M_ISFIELD(_QUAL1_,"42")) || (M_ISFIELD(_QUAL2_,"02") || M_ISFIELD(_QUAL2_,"03") || M_ISFIELD(_QUAL2_,"04") || M_ISFIELD(_QUAL2_,"05") || M_ISFIELD(_QUAL2_,"06") || M_ISFIELD(_QUAL2_,"07") || M_ISFIELD(_QUAL2_,"08") || M_ISFIELD(_QUAL2_,"12") || M_ISFIELD(_QUAL2_,"13") || M_ISFIELD(_QUAL2_,"14") || M_ISFIELD(_QUAL2_,"18") || M_ISFIELD(_QUAL2_,"20") || M_ISFIELD(_QUAL2_,"21") || M_ISFIELD(_QUAL2_,"22") || M_ISFIELD(_QUAL2_,"23") || M_ISFIELD(_QUAL2_,"28") || M_ISFIELD(_QUAL2_,"29") || M_ISFIELD(_QUAL2_,"30") || M_ISFIELD(_QUAL2_,"33") || M_ISFIELD(_QUAL2_,"41") || M_ISFIELD(_QUAL2_,"42")) ?
M_NOTEMPTY && _DateDiff(DAY,GetFieldNoDate(uiCurFieldNo),August1Year2) < 0L:
M_TRUE