ITT Return: Student Entity

The Create Extract process creates ITT Student entities only if all the following conditions are satisfied:

  • Report to HESA checkbox is selected on the HESA Instance page for the HESA Instance record.

  • The student's program commencement date is before or within the reporting period.

  • Either: (a) the student has been term activated for a term that begins within the reporting period and the student has at least one enrolled class related to that term or (b) the student has an FTE value of greater than zero for the reporting period. The process determines the FTE value for the reporting period from the HESA Instance record as either the Override FTE value or else the Calculated FTE value.

  • The most recent effective dated Student Program stack record has a Program Status matching one of the Eligible Program Statuses defined for the return on the HESA Returns page.

  • The derived TTCIDC value is 01 and the TTCIDC value is determined by the value defined under Program, Plan, or Sub-Plan.

  • Either the start date of the instance is before the reporting period start date and the Continuing Students checkbox is selected, or the start date of the instance is within the reporting period dates and the New Students checkbox is selected.

Note: Students are not included in the return if TTCID is 0 (zero) or is one of the codes only relevant to the Student return (5, 9, D, F, J, K) or is blank or is NULL ERROR.

If all the conditions are satisfied, then the process creates a record in the ITT Student Extract table with status set to ACTIVE using the following values:

  • EMPLID

  • HUSID: The process determines this value from External System ID record for the EMPLID, where the ID type is the same as that defined for HUSID on the HESA Types page. If HUSID does not exist, the process creates a new HUSID.

  • NUMHUS (Student Instance Number): The process determines this value from the HESA Instance record as either Linked Career and Linked Career Number (if defined). Otherwise, it uses a combination of Career and Career Number as the NUHMUS value, that is ACAD_CAREER and STDNT_CAR_NBR. For example, UGRD1.

  • COURSEID: If a sub-plan is selected as the run parameter, the process uses the Sub-Plan code as the COURSEID, If the subplan is not selected, the process uses the plan code.

If you provided an EMPLID for the Student ID run parameter, the process creates ITT Student entity records for only the selected EMPLID.

The Create Extract process selects External Degree records to derive the degree fields (such as DEGENDDT and DEGEST). If the student has multiple records, the process selects the most recent record.

If you have selected the Null Errors Only checkbox for the Include Student Entities on the Create Extract Data page, the process selects distinct EMPLIDs from the existing active ITT extract data, where at least one field in the Student or Course Subject extract data has a derived value of NULL ERROR. The process then selects Student entity records for these EMPLIDs.

If you have selected the Validation Errors Only checkbox for the Include Student Entities, the process first deletes any Validation Error staging records where EMPLID is blank. Then, it selects distinct EMPLIDs from the Validation Error staging table. The process selects Student entity records for these EMPLIDs. Finally, it deletes records from the Validation Error staging table where EMPLID is populated.

For all field derivations:

  • If NULL ERROR has been derived, the Field Status is set to Error.

  • If a Derived Value is not blank, the Field Status is set to New.

  • If a Derived Value is blank, the Field Status is blank.

If the Compare Extract with Submitted checkbox is not selected, the Entity Status is set to:

  • Error when there is at least one field that has Field Status of Error in the extract.

  • New for all other entities.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

HESA Instance Data - Entry Profile

APPLYAPPLICATIONID

Application Data (Student Admissions > Application Maintenance > Maintain Applications > Application Data)

External Application Nbr

Field Derivation Rule: Include for all students

Derivation Steps:

  1. Derive from HESA Instance Data.

  2. Reference the Student Program record for the related instance to find the admission application number (ADM_APPL_NBR). This is then used to reference the admissions data record (ADM_APPL_DATA) to find the external application number (EXT_ADM_APPL_NBR) that holds the application ID plus the choice number for Apply applications. For example, 60018-1.

    If the external application number isn't null and doesn't start with UC or GT, then the ID value minus the dash '-' and choice elements is derived: 60018.

  3. Derive as null.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Biographical Details (Campus Community > Personal Information (Student) > Add/Update a Person > Biographical Details)

