09-OCT-2021 SOU DEVL 07/07/2021 PAGE: 1 ***BEFORE*** REASSIGN ADVISOR ***BEFORE*** FROM 940999999 Waterton, Nigel TO 940999999 Derr, Edward EFF TERM: 202101 MIN REG TERM: 000000 EFFECTIVE ADVISEE ID NAME TERM ADVISOR ID NAME ADVR STVADVR_DESC P ---------- ------------------------- --------- ---------- ------------------------- ---- ------------------------------ - 940999999 Armenta, Emily 202003 940999999 Hocevar, Kristin MJR Major Advisor Y 940999999 940999999 Waterton, Nigel MNR Minor Advisor N 940999999 Bartlett, Eva 202002 940999999 Boudreau, Theresa MJR Major Advisor Y 940999999 940999999 Griess, Leandra SSC SSC Advisor N 940999999 940999999 Waterton, Nigel MNR Minor Advisor N 940999999 Chamberlin, Wyatt 202004 940999999 Eaton, Samantha SAS Success at Southern Advisor N 940999999 940999999 Elson, Adam MNR Minor Advisor N 940999999 940999999 Smith, Vincent MJR Major Advisor Y 940999999 940999999 Waterton, Nigel MNR Minor Advisor N 940999999 Defazio, Marissa 202002 940999999 Smith, Vincent MJR Major Advisor Y 940999999 940999999 Waterton, Nigel MNR Minor Advisor N 940999999 Heard, Mallory 202003 940999999 Slattery, Dennis MJR Major Advisor Y 940999999 940999999 Waterton, Nigel MNR Minor Advisor N 940999999 McCord, Isabella 202003 940999999 Lyon, Cherstin HNRC Honors College Advisor N 940999999 940999999 Waterton, Nigel MNR Minor Advisor N 940999999 940999999 Yamaguchi, Precious MJR Major Advisor Y 940999999 Pomeroy, Toni 202003 940999999 McGrady, Pavlina MJR Major Advisor Y 940999999 940999999 Waterton, Nigel MNR Minor Advisor N ---------- ************************* ********* 18 adv_reassign_advisor.sql 09-OCT-2021 SOU DEVL 07/07/2021 PAGE: 1 ***AFTER*** REASSIGN ADVISOR ***AFTER*** FROM 940999999 Waterton, Nigel TO 940999999 Derr, Edward EFF TERM: 202101 MIN REG TERM: 000000 EFFECTIVE ADVISEE ID NAME TERM ADVISOR ID NAME ADVR STVADVR_DESC P ---------- ------------------------- --------- ---------- ------------------------- ---- ------------------------------ - 940999999 Armenta, Emily 202101 940999999 Derr, Edward MNR Minor Advisor N 940463359 940999999 Hocevar, Kristin MJR Major Advisor Y 940999999 Bartlett, Eva 202101 940999999 Boudreau, Theresa MJR Major Advisor Y 940999999 940999999 Derr, Edward MNR Minor Advisor N 94999999 940999999 Griess, Leandra SSC SSC Advisor N 940999999 Chamberlin, Wyatt 202101 940999999 Derr, Edward MNR Minor Advisor N 940999999 940999999 Eaton, Samantha SAS Success at Southern Advisor N 940999999 940999999 Elson, Adam MNR Minor Advisor N 940999999 940999999 Smith, Vincent MJR Major Advisor Y 940999999 Defazio, Marissa 202101 940999999 Derr, Edward MNR Minor Advisor N 940999999 940999999 Smith, Vincent MJR Major Advisor Y 940999999 Heard, Mallory 202101 940999999 Derr, Edward MNR Minor Advisor N 940999999 940999999 Slattery, Dennis MJR Major Advisor Y 940999999 McCord, Isabella 202101 940999999 Derr, Edward MNR Minor Advisor N 940999999 940999999 Lyon, Cherstin HNRC Honors College Advisor N 940999999 940999999 Yamaguchi, Precious MJR Major Advisor Y 940999999 Pomeroy, Toni 202101 940999999 Derr, Edward MNR Minor Advisor N 940999999 940999999 McGrady, Pavlina MJR Major Advisor Y ---------- ************************* ********* 18 adv_reassign_advisor.sql