« November 2012 | Main | January 2013 »

December 24, 2012

Christmas Vacation

I'm on vacation!

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

December 14, 2012

SAAADMS/SAAQUIK trigger error in test

The Banner team ran into a trigger error while updating a record in SAAADMS and SAAQUIK in TEST. I traced the error to a trigger that updates the student PIN number record in GORPRAC. The trigger looks through an audit table in GORPAUD to see if an external_user name has already been used. The table was missing some records (which may have been manually deleted) so it used an external_user name that's aleady been used and through a constraint error. I ran a sql script from Sungard that recreates those missing records and it seemed to fix the error.

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

SSBSECT/SSRMEET/SIRASGN trigger mods

I put the ssbsect/ssrmeet/sirasgn triggers into production this week. These triggers restrict updates to these tables if the user belongs to the USR_SCHEDULE_DEPTACCESS_M class in Banner. The Registrar has an admin page in Wolf Web that can control which terms can be updated. The code is located in the wou_web.p_staff_class_update_access package. We ran into an unexpected glitch with the triggers and it prevented updates from Astra so I modified the SSRMEET trigger so that it allows updates.

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

December 6, 2012

Scarf modification for cancelled students

I made a change to the scarf script so that it picks up the prior admit decision for students that cancelled their admission. By default, scarf picks up the last admit decision, which is fine except for cancelled students. We have to send the initial admit decision and not the cancelled code to scarf. I had to fix these manually in the past so this will be one less problem that I need to fix when it comes time to run scarf.

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

Degreeworks modification - current term curriculum

I made a modification to the Degreeworks script bannerextract.config because it was pulling future term curriculum data for some students. The Registrar's office requested this mod because on a particular student, Degreeworks was pulling their graduate data even though the student hasn't completed their undergraduate work (this student applied for graduate school prior to getting their degree). The modification will only pull curriculum data that is less than or equal to the current term.

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