Data Futures Return: Entry Profile Entity

The selection is similar to the Student return.

For each Engagement entity in the extract, a single Entry Profile entity is created if either the Engagement.ENGSTARTDATE value is within the reporting period, or the Entry Profile check box in HESA Instance is selected.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

ACCESSPRG

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = Scotland

  • Engagement.HIGHESTQOE = X0000 or X0001

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11 or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

APELCRD

Program HESA Data

APELCRD

Plan HESA Data

APELCRD

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = England

  • EntryProfile.CRDPTSTU is not null

Derivation Steps:

  1. Derive from the HESA Instance Data — Entry Profile.

  2. Derive from Plan HESA Data.

  3. Derive from Program HESA Data.

  4. Use default.

  5. Derive as null.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

CARELEAVERE

Field Derivation Rule: Derive a value if one of the following sets of conditions is met:

  • Country = England

    • EntryProfile. PERMADDCOUNTRY = = XF, XG, XH, XI, XK, XL, GG, JE or IM

    • Qualification.QUALCAT starts with H, I, J or C or is M0002, M0016, M0018 excluding H0009 and H0010

    • Engagement INCOMINGEXCHANGE is null

    • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

  • Country = Northern Ireland

    • EntryProfile. PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

    • Qualification.QUALCAT starts with H, I, J or C or is M0002, M0016, M0018

    • Engagement ENGSTARTDATE is after 2013-07-31

  • Country = Scotland

    • EntryProfile. PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

    • Engagement INCOMINGEXCHANGE is null

    • Engagement ENGSTARTDATE is after 2013-07-31

If the Country is England and the Engagement is subsequently flagged as dormant, update derived value to null and set the derivation step to zero.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

CRDPTSTU

Program HESA Data

CRDPTSTU

Plan HESA Data

CRDPTSTU

Field Derivation Rule: Derive a value if Country = England.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Derive from Plan HESA Data.

  3. Derive from Program HESA Data.

  4. Use default.

  5. Derive as null.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

CRDSCM

Program HESA Data

CRDSCM

Plan HESA Data

CRDSCM

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = England

  • EntryProfile.CRDPTSTU is not null

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Derive from Plan HESA Data.

  3. Derive from Program HESA Data.

  4. Use default.

  5. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

DEPENDANT

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = Northern Island

  • EntryProfile.PERMADDCOUNTRY = XG

  • Engagement.INCOMINGEXCHANGE is null

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

ENTPRODEP

Field Derivation Rule: Derive a value if these conditions are met:

  • Country = Northern Ireland

  • EntryProfile.PERMADDCOUNTRY = XG

  • Engagement.INCOMINGEXCHANGE is null

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

ESTRANGED

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = Scotland

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

  • Qualification.QUALCAT with H, I, J or C or is M0002

  • Engagement ENGSTARTDATE is after 2020-07-31

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

  • A related CourseInitiative.COURSEINITID is not 027.

  • There are no StudentInitiative entities for the Engagement in the extract with STUINITID of 027 or 030.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

HIGHESTQOE

Field Derivation Rule: Derive a value if these conditions are met:

  • Engagement.INCOMINGEXCHANGE is null.

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

  • A related CourseInitiative.COURSEINITID is not 027.

  • There are no StudentInitiative entities for the Engagement in the extract with STUINITID of 027 or 030.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

Personal Information (Student) > Add/Update a Person > Biographical Information > Biographical History

Marital Status

HESA Instance Data — Entry Profile

MARSTATE

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = Northern Ireland

  • EntryProfile.PERMADDCOUNTRY = XG (Northern Ireland)

  • Engagement.INCOMINGEXCHANGE is null

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Derive the Marital Status value from the most recent effective-dated active Biographical History record that falls within the reporting period end date. This is mapped to a HESA code using the HESA Marital Status mapping for the institution.

  3. Use default.

  4. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

PAREDE

Field Derivation Rule: Derive a value if any of the following sets of conditions is met:

  • Country = England

    • EntryProfile. PERMADDCOUNTRY = = XF, XG, XH, XI, XK, XL, GG, JE or IM

    • Qualification.QUALCAT starts with H, I, J or C or is M0002, M0016, M0018 excluding H0009 and H0010

    • Engagement INCOMINGEXCHANGE is null

    • The most recent Session Status entity (based on STATUSVALIDFROM date) for the current Student Course Session does not have STATUSCHANGED = 02 (dormant) and a STATUSVALIDFROM on or before the StudentCourseSession.SCSSTARTDATE

    • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12

  • Country = Northern Ireland

    • EntryProfile.PERMADDCOUNTRY = = XF, XG, XH, XI, XK, XL, GG, JE or IM

    • Engagement ENGSTARTDATE is after 2013-07-31

    • Qualification.QUALCAT starts with H, I, J, or C, or is M0002, M0016 or M0018

  • Country = Scotland

    • EntryProfile.PERMADDCOUNTRY = = XF, XG, XH, XI, XK, XL, GG, JE or IM

    • Qualification. QUALCAT = M0002, H0003, H0004, H0005, I0001, J0000, J0001, J0002, J0003, C0000 or C0001

    • StudentCourseSession INTERCALATION is not 01

    • Engagement INCOMINGEXCHANGE is null

    • Engagement ENGSTARTDATE is after 2007-07-31

    • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12

    • A related CourseInitiative.COURSEINITID is not 027

    • There are no StudentInitiative entities for the Engagement in the extract with STUINITID of 027 or 030

If the Country is England and the Engagement is subsequently flagged as dormant, update derived value to null and set the derivation step to zero.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

Personal Information (Student) > Biographical (Student) > Addresses/Phones > Addresses

Country

Returns Setup > HESA Types

Address Types

HESA Instance Data — Entry Profile

PERMADDCOUNTRY

