Data Futures Return: Funding Body Entity

For each Student Course Session entity in the extract, entities are created if these conditions are met and FUNDINGBODY or FUNDINGBODY2 values exist.

  • 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 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.

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 isn't PGR or incoming exchange.

ELQ is only derived for England when FEEELIGE = 01 and the student isn't PGR or incoming exchange.

The entity selection excludes overseas and ELQ students allowing a default to be defined and used for all other students.

Return: Data Futures

Entity: Funding Body

Page Used:

Page

Page Element

Program HESA Data (Program Instance HESA Data)

FUNDINGBODY, FUNDINGBODY2

Plan HESA Data (Plan Instance HESA Data)

FUNDINGBODY, FUNDINGBODY2

Sub-Plan HESA Data (Sub-plan Instance HESA Data)

FUNDINGBODY, FUNDINGBODY2

HESA Instance Data

FUNDINGBODY, FUNDINGBODY2

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant for FUNDINGBODY to create a single entity.

  2. Derive values from HESA Instance.

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

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

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

  6. Use default for FUNDINGBODY to create a single entity.