What if we added a column to the advisee table (see the end) to alert faculty advisors:
--when a student has entered information on their MRW that advisor can look
over / approve
--when a student has submitted a worksheet as an SRC, which needs the Advisor's
approval
--that they have sent the SRC to the Deans or not
--other?
| Majors | ||||||
| Name (WesID) | Major(s) | Status | GPA | Credits | GenEd Status | MRW/SCF status |
|---|---|---|---|---|---|---|
| 2005 | ||||||
| Schmoe, Joseph | GOVT,PHIL | ENRL | 88.591 | 30.2 | STAGE 1 COMPL | Approve SCF |