« TSP1098 | Main | SZRCRSF modification »
January 7, 2011
Non-standard updates
I did a few non-standard updates in Banner this week.
Updated the spraddr_asrc_code for codes that were entered in lower case. This caused a constraint error when a student updated their address and the asrc code didn't exist in stvasrc.
I added 'ODL' goradid records for students that had GO phone numbers with the area code of '000000' and an Oregon Driver's License number in the comment field. I removed the invalid GO records from SPRTELE.
I wrote a script to fix area codes that have more than 3 digits (the area code and phone number were combined). The code removes the extra digits from the area code and adds it to the phone number column. I ran this in test and awaiting approval to apply to production.
Posted by soukupm at January 7, 2011 3:06 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.)