Return to Navigation

KIS Return: Institution Entity

The Create Extract process creates a single Institution entity and saves it to the Institution Extract record (SSR_HE_INST_EXT).

Where fields are derived from the Institution HESA Data record, values are selected from the most recent effective dated record where the effective date falls on or before the end of the reporting period. Values are stored in the Institution Fields Extract record (SSR_HE_INTEX_FL).

Return: KIS

Entity: Institution

Page Used:

Page

Page Element

Institution HESA Data

NSP

Field Derivation Rule: If Country = England, derive a value. Otherwise, do not derive a value and leave the field blank.

Derivation Steps:

  1. Derive from the Institution HESA Data page.

  2. Derive as NULL ERROR.

Return: KIS

Entity: Institution

Page Used:

Page

Page Element

Institution HESA Data

OTHERINST

Field Derivation Rule: Include for all Institution entities.

Derivation Steps:

  1. Derive from the Institution HESA Data page.

  2. Do not derive a value and leave the field blank.

Note: Nine fields are provided rather than the maximum 100 available.

Return: KIS

Entity: Institution

Page Used:

Page

Page Element

Institution HESA Data

OTHERINST2 to OTHERINST9

Field Derivation Rule: Include for all Institution entities.

Derivation Steps:

  1. Derive from the Institution HESA Data page.

  2. Do not derive a value and leave the field blank.

Return: KIS

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.

The seeded record ID for the KIS return is 061.

Return: KIS

Entity: Institution

Page Used:

Page

Page Element

Institution HESA Data

Student Union URL

Field Derivation Rule: Include for all Institution entities.

Derivation Steps:

  1. Derive from the Institution HESA Data page.

  2. Derive as NULL ERROR.

Return: KIS

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.