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:

  1. 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

  2. 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:

  1. If Course entity is based on a sub-plan, derive Code field value from the Sub-Plan HESA Data page.

  2. Derive Code field value from the Plan HESA Data page.