Student Record Return: Course Entity

If you select the Include Course Entities check box on the Create Extract Data page, the Create Extract process creates Course entities based on the academic plans and academic subplans of the institution that are active and have been set up as eligible for reporting to HESA on the Plan HESA Data or the Sub-Plan HESA page.

If you select the Enable Sub-Plan Reporting check box on the HESA Returns page, the Create Extract process looks at both subplans and plans with the Report to HESA check box selected. If you did not select the Enable Sub-Plan Reporting check box on the HESA Returns page or if no subplan records are marked for reporting to HESA, then the extract process looks at only plan records for deriving the Course fields.

Note: You can specify an academic subplan, academic plan, or both on the Create Extract Data page to test the Create Extract process for a single plan or subplan. The process then uses the specified subplan or plan to create the Course entities. You must select the Enable Sub-Plan Reporting check box on the HESA Returns page if you want to specify a subplan on the Create Extract Data page.

If you have specified an academic career on the Create Extract Data page and no plan, the process includes only those plans that are related to the specified academic career either by looking at the Academic Career field on the Academic Plan Table page or by looking at the parent Academic Program settings (Academic Program field on the Academic Plan Table page and then Academic Career field on the Academic Program Table page).

If you have specified an academic career on the Create Extract Data page and no subplan, the process includes only those subplans whose parent Academic Plan is related to the Academic Career either directly (Academic Career field on the Academic Plan Table page) or by looking at the parent Academic Program settings (Academic Program field on the Academic Plan Table page, and then the Academic Career field on the Academic Program Table page).

If you have specified an academic plan on the Create Extract Data page and no subplan, the process includes only those subplans that are related to the specified plan by looking at the Academic Plan field on the Academic Sub-Plan Table page.

If you have selected the Null Errors Only check box for the Include Course Entities on the Create Extract Data page, the process selects distinct COURSEID values from the existing active Course extract data, where at least one field in the Course or Course Subject extract data has a Derived Value of NULL ERROR. The process then selects Course entity records for these COURSEIDs.

If you have selected the Validation Errors Only check box for the Include Course Entities, the process first deletes any Validation Error staging records where all of the COURSEID, MODID and EMPLID fields are blank. Then, it selects distinct COURSEID values from the Validation Error staging table for rows where COURSEID is not blank and EMPLID is blank. The process selects Course entity records for these COURSEIDs. Finally, it deletes records from the Validation Error staging table where COURSEID is populated and EMPLID is blank.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	AWARDBOD
Plan HESA Data	AWARDBOD
Sub-Plan HESA	AWARDBOD

Field Derivation Rule: Derive a value if the following conditions are met:

Course.COURSEAIM begins with D, E, L, M, H, I, J or C.
Course.COURSEAIM does not end with 99 (that is, H99, L99, M99, I99, J99, C99).

Do not derive a value and leave the field blank, if the conditions are not met.

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.
Default to the derived Institution.UKPRN value.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	AWARDBOD2 to 8
Plan HESA Data	AWARDBOD2 to 8
Sub-Plan HESA	AWARDBOD2 to 8

Field Derivation Rule: Derive a value if the following conditions are met:

Course.COURSEAIM begins with D, E, L, M, H, I, J or C.
Course.COURSEAIM does not end with 99 (that is, H99, L99, M99, I99, J99, C99).

Do not derive a value and leave the field blank, if the conditions are not met.

Derivation Steps:

If Course.AWARDBOD was derived from a subplan (derivation step 2 in the previous subsection), derive from the Sub-Plan HESA page.
If Course.AWARDBOD was derived from a plan (derivation step 3 in the previous subsection), derive from the Plan HESA Data page.
If Course.AWARDBOD was derived from a program (derivation step 4 in the previous subsection), derive from the Program HESA Data page.
Do not derive a value and leave the field blank.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	BITTM
Plan HESA Data	BITTM
Sub-Plan HESA	BITTM

