Session Status

Child Entities: None

Each entity is uniquely identified by the combination of SC Session ID and Status Valid From date. If the derived value for STATUSVALIDFROM is after the SCSSTARTDATE (that is, the second or subsequent entity), and the Entity Status or Field Status is blank, the Entity Status and Field Status for each non-null field is set to New. Otherwise, the following processing is done:

If there are no existing Session Status entities in submitted data for the Student Course Session (matched on INSTITUTION, SID, NUMHUS, and SC Session ID), then:

• If the Derived Value for STATUSCHANGEDTO is 01 (Active), and the Entity Status or Field Status is blank, the Entity Status and Field Status for each non-null field is set to Unchanged.

  An entity does not need to be reported for Active students that have not previously been reported as dormant/writing up.

• If the Derived Value for STATUSCHANGEDTO is any other value, and the Entity Status or Field Status is blank, the Entity Status and Field Status for each non-null field is set to New.

• If the Derived Value for STATUSVALIDFROM is the same or later than the SCSSTARTDATE, the derived values are not changed.

If there is at least one existing Session Status entity in extract for the Student Course Session, then:

• If the Derived Value for STATUSCHANGEDTO is the same as the reported value in extract for the existing entity with the latest STATUSVALIDFROM date (i.e. the most recently reported previous entity), the Entity Status and Field Status for each non-null field is set to Unchanged.

• If the Derived Value for STATUSCHANGEDTO is different to the reported value in extract for the existing entity with the latest STATUSVALIDFROM date (i.e. the most recently reported previous entity), then:

  • If the Derived Value for STATUSVALIDFROM in the extract is later than the latest reported STATUSVALIDFROM date in extract, in the extract the Entity Status and Field Status for each non-null field is set to New.

    No changes are made to the derived STATUSVALIDFROM date.

  • If the Derived Value for STATUSVALIDFROM in the extract is on or before the most recently reported STATUSVALIDFROM date in extract, the new entity is updated as an amendment to the previously reported entity. The Entity Status and the Field Status for STATUSCHANGEDTO are set to Amended. The Derived Value and Reported Value for STATUSVALIDFROM in the extract are updated to the latest Reported Value for STATUSVALIDFROM from extract along with the key SSR_HE_VALID_FROM. The derivation step is set to 99 and Field Status is set to Unchanged.