Student (DFSTDNT) Return: Registration Role Entity

For each Engagement extract record, an entity is created if the REGBODYID field has a value defined in the latest HESA Instance record where the effective date falls on or before the reporting period end date.

This also applies at the Sub-Plan, Sub-Plan Offering, Plan, Plan Offering, Program, or Program Offering levels. If a value isn't defined at any level, any entity isn't created.

Return: DFSTDNT

Entity: Registration Role

Pages Used:

Page

Page Element

Program HESA Data

REGBODYID

Program Offering/Year HESA

REGBODYID

Plan HESA Data

REGBODYID

Plan Offering/Year HESA

REGBODYID

Sub-Plan HESA

REGBODYID

Sub-Plan Offering/Year HESA

REGBODYID

HESA Instance

REGBODYID

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Derive value from HESA Instance.

  2. If entity is based on a sub-plan, derive value from Sub-Plan Offering/Year HESA based on the Academic Load of the instance.

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

  4. Derive value from Plan Offering/Year HESA based on the Academic Load.

  5. Derive value from Plan HESA Data.

  6. Derive value from Program Offering/Year HESA based on the Academic Load.

  7. Derive value from Program HESA Data.