Student Record Return: Student On Module Entity
The Create Extract process can create a maximum of 128 Student On Module records for each Instance in the return to indicate which modules (Campus Solutions courses) the student has been studying during the reporting period. The process selects Student On Module records based on the student's course enrollments and the course offering records included in the related Module entities of the return.
The process creates the Student On Module entities only if the Include Student Entities check box is selected on the Create Extract Data page.
HESA requires Student On Module records only if Instance.STULOAD is greater than zero. However, academic institutions can optionally include Student On Module records in the return when STULOAD = 0.
To choose student enrollment records for the Student on Module entity creation, the process:
Selects all activated terms for the student career.
From each activated term, selects classes that satisfy the following conditions:
Class Start Date is within the reporting period, or Class End Date is within the reporting period, or Class Start Date is prior to the reporting period and Class End Date is after the reporting period.
Status = Enrolled or Dropped.
Units Taken value is greater than zero.
Grading basis value matches one of the values defined in the Grading Basis Inclusion region with the Extract check box selected on the HESA Configuration page.
A Repeat Code value does not exist or does not match a value defined in the Repeat Code Exclusion region with the Extract check box selected on the HESA Configuration page.
If the student has multiple careers with the same Academic Career value as the career being processed (that is, the same career value with different career numbers), then the process applies a further filter to the class enrollments. In that case, the process selects the class only if the program value of the enrollment record does not exist or matches one of the program values in the Student Program records for that career and career number.
When the process considers class start and end dates for class enrollments where the Session = OEE (open entry/exit), rather than selecting the class start/end dates, the process selects the values from the Student OEE Enrollment Data record for the class enrollment. If the end date is not defined in Student OEE Enrollment Data then the process uses the class end date. The start date is mandatory for a Student OEE Enrollment Data record. Note that the process does not consider linked careers for Student On Module.
For students with a STULOAD value of greater than zero, if there are no relevant class enrolments, the process creates a single Student On Module entity for the student. The process creates the single Student On Module entity only if the combination of Plan and Year has been defined as a dummy module and included in the Module entity.
Return: Student Record
Entity: StudentOnModule
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
APEL |
Field Derivation Rule: If Country = Wales, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
Derive from the HESA Module Data page.
Use default.
Derive as NULL ERROR.
Note: You can define an APEL value at Course Offering/Module level if the module is an APEL module only.
Return: Student Record
Entity: StudentOnModule
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
LANGPCNT |
Field Derivation Rule: If Country = Northern Ireland, Scotland, or Wales, derive a value. Otherwise, do not derive a value and leave the field blank.
Derivation Steps:
Use constant.
Derive from the HESA Module Data page.
Use default.
Derive as NULL ERROR.
Return: Student Record
Entity: Student On Module
Pages Used: None
Field Derivation Rule: Include for all Student On Module entities.
Derivation Step:
1. For each student enrollment record valid for the reporting period, the process determines MODID as a combination of Course ID plus Course Offering Number from the related Course Offering record.
Return: Student Record
Entity: Student On Module
Pages Used:
Page |
Page Element |
---|---|
Module HESA Data |
MODCOUNT |
Field Derivation Rule: Derive a value if the following conditions are met:
Country = Wales
Course.COURSEAIM begins with C, D, E, L, M, H, I or J
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Derive from the Module HESA Data page.
Use default.
Derive as NULL ERROR.
Return: Student Record
Entity: Student On Module
Pages Used:
Page |
Page Element |
---|---|
Enrollment |
Grading Basis Grade In/Official |
Module Outcome |
HESA Module Outcome |
Field Derivation Rule: Include for all Student On Module entities.
Derivation Steps:
Derive as the mapped HESA Module Outcome for the grade selected in the enrollment record.
Use default.
Derive as NULL ERROR.
If HESA Module Data dummy module flag for MODID = Y, derive as 07.
Return: Student Record
Entity: Student On Module
Pages Used: None
Field Derivation Rule: Include for all Student On Module entities.
Derivation Steps:
Use constant.
Derive as 1 if the class start date is before the reporting period, and the class end date is within the reporting period.
Derive as 2 if the class start and end dates are within the reporting period.
Derive as 3 if the class start date is within the reporting period, and the class end date is after the reporting period.
Derive as 4 if the class end date is before the reporting period and MODOUT is not 6.
Derive as 6 if the class start date is before the reporting period and the class end date is after the reporting period.
Use default.
Derive as NULL ERROR.
Note that the derivation logic compares class start and end dates with the reporting period dates to determine the status.
If HESA Module Data dummy module flag for MODID = Y, derive as 05.
When considering class start and end dates for class enrollments where the Session = OEE, rather than selecting the class start and end dates, the derivation logic selects values from the Student OEE Enrollment Data record for the class enrollment. If the end date is not defined in Student OEE Enrollment Data record, then the logic uses the class end date. The start date is mandatory in the Student OEE Enrollment Data record.
Return: Student Record
Entity: Student On Module
Page Used:
Page |
Page Element |
---|---|
Module HESA Data |
MODYR |
Field Derivation Rule: Derive a value if the following conditions are met:
Country = England or Northern Ireland
Instance.INSTAPP = 1
Instance.TYPEYR = 2, 3, 4, or 5
Do not derive a value and leave the field blank, if the conditions are not met.
Derivation Steps:
Derive from the Module HESA Data page.
Use default.
Derive as NULL ERROR.
For dummy modules:
Derive from the HESA Dummy Module Data page.
Use default.
Derive as NULL ERROR.
Note: The field is only derived if INSTAPP = 1, therefore, usually this field will not have any value.