Data Futures Return: Student Initiatives Entity
For each Engagement extract record, an entity is created if STUINITID has a value defined in the latest HESA Instance record where the effective date falls on or before the reporting period end date or at Program, Plan, Plan Offering Year, Sub-Plan, and Sub-Plan Offering Year levels.
Return: Data Futures
Entity: Student Initiatives
Page Used:
Page |
Page Element |
---|---|
Program HESA Data |
STUINITID |
Plan HESA Data |
STUINITID |
Plan Offering Year HESA Data |
STUINITID |
Sub-Plan HESA Data |
STUINITID |
Sub-Plan Offering Year HESA Data |
STUINITID |
HESA Instance Data |
STUINITID |
Field Derivation Rule: Include for all entities
Derivation Steps:
-
Derive from HESA Instance Data.
-
If the entity is based on a sub-plan, derive from Sub-Plan Offering Year HESA Data for the combination of Academic Load and Year of Program of the student instance.
-
If the entity is based on a sub-plan, derive from Sub-Plan Instance HESA Data.
-
Derive from Plan Offering Year HESA Data based for the combination of Academic Load and Year of Program of the student instance.
-
Derive from Plan Instance HESA Data.
-
Derive from Program Instance HESA Data.