HESA Unique Student Identifier (HUSID/SID)

Return: ITT

Entity: Student

Page Used:

Page	Page Element
External System ID	External System ID

Field Derivation Rule: Include for all students.

Derivation Step:

1. Derive from the most recent non-future external system ID records matched on EMPLID where the ID type is the same as that defined for SID in the HESA configuration record.

2. If an SID isn't found, a new SID is created according to the Create Student Identifiers process, and that value is derived.

3. If the student has an existing HUSID, that is used to create the SID. Otherwise, a new SID is created.

   1. First two digits: Last two digits of the year from earlier MATR or ACTV row in the student program.

   2. Next eight digits: The provider's UKPRN.

   3. Next 6 digits: The next 6-digit sequence number from HESA configuration. The sequence number is automatically incremented when a value is used.

   4. Last digit: Check digit.

   The new SID is stored as an External System ID using the current effective date.

4. Derive as NULL ERROR.