Date of Birth

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Derive from the Biographical Details page in the format YYYY-MM-DD.

  2. Derive as NULL ERROR.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

HESA Instance

BURSLEV

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Use constant.

  2. Derive from the HESA Instance page.

  3. Use default.

  4. Derive as NULL ERROR.

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.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Person HESA Data

DISABILITY to DISABILITY 8

Impairment AUS (Campus Community > Personal Information > Health Information > Impairment AUS )

Type of Impairment

Disability (Records and Enrollment > HESA Reporting > Codes and Mappings > Code Mappings > Disability)

HESA Disability

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from the Person HESA Data page.

  2. If no values are defined in Person HESA Data, derive as the HESA code for each of the mapped Impairment record. Unmapped records aren't considered.

  3. Use default, DISABILITY2 to 8 derive as null.

  4. Derive as null.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

HESA Instance Data

ENGEXPECTEDENDDATE

Student Program

Expected Graduation Term

Term Table — Attributes (Set Up SACR > Foundation Tables > Term Setup > Term/Session Table > Term Table)

Date attribute for ENGEXPECTEDENDDATE

HESA Returns Setup — Common Attributes

Common Attributes

Note: This is included as EXPECTEDENDDATE in the XML file in a similar way to PGCECLSS in Previous Qualification.

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Derive from the HESA Instance page.

  2. Derived as the date attribute for the Expected Graduation Term in the most recent Student Program record converted to the YYYY-MM-DD format.

  3. Derive as the Term End Date for the Expected Graduation Term in the most recent Student Program record converted to the YYYY-MM-DD format.

  4. Use default.

  5. Derive as NULL ERROR.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data

ENTRYRTEE

Plan HESA Data

ENTRYRTEE

Sub-Plan HESA

ENTRYRTEE

HESA Instance

ENTRYRTEE

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. Derive from HESA Instance page.

  3. If Instance.COURSEID is based on a sub-plan, derive value from the Sub-Plan HESA page.

  4. Derive value from Plan HESA Data page.

  5. Derive value from Program HESA Data page.

  6. Use default.

  7. Derive as NULL ERROR.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Person HESA Data

ETHNICS

Ethnicity (Campus Community > Personal Information (Student) > Biographical (Student) > Personal Attributes > Ethnicity)

Regulatory Region, Ethnic Group

Ethnicity (Records and Enrollment > HESA Reporting > Codes and Mappings > Code Mappings > Ethnicity)

HESA Ethnicity

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from the Person HESA Data page.

  2. Select Person Ethnicity records as follows:

    • If a single record exists, use that record.

    • If multiple records exist and one is marked as Primary on the Campus Community Ethnicity page, use that record.

    • If multiple records exist and none are marked as Primary, select the record with the highest Percentage defined in the Ethnicity Detail page.

    • If multiple records are indistinguishable, select the lowest alphabetic Ethnic Group code.

    For the selected record, use the HESA Ethnic code from the mapping between the Ethnic Group, Regulatory Region, and the HESA Ethnic code. If no mapping exists, log an error message and skip to next step.

  3. Use default.

  4. Derive as null.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Names (Campus Community > Personal Information (Student) > Add/Update a Person > Biographical Details > Names)

First Name

Middle Name

Note: The First Name page element can accept a maximum of 30 characters.

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Use the First Name and Middle Name values from the Primary Name record.

  2. Derive as NULL ERROR.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data

FUNDCODE

Plan HESA Data

FUNDCODE

Sub-Plan HESA

FUNDCODE

HESA Instance

FUNDCODE

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Use constant.

  2. Derive from the HESA Instance page.

  3. If Student.COURSEID is based on a subplan, derive from the Sub-Plan HESA page.

  4. Derive from the Plan HESA Data page.

  5. Derive from the Program HESA Data page.

  6. Use default.

  7. Derive as NULL ERROR.

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.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Entry Profile

INDSLFCRT

Field Derivation Rule: If Student.COMDATE is in the current reporting period, derive a value. Otherwise, derive as NULL ERROR.

