« October 2012 | Main | December 2012 »

November 30, 2012

SSASECT form problem on 8.5.3.1

I ran into a problem with the form SSASECT 8.5.3.1 on our test instance this week. After you fill in the term code and crn and paged down to the next block on the form, no data was being displayed for the course. I worked with Sungard on this problem and it turned out to be we were missing two update scripts from Banner 8.4 that populated a new column in ssbsect (SSBSECT_PREREQ_CHK_METHOD_CDE). This value was null and need a value.

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

Update to research_201201_4th

I did an update to the research table to populate the correct race/ethnicity codes because we were running an old version of the research script that was pulling from the old race column on spbpers. I kept a backup copy of the original table (research_201201_4th_bak).

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

November 19, 2012

Happy Turkey Day

Happy Happy Turkey Day!!

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

Scarf Financial Aid detail codes to exclude

Note to self: Any financial aid detail codes that are used as clearing accounts should be excluded from the finaid_xwalk table. These detail codes will throw the balance off per term (you'll end up with negative aid amounts).

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

November 16, 2012

Scarf Financial Aid End of Year

I'm working on the scarf financial aid end of year report this week. This report covers the 2011-12 academic year. I had to meet with the Business Office because there was several detail codes that were added in 2011-12. We map these detail codes to scarf financial aid category codes.

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

Powerfaids update 18

I upgraded Powerfaids from 17.3 to 18 this week. I had to do two upgrades 17.3 to 17.4 then 17.4 to 18 since we skipped an upgrade.

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

November 9, 2012

Scheduler Minute jobs

I found out this week that the jobs we have running every minute were stopping at 4pm. The jobs were set to run M-F during business hours (8-5). The runtime was set to 08-16 (military time) but Oracle must be interpreting 16 as the stop time. I set the hour to 17 and the jobs run all the way up to 5pm now.

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

TSAAREV Form Mod

There is a form mod on TSAAREV (accounts receivable form) that was missing from the Banner upgrade this last weekend. The transaction date and effective date columns are swapped on the form. This mod was put in so that the cashiers can view the transaction date without having to scroll the screen.

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

November 2, 2012

Clearinghouse updates

I made some changes to the Clearinghouse script this week. The output file now includes: Majors (1&2), CIPC codes for Major 1 & 2, Degree Seeking flag, Class level, and updated grad_date so that it includes less than half time students. These changes are in production now.

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

SSBSECT/SSRMEET mod

I've been working on a table trigger for SSBSECT and SSRMEET for the Registrar's Office that will allow staff to update classes on the SSASECT form in Banner for specific terms. The staff member must belong to the USR_SCHEDULE_DEPTACCESS_M class in Banner INB. Term codes can be added or deleted through a web page on Wolf Web (p_staff_class_update_access) under the Faculty Main Menu. The functional team is testing the program this week and I should be able to put it in production sometime early next week.

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