Student

Parent Entity: None

Each entity is uniquely identified by Student Identifier (SID).

Fields

For each Student 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, 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.

• FIeld Status is set to Unchanged.

Entities

For each Student 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 most recent submitted data record, Entity Status is set to New and Trainee 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.

  • Trainee ID in the extract record is updated with the value from submitted data, if the field 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.

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

Since placements and degrees can be sent via the API without the student/trainee, the status of the Student entity isn't updated based on the child placement and degree entities.