Derivation Step:

  1. Derive from the Entry Profile page.

  2. Use default.

  3. Derive as NULL ERROR.

The system always returns a value, because the inclusion condition is always met and while selecting students for the extract, the system considers only those students for whom COMDATE is between reporting period start and end dates.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data (Program Instance HESA Data)

INITIATIVES-ITT, INITIATIVES-ITT2

Plan HESA Data (Plan Instance HESA Data)

INITIATIVES-ITT, INITIATIVES-ITT2

Sub-Plan HESA (Sub-plan Instance HESA Data)

INITIATIVES-ITT, INITIATIVES-ITT2

HESA Instance

INITIATIVES-ITT, INITIATIVES-ITT2

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Derive from the HESA Instance page.

  2. If Instance.COURSEID is based on a subplan, derive from the Sub-Plan HESA page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Do not derive a value and leave the field blank.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data

ITTAIM

Plan HESA Data

ITTAIM

Sub-Plan HESA

ITTAIM

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Use constant.

  2. If subplan is being reported, derive from the Sub-Plan HESA page.

  3. Derive from the Plan HESA Data page.

  4. Derive from the Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

HESA Instance

ITTCOMDATE

Note: This field is included as TRAINEESTARTDATE in the XML file.

Field Derivation Rule: Include for all students.

Derivation Steps:

  1. Derive from the HESA Instance page.

  2. Derive as null.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program Offering/Year HESA

MODE (Program Year HESA Data group box)

Plan Offering/Year HESA

MODE (Plan Year HESA Data group box)

Sub-Plan Offering/Year HESA

MODE (Sub-Plan Year Data group box)

Student Program

Program Action

Action Reason

Student Program

Acad Load

HESA Instance

MODE

Mode of Study (Records and Enrollment > HESA Reporting > Codes and Mappings > Code Mappings > Mode of Study)

HESA Mode of Study

HESA Action Reasons

Change of Mode Mapping

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from the HESA Instance page.

  2. Select the most recent effective dated record in the Student Program that has an effective date on or before the reporting period end date and a Program Action and Reason mapped to a HESA MODE value as part of the Change of Mode Mapping in HESA Return Setup.

    Convert the mapped HESA mode value:

    • If the value is 01, 12, 13, 14, 23, 24, 25, 43, 65, 66, 67, 68 or 69, derive 01 (full-time).

    • If the value is 02, derive 02 (other full-time).

    • If the value is 31, 32, 33, 34, 35, 36, 37, 38, 39 or 44, derive 31 (part-time).

    • If the value is 63 or 73, derive 63 (dormant – previously full-time).

    • If the value is 64 or 74, derive 64 (dormant – previous part-time).

  3. Map the Academic Load for the most recent effective dated record in the Student Program that has an effective date on or before the reporting period end date to a HESA MODE value using the HESA Mode of Study mapping.

    • If the value is 01, 12, 13, 14, 23, 24, 25, 43, 65, 66, 67, 68 or 69, derive 01 (full-time).

    • If the value is 02, derive 02 (other full-time).

    • If the value is 31, 32, 33, 34, 35, 36, 37, 38, 39 or 44, derive 31 (part-time).

    • If the value is 63 or 73, derive 63 (dormant – previously full-time).

    • If the value is 64 or 74, derive 64 (dormant – previous part-time).

  4. Derive as NULL ERROR.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Person HESA Data

NATION

Citizenship and Passport (Campus Community , Personal Information (Student), Identification (Student), Citizenship, Citizenship and Passport)

Country

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Derive from the Person HESA Data page.

  2. Select person citizenship records and retrieve the related two-character code (COUNTRY_2CHAR) from the Country table (PS_COUNTRY_TBL).

    If a single record exists, derive the Campus Solutions country code.

  3. If multiple person citizenship records are found and a record has a value of GB, derive as GB.

  4. If multiple records are found, and none have the GB country value but a minimum one record has a country value that is marked as European Union (EU) country then derive the EU country. If there are multiple EU countries report the one with the lowest alphabetic HESA code. Note that the PS_COUNTRY_TBL contains an indicator (EU_MEMBER_STATE) to specify if the country is a member of the EU.

  5. If multiple records are found and none have the UK or EU value, select the lowest alphabetic code

  6. Use default.

  7. Derive as NULL.

