Trigger: Graduation each year
Graduate students get removed from the school’s PharmSchool DB and email distribution lists when one of two things happen. Either Lori Altenbaugh emails me and tells me they have fully graduated, or they are listed in the graduation program.
Steps:
- Get a copy of the graduation program from Kathy Stell
- Use the lists in it to mark records in the PharmSchool DB
- 1) Use the layout “tow_GraduatedGradStudents
- 2) in the field MGT, add an “X” for each student listed in the program
- Export these records from PharmSchool- export al fields in Person, Directory, and GradStudent tables. Use this to import these records into the Alumni DB, Grad Student table.
- 3) Export as XLSX a list of the MS graduates. Ask Lori and Maggie to mark any students who are staying int he program as a PhD student, and change the program, program track, and advisor for these students.
- 4) Export as XLSX a list of PhD grads and ask if there is any reason why they should remain in the directory or the distribution lists
- Upon receiving replies from Lori or Maggie, delete or update the PharmSchool records (in the GradStudent table) of any remaining student. Remove the “X” in the MGT field.
- Find the records where MGT = X
- Export the distribution list field for these records as a text file
- Use the DistList text export to remove the addresses from the these lists: RxSchool, RxGrad, PharmSciences, PTC , Baum, Pavilion