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:
Derive from the most recent effective-dated Person HESA Data, where the effective date is on or before the reporting period end date.
Use default.
Derive as null.