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:
Use constant.
Derive value from HESA Instance.
Use default.
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:
Use constant.
Derive value from HESA Instance.
Use default.
If Country = Northern Ireland, derive as NULL ERROR.
-
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:
-
Derive from HESA Instance.
-
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.
-
If the course level of the Engagement is sub-plan, value from Sub-Plan Instance HESA Data.
-
Derive from Plan Year HESA for the combination of Academic Load and the Year of Program.
-
Derive from Plan Instance HESA Data.
-
Derive from Program Instance HESA Data.
-
Use default.
-
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:
-
Use constant.
-
Derive from HESA Instance.
-
If the course level of the Engagement is sub-plan, derive from Sub-Plan Instance HESA Data.
-
Derive from Plan Instance HESA Data.
-
Derive from Program Instance HESA Data.
-
Use default.
-
Derive as null.