Data Futures Return: Module Entity
If you select the Include Module Entities check box on the Create Extract Data page, the Create Extract process creates the Module entities. To create Module entities, the process uses the institution's Course Offering records that are active and have been set up as eligible for reporting to HESA. You must select the Report to HESA check box on the HESA Module Data page to make a course offering record eligible for HESA reporting.
The process includes dummy modules in the module entity.
Note: When you run the Create Extract process, you can choose to enter the course ID or course offering number as a run parameter for testing purposes. The Create Extract process then uses the specified course ID or course offering number to create the Module entities.
If you have selected an academic career and no course offering on the Create Extract Data page, then the process selects only those course offerings that are related to the selected career.
If you have selected the Null Errors Only check box for the Include Module Entities on the Create Extract Data page, the Create Extract process selects distinct MODID values from the existing active Module extract data, where at least one field in the Module or Module Subject extract data has a Derived Value of NULL ERROR. The process then selects Module entity records for these MODIDs.
If you have selected the Validation Errors Only check box for the Include Module Entities, the Create Extract process first deletes any Validation Error staging records where all of the COURSEID, MODID and EMPLID fields are blank. Then, it selects distinct MODID values from the Validation Error staging table for rows where MODID is not blank and EMPLID is blank. The process selects Module entity records for these MODIDs. Note that the File Parser process removes the leading zeroes from MODID, therefore, the comparison of MODID with Course ID and Course Offering Number includes the logic to correctly match the values. The system makes an assumption that the Course Offering Number is a single digit. Finally, the Create Extract process deletes records from the Validation Error staging table where MODID is populated and EMPLID is blank.
Return: Data Futures
Entity: Module
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
CRDTPTS |
Catalog Data (Curriculum Management, Course Catalog, Catalog Data) |
Maximum Units, Academic Progress Units, Enrollment Unit Load Calc Type |
Field Derivation Rule: Include for all entities
Derivation Steps:
Derive from the HESA Module Data page.
Select the Course Catalog record for the Course ID. If the Enrollment Unit Load Calc Type value is Academic Progress Units, derive from the Academic Progress Units value. If the Enrollment Unit Load Calc Type value is any other value, derive from the Maximum Units value. Round off the fractional values to the nearest whole number. This step is not performed for dummy modules.
Use default.
Derive as null.
Return: Data Futures
Entity: Module
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
CRDTSCMM |
HESA Dummy Module |
CRDTSCMM |
Field Derivation Rule: Include for all entities
Derivation Steps:
Use constant.
Derive from the HESA Module Data page.
Use default.
Derive as null.
Return: Data Futures
Entity: Module
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
FTE |
HESA Dummy Module |
FTE |
Field Derivation Rule: Include for all entities
Derivation Steps:
Use constant.
Derive from the HESA Module Data page.
Use default.
Derive as NULL ERROR.
Return: Data Futures
Entity: Module
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
MODLANGID |
HESA Dummy Module |
MODLANGID |
Field Derivation Rule: Include where Country = Northern Ireland or Scotland
Derivation Steps:
Derive from the HESA Module Data page.
Use default.
Derive as null.
Return: Data Futures
Entity: Module
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
LEVLPTSM |
HESA Dummy Module |
LEVLPTSM |
Field Derivation Rule: If Module.CRDTPTS is greater than zero, derive a value.
Derivation Steps:
Use constant.
Derive from the HESA Module Data page.
Use default.
Derive as null.
Return: Data Futures
Entity: Module
Page Used:
Page |
Page Element |
---|---|
HESA Module Data |
Course ID Course Offering Nbr |
Field Derivation Rule: Include for all Module entities.
Derivation Steps:
Derive as combination of Course ID plus Course Offering Number (CRSE_ID and CRSE_OFFER_NBR column values from PS_CRSE_OFFER), or the combination of Academic Plan and Year for dummy modules. For example, if Course ID = 001248 and Offering Number = 2, then MODID = 0012482.