« April 2013 | Main | June 2013 »

May 31, 2013

E-disburse update - Email status

I made a modification to the E-disburse process TZPEDRF so that it saves the status of the emails that were sent for the day. The status is stored in the table tzredrg_email_status. This table can be used to get a count of emails that were sent for the day and if the email was successfully sent.

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

Banner Update this weekend

We will be updating Banner INB and Wolf web this weekend. The URL for Banner INB will change, the new url will be added to our Banner webpage: http://www.wou.edu/bannerINB. Single sign on for Banner INB is also getting updated this weekend.

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

May 23, 2013

New computer

I worked on my new computer this week and got everything (that I know of) installed. It's great having a computer that's not littered with applications that I haven't used in years.

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

Mod to SFKWLAT

I made a change to the package SFKWLAT so that it sends an email to the registrar's office when a student is notified that an class has opened when they are on the waitlist.

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

May 18, 2013

Realtime schedule fix

I made some changes to the realtime schedule this week to fix an issue where the waitlist column was not displaying for courses that had non-typical start and end dates.

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

Dropped several temp tables

I dropped several temporary tables this week to clean up our database. All of the tables ended in '%BAK'. These are used to temporarily backup tables before a non-standard update.

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

May 10, 2013

Pinmail migrated to Linux

I migrated the program PINMAIL to Linux this week. This program is used to notify the summer session students that their pawprint account will be created. This script was a little bit tougher to convert because it calls three other programs to complete the job.

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

Reverse transfer update #2

To send out the reverse transfer transcripts, you have to run GLBDATA (or insert records directly into the glbextr table) to grab the population of students. Then you run SHRTPOP on that selection. Finally you run SHREDIY to transfer the transcripts. The first parameter has to be set to "Y" so that it sends transcripts from the SHRTPOP population.

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

May 3, 2013

Oracle upgrade delayed

We're delaying the oracle upgrade this weekend because more testing and work needs to be done. We're having problems with font being too small for Banner INB. Some of the characters are being cut off on the side bar and the menu font is tiny.

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

Reverse transfer program update

I finished the query to pull the reverse transfer qualified students. The application code is "REGISTRAR" and the selection ID is "REVERSE_TRANSFER". The query for the reverse transfer students is in a view named ZFVREVT.

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