Residency Self-Report (Campus Community > Personal Information (Student) > Identification (Student) > Residency Data > Residency Self-Report)

Residency Self-Report—State and Country

Field Derivation Rule: Derive a value if Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Derive the Residency Self-Report record with the latest Date Reported prior to COMDATE. If no record is found then select the record with the earliest Date Reported date on or after ENGSTARTDATE.

    If a record is found and the Country value is not GBR and is mapped to a HESA Domicile in the HESA Nationality mapping, derive that value. Otherwise, derive the two-character code (COUNTRY_2CHAR) from the Country table (COUNTRY_TBL).

  3. Derive the associated HESA Code (e.g. XF, XG, XH, XI) from the UCAS APR Mapping if a Residency Self-Report record is found with Country of GBR and State is defined. If no mapping is found, derive XK.

  4. Derive XK if a Residency Self-Report record is found with Country of GBR and State isn't defined.

  5. Derive the Country Code from the most recent active effective-dated address record prior to ENGSTARTDATE, and has an Address Type that corresponds with those defined for PERMADDCOUNTRY in Address Types in HESA Returns Setup. If no record is found prior to ENGSTARTDATE, the record with the earliest effective date on or after ENGSTARTDATE with a defined Address Type is selected. If multiple valid addresses are found with the same effective date (for example, when multiple address types are defined), then one will be randomly picked.

    The two-character Country Code is derived from the Country table with the exception of GBR where XK (United Kingdom, not otherwise specified) is derived rather than GB which is the ISO two-character code for UK, but is not included in the HESA code set.

  6. Use default.

  7. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

Personal Information (Student) > Biographical (Student) > Addresses/Phones > Addresses

Postal Code

Returns Setup > HESA Types

Address Types

HESA Instance Data — Entry Profile

PERMADDPOSTCODE

Field Derivation Rule: Derive a value if these conditions are met:

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Select the postal code from the most recent effective-dated address record prior to ENGSTARTDATE that has an address type defined for PERMADDCOUNTRY in the address types in HESA Returns Setup. If no record is found prior to ENGSTARTDATE, the record with the earliest effective date on or after ENGSTARTDATE with a defined address type is selected. If multiple valid address are found with the same effective date, then one is randomly selected.

    If the derived Postal Code is longer than 8 characters, the step is skipped.

  3. Use default.

  4. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

Entry Profile

PREVIOUSPROVIDER

Field Derivation Rule: Derive a value if all conditions are met:

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

  • StudentCourseSession INTERCALATION is not 01

  • Engagement.INCOMINGEXCHANGE is null

  • Qualification QUALCAT = M0002, H0003, H0004, H0005, I0001, I0007, J0000, J0001, J0002, J0003, C0000 or C0001

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

  • A related CourseInitiative.COURSEINITID is not 027.

  • There are no StudentInitiative entities for the Engagement in the extract with STUINITID of 027 or 030

Derivation Steps:

  1. Derive from Entry Profile page.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

Person HESA Data

RELIGIOUSBGROUND

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = Northern Ireland

  • EntryProfile.PERMADDCOUNTRY = XG (Northern Ireland)

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from the most recent effective-dated Person HESA Data, where the effective date is on or before the reporting period end date.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

SECE

Field Derivation Rule: Derive a value if all conditions are met:

  • EntryProfile.UCASSCHEMECODE is not null

  • Qualification.QUALCAT = H, I, J or C or is M0002

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

SOC2010

Field Derivation Rule: Derive a value if all conditions are met:

  • Engagement..ENGSTARTDATE is before 2022-08-01

  • EntryProfile.UCASSCHEMECODE is not null

  • Qualification.QUALCAT = H, I, J or C or is M0002

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

HESA Instance Data — Entry Profile

SOC2020

Field Derivation Rule: Derive a value if all conditions are met:

  • EntryProfile.UCASSCHEMECODE is not null

  • Qualification.QUALCAT = H, I, J or C or is M0002

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE or IM

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from HESA Instance Data — Entry Profile.

  2. Use default.

  3. If SOC2010 exists and has a derived value, derive as null.

  4. Derive as NULL ERROR.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

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

External Application Number

Entry Profile

UCASSCHEMECODE

Field Derivation Rule: Derive a value if any one of these conditions is met:

  • Country is England or Northern Ireland

  • Country = Scotland and Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND is not 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from Entry Profile page.

  2. Reference the Student Program record for the related Instance with the highest Registration Number to find the admission application number (ADM_APPL_NBR), which is used to reference the Admissions Data record (ADM_APPL_DATA) to find the External Application Number (EXT_ADM_APPL_NBR) that holds the UCAS Application Code plus Choice Number for UCAS applications. To handle change of career between the original UCAS application and the current student program, the matching doesn't consider Career and Career Number.

    If the External Application Number is not null and is a UCAS number, that is, a 4-character application code that begins with ‘UC’ plus ‘-‘ plus a single-digit choice number (for example, UC01-1), then the UCAS value minus the ‘-‘ and choice elements is derived (for example, UC01). Only values beginning with ‘UC’ are derived.

  3. Use default.

  4. Derive as null.

Return: Data Futures

Entity: Entry Profile

Page Used:

Page

Page Element

Entry Profile

YRLPPROV

Field Derivation Rule: Derive a value if all conditions are met:

  • Country = Scotland

  • Student Initiatives entity exists with STUINITID = 016 (Articulation)

  • Leaver.ENGENDDATE is null, or is more than 14 days after Engagement.ENGSTARTDATE, or is less than 15 days after Engagement.ENGSTARTDATE and Leaver.RSNENGEND isn't 03, 05, 11, or 12.

Derivation Steps:

  1. Derive from Entry Profile page.

  2. Use default.

  3. Derive as NULL ERROR.