Field Derivation Rule: Derive a value only if the following conditions are met:

Country = Wales, Scotland, or Northern Ireland
Course.REDUCEDC = 00, 01, or 04
Course.TTCID = 1 or 2

Do not derive a value and leave the field blank, if the conditions are not met.

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: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	CLSDCRS
Plan HESA Data	CLSDCRS
Sub-Plan HESA	CLSDCRS

Field Derivation Rule: Derive a value only if the following conditions are met:

Country = England
Course.REDUCEDC = 00

Do not derive a value and leave the field blank, if the conditions are not met.

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

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	COLLORG
Plan HESA Data	COLLORG
Sub-Plan HESA	COLLORG

Field Derivation Rule: Derive a value only if the following conditions are met:

Country = England
Course.REDUCEDC = 00
Course.COURSEAIM does not equal D00, D01, D90, L00, L80, L90, or L91

Do not derive a value and leave the field blank, if the conditions are not met.

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: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	COURSEAIM
Plan HESA Data	COURSEAIM
Sub-Plan HESA	COURSEAIM

Field Derivation Rule: Include for all Course entities.

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: Student Record

Entity: Course

Pages Used: None

Field Derivation Rule: Include for all Course entities.

Derivation Steps:

If the Course entity is based on a subplan, derive from the Academic Sub-Plan Table record.
Derive from the Academic Plan Table record.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Plan HESA Data	Course Title
Sub-Plan HESA	HESA Course Title
Academic Plan Table select (Set Up SACR, then select Foundation Tables, then select Academic Structure, then select Academic Plan Table )	Academic Plan
Academic Sub-Plan Table select (Set Up SACR, then select Foundation Tables, then select Academic Structure, then select Academic SubPlan Table)	Academic Subplan

Field Derivation Rule: Include for all Course entities.

Derivation Steps:

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

If the Course Title field does not have a value, use a combination of the plan and subplan descriptions from the Academic Plan Table and Academic Sub-Plan Table pages.
Derive from the Plan HESA Data page.

If the Course Title field does not have a value, use the plan description from the Academic Plan Table page.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	FEQAIMC
Plan HESA Data	FEQAIMC
Sub-Plan HESA	FEQAIMC

Field Derivation Rule: Include for all Course entities.

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.
Do not derive a value and leave the field blank.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	MSFUND
Plan HESA Data	MSFUND
Sub-Plan HESA	MSFUND

Field Derivation Rule: Derive a value if Course.REDUCEDC = 00, 01 or 04. Otherwise, do not derive a value and leave the field blank.

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.
If Country = Scotland, Northern Ireland or Wales, derive as NULL ERROR.
Do not derive a value and leave the field blank.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	NHSBURSARY
Plan HESA Data	NHSBURSARY
Sub-Plan HESA	NHSBURSARY

Field Derivation Rule: Derive a value if Country = Northern Ireland, England or Wales and REDUCEDC = 00

Derivation Steps:

Use Constant.
If the Course entity is based on a sub-plan, derive from the Sub-Plan HESA page.
Derive from Plan HESA Data.
Derive from Program HESA Data
Use default.
Derive as NULL ERROR.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Plan HESA Data	OWNCOURSEID
Sub-Plan HESA Data	OWNCOURSEID

Field Derivation Rule: Include for all Course entities.

Derivation Steps:

If Course entity is based on a subplan, derive from the Sub-Plan HESA Data page.
Derive from the Plan HESA Data page.
Do not derive a value and leave the field blank.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	REDUCEDC
Plan HESA Data	REDUCEDC
Sub-Plan HESA	REDUCEDC

Field Derivation Rule: Include for all Course entities.

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: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	REGBODY
Plan HESA Data	REGBODY
Sub-Plan HESA	REGBODY

Field Derivation Rule: Derive a value if the following conditions are met:

Course.COURSEAIM = M16, M26, M76, M86, H16, H62, H76, I16, I76, J26, or J76
Course.REDUCEDC = 00 or 01

