« All_rows hint file | Main | Work Report »
July 27, 2007
Email Inactivate
I wrote a procedure today that inactivates all email addresses that don't match ldap email addresses (or not in ldap at all). This will clean up the goremal table so that we only have valid and working email address in that table. The procedure is called wou_email.p_invalid_email_addresses. The output is vnumber,banner email, ldap email for students where the email address did not match. The first run cleaned up 269 records, most of which were students that left at least 2 years ago, cancelled admission, or was a staff member with a staff email address already in Banner.
Posted by soukupm at July 27, 2007 3:18 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)