Data Futures Return: Funding Body Entity
For each Student Course Session entity in the extract, a single entity is created if these conditions are met and a non-null FUNDINGBODY value can be derived:
The related Engagement entity in the extract doesn’t have FEEELIGE = 02 (not eligible to pay home fees) or 03 (eligibility not assessed).
The related Engagement entity in the extract doesn’t have FEESTATUS = 03 (overseas fees) or 04 (eligibility not assessed).
The related FundingAndMonitoring entity in the extract doesn’t have ELQ = 01 (non-exempt ELQ) or 09 (not required).
-
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.
Note: FEEELIGE is derived for all Engagements in England and Northern Ireland. FEESTATUS is derived for all Engagements in Scotland. ELQ is derived only for England, whether FEEELIGE = 01 and the student is not PGR or incoming exchange.
Return: Data Futures
Entity: Funding Body
Page Used:
Page |
Page Element |
---|---|
Program HESA Data (Program Instance HESA Data) |
FUNDINGBODY |
Plan HESA Data (Plan Instance HESA Data) |
FUNDINGBODY |
Sub-Plan HESA Data (Sub-plan Instance HESA Data) |
FUNDINGBODY |
HESA Instance Data |
FUNDINGBODY |
Field Derivation Rule: Include for all entities
Derivation Steps:
Use constant.
Derive from HESA Instance.
If the related Engagement entity is based on a sub-plan, derive from Sub-Plan HESA Data
Derive from Plan HESA Data based on the related Engagement entity.
Derive from Program HESA Data based on the related Engagement entity.
Use default.
Derive as null.