« December 2010 | Main | February 2011 »

January 28, 2011

Non-standard update: SGRSATT

I did a non-standard update today in preparation for the minimum credit hour switch to baseline. I created a new attribute "INTL" on sgrsatt for all active International students. For the students that had existing attributes, I copied those to the upcoming term (201003) so that the attribute is still active.

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

New job submission - SZPMHRS

I created a new job submission called SZPMHRS that copies the min/max registration hours to a new term. I added 45 new minimum credit hour rules for the Athletes and International students and this would be a bit much to have the Registrar's office copy these each term. This job will save them some time from manually entering them. The input is previous term (the term you want to copy from) and new term (the term you want to copy to).

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

New Cron - SZRINTL

I created a new cron job this week named SZRINTL. This is a list of International students that are below their required minimum credit hours (12 for UG,9 for GR). This was needed because the baseline minimum credit hour process in Banner only works when a student reaches the minimum credit hours and tries to drop below that minimum. If a student never reaches the minimum credits, they can continue to drop credit hours. This report will catch any students that fall into this category.

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

January 21, 2011

term_enrolled view updated

I updated the term_enrolled view this week. The view now pulls student's curriculum information (major,minor,concentration 1 - 3, and program code) from the new curriculum tables instead of sgbstdn.

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

Minimum credit hours revisited

I started working on the baseline minimum credit hour process in Banner again so that we can remove our current mod. Using the minimum credit hours for athletes is pretty straight forward, very little needs to be setup. For International students, we'll have to create an attribute in SGASADD so that we can identify them (using the citizenship code would be the most ideal solution but it is not supported). I'll be setting up meetings next week to go over the new process and hopefully put this into production the following week.

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

January 14, 2011

Tab highlighting mystery in Wolf Web

I solved the mystery of why the personal information and staff menu tabs are highlighted in Wolf Web when you first login. This is controlled by a field called module. Each procedure and menu item is associated with a module. The staff menu and personal information menu items were assigned to the "Web General" module. When you first login, the web general module is active so all tabs assigned to web general are highlighted in blue. To fix this issue, I created a new module "custom" and assigned the personal menu and staff menu to it.

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

SZRCRSF modification

I made some changes to the job submission SZRCRSF. The output will list all course fees separately now. The Veteran's office needed this to separate tuition fees and additional course fees.

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

January 7, 2011

Non-standard updates

I did a few non-standard updates in Banner this week.

Updated the spraddr_asrc_code for codes that were entered in lower case. This caused a constraint error when a student updated their address and the asrc code didn't exist in stvasrc.

I added 'ODL' goradid records for students that had GO phone numbers with the area code of '000000' and an Oregon Driver's License number in the comment field. I removed the invalid GO records from SPRTELE.

I wrote a script to fix area codes that have more than 3 digits (the area code and phone number were combined). The code removes the extra digits from the area code and adds it to the phone number column. I ran this in test and awaiting approval to apply to production.

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

TSP1098

The Business office ran into a problem where the TSP1098 tax process was already run but one student's tax information needed to be adjusted. I ended up doing a non-standard update on tbraccd to back date the activity date and effective date and setting the ttbtaxn_test_mode_ind back to 'Y'. Both of these did not fix the problem though. When I updated the tbraccd_entry_date and the Business office modified the tax rules in Banner, the student's record updated correctly.

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