KIS Return: Location Entity
The Create Extract process creates one or more Location entities in the Location Extract Data record (SSR_HE_LOCN_EXT) for the single Institution extract record for the KIS return. As with the Institution entity fields, values are selected from the most recent effective dated Institution HESA Data record where the effective date is on or before the reporting period end date.
The LOCID and LOCNAME are derived as part of the initial entity selection and stored in the Location Extract Data record (SSR_HE_LOCN_EXT). The remaining fields are derived and stored in the Location Fields Extract record (SSR_HE_LOC_EXFL).
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
ACCOMURL |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Derive as NULL ERROR.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
INSTBEDS |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Do not derive a value and leave the field blank.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
INSTLOWER |
Field Derivation Rule: If Location.INSTBEDS exists, 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: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
INSTUPPER |
Field Derivation Rule: If Location.INSTBEDS exists, 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: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
LATITUDE |
Field Derivation Rule: If Location.INSTBEDS exists, 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: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
Location ID |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
1. Derive from the Institution HESA Data page.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
Location Name |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
1. Derive from the Institution HESA Data page.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
LOCUKPRN |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Do not derive a value and leave the field blank.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
LONGITUDE |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Derive as NULL ERROR.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
PRIVATELOWER |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Derive as NULL ERROR.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
PRIVATEUPPER |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Derive as NULL ERROR.
Return: KIS
Entity: Location
Page Used:
Page |
Page Element |
---|---|
Institution HESA Data (Locations group box) |
Student Union URL |
Field Derivation Rule: Include for all Location entities.
Derivation Steps:
Derive from the Institution HESA Data page.
Do not derive a value and leave the field blank.
Note: The return uses this field when the location has a different student union. This field is also included in the Institution entity.