« February 2010 | Main | April 2010 »

March 26, 2010

New scripts for clearinghouse reports

I rewrote the clearinghouse scripts for creating the header and footer records (clrhse.pl and degrverify.pl). The old versions were still on banner 7.x code (these did not port over cleanly when I tried).

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

Non-standard update: shrgrdo and shrgrds

I did a non-standard update and removed some mismatched records in shrgrdo (grade mode maintenance table) and shrgrds (grade substitution table). This was a fix suggested by sungard support center for fixing grades that don't roll because of an invalid grade mode error. I backed up the table just in case I need to reload the records (shrgrds_bak and shrgrdo_bak). I didn't notice any ill effects from removing these records.

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

March 19, 2010

SWAROUS updated

I updated the SWAROUS report this week to comply with the new OUS format. It now displays residency numbers for the prior year, the first time freshman ethnicity breakout is removed, and the admit decision page is removed.

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

SZPBCHK updated

I made an change to SZPBCHK today so that students will not receive a check if they've dropped a course within the last 14 days and have not recently receive financial aid.

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

March 12, 2010

TZPECHK - Fixed bug

I made some changes to TZPECHK (our e-check reconciliation process) so that it doesn't overwrite an error status in the table if an error was never resolved by the cashiers. These errors should appear on every reconcilation report until the problem is resolved and a programmer clears the status.

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

Scarf - new ethnicity and race code

I added some new code to the scarf script so that it looks at the new race table and ethnicity code in spbpers. So far it seems to be producing the correct data. I still need to do some debugging to make sure all races are reported (students can have more than one race in the new record structure).

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

March 5, 2010

Min/Max registration hours

I worked on the min/max registration process this week and came up with a list of items I'll need to do to set it up in production. Some of the steps will involve a few non-standard updates and a new cohort code to identify international students. I created some scripts to do the mass update on the athlete table, populating the international cohorts, and setting the minimum rules.

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

Race/Ethnicity update

I ran the gurethnicity script in production today to update everyone's race and ethnicity in Banner. I ran into one error while running the script but I got it fixed (one person had a null citizenship code). The banner team cleaned up a lot of the data when I was running this script in test so most of the errors were avoided.

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