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:

  1. Use constant.

  2. Derive from HESA Instance.

  3. If the related Engagement entity is based on a sub-plan, derive from Sub-Plan HESA Data

  4. Derive from Plan HESA Data based on the related Engagement entity.

  5. Derive from Program HESA Data based on the related Engagement entity.

  6. Use default.

  7. Derive as null.