In most cases, you can use the Campus Solutions two-character country code to report the NATION value. However, some Campus Solutions country codes are not valid for HESA reporting. For example, the Campus Solutions Cyprus code (CY) cannot be reported. Cyprus has to be reported as XA, XB, or XC. In these cases, you must use the Nationality code mapping page to ensure the correct NATION values are reported to HESA.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

External System ID

External System ID

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Determine from the External System ID records for the person with the External ID Type defined for NIN in the HESA Types page.

  2. Do not derive a value and leave the field blank.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Electronic Addresses

Email Address (preferred)

Field Derivation Rule: Include for all students.

Derivation Steps:

  1. Derive from preferred email address defined for the student if the email type is defined in Email Types in HESA Returns Setup.

  2. Derive from a non-preferred email address if the email type is defined in Email Types in HESA Returns Setup. If there's more than one record, the record with the lowest alpha type is derived.

  3. Derive as NULL ERROR.

Return: ITT

Entity: Student

Pages Used: None

Field Derivation Rule: Include for all Student entities.

Derivation Step:

1. Derive as EMPLID.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data (Program Instance HESA Data)

PGAPPSTDT

Plan HESA Data (Plan Instance HESA Data)

PGAPPSTDT

Sub-Plan HESA Data (Sub-plan Instance HESA Data)

PGAPPSTDT

HESA Instance Data

PGAPPSTDT

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Use the value from HESA Instance Data.

  2. If COURSEID is based on a sub-plan, use the value from Sub-Plan Instance HESA Data.

  3. Derive the value from Plan Instance HESA Data.

  4. Derive the value from Program Instance HESA Data

  5. Use the default value.

  6. Derive as null.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Names (Campus Community, Personal Information (Student), Add/Update a Person, Biographical Details, Names)

Surname

Field Derivation Rule: If the student has at least one Instance with REDUCEDI = 00, 01, or 04 derive a value. Otherwise, do not derive a value and leave the field blank.

Derivation Steps:

  1. Derive the previous Last Name from the Primary Name Type History table. This is done by finding the most recent end dated record in which last name is different from the current one.

  2. Do not derive a value and leave the field blank.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Program HESA Data

QLAIM

Plan HESA Data

QLAIM

Sub-Plan HESA

QLAIM

Field Derivation Rule: Derive a value if Student.ITTAIM = 202.

Derivation Steps:

  1. Use constant.

  2. If a sub-plan is reported, derive value from Sub-Plan HESA page.

  3. Derive value from Plan HESA Data page.

  4. Derive value from Program HESA Data page.

  5. Use default.

  6. Derive as NULL ERROR.

Return: ITT

Entity: Course Subject

Pages Used:

Page

Page Element

Program HESA Data — HECoS Subjects

Subject

ITT Subject

Plan HESA Data — HECoS Subjects

Subject

ITT Subject

Sub-Plan HESA — HECoS Subjects

Subject

ITT Subject

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. If the Course ID is derived from a Sub-Plan and at least one HECoS Subject is defined in Sub-Plan HESA Data with ITT Subject selected, records with ITT Subject selected are used to derive SBJCA, SBJCA2 and SBJCA3.

  2. If at least one HECoS Subject is defined in Plan HESA Data with ITT Subject selected, records with ITT Subject selected are used to derive SBJCA, SBJCA2 and SBJCA3.

  3. If at least one HECoS Subject is defined in Program HESA Data with ITT Subject selected, records with ITT Subject selected are used to derive SBJCA, SBJCA2 and SBJCA3.

  4. Use default for SBJCA, SBJCA2, SBJCA3.

  5. Derive SBJCA as NULL ERROR.

    Derive SBJCA2 and SBJCA3 as null.

