ISSUE: The Copy Students to Summer School process was run too early. Students need to be deleted from the Summer School and the DPT value need to be reset so the process can be run again.

Environment

  • Summer School


Cause

Used the Copy Students to Summer School process before Summer School Course Requests were completed


Resolution

Delete the students that were copied over to the Summer Schools. 


EXAMPLE:

SELECT * FROM STU
WHERE SC IN ( 100, 101 ) 
AND DEL = 0 

SELECT * INTO STU_backup06052024 FROM STU

UPDATE STU 
SET DEL = 1 
WHERE SC IN ( 100, 101 ) 
AND DEL = 0


Reset the DPT Value

DELETE DPT WHERE NM = 'SummerSchoolInitialized'