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 |
Academic Plan |
Academic Sub-Plan 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.