Data Futures Return: Funding and Monitoring Entity

For each Student Course Session entity in the extract, an entity is created if these conditions are met.

  • The most recent Session Status entity (based on STATUSVALIDFROM date) for the current Student Course Session does not 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 is not 03, 05, 11 or 12.

Because there is no unique identifier and there are no required fields for the entity, there may be cases where an entity is created with all the fields derived as null. Rather than include the coverage rules for each field in the entity selection, the compare processing will set the Entity Status to Unchanged if all the derived fields are null to prevent the entity from being included in the XML file or moved to the master record.

Return: Data Futures

Entity: Funding and Monitoring

Page Used:

Page

Page Element

HESA Instance

ELQ

Field Derivation Rule: Include for entities where:

  • Country = England

  • The related Engagement.FEEELIGE = 01 (home fees)

  • The related Qualification.QUALCAT begins with E, M, H, I, J or C

  • The related Engagement.INCOMINGEXCHANGE is null

Derivation Steps:

  1. Use constant.

  2. Derive value from HESA Instance.

  3. Use default.

  4. Derive as NULL ERROR.

Return: Data Futures

Entity: Funding and Monitoring

Page Used:

Page

Page Element

HESA Instance

FUNDCOMPFM

Field Derivation Rule: Derive a value if all the following conditions are met:

  • Country = England or Northern Ireland

  • The related StudentCourseSession.SCSENDDATE is not null

  • The related Engagement.INCOMINGEXCHANGE is null

Derivation Steps:

  1. Use constant.

  2. Derive value from HESA Instance.

  3. Use default.

  4. If Country = Northern Ireland, derive as NULL ERROR.

  5. Derive as null.

Return: Data Futures

Entity: Funding and Monitoring

Page Used:

Page

Page Element

Program HESA Data

FUNDLENGTH

Plan HESA Data

FUNDLENGTH

Plan Offering HESA Data

FUNDLENGTH

Plan Year HESA Data

FUNDLENGTH

Sub-Plan HESA Data

FUNDLENGTH

Sub-Plan Offering HESA Data

FUNDLENGTH

Sub-Plan Year HESA Data

FUNDLENGTH

HESA Instance

FUNDLENGTH

Field Derivation Rule: Include for entities where Country = England or Northern Ireland.

Derivation Steps:

  1. Derive from HESA Instance.

  2. If the course level of the Engagement is sub-plan, derive from Sub-Plan Year HESA for the combination of Academic Load and Year of Program.

  3. If the course level of the Engagement is sub-plan, value from Sub-Plan Instance HESA Data.

  4. Derive from Plan Year HESA for the combination of Academic Load and the Year of Program.

  5. Derive from Plan Instance HESA Data.

  6. Derive from Program Instance HESA Data.

  7. Use default.

  8. Derive as NULL ERROR.

Return: Data Futures

Entity: Funding and Monitoring

Page Used:

Page

Page Element

Program HESA Data

NONREGFEE

Plan HESA Data

NONREGFEE

Sub-Plan HESA Data

NONREGFEE

HESA Instance

NONREGFEE

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. Derive from HESA Instance.

  3. If the course level of the Engagement is sub-plan, derive from Sub-Plan Instance HESA Data.

  4. Derive from Plan Instance HESA Data.

  5. Derive from Program Instance HESA Data.

  6. Use default.

  7. Derive as null.