Data Futures Return: Off Venue Activity Entity
For each Student Course Session in the extract, entities are created based on Off Venue Activity records defined for the most recent effective-dated HESA Instance record where the effective date falls on or before the reporting period end date. Records are not included if the Start Date is after the reporting period end date. Records without Start Dates are included.
If no entities are created from HESA Instance and a default value is defined for ACTTYPEID in returns setup, a single entity is created using default, null, or NULL ERROR values.
The OVAID unique identifier is derived as SCSESSIONID (unique identifier for parent Student Course Session) + Sequence Number, defaulting to 1 for the first entity and incremented for subsequent entities.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
Off Venue Activity ( |
Duration |
Field Derivation Rule: Include for all entities.
Derivation Step:
-
Derive value from HESA Instance — Off Venue Activity.
-
Use default.
-
Derive as NULL ERROR.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
Off Venue Activity ( |
Duration Type |
Field Derivation Rule: Include for all entities.
Derivation Step:
-
Derive value from HESA Instance — Off Venue Activity.
-
Use default.
-
Derive as NULL ERROR.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
Off Venue Activity ( |
End Date |
Field Derivation Rule: Include for all entities.
Derivation Steps:
Derive value from HESA Instance — Off Venue Activity, converted to YYYY-MM-DD.
-
Use default.
Derive as null.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
Off Venue Activity ( |
Start Date |
Field Derivation Rule: Include for all entities.
Derivation Steps:
Derive value from HESA Instance — Off Venue Activity, converted to YYYY-MM-DD.
-
Use default.
Derive as null.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
Off Venue Activity ( |
Activity Type |
Field Derivation Rule: Include for all entities.
Derivation Step:
-
Derive value from HESA Instance — Off Venue Activity.
-
Use default.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
Campus Community > Organization > Create/Maintain Organizations > Organization Location |
Country |
|
Off Venue Activity ( |
External Org ID |
|
Off Venue Activity ( |
Country |
Field Derivation Rule: Include for all entities.
Derivation Step:
-
Derive value from HESA Instance — Off Venue Activity.
-
If an Ext Org ID is defined, derive from the Country value defined for the primary location from the most recent effective-dated Organization Table and Organization Location records. The 3-character country code is converted to the 2-character country code defined in the Country Table.
-
Use default.
-
Derive as NULL ERROR.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
|
UKPRN, Unique Reference Number, Companies House Number, National Health Service ID, Host ID |
|
Off Venue Activity ( |
External Org ID |
|
Off Venue Activity ( |
Host ID Type |
Field Derivation Rule: Derive a value if ACTTYPEID = 01 (TT placement) or 04 (studying).
Derivation Steps:
Derive value from HESA Instance — Off Venue Activity.
If an External Org ID is defined, derive UKPRN from the most recent effectivedated Organization Table record.
If an External Org ID is defined, derive Unique Reference Number from the most recent effective-dated Organization Table record.
If an External Org ID is defined, derive the Host ID from the most recent effective dated Organization Table record.
-
Use default.
Derive as NULL ERROR.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
|
UKPRN, Unique Reference Number, Companies House Number, National Health Service ID, Host ID |
|
Off Venue Activity ( |
External Org ID |
|
Off Venue Activity ( |
Host ID Type |
Field Derivation Rule: Derive a value if ACTTYPEID = 01 (TT placement) or 04 (studying).
Derivation Steps:
Derive value from HESA Instance — Off Venue Activity.
If an External Org ID is defined and UKPRN is defined in the most recent effective dated Organization Table record, derive 01.
If an External Org ID is defined and Unique Reference Number is defined in the most recent effective dated Organization Table record, derive 02.
If an External Org ID is defined and Host ID is defined in the most recent effective dated Organization Table record, derive 05.
-
Use default.
Derive as NULL ERROR.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
|
Scheme |
Field Derivation Rule: Include for all entities
Derivation Step:
-
Derive value from HESA Instance — Off Venue Activity.
-
Use default.
-
Derive as NULL ERROR.
Return: Data Futures
Entity: Off Venue Activity
Page Used:
|
Page |
Page Element |
|---|---|
|
|
Module Instance |
Field Derivation Rule: Include for all entities
Derivation Steps:
Derive value from HESA Instance — Off Venue Activity.
-
Use default.
Derive as null.