PG Entry Qualification Subject

Parent Entity: PG Entry Qualification Award

Child Entities: None

The entity only has a single Subject Identifier (SUBJECTID). In cases where multiple entities were previously reported and one or more no longer apply, extract entities are created with Entity Status of Delete.

Fields

For each PG Entry Qualification Subject field extract record for the return, the record is compared with the corresponding submitted data record:

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

  • If the combination of Institution, SID, Degree ID, Subject ID and Field does not exist in the submitted data record, set the Field Status to New.

  • If the combination exists in the submitted data record and the Entity Status in the most recent submitted data record is Delete, set the 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 the Field Status to Amended.

  • Set the 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 PG Entry Qualification Subject entity extract record for the return, the record is compared with the corresponding submitted data record:

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

  • If the combination of Institution, SID, Degree ID and Subject ID does not exist in the submitted data record, set the Entity Status to New.

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

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

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

  • For any existing entities in submitted data where the Subject for the entity does not appear in the extract, a new entity is created in the extract using the Subject with Entity Status of Delete and a new field extract record for the SUBJECTID is created with Field Status of Delete.