Qualification Subject

Child Entities: None

Each entity is uniquely identified by the HECOS subject code. In cases where multiple entities were previously reported and one or more no longer apply, extract entities are created with Entity Status of Delete.

Field

For each Qualification Subject field extract record for the return with a Derived Value, 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, Qualification ID, Subject 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. Proportion may be set to Amended if the subject has previously been reported but the proportion has changed.

  • If the field is QUALITT and the Reported Value in the extract is not null and any of the other fields for the entity (i.e. QUALPROPORTION) have been set to a Field Status of Amended, set Field Status to Amended. This condition is included to ensure values for QUALITT are always included in the XML when the Proportion has changed.

  • 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 Qualification Subject 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, Qualification ID and Subject 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 Field extract records with Field Status of New or Amended, set Entity Status to Amended.

  • Set Entity Status to Unchanged, that is, either there are no fields or all the fields have Field Status of Unchanged.

  • For any existing entities in extract where the subject for the entity doesn't appear in the submitted data record, create a new entity using Subject with Entity Status of Delete. Create a new field extract record QUALSUBJECT with Field Status of Delete.