Student (DFSTDNT) Return: Module Entity

When running the Create Extract process (with the Include Module Entities checkbox selected), module records for institutions where “Report to HESA = Y” are included based on these criteria.

• If you select Null Errors Only for Module Entities, only unique MODID values from active module extract data are included, where any field in the Module or Module Subject extract data contains a NULL ERROR.

• If you select Validation Errors Only, the process:

  • Deletes staging records where COURSEID, MODID, and EMPLID are all blank.

  • Selects unique MODID values from the validation error staging table where MODID isn’t blank and EMPLID is blank.

  • Deletes these processed staging records after extraction.

  • As leading zeroes are removed from MODID by the file parser, the matching logic assumes Course Offering Number is a single digit where relevant.

• If you enter a Course ID or Course Offering Number as a parameter, only records that match those values are included.

• If you select an Academic Career (without specifying a Course Offering), only course offerings tied to the chosen academic career are included.

Otherwise, module records are included only if these conditions are true:

• The course offering’s effective-dated row overlaps the reporting period.

• The related Course Catalog record has an “Active” status.

For standard modules, here's how MODID and MTITLE are determined:

• MODID: Course ID (max 6 chars) plus Course Offering Number (max 2 digits), e.g., 0012482.

• MTITLE: Module Title from HESA Module Data. If not defined, use the Course Catalog description.

For dummy modules, here's how MODID and MTITLE are determined:

• MODID: Academic Plan (max 10 chars) plus Year (max 2 digits), e.g., ENGL2.

• MTITLE: Module Title from HESA Dummy Module Details. If not set, combine the Plan description, the word “Year,” and the year value, e.g., “PhD English Year 2”.