Student Record Return: Learning Delivery Work Placement Entity

For each Instance entity, the Create Extract process creates Learning Delivery Work Placement entities when:

  • Country = England

  • Instance.FESTUMK = 1, 3 or 4

  • Instance.REDUCEDI = 00 or 01

  • Instance.COMDATE is on or after 2014-08-01

  • Instance.FUNDMODEL is not 99

  • Include FE check box is selected on the HESA Returns page

Entities are created based on placement records defined in HESA Instance Data, Further Education, Work Placement.

Records are not considered if the end date is earlier than the reporting period start date or the start date is after the reporting period end date.

Return: Student Record

Entity: Learning Delivery Work Placement

Page Used:

Page

Page Element

Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education)

Employer ID (in the Work Placement region)

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from Further Education.

  2. Derive as null.

Return: Student Record

Entity: Learning Delivery Work Placement

Page Used:

Page

Page Element

Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education)

End Date (in the Work Placement region)

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from Further Education, converted to YYYY-MM-DD.

  2. Derive as null.

Return: Student Record

Entity: Learning Delivery Work Placement

Page Used:

Page

Page Element

Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education)

End Date (in the Work Placement region)

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from Further Education, converted to YYYY-MM-DD.

  2. Derive as null.

Return: Student Record

Entity: Learning Delivery Work Placement

Page Used:

Page

Page Element

Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education)

Hours (in the Work Placement region)

Field Derivation Rule: Include for all entities.

Derivation Steps:

  1. Derive from Further Education.

  2. Derive as NULL ERROR.

Return: Student Record

Entity: Learning Delivery Work Placement

Page Used:

Page

Page Element

Further Education (Records and Enrollment, Career and Program Information, HESA Instance Details, Further Education)

Start Date (in the Work Placement region)

Field Derivation Rule: Include for all entities.

Derivation Steps: Derive from Further Education, converted to YYYY-MM-DD.