Graduate Outcomes Return: Graduate Entity

Return: GRADOUT

Entity: Graduate

Pages Used: None

Field Derivation Rule: Include for all entities.

Derivation Steps:

1. Select the most recent active, effective-dated address record with an Address Type that corresponds to Address Types for COUNTRY in the HESA Return Setup record (or if no Address Types are defined then consider all address types) where the country code is one of the UK codes (GBR, ENG, SCT, WAL, NIR, XF, XG, XH or XI).

   If multiple UK addresses are found with the same effective date, then one is randomly selected.

   Derive the HESA country code as follows:

   • GBR = XK

   • ENG or XF = XF

   • NIR or XG = XG

   • SCT or XH = XH

   • WAL or XI = XI

2. Select the most recent active, effective-dated address record with an Address Type that corresponds to Address Types for COUNTRY in the HESA Return Setup record (or if no Address Types are defined then consider all address types) where the country code is not one of the UK codes.

   If multiple non-UK addresses are found with the same effective date, then one is randomly selected.

   Derive the two-character country code from the Country table, for example: AUS (Australia) = AU.

3. Use default. (for example, ZZ = not known)

4. Derive as NULL ERROR.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Include for all entities.

Derivation Steps:

1. Select up to three email addresses where the email type matches one of the types set up in Returns Setup – HESA types for EMAIL, or no types are set up for the return for EMAIL.

   If one of the selected emails has preferred = “Y,” that record is used for EMAIL and any other selected email addresses are used for EMAIL2 and EMAIL3. If more than three email addresses are selected, then the values are derived by by email type in ascending order.

2. Derive as NULL.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Include for all entities.

Derivation Steps:

1. Derive from the survey record.

2. Derive as NULL.

Return: Student Record

Entity: Student

Page Used:

Field Derivation Rule: Include for all entities

Derivation Steps:

1. If First Name space Middle Name of the most recent effective-dated primary name record is different from the derived FNAMES value, derive the value.

2. Derive as null.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Include for all entities.

Derivation Steps:

1. Derive from the survey record.

2. If Date of Death is populated, derive as 01 (deceased).

3. If null values are derived for all email and telephone fields, derive as 02 (not contactable by email or telephone).

4. Derive as NULL.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Include for all entities.

Derivation Step: Derive from the survey record.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: If Home/EU/Overseas is not 3 (overseas), derive up to 3 values from non-UK phone numbers where the phone type matches one of the types set up in Returns Setup – HESA Types for INTTEL, or no types are set up for the return for that field and either one of the following:

• Country Code has a value and is not 000 nor 044

• Country Code is blank or 000, phone number starts with +, and Phone number does not start +44

If one of the selected records has Preferred = “Y,” that record is used for INTTEL and any other records are used for INTTEL2 and INTTEL3. If more than 3 non-UK phone numbers are selected, then fields are derived by phone type in ascending order. Phone numbers that are longer than 17 digits and not flagged as preferred are not considered.

If Home/EU/Overseas is 3, or there are no international telephone numbers, the field is null.

Derivation Step:

1. Remove special characters, spaces, and leading zeros from the phone number as well as any country code with leading zeros. Two leading zeroes are added for the UK international direct dialing code.

   Derive the value if it is 17 digits or fewer.

2. For INTTEL, if the preferred phone number is derived and the derived number is longer than 17 digits, derive as NULL ERROR.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Include for all entities.

Derivation Step: Derive from the survey record.

Return: Student Record

Entity: Student

Page Used:

Field Derivation Rule: Include for all entities

Derivation Steps:

1. If the Last Name of the most recent effective-dated primary name record is different from the derived SURNAME value, derive the value.

2. Derive as null.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Include for all entities.

1. Derive from the survey record.

2. Derive as NULL ERROR.

Return: GRADOUT

Entity: Graduate

Pages Used:

Field Derivation Rule: Derive up to three values from UK phone numbers where:

• Phone type matches one of the types set up in Returns Setup – HESA Types for UKMOB, or types are not set up for the return for that field

• Country code is blank, 000, or 044

• Phone number does not start with + or starts with +44

• Phone number where the special characters, spaces, leading 44, and leading zeros are removed starts in the range 71 to 79

If one of the selected records has Preferred = “Y,” that record is used for UKMOB and any other records are used for UKMOB2 and UKMOB3. If more than three UK phone numbers are selected, then fields are derived by phone type in ascending order.

Derivation Step:

1. Remove special characters, spaces, and leading 44 from the phone number. A leading zero is added if one does not exist.

   Derive the value if it is 11 digits.

2. If the preferred phone number is derived and the derived number is not 11 digits, derive as NULL ERROR.

Return: GRADOUT

Entity: Graduate

Page Used:

Field Derivation Rule: If Home/EU/Overseas is not 3 (overseas), derive up to three values from UK phone numbers where:

• Phone type matches one of the types set up in Returns Setup – HESA Types for UKTEL, or types are not set up for the return for that field

• Country code is blank, 000, or 044

• Phone number does not start with + or +44

• Phone number where the special characters, spaces, leading 44, and leading zeros are removed does not start in the range 71 to 79

If one of the selected records has Preferred = “Y,” that record is used for UKTEL and any other records are used for UKTEL2 and UKTEL3. If more than three UK phone numbers are selected, then UKTEL2 and UKTEL3 are derived by phone type in ascending order.

If Home/EU/Overseas is 3, or there are no UK telephone numbers, the field is null.

Derivation Step:

1. Remove special characters, spaces, and leading 44 from the phone number. A leading zero is added if one does not exist.

   Derive the value if it is 10 or 11 digits.

2. If the preferred phone number is derived and the derived number is not 10 or 11 digits, derive as NULL ERROR.