Return to Navigation

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 select (Records and Enrollment, then select HESA Reporting, then select HESA Returns Setup, then select Reporting Periods)

Record Year

Returns select (Records and Enrollment, then select HESA Reporting, then select HESA Returns Setup, then select 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.