Student Record Return: Learner Employment Status Entity
For each Instance entity, the Create Extract process creates Learner Employment Status entities when all of the following conditions are met:
Country = England
You have selected the Include FE check box on the HESA Returns page
Instance.FESTUMK = 1, 3 or 4 AND Instance.REDUCEDI = 00 or 01 AND Instance.FUNDMODEL is between 25 and 99 inclusive
The Learner Employment Status entities are created based on Employment Status records defined on the Further Education page, starting with the record with the lowest Record Number value. There is no limit on the number of entities. If records are not defined on the page, then the process does not create the entities.
Return: Student Record
Entity: Learner Employment Status
Page Used:
Page |
Page Element |
---|---|
Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education) |
Status Date |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
1. Derive from the Further Education page, converted to YYYY-MM-DD format.
Return: Student Record
Entity: Learner Employment Status
Page Used:
Page |
Page Element |
---|---|
Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education) |
Employer ID |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
Derive from the Further Education page.
Derive as NULL ERROR if one of the following conditions is met:
Instance.PROGTYPE = 02, 03, 20, 21, 22, 23, or 25
Instance.FUNDMODEL = 70 or 99
Do not derive a value and leave the field blank.
Return: Student Record
Entity: Learner Employment Status
Page Used:
Page |
Page Element |
---|---|
Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education) |
Employment Status |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
1. Derive from the Further Education page.
Return: Student Record
Entity: Learner Employment Status
Page Used:
Page |
Page Element |
---|---|
Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education) |
Agreement ID |
Field Derivation Rule: Derive a value if all conditions are met:
Instance.FUNDMODEL = 36
A LearningDeliveryFAM entity exists for the Instance with LEARNDELFAMTYPE = ACT and LEARNDELFAMCODE = 1
Derivation Steps:
Derive from the Further Education page.
Derive as NULL ERROR.
Return: Student Record
Entity: Learner Employment Status
Page Used:
Page |
Page Element |
---|---|
Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education) |
Workplace Postcode |
Field Derivation Rule: Include for all Instance entities.
Derivation Steps:
Derive from the Further Education page.
Formatting: If the value is more than four continuous characters, add a space before the final three characters of the postcode.
If Instance.PROGTYPE = 02, 03, 10, 20 or 21 or Instance.FUNDMODEL = 45, do not derive a value, leave the field blank and set Reason For Null = 1.
Do not derive a value and leave the field blank.