« August 2007 | Main | October 2007 »
September 27, 2007
SZRRETN updated
I added two new parameters to SZRRETN (retention rate report), level code and exclude graduates. Exclude graduates removes any students from the calculation if they student received a degree by the second term parameter.
Posted by soukupm at 5:22 PM | Comments (0)
September 21, 2007
New Research Script
I finished up a new research table script and put it into production yesterday. It has several new columns including email addresses, all act and satc scores, and program codes. I cleaned up a lot of sql in it so that it runs faster and is a lot more readable. So far, I've ran it for Spring 2007, Summer 2007 and Fall 2007. It's on the cron job so any new terms will autmatically use this script. To create a new term use swiurch_create.sql.
Posted by soukupm at 2:45 PM | Comments (0)
September 18, 2007
SGASADD attributes and web registration groups
The registrar's added two new SGASADD attributes called SOPH and JUNR for articulation agreements made by the university. These new attributes will be used by the web registration script to determine if a student should be included in a higher registration group than what their current total credit hours would have placed them in. For example, if a student transfers in below 45 credit hours (technically a Freshman) and they have a SOPH attribute, they will be placed into the lowest sophomore registration group. The same thing works for the JUNR attribute, the student would be placed into the lowest Junior class group if their credit hours are below 90.
Posted by soukupm at 3:33 PM | Comments (0)
September 12, 2007
Blank Screen when running Banner INB
I ran into another problem today with a user that had google desktop installed on their computer and trouble getting into Banner INB. It seems to interfere with the Banner INB loading and ends up producing a blank white screen instead of the login page. If you uninstall google desktop, then Banner INB works again.
Posted by soukupm at 11:47 AM | Comments (0)
September 7, 2007
Added two new functions
I added two new functions to the wou_misc package today called f_get_sport and f_get_in_sep. F_get_sprt(pidm,term) returns a sport code if a student participated in sports for the given term. F_get_in_sep(pidm) returns a 'Y" if the student participated in the Student Enrichment Program.
Posted by soukupm at 3:40 PM | Comments (0)
Jobs aborting due to password expire
We've had a few calls now since the password expire policy went into affect where a previously working job submission all of a sudden starts aborting. The problem has to do with the way perl scripts login to the database. When it attempts to login, a password error is raised and the job submission aborts. The workaround is to have the user change their password when their password is expired.
Posted by soukupm at 3:08 PM | Comments (0)