For steps 2, 3, or 4, the process:

  • Chooses the records that have the ITT Subject check box selected.

  • Determines the main subject by choosing the record with the greatest percentage, if multiple records have the ITT Subject check box selected.

  • Determines the main subject by choosing the first record in the alphabetical code order, if multiple records have the ITT Subject check box selected and have the same percentage.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data (Program Instance HESA Data)

SDEMPLOY

Plan HESA Data (Plan Instance HESA Data)

SDEMPLOY

Sub-Plan HESA Data (Sub-plan Instance HESA Data)

SDEMPLOY

HESA Instance Data

SDEMPLOY

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. Derive from HESA Instance Data.

  3. If COURSEID is based on a sub-plan, derive from Sub-Plan Instance HESA Data.

  4. Derive from Plan Instance HESA Data.

  5. Derive from Program Instance HESA Data.

  6. Use default.

  7. If ENTRYRTEE is 03, derive as NULL ERROR.

  8. Derive as null.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data (Program Instance HESA Data)

SDLEAD

Plan HESA Data (Plan Instance HESA Data)

SDLEAD

Sub-Plan HESA Data (Sub-plan Instance HESA Data)

SDLEAD

HESA Instance Data

SDLEAD

Field Derivation Rule: Include for all entities

Derivation Steps:

  1. Use constant.

  2. Derive from HESA Instance Data.

  3. If COURSEID is based on a sub-plan, derive from Sub-Plan Instance HESA Data.

  4. Derive from Plan Instance HESA Data.

  5. Derive from Program Instance HESA Data.

  6. Use default.

  7. Derive as NULL ERROR.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Biographical Details (Campus Community , Personal Information (Student), Add/Update a Person, Biographical Details)

Gender

Gender (Records and Enrollment, HESA Reporting, Codes and Mappings, Code Mappings, Gender)

HESA Sex Identifier

Campus Community, Personal Information, Add/ Update a Person, HESA Student Data

Campus Community, Personal Information, Add/Update a Person, HESA Restricted Data

SEXIDS

Field Derivation Rule: Include for all entities.

Derivation Step:

  1. Derive from Person HESA Data.

  2. Select the Gender value from the Biographical History record. Derive as the mapped HESA value for the selected Gender value.

  3. If no mapping is found, then derive as

    • If the gender value is Male, derive as 11.

    • If the gender value is Female, derive as 10.

  4. Use default.

  5. Derive as NULL ERROR.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data

STUACCID

Plan HESA Data

STUACCID

Sub-Plan HESA Data

STUACCID

HESA Instance

STUACCID

Note: This field is included as ITTPHSC in the XML file.

Field Derivation Rule: Include for all entities

Derivation Step:

  1. Derive from HESA Instance Data.

  2. Derive from Sub-Plan HESA Data.

  3. Derive from Plan HESA Data.

  4. Derive from Program HESA Data.

  5. Derive as NULL ERROR.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

Names (Campus Community, Personal Information (Student), Add/Update a Person, Biographical Details, Names)

Last Name

Note: The Last Name page element can accept a maximum of thirty characters.

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Use the Last Name value from the Primary Name record.

  2. Derive as NULL ERROR.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

External System ID

External System ID

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Select External System ID records for the person with the External ID Type defined for TREFNO in the HESA Types page.

  2. Use default.

  3. Do not derive a value and leave the field blank.

Return: ITT

Entity: Student

Pages Used:

Page

Page Element

Program HESA Data

TTCIDC

Plan HESA Data

TTCIDC

Sub-Plan HESA

TTCIDC

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from the Sub-Plan HESA page.

  2. Derive from the Plan HESA Data page.

  3. Derive from the Program HESA Data page.

Return: ITT

Entity: Student

Page Used:

Page

Page Element

HESA Instance

Year of Program

Field Derivation Rule: Include for all Student entities.

Derivation Steps:

  1. Derive from the HESA Instance page.

  2. Use default.

  3. Derive as NULL ERROR.