08-OCT-2021 SOU DEVL 07/07/2021 PAGE: 1 ***BEFORE*** REASSIGN ADVISOR ***BEFORE*** FROM 940999999 Babbitt, Troy TO 940999999 Rice, Michael EFF TERM: 202101 MIN REG TERM: 202001 EFFECTIVE ADVISEE ID NAME TERM ADVISOR ID NAME ADVR STVADVR_DESC P ---------- ------------------------- --------- ---------- ------------------------- ---- ------------------------------ - 940999999 Brodie, Danielle 202001 940999999 Babbitt, Troy SEM Seminar Advisor Y 940999999 940999999 Williams, Robin SSC SSC Advisor N 940999999 Burton, Gabriella 202003 940999999 Babbitt, Troy SEM Seminar Advisor Y 940999999 940999999 Griess, Leandra SSC SSC Advisor N 940999999 Decker, Cameron 202001 940999999 Babbitt, Troy SEM Seminar Advisor Y 940999999 940999999 Derr, Edward SSC SSC Advisor N 940999999 McCall, Parker 202001 940999999 Babbitt, Troy SEM Seminar Advisor Y 940999999 940999999 Lucas, Robert MJR Major Advisor N 940999999 Ramsey, Earl 202001 940999999 Babbitt, Troy SEM Seminar Advisor Y 940999999 Weagel, Aaron 202001 940999999 Babbitt, Troy SEM Seminar Advisor Y 940999999 940999999 Williams, Robin SSC SSC Advisor N ---------- ************************* ********* 11 adv_reassign_advisor.sql 08-OCT-2021 SOU DEVL 07/07/2021 PAGE: 1 ***AFTER*** REASSIGN ADVISOR ***AFTER*** FROM 940999999 Babbitt, Troy TO 940999999 Rice, Michael EFF TERM: 202101 MIN REG TERM: 202001 EFFECTIVE ADVISEE ID NAME TERM ADVISOR ID NAME ADVR STVADVR_DESC P ---------- ------------------------- --------- ---------- ------------------------- ---- ------------------------------ - 940999999 Brodie, Danielle 202101 940999999 Rice, Michael SEM Seminar Advisor Y 940999999 940999999 Williams, Robin SSC SSC Advisor N 940999999 Burton, Gabriella 202101 940999999 Griess, Leandra SSC SSC Advisor N 940999999 940999999 Rice, Michael SEM Seminar Advisor Y 940999999 Decker, Cameron 202101 940999999 Derr, Edward SSC SSC Advisor N 940999999 940999999 Rice, Michael SEM Seminar Advisor Y 940999999 McCall, Parker 202101 940999999 Lucas, Robert MJR Major Advisor N 940999999 940999999 Rice, Michael SEM Seminar Advisor Y 940999999 Ramsey, Earl 202101 940999999 Rice, Michael SEM Seminar Advisor Y 940999999 Weagel, Aaron 202101 940999999 Rice, Michael SEM Seminar Advisor Y 940999999 940999999 Williams, Robin SSC SSC Advisor N ---------- ************************* ********* 11 adv_reassign_advisor.sql 08-OCT-2021 SOU DEVL 07/07/2021 PAGE: 1 STUDENTS WHOSE ADVISORS WERE ENDED FROM 940999999 Babbitt, Troy TO 940999999 Rice, Michael EFF TERM: 202101 MIN REG TERM: 202001 MOST RECENT MOST RECENT OLD ADVISOR ADVISING NAME ID REG TERM STUDENT REC EMPL STATUS END TERM ------------------------------ --------- ----------- ----------- ----------- -------- Gaylord, Christopher 940999999 201902 201902 Terminated 202101 Goyt, Madelyn 940999999 201902 201902 Terminated 202101 Graciano, Nelson 940999999 201903 201903 Terminated 202101 Truex, Tattum 940999999 201902 201902 Terminated 202101 Waechtler, Mya 940999999 201903 201903 Terminated 202101 adv_reassign_advisor.sql