Data Futures Return: Student Financial Support Entity

For each Student Course Session entity in the extract, entities are derived based if these conditions are met:

• The most recent Session Status entity (based on STATUSVALIDFROM date) for the current Student Course Session of the current Engagement doesn't have STATUSCHANGED = 02 (dormant) and a STATUSVALIDFROM on or before the StudentCourseSession.SCSSTARTDATE.

• Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND isn't 03, 05, 11 or 12.

Entities are derived based on these conditions:

• Financial Support records defined for the most recent non-future HESA Instance record for the Registration. Only records with Support Type populated are selected. The derivation step for the related fields is set to 1.

• Whether the student has a Support Service Request value defined in the Impairment record, and that value is mapped to a Support Type code in the Disability Allowance mapping, and FINSUPTYPE value (i.e., 100) hasn't been extracted from Financial Support. A single entity is created using the mapped FINSUPTYPE code. The derivation step for the related fields is set to 2.

• If no entities have been created from the previous steps and a default value is defined for FINSUPTYPE in the returns setup with the derivation step for FINSUPTYPE set to 3.