Do not derive a value and leave the field blank, if the conditions are not met.

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: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	SKEUNITS
Plan HESA Data	SKEUNITS
Sub-Plan HESA	SKEUNITS

Field Derivation Rule: Derive a value if the following conditions are met:

Country = England
Course.REDUCEDC = 07 (SKE) or Course.TTCID = F (SKE)

Do not derive a value and leave the field blank, if the conditions are not met.

Derivation Steps:

Use Constant.
If the Course entity is based on a sub-plan, derive from the Sub-Plan HESA page.
Derive from Plan HESA Data.
Derive from Program HESA Data
Use default.
Derive as NULL ERROR.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	SKEOS
Plan HESA Data	SKEOS
Sub-Plan HESA	SKEOS

Field Derivation Rule: Derive a value if the following conditions are met:

Country = England
Course.REDUCEDC = 07 (SKE) or Course.TTCID = F (SKE)

Do not derive a value and leave the field blank, if the conditions are not met.

Derivation Steps:

Use Constant.
If the Course entity is based on a sub-plan, derive from the Sub-Plan HESA page.
Derive from Plan HESA Data.
Derive from Program HESA Data
Use default.
Derive as NULL ERROR.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	TQSSEC
Plan HESA Data	TQSSEC
Sub-Plan HESA	TQSSEC

Field Derivation Rule: Derive a value if the following conditions are met:

Country = Scotland or Northern Ireland
Course.REDUCEDC = 00
Course.TTCID = 1 or 2

Do not derive a value and leave the field blank, if the conditions are not met.

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: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	TQSSUB, TQSSUB2, TQSSUB3
Plan HESA Data	TQSSUB, TQSSUB2, TQSSUB3
Sub-Plan HESA	TQSSUB, TQSSUB2, TQSSUB3

Field Derivation Rule: Derive a value if the following conditions are met:

Country = Scotland
Course.REDUCEDC = 00
Course.TQSSEC = 2

Do not derive a value and leave the field blank, if the conditions are not met.

Derivation Steps:

Use constant to create a single TQSSUB field.
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 to create a single TQSSUB field.
Derive a single TQSSUB field as NULL ERROR.

Note: The system can derive up to three values. Each of the values is included as a separate TQSSUB field in the XML file.

Return: Student Record

Entity: Course

Pages Used:

Page	Page Element
Program HESA Data	TTCID
Plan HESA Data	TTCID
Sub-Plan HESA	TTCID

Field Derivation Rule: Derive a value if one of the following conditions is met:

Country = England, Northern Ireland or Scotland AND Course.REDUCEDC = 00, 01, 04, 07 or 09.
Country = Wales AND Course.COURSEAIM does not begin with P, Q, R, S or X AND Course.REDUCEDC = 00, 01, 04, 07 or 09.

Do not derive a value and leave the field blank, if the conditions are not met.

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.

Student Record Return: Course Entity

Awarding Body 1 (AWARDBOD)

Awarding Body 2 to 8 (AWARDBOD2 to 8)

Bilingual ITT Marker (BITTM)

Closed Course (CLSDCRS)

Collaborating Organization (COLLORG)

General Qualification Aim of Course (COURSEAIM)

Course Identifier (COURSEID)

Course Title (CTITLE)

FE General Qualification Aim (FEQAIMC)

Major Source of Funding (MSFUND)

NHS Bursaries (NHSBURSARY)

Own Course Identifier (OWNCOURSEID)

Reduced Course Return Indicator (REDUCEDC)

Regulatory Body for Health and Social Care Students (REGBODY)

Subject Knowledge Enhancement Units (SKEUNITS)

Subject Knowledge Enhancement Placement (SKEOS)

Teaching Qualification Sought Sector (TQSSEC)

Teaching Qualification Sought Subject (TQSSUB)

Teacher Training Course (TTCID)