« June 2013 | Main | August 2013 »

July 26, 2013

Tuition Equity and Scarf

I made some changes to the scarf script this week to identify the tuition equity students in Banner and map these students with the scarf code TUEQ. These student have a rate code TEP13 or TEBAS and have an attribute in sgrsatt TUEQ.

Posted by soukupm at 10:39 AM | Comments (0)

Echeck changes

The echeck process was recently changed that allows Visa payments to be made. This change caused some problems with the reconciliation process because an extra entry is sent for the visa payment fees. I modified the script TZPECHK so that it handles these extra entries (for now it's just ignoring the lines and the cashiers are manually entering the fees into Banner). We are working with the bank to see if these extra fee lines can be removed from the file.

Posted by soukupm at 10:29 AM | Comments (0)

July 18, 2013

New job submission - SZRRTAC

I created a new job submission this week called SZRRTAC (Course Equivalents in Transfer Articulation for a College). This is a report similar to SWRRTAC but prints in pipe delimited format so it can easily be imported into Excel.

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

Payroll load script pzprost.pl updated

I updated the payroll roster load script pzprost.pl this week. It still had VMS directories in the script so I updated those to linux directory locations. I updated the readme.payroll_timesheets file under /san/home/wou/common to reflect these changes.

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

July 11, 2013

Waitlist problem

Before the previous SOAR, the block courses were opened up while the waitlisting cron (SFRBWLP) was running. This caused quite a mess because it notified students of available seats when the seats were not truly available. To fix this problem, I deleted all of the records that were created that day from the table SFRWLNT. Then ran the job submission SFPWLRO which reassigned the students back to their original waitlist order.

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

Garden 2013

Here's some pictures of my garden for 2013.

Posted by soukupm at 9:28 AM | Comments (0)

July 3, 2013

Happy 4th of July

Just what the title says. Time to go on vacation now...

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

Scarf changes - added remapping for high school codes

In Banner, staff use generic SBGI codes (HS in Ohio, HS in California,etc) for high schools that the CEEB code is unknown. These codes need to be remapped to an appropriate code in Scarf. I built a hash table that remaps all of these to valid scarf codes.

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