« August 2006 | Main | October 2006 »
September 29, 2006
SZRENR2: Enrolled Students Job Submission
I created a new job submission in Banner called SZRENR2 for the Registrar's Office. It prints out a list of enrolled students for the term by level code. The output includes vnum, name, catalog term, program, major, minor, and concentrations.
Posted by soukupm at 03:08 PM | Comments (0)
September 28, 2006
SSASECT Error: Cannot create, record already exists for section
Brian and I spent a fair amount of time this morning figuring out why the registrar's office couldn't add a new course. It was erroring out with the message "Cannot create, record already exists for section" when you try to use the "ADD" crn in SSASECT. We traced it down to the table SOBTERM, which seems to hold the last course that was created. When you use the "ADD" crn in SSASECT, it returns the field sobterm_crn_oneup + 1. Somehow a crn got skipped in this table and the crn that it was returning already existed in the table SSBSECT. So I just updated the table sobterm and incremented the sobterm_crn_oneup number by 1 and that seemed to fix it.
Posted by soukupm at 10:25 AM | Comments (0)
September 22, 2006
SWEFADP2 - Advisee list by Advisor
I made some changes to the job submission SWEFADP2 and added 2 new columns to the report: degree code and program code. I had to make a change to the term_students() subroutine in wou_student.pm (file with many subroutines used in a lot of our perl based job submissions). The original sql in that subroutine was not selecting that information so I added those two columns.
SWEFADP2 actually has 2 different scripts that it calls depending on if you select database for your printer or just print directly to the printer. SWEFADP2.PL is called if printing to database and it's a pipe separated list of students. SWEFADP3.PL is used for printing directly to a printer. I made a change to this script to fix the margins because it was printing about an inch and a half from the left side and dropping some columns at the end. I added a printer escape sequence to the start of the file that tells the printer to set the left margin to 0. Search the file SWEFADP3.PL for "margin" to see an example of how to do this.
Posted by soukupm at 01:07 PM | Comments (0)
September 15, 2006
Research table update; New version of Soremal
I added a new column to the research table that contains the residency code. The new field is called "resd". Residency was being collected in the column "bsum" prior to this but it had a few bugs and in most cases wasn't getting populated correctly.
I compiled a new version of SOREMAL and added in the few mods that we had from the old version. The old version was using a workaround for mass emailing because of an old oracle 9.1 bug, but I switched back to baseline since that bug doesn't exist any more.
Posted by soukupm at 02:26 PM | Comments (0)
September 13, 2006
Math Placement Test Code
By request from the Math Department and Registrar's Office, I added a new test score code to banner called "MTHP" (short for math placement). We had a meeting earlier this summer about this but chose to postpone it until after SOAR. This change was needed to accommodate Math 70 placement scores in banner. I also changed the math placement score script (used during soar for mass loading ) so that it works with these new scores.
Posted by soukupm at 03:21 PM | Comments (0)
September 08, 2006
Banner 7.3 upgrade, scarf degree report, finaid load cipc
The Banner 7.3 upgrade over the weekend went pretty well. I put on all my web mods on monday and tested them out tuesday and everything seems to be working good.
I've been working with the registrar on the scarf degree report this week. We're verifying the numbers and double checking a few items that might be a problem, mostly concentrations. It helps to have a second person taking a look at the numbers because it's pretty easy to over look something, espcially when your dealing with a lot of data.
I added a new column (cipc code) for the financial aid admissions end of term report and changed the logic so that it reports all major codes instead of a few specific ones. They use this report to load data into powerfaids.
Posted by soukupm at 02:55 PM | Comments (0)