Placement

Each Placement entity is uniquely identified by the combination of School URN, Placement Name, and Start Date. In cases where an entity was previously reported for the current reporting period and no longer applies, extract entities are created with Entity Status of Delete.

Fields

For each Placement 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, School URN, Placement Name, Start Date, and Field doesn't exist in the most recent submitted data record, Field Status is set to New.

Otherwise, the field already exists in submitted data.

  • If the Entity Status in the most recent submitted data record is Delete (in other words, previously deleted), Field Status is set to New.

  • If the Reported Value in the extract is different from the Reported Value in the most recent submitted data record (this would only apply to Postcode), Field Status is set to Amended.

  • Field Status is set to Unchanged.

Entities

For each Placement 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, SID, School URN, Placement Name, and Start Date doesn't exist in the submitted data record, Entity Status is set to New and Placement ID is kept blank in the extract record.

Otherwise, the entity already exists in submitted data.

  • If the Entity Status in the most recent submitted data record is Delete (in other words, previously deleted), Entity Status is set to New and Placement ID is kept blank in the extract record.

  • If there are one or more Field extract records with Field Status of New or Amended, Entity Status is set to Amended and Placement ID in the extract record is updated with the value from submitted data—if the value in submitted data isn't blank.

  • If there are no Field extract records with Field Status of New or Amended, Entity Status is set to Unchanged and Placement ID in the extract record is updated with the value from submitted data—if the value in submitted data isn't blank

Obsolete entities are deleted. A check is done on Start Date to prevent the deletion of records from previous reporting periods.

For any existing entities in submitted data where the School URN, Placement Name, and Start Date for the entity doesn't appear in the extract data and the Start Date is in the reporting period:

  • A new entity is created in the extract with Entity Status of Delete and Placement ID set to the value from the submitted data record.

  • A new field extract field record is created for School URN and Placement Name with Field Status of Delete.

Because School URN and Placement Name are part of the key, only updates to Postcode value will trigger an Entity Status of Amended. Postcode isn't included for Delete extract entities.