Data Futures Return: Disability Entity
For each Student entity in the extract, entities are created using either the current value in HESA Person Data or Impairment records if these conditions are met:
-
Student has an Engagement entity in the extract where 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.
Only one of the following steps is used to create entities:
If any of the disability fields (DISABILITY to DISABILITY8) are defined in the most recent effective-dated Person HESA Data where the effective date is on or before the reporting period end date, for each DISABILITY field defined an entity is created with derivation step 1.
-
An entity is created for each Impairment record for the student where the code is mapped to a HESA DISABILITY code with derivation step 2.
-
A single entity is created with DISABILITY derived either from the default value (if defined) with derivation step 3 or as NULL ERROR with derivation step 4. The default value can be defined as 99 (not available).
If all the Engagements for the student are subsequently flagged as dormant, delete the derived entity and associated extract fields.
Return: Data Futures
Entity: Disability
Page Used:
|
Page |
Page Element |
|---|---|
|
Person HESA Data |
DISABILITY, DISABILITY2 to 8 |
|
Personal Information > Health Information > Impairment Regional |
Type of Impairment |
Field Derivation Rule: Include for all entities
Derivation Steps:
Derive value from Person HESA Data.
Derive value as the mapped DISABILITY code for the Impairment record.
Use default.
Derive as NULL ERROR.