« August 2010 | Main | October 2010 »

September 24, 2010

SZPOFAX updated

I updated the program SZPOFAX this week. This program processes the OFAX file for dual enrolled students. We got a file that contained ID numbers that were missing the leading zeros so it didn't match the ID in Banner and didn't load the records. I added some code so that it automatically pads the IDs with zeros if the length is less than 9 characters.

Posted by soukupm at 3:32 PM | Comments (0)

SWEXHLD updated

I updated the job submission SWEXHLD (places advising holds on students). It now excludes any students with the major '9NRS' (nursing students). This modification was requested by the Advising office.

Posted by soukupm at 3:25 PM | Comments (0)

September 17, 2010

Staff Development - Adobe Flash CS4

I watched a few more Flash tutorial videos today for my staff development time. Flash has a lot of really cool features and I'm looking forward to playing around with it and building something of my own.

Posted by soukupm at 2:52 PM | Comments (0)

Banner - Minimum credit hours

I've been working on a solution to get the baseline minimum credit hours to work for us for the athletes and international students. One of the major problems we had with it was that a student that was already registered for the term would not get the appropriate minimum credit hours assigned to them. The reason is that the enrollment record (along with the minimum credit hours) is created when the student registers for classes and is never updated. I found a baseline procedure that will re-evaluate the credit hour rules and return the correct credit hours for a student. All that I would need to do is select all of the athletes and international students registered for the term and compare the minimum credit hours between their enrollment record and the results from the procedure and update if necessary.

Posted by soukupm at 1:35 PM | Comments (0)

September 10, 2010

Banner 8.3 upgrade: Degree Evaluation

I looked into the issues with the XML degree evaluation that the Registrar's office sent me. It looks like most of the problems will take a while to fix (more time than what we have since we're going live on Banner 8.3 next month). I'm going to the make the mods to go back to the html version.

Posted by soukupm at 4:23 PM | Comments (0)

Banner 8.3 upgrade: sgrsatt trigger

Our trigger "insert_sgrsatt_from_shrtram" broke in Banner 8.3. This trigger adds attribute codes to transfer students. I traced the problem down to a new column that was added to the table SGRSATT. I got the trigger fixed and put the code in \8.3 point release\WOU Mods\Triggers directory.

Posted by soukupm at 4:12 PM | Comments (0)

September 3, 2010

SZRCMNT Changes

I made some changes to SZRCMNT this week so that it can handle null date values (all of these were dropping off the report when they shouldn't have). If the date parameters are left blank, it will default to sysdate.

Posted by soukupm at 3:47 PM | Comments (0)

New job submission - SZRHINS

I created a new job submission this week for the business office called SZRHINS. This is a report for the health insurance process. The input is term code and report type (R=regular,I=international,E=ESL,S=summer). The output is CSV format.

Posted by soukupm at 3:39 PM | Comments (0)