Copying Submitted Data Records for Student and Register

The Institution extract record is used to find the most recent effective-dated records that need to be copied. The same logic applies to both Student and ITT/Register but different records are copied.

To copy extract records:

1. Select the most recent effective date and effective sequence from Institution extract for the Institution where Return Type is DFSTDNT or ITT.

2. Find the new effective date as the current date, and the new effective sequence as the highest existing effective sequence for the current date + 1 (or as 1, if the most recent record is for an earlier date).

3. Copy the existing Institution extract record using the new date/sequence from step 2.

4. For each extract entity and field record with return type = DFSTDNT or ITT:

   • Rows for the existing date/sequence selected in step 1 where the Entity or Field Status isn't Delete are copied to new rows using the new effective date/sequence in step 2.

   • The Entity Status and Field Status values for all the new records is initially set to Unchanged.

   Note:

   Any rows for earlier effective dates that have been deleted before the most recent record and any records that were marked as Delete in the most recent record aren't copied to the new record.

If there's no existing Institution extract record for the DFSTDNT or ITT return type, the copy extract step is skipped. This will happen the first time the extract synch process is run.