DLHE Return: Student Entity
The Create Extract process creates a Student entity for each distinct DLHE survey record.
If at least one survey status has been defined on the HESA Returns page, then the process includes a survey only if the survey has a status value that matches one of the defined statuses. If you have not defined a survey status on the HESA Returns page, then the process includes the survey irrespective of status value. Use the Survey Management component to verify the status of a survey (Records and Enrollment, HESA Reporting, Destination of Leavers, Survey Management).
If you have selected the Null Errors Only check box for the Include Student Entities on the Create Extract Data page, the process selects distinct EMPLIDs from the existing active DLHE extract data, where at least one field in the Student, Employment, Study, or Teaching extract data has a derived value of NULL ERROR. The process then selects the survey records for these EMPLIDs. If a student has more than one survey record, then the process selects all the student's surveys if any of them has any NULL ERROR values.
If you have selected the Student Override check box, the process considers the survey records for only the EMPLIDs you have selected.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Enter DLHE Survey (Section A) self-service |
Q1 – Activities check box 1 |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
If Student.STATUS = 07 or 08, derive as X (ineligible or explicit refusal).
If the check box is selected, derive as 1.
If none of the check boxes has been selected (that is, Student.ALLACT2 to Student.ALLACT8 are all derived as NULL), derive as NULL ERROR.
Do not derive a value and leave the field blank.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Enter DLHE Survey (Section A) self-service |
Q1 – Activities check boxes 2 to 8 |
Field Derivation Rule: Student.STATUS is not 07 or 08.
Derivation Steps:
Derive as follows:
ALLACT2 - Derive as 2 if the check box is selected.
ALLACT3 - If reporting period is 2013/14 or later, derive as 9 if the check box is selected. Otherwise, derive as 3 if the check box is selected.
ALLACT4 - Derive as 4 if the check box is selected.
ALLACT5 - Derive as 5 if the check box is selected.
ALLACT6 - Derive as 6 if the check box is selected.
ALLACT7 - Derive as 7 if the check box is selected.
ALLACT8 - Derive as 8 if the check box is selected.
Do not derive a value and leave the field blank.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Survey Details |
Survey |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
1. Derive from the survey record, either 1 or 2.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Enter DLHE Survey (Section E) self-service |
Q30 |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
If Student.STATUS = 03, 05, 06, 07 or 08, derive as 6 (unable to code).
Derive from the survey record.
If Student.STATUS = 02, derive as 6.
Use default (from HESA Fields page in the HESA returns setup).
Derive as NULL ERROR.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Enter DLHE Survey (Section E) self-service |
Q29 |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
If Student.STATUS = 03, 05, 06, 07 or 08, derive as 6 (unable to code).
Derive from the survey record.
If Student.STATUS = 02, derive as 6.
Use default.
Derive as NULL ERROR.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Enter DLHE Survey (Section E) self-service |
Q28 |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
If Student.STATUS = 03, 05, 06, 07 or 08, derive as 6 (unable to code).
Derive from the survey record.
If Student.STATUS = 02, derive as 6.
Use default.
Derive as NULL ERROR.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Survey Details |
HUSID |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
1. Derive from the survey record.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Enter DLHE Survey (Section A) self-service |
Q1 – Most important option |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
If Student.STATUS = 07 or 08, derive as X (ineligibility or explicit refusal).
If a Most important option has been selected, derive the value from 1 to 8 (depending on which Most important option is selected).
If the reporting period is 2013/14 or later, convert 3 to 9.
Derive as NULL ERROR.
Return: DLHE
Entity: Student
Page Used:
|
Page |
Page Element |
|---|---|
|
Survey Details |
Survey Method |
Field Derivation Rule: Include for all survey records in a DLHE return.
Derivation Steps:
Derive from the survey record.
Use default value (this is derived from the HESA Fields page not from the Survey Status value on the HESA Returns page).
Derive as NULL ERROR.