Data Futures Return: Venue Entity

Venue extract records are only created if the ‘Include Course entities’ parameter is selected.

An entity is created for each Venue ID defined in Institution HESA Data from the most recent effective-dated record, where the effective date is on or before the reporting period end date.

Return: Data Futures

Entity: Venue

Page Used:

Page

Page Element

Institution HESA Data — Venues

Own Venue ID

Field Derivation Rule: Include for all entities.

Derivation Step:

  1. Derive value from Venue.

  2. Derive as null.

Return: Data Futures

Entity: Venue

Page Used:

Page

Page Element

Institution HESA Data — Venues

Postcode

Field Derivation Rule: Include for all entities.

Derivation Step: Derive value from Venue.

Return: Data Futures

Entity: Venue

Page Used:

Page

Page Element

Institution HESA Data — Venues

Venue Name

Field Derivation Rule: Include for all entities.

Derivation Step: Derive value from Venue.

Return: Data Futures

Entity: Venue

Page Used:

Page

Page Element

Institution HESA Data — Venues

UKPRN

Field Derivation Rule: Derive if Country = England.

Derivation Steps:

  1. Derive value from Venue.

  2. Derive as UKPRN for the provider institution from HESA Configuration.