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:
Use constant.
If Course entity is based on a subplan, derive from the Sub-Plan HESA page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
Use constant.
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
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.
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:
Use constant.
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
Use constant.
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
Use constant.
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
Use constant.
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
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:
Use constant.
If parent Course is based on a sub-plan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Derive from the Program HESA Data page.
Use default.
Derive as NULL ERROR.