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:
Derive from the Institution HESA Data page.
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:
Derive from the Institution HESA Data page.
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:
Derive from the Institution HESA Data page.
Do not derive a value and leave the field blank.
Return: KIS
Entity: Institution
Pages Used:
Page |
Page Element |
---|---|
Reporting Periods |
Record Year |
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:
Derive from the Institution HESA Data page.
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:
Derive from the HESA Returns page.
Derive as NULL ERROR.