Data Futures Return: Language Proficiency Entity

For each Student entity in the extract, if all these conditions are met, a single entity is created:

  • Country = Scotland

  • EntryProfile.PERMADDCOUNTRY = XF, XG, XH, XI, XK, XL, GG, JE, or IM. If a value isn't found in the extract, the value is selected from the most recent submitted data record. If there's no value in the submitted data, a value is derived without reference to the field derivation rule.

  • LANGPROFICIENCYID is defined in the most recent effective-dated Person HESA Data, where the effective date is on or before the reporting period end date.

Return: Data Futures

Entity: Language Proficiency

Page Used:

Page

Page Element

Person HESA Data

LANGPROFICIENCYID

Field Derivation Rule: Include for all entities

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

Return: Data Futures

Entity: Language Proficiency

Page Used:

Page

Page Element

Person HESA Data

PROFICIENCYTYPE

Field Derivation Rule: Include for all entities

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.