Data Futures Return: Course Entity

Course extract records are created if you select the Include Course Entities check box. If you select the Enable Sub-Plan Reporting check box on the HESA Returns page, the eligible academic sub-plans for the institution are selected from ACAD_SUBPLN_TBL. Eligible academic plans for the institution are selected from ACAD_PLAN_TBL.

Records are only included if the Report to HESA check box is selected.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

BITTMC

Plan HESA Data

BITTMC

Sub-Plan HESA

BITTMC

Field Derivation Rule: If all the following conditions are met, a value is derived:

  • Country = Scotland or Northern Ireland

  • Course.TTCIDC = 01 or 02

Derivation Steps:

  1. Use constant.

  2. If Course entity is based on a subplan, derive from the Sub-Plan HESA page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

CLSDCRSC

Plan HESA Data

CLSDCRSC

Sub-Plan HESA

CLSDCRSC

Field Derivation Rule: Derive a if Country = England.

Derivation Steps:

  1. Use constant.

  2. If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Plan HESA Data

Course Title

Academic Plan Table

Description

Sub-Plan HESA

Course Title

Academic Sub-Plan Table

Description

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. If the Course entity is based on a sub-plan, derive as either:

    • Course Title from Sub-Plan HESA (if defined).

    • Combination of Plan and Sub-Plan descriptions separated by a space.

  2. Derive from the Academic Plan.

    • Course Title from Sub HESA Data(if defined).

    • Plan description

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

FULLYFLEX

Plan HESA Data

FULLYFLEX

Sub-Plan HESA Data

FULLYFLEX

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as null.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

FUNDLEVEL

Plan HESA Data

FUNDLEVEL

Sub-Plan HESA Data

FUNDLEVEL

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

PREREQUISITE

Plan HESA Data

PREREQUISITE

Sub-Plan HESA Data

PREREQUISITE

Field Derivation Rule: Derive a value if Country = England or Northern Ireland.

Derivation Steps:

  1. Use constant.

  2. If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

Qualification ID

Plan HESA Data

Qualification ID

Sub-Plan HESA Data

Qualification ID

Field Derivation Rule: Include for all entities

Derivation Steps:

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

  2. Derive from the Plan HESA Data page.

  3. Derive from the Program HESA Data page.

  4. Use default.

  5. Derive as NULL ERROR.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

SANDWICHCD

Plan HESA Data

SANDWICHCD

Sub-Plan HESA Data

SANDWICHCD

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: Data Futures

Entity: Course

Pages Used:

Page

Page Element

Program HESA Data

TTCIDC

Plan HESA Data

TTCIDC

Sub-Plan HESA Data

TTCIDC

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.