Off Venue Activity

Child Entities: None

Each entity is uniquely identified by Off Venue Activity ID that is derived as Student Course Session ID + Sequence Number defaulting to 1 for the first entity and incremented for subsequent entities.

Fields

For each Off Venue Activity 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, SID, NUMHUS,SC Session ID, Activity ID and Field doesn't exist in the submitted data record, 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 Off Venue Activity 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, NUMHUS, SC Session ID and Activity ID doesn't exist in the submitted data record, 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 child fields extract or all the fields have Field Status of Unchanged.