Course Initiative

Child Entities: None

Each entity is uniquely identified by Initiative ID. Although Valid From is part of the key, this is not used in the comparison. The check is to determine whether or not the Initiative ID has already been reported. In cases where entities were previously reported and one or more no longer apply, extract entities are created with Entity Status of Amended and Valid To populated.

Fields

For each Course Initiative 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 Course ID, Initiative 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 from 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 Course Initiative entity extract record for the return, the record is compared with the corresponding submitted data (MST) record:

  • If the combination of Course ID, and Initiative ID doesn't exist in the submitted data record, set Entity Status to New.

  • Set Entity Status and Field Status to Unchanged, that is, the Initiative ID already exists in extract.

  • For any existing entities in extract where the Initiative ID for the entity doesn't appear in the submitted data record and Valid To is blank, create a new entity in the extract using the Initiative ID with Entity Status of Amended.

    New field extract records are created for COURSEINITID and COURSEVALIDFROM using the values from extract with Field Status of Unchanged. A field extract record is created for COURSEVALIDTO with Derived Value set to the reporting period start date in YYYY-MM-DD format and Field Status of New. If the derived COURSEVALIDTO date is before the COURSEVALIDFROM date, the value is set to the same value as COURSEVALIDFROM. The derivation step is set to 99 for each field.