Data Futures Return: Leaver Entity

For each Engagement entity in the extract, a single Leaver entity is created if the derived ENGENDDATE for the Instance/Student Registration falls within the reporting period.

ENGENDDATE is derived as follows:

1. Derive from HESA Instance Data.

2. If the latest row in Student Program (that has an effective date in the reporting period) has a program action/reason combination that is mapped to a Leaver Reason (RSNENGEND), and the student is a taught student, then the date is derived as the latest related StudentCourseSession.SCSENDDATE in the extract or submitted data if these conditions are true:

   • The related Qualification.QUALCAT in extract or submitted data does not start with D or L.

   • The Qualification is linked from the most recent Student Course Session of the parent Engagement entity via COURSEID (stored in Engagement extract but reported as part of Student Course Session) and QUALID.

3. If the latest row in Student Program (that has an effective date in the reporting period) has a program action/reason combination that is mapped to a Leaver Reason (RSNENGEND), the date is derived from the effective date in Student Program/Plan.

4. If a default value is defined for ENGENDDATE in returns setup.

In some cases, the end of attendance may be in a reporting period prior to the awarding of a degree. For example, if a student completes their final year in summer 2020 but has re-sits, the end of attendance date might be 30-JUN- 2020 (reflecting the end of the teaching and assessment). But the degree might not be awarded until 30-SEP-2020. In this case, the Leaver entity will be triggered when the Student Program/Plan is completed in the 01-AUG-2020 to 30-NOV-2020 reporting period, although the ENGENDDATE will fall in the previous reporting period.

The Leaver entity could be reported in an earlier reporting period if a Student Program/Plan record with mapped RSNENGEND (that is, completion of course – result unknown) was added on or before 31-JUL-2020 to indicate that the student has completed attendance but not yet been made an award. In that scenario, the Leaver entity would be reported again in the reporting period when the award was made with an updated RSNENGEND value.