Data Futures Return: Course Reference Entity
Course Reference extract records are created if you selected the Include Course Entities parameter check box.
Note: OWNCOURSEID is displayed in Plan HESA Data and Sub-Plan HESA Data. The other fields are displayed under KIS Course Data.
For each Academic Plan or Sub-Plan (keyed on COURSEID) in the Course Extract for the return with status of ACTIVE:
If the Course is derived from a Sub-Plan:
If OWNCOURSEID is defined for the sub-plan or parent plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 01.
If UCASPROGID is defined for the sub-plan or parent plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 02.
If UCASCOURSEID is defined for the sub-plan or parent plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 03.
If UCASCOURSEID2 is defined for the sub-plan or parent plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 03.
If UCASCOURSEID3 is defined for the sub-plan or parent plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 03.
If none of the fields are defined for the sub-plan or plan, entities aren't created.
If the Course is derived from a Plan:
If OWNCOURSEID is defined for the plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 01.
If UCASPROGID is defined for the plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 02.
If UCASCOURSEID is defined for the plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 03.
If UCASCOURSEID2 is defined for the plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 03.
If UCASCOURSEID3 is defined for the plan, a Course Identifier entity is created with COURSEREFRNCIDTYPE = 03.
If none of the fields are defined for the plan, entities aren't created.
Return: Data Futures
Entity: Course Reference
Pages Used:
Page |
Page Element |
---|---|
Plan HESA Data |
OWNCOURSEID |
Sub-Plan HESA Data |
OWNCOURSEID |
Plan HESA Data—KIS Course Data |
UCASPROGID |
Sub-Plan HESA Data—KIS Course Data |
UCASPROGID |
Plan HESA Data—KIS Course Data |
UCASCOURSEID |
Plan HESA Data—KIS Course Data |
UCASCOURSEID2 |
Plan HESA Data—KIS Course Data |
UCASCOURSEID3 |
Sub-Plan HESA Data—KIS Course Data |
UCASCOURSEID |
Sub-Plan HESA Data—KIS Course Data |
UCASCOURSEID2 |
Sub-Plan HESA Data—KIS Course Data |
UCASCOURSEID3 |
Field Derivation Rule: Include for all entities
Derivation Steps:
If Course entity is based on a sub-plan, derive from the Sub-Plan HESA Data page:
OWNCOURSEID = 01
UCASPROGID = 02
UCASCOURSEID, UCASCOURSEID2, UCASCOURSEID3 = 03
Derive from the Plan HESA Data page:
OWNCOURSEID = 01
UCASPROGID = 02
UCASCOURSEID, UCASCOURSEID2, UCASCOURSEID3 = 03
Return: Data Futures
Entity: Course Reference
Pages Used:
Page |
Page Element |
---|---|
Plan HESA Data |
OWNCOURSEID |
Sub-Plan HESA Data |
OWNCOURSEID |
Plan HESA Data—KIS Course Data |
UCASPROGID |
Sub-Plan HESA Data—KIS Course Data |
UCASPROGID |
Plan HESA Data—KIS Course Data |
UCASCOURSEID |
Plan HESA Data—KIS Course Data |
UCASCOURSEID2 |
Plan HESA Data—KIS Course Data |
UCASCOURSEID3 |
Sub-Plan HESA Data—KIS Course Data |
UCASCOURSEID |
Sub-Plan HESA Data—KIS Course Data |
UCASCOURSEID2 |
Sub-Plan HESA Data—KIS Course Data |
UCASCOURSEID3 |
Field Derivation Rule: Include for all entities
Derivation Steps:
If Course entity is based on a sub-plan, derive Code field value from the Sub-Plan HESA Data page.
Derive Code field value from the Plan HESA Data page.