« November 2010 | Main | January 2011 »

December 31, 2010

Happy New Year!!

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

December 27, 2010

Vacation Part 2

No updates because I'm on vacation. :)

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

December 24, 2010

Merry Christmas!!!

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

December 20, 2010

Vacation

No updates because I'm on vacation. :)

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

December 17, 2010

Add/Drop fee trigger updated

I updated the add/drop fee trigger (st_sfrstca_before_insert_row) this week because it was not excluding records in the table for submitted grades. These records look like normal registration records except the message field will have "Final grade updated".

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

SZPOFAX load gotcha

SZPOFAX loads the dual enrollment course information for students. It automatically selects the current term from Banner to load data into the ryrofax table. If someone pre-loads a future term, the current term data will be wiped out (it does a delete from table where the term_code = current term before it loads new data). I mentioned this to Financial Aid so they are aware of this problem. The data can be reloaded by running the previous term's data through SZPOFAX.

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

December 10, 2010

BWCKSCHD Mod

I made a change to the BWCKSCHD package for the Registrar's office because it was displaying CAPP information that was confusing to students when they looked up course information in Wolf Web.

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

December 7, 2010

GORADID - non-standard update

I did a non-standard update on the table GORADID to fix a couple SSID numbers that had leading spaces in front of the ID number.

I changed the scarf script so that it gets the SSID number from GORADID instead of SYBSSID.

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

December 3, 2010

Invalid Phone numbers

I met with the Banner team to discuss some of the invalid phone numbers in Banner, particularly the GO phone numbers with '000000' area code. This field was incorrectly used for driver's license numbers. We decided that it would be best to store this data in the additional identification field on the SPAIDEN form. I'll run a non-standard update and move the existing driver's license numbers over to the table GORADID and delete the invalid phone number records in SPRTELE.

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

TZPMATC changes

I made some changes to TZPMATC (matriculation charge process) this week. I added graduate students to the process (they are now charged a matriculation fee). I also added an audit and update mode so that someone can run the program to see the results without updating Banner.

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