Language Proficiency

Child Entities: None

Each entity is uniquely identified by Language Identifier that is derived as the language code from Person HESA Data. In cases where entities were previously reported and no longer apply, extract entities are created with Entity Status of Delete.

Fields

For each Language Proficiency field extract record for the return, the record is compared with the corresponding submitted data (MST) record:

  • If the Derived Value of the field is NULL ERROR, set Field Status to Error.

  • If the combination of Institution, SID, Language ID and Field doesn't exist in the submitted data record, set Field Status to New.

  • If the combination exists in the extract record and the Entity Status in the most recent submitted data record is Delete, set Field Status to New.

  • If the Reported Value in the extract is different to the Reported Value in the most recent submitted data record, set Field Status to Amended.

  • Set Field Status to Unchanged, that is, Reported Value in the extract is the same as in the most recent submitted data record.

Entities

For each Language Proficiency entity extract record for the return, the record is compared with the corresponding submitted data (MST) record:

  • If at least one field has Field Status of Error, set Entity Status to Error.

  • If the combination of Institution, SID and Language ID doesn't exist in the submitted data record, set Entity Status to New.

  • If the combination exists in the extract record and the Entity Status in the most recent submitted data record is Delete, set Entity Status to New.

  • If there are one or more child Field extract records with Field Status of New or Amended, set Entity Status to Amended.

  • Set Entity Status to Unchanged, that is, there are no child entities or fields with status New or Amended that need to be reported.

  • For any existing entities in extract where the Language ID for the entity doesn't appear in the submitted data record, create a new entity using the Language ID with Entity Status of Delete. New field extract records for LANGPROFICIENCYID and PROFICIENCYTYPE is created with Field Status of Delete.