Degree

Since only one Degree entity is created per student, for the purposes of updating existing records, each entity can be uniquely identified by Institution and SID.

There's no delete processing for this entity.

Fields

For each Degree field extract record for the return where the Derived Value isn't null, the record is compared with the corresponding submitted data record.

• If the Derived Value of the field is NULL ERROR, the Field Status remains as Error.

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

Otherwise, the field exists in submitted data.

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

• The Field Status is set to Unchanged.

Entities

For each Degree 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, the Entity Status remains as Error.

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

Otherwise, the record already exists in submitted data.

• If there are one or more Field extract records with Field Status of New or Amended:

  • Entity Status is set to Amended.

  • The Degree ID field in the extract record is updated with the value from submitted data, if the value in submitted data isn't blank.

• If there aren't any Field extract records with Field Status of New or Amended:

  • Entity Status is set to Unchanged.

  • The Degree ID field in the extract record is updated with the value from submitted data, if the value in submitted data isn't blank.