Student Record Return: Institution Entity

The Create Extract process creates a single Institution entity. The Institution entity is composed of three fields.

Return: Student Record

Entity: Institution

Page Used:

Page

Page Element

HESA Returns

INSTAPP

Field Derivation Rule: If the country is England or Northern Ireland, derive a value. Otherwise, do not derive a value and leave the field blank.

Derivation Steps:

  1. Derive from the HESA Returns page.

  2. Derive as NULL ERROR.

Return: Student Record

Entity: Institution

Pages Used:

Page

Page Element

Reporting Periods (Records and Enrollment > HESA Reporting > HESA Returns Setup > Reporting Periods)

Record Year

Returns (Records and Enrollment > HESA Reporting > HESA Returns Setup > Returns)

Record ID

Field Derivation Rule: Include for all Institution entities.

Derivation Steps:

  1. Derive as YYNNN, where YY is the final two digits of the Record Year (for example, 09 for 2009) and NNN is the 3-digit Record ID for the seeded return.

  2. Derive as NULL ERROR.

For Student Return 2009/10, the Record ID must be 051 and the Record Year for the Reporting Period must be 2009. The correct Record ID and Record Year for Student Return 2009/10 are delivered with your system.

Return: Student Record

Entity: Institution

Page Used:

Page

Page Element

HESA Configuration

UKPRN

Field Derivation Rule: Include for all Institution entities.

Derivation Steps:

  1. Derive from the HESA Returns page.

  2. Derive as NULL ERROR.