« PL/SQL Errors/Debugging messages enable on WOUDEV | Main | Report for the week »
March 01, 2007
Work Report
Some of the things I've been working on lately...
I did a non-standard update to TBBEACT and TBRACCT on 2-23-07 for the Business Office to set the effective dates back to 01-01-1980 for some new detail codes that needed to be back dated. A copy of the scripts are in the programming request booklet.
Updated the email update and section tally to include spring and summer terms.
While I was working on a fix for SZRFORN so that it didn't include credit hours for students that cancelled or withdrew, I found a problem with both the clearing house script and our research table script. Both of these were counting credit hours for students that withdrew before the 4th week, which is not consistant with Scarf and IPEDS reporting. I fixed both of these scripts so that they don't count those credit hours.
The online survey that pops up during registration seems to be producing some duplicate entries for the same student. It could be a web issue (possibly double clicking the button or time-out issue). For now, I'm having it select rownum 1 when it looks in the users table for the vnumber.
There was a problem with the student email update procedure that was causing more than one email record to have the preferred indicator turned on if the student already had it selected as preferred for an ADMS email type. This will cause problems with some of the baseline banner apps so I wrote some new logic in the procedure so that it now checks for existing preferred indicators and turns them off whenever an update is made to goremal table.
Joe and I switch all the cron jobs from wolfman to winchester.
Did several reports this week -
Woodburn students report for Registrar's Office.
List of non-admits for fall and winter terms with course information for Admissions.
Added email addresses to Josten's graduation report for Registrar.
Report for table SMRSSUB for Registrar's office.
Schedule of classes with start and end dates for Financial Aid.
Posted by soukupm at March 1, 2007 02:43 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.)