Start Date of Instance (COMDATE)

Return: ITT

Entity: Student

Page Used:

Page Page Element

HESA Instance

Start Date of Instance

Note:

This field is included as ITTSTARTDATE in the XML file.

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Derive from the HESA Instance page.

  2. If there is a Research Candidate record for the instance:

    1. Select the Begin Date (SSR_RS_BEGIN_DT) from the most recent active Consumption record where the effective date is on or before the reporting period end date.

    2. Derive the Begin Date formatted to YYYY-MM-DD.

    3. Match the Research Candidate record (SSR_RS_CAND_HDR) to the instance on EMPLID, Institution, Career and Career Number to find the Research Candidate Number (SSR_RS_CANDIT_NBR). If multiple records are found, the record with the highest candidate number is selected.

    4. Associate consumption records (SSR_RS_CONSMPTN) with the Research Candidate record by EMPLID, Institution and Research Candidate Number.

    The calculated value is stored in the HESA Instance Data record.

  3. Use the following process to calculate the earliest class start date for enrolled classes related to the Instance being reported. This selection is similar to that done for StudentOnModule except that it is not restricted to classes overlapping the reporting period and considers enrollments for linked careers.

    1. Select all activated terms for the student career of the Instance.

    2. From each activated term, select classes that satisfy the following conditions:

      – Status = Enrolled

      – 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 checkbox selected on the HESA Configuration page.

      – Repeat Code value does not exist or does not match a value defined in the Repeat Code Exclusion region with the Extract checkbox 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 apply a further filter to the class enrollments. In such a case, select 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.

    3. If the Instance has been linked to a prior student career using the Linked Career and Linked Career Number fields in the HESA Instance record, then also consider classes for the previous career.

    4. Derive the earliest Class Start Date from all the selected classes as COMDATE.

  4. Derive as the earliest Effective Date of the HESA Instance records.