Data Futures Return: Study Location Entity

For each Student Course Session extract record, entities are created if any one of these conditions is true:

  • If DISTANCESL is defined in HESA Instance Data, a single entity is derived with derivation step 1 with null derived for VENUEID.

  • If StudentCourseSession.STUDYABROAD isn't 01 (full SCS abroad) and StudentCourseSession.PLACEMENT is null and Engagement.ENGPRINONUK is not 01:

    • If VENUEID is defined in the most recent HESA Instance record, a single entity is created with derivation Step 2. Derive STUDYPROPORTION in Step 2 if it's defined in HESA instance. Otherwise, derive STUDYPROPORTION as 100.

    • If one or more Venues are defined in the related Sub-Plan Year or Plan Year HESA Data record, an entity is created for each Venue record with derivation steps for STUDYPROPORTION and VENUEID set to 3 or 5.

    • If one or more Venues are defined in the related Sub-Plan Offering or Plan Offering HESA Data record, an entity is created for each Venue record with derivation steps for STUDYPROPORTION and VENUEID set to 4 or 6.

    • If the Campus value from the most recent Student Program record with an effective date on or before the reporting period end date is defined as the Own Venue ID for a Venue record defined in Institution HESA Data, a single entity is created with the VENUEID derived from that record and STUDYPROPORTION derived as 100 with derivation Step 7.

    • If no entities have been created in the previous steps and default values are defined for both VENUEID and STUDYPROPORTION, a single entity is created with derivation step 8 for both fields.

    In each case, DISTANCESL is derived as null in step 2.

Study Abroad and Placement details are recorded in OffVenueActivity.

STUDYLOCID is derived as SCSESSIONID and a sequence number.

Return: Data Futures

Entity: Study Location

Page Used:

Page

Page Element

HESA Instance

DISTANCESL

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive value from HESA Instance.

  2. Derive as null.

Return: Data Futures

Entity: Study Location

Page Used:

Page

Page Element

HESA Instance Data

STUDYPROPORTION

Plan Offering HESA Data — Venues

Percentage

Plan Year HESA Data — Venues

Percentage

Sub-Plan Offering HESA Data – Venues

Percentage

Sub-Plan Year HESA Data – Venues

Percentage

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. If DISTANCESL isn't null, derive as 100.

  2. If VENUEID is derived from HESA Instance in step 2, derive as STUDYPROPORTION from HESA Instance (if it's defined). Otherwise, derive as 100.

  3. If the parent Engagement entity is based on a sub-plan, derive value from Sub-Plan Year HESA Data – Venues.

  4. If the parent Engagement entity is based on a sub-plan, derive value from Sub-Plan Offering HESA Data – Venues.

  5. If the parent Engagement entity is based on a plan, derive value from Plan Year HESA Data — Venues.

  6. If the parent Engagement entity is based on a plan, derive value from Plan Offering HESA Data — Venues.

  7. If VENUEID is derived from Campus, derive as 100.

  8. Use default.

Return: Data Futures

Entity: Study Location

Page Used:

Page

Page Element

Plan Offering HESA Data — Venues

Venue ID

Plan Year HESA Data — Venues

Venue ID

Sub-Plan Offering HESA Data – Venues

Venue ID

Sub-Plan Year HESA Data – Venues

Venue ID

HESA Instance Data

VENUEID

Student Program

Campus

Institution HESA Data – Venues

Venue ID, Own Venue ID

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. If DISTANCESL isn't null, derive as null.

  2. Derive from HESA Instance Data.

  3. If the parent Engagement entity is based on a sub-plan, derive value from Sub-Plan Year HESA Data – Venues.

  4. If the parent Engagement entity is based on a sub-plan, derive value from Sub-Plan Offering HESA Data – Venues.

  5. If the parent Engagement entity is based on a plan, derive value from Plan Year HESA Data — Venues.

  6. If the parent Engagement entity is based on a plan, derive value from Plan Offering HESA Data — Venues.

  7. If the Campus value is defined as the Own Venue ID value for a Venue record for the Institution in Institution HESA Data, derive the Venue ID of that record. If there are multiple Venue records with the same Own Venue ID value, derive the record with the lowest Venue ID.

  8. Use default.