« December 2005 | Main | February 2006 »
January 30, 2006
SZRGRAD
Job submission
parameters : term code
List student, degree, and honors that graduated in given term.
Posted by wendlerb at 1:22 PM | Comments (0)
January 24, 2006
SZRPCOL
This is a report that lists student and colleges attended prior to admission to WOU. It has two parameters:Start and End Terms to give a term range to select against. It also outputs total credit hours for the college.
Posted by wendlerb at 2:38 PM | Comments (0)
January 23, 2006
Research table
SWIURCH is a sql script that runs in 3 cron jobs to populate the research table for 3 terms. This is a wou table with data coming from multiple sources and is used for a great number of sis reports. Scarf reporting makes use of this heavily as well. I noticed major/minor information was still coming from the table sgbstdn. Banner 7 has changed this to a new table sorlfos and even though sgbstdn is supposed to be getting backfilled, I've run across some instances where this is no longer the case. So I changed the swiurch script to pull major/minor info from sorlfos.
Posted by wendlerb at 8:45 AM | Comments (0)
January 20, 2006
SHATATR bug
When trying to create a new effective term for a inst course, you get the error "Unable to create attribute record" when a previous attribute exists. Searched through the form and found where bug was occuring. It looks at scrattr records and has a logic problem getting the eff term to use on the new record. I found the bug on the SCT site and it looks like it is addresed in the Banner 7.2 release. If I can find the form, maybe I can put fix on 7.1x version of form but for now we have work around.
Posted by wendlerb at 8:11 AM | Comments (0)
January 19, 2006
Tax Notification
This is on web for student and has years hard coded into the packages. I made chnges to bwskoacc to handle the administratoe look up of any student. I also looked at bwtktxys and ttkfunc to habdle the student look up. We changed it to a date range of 2003 to 2005.
Posted by wendlerb at 11:10 AM | Comments (0)
January 13, 2006
SZRLOWE
Low Enrollment Report
This report list crns that have less than 12 students enrolled. It matches the instructor teaching the class with his academic rank and salary. In order to do this I had to create some functions in wouprd under baninst1 to grab data across a database link to wops. The rank comes from the table perrank and the term salary comes from nbrjobs ann salary / 3. The request also asks for fte per course but banner only has an fte for the job. Apparently there is a field for this on student(fte per course) but it has never been entered. The numbers the provost office uses for this are a little unclear so more discussion on it is on the way.
Posted by wendlerb at 8:23 AM | Comments (0)
January 11, 2006
Fee payment
Last Friday I changed the cron com file of swbrchk to print to w_cha_ching but it started printing to w_sischeck Monday morning. This was same day we pushed through about 260 checks from the web aid release. Looks like I must of included the version number when editing file because the file created for that date was a lower number. Thus, it was not the file that kicked in during sleepwake restart. I edited file correctly next day and it was fine.
Posted by wendlerb at 9:01 AM | Comments (0)
January 5, 2006
Computer upgrades
Sally got a new computer. Need to make sure computing services realizes that her compuer has specific setup for check printing. Folder on network must have got corrupted somehow causing a big headache. Driver for printer is specific to Troy but named the same as a regular hp driver. It is not the same however.
Posted by wendlerb at 2:10 PM | Comments (0)
January 3, 2006
SOIL and Perkins Loans
We have not been getting a SOIL file to the state with Perkins loan info ever since WOU switched to CLM. I fixed some V#s on this system so I was at least a little familiar with it. It's set up in a SQL Server environment. I have the format of the data transfer file but did not know the corresponding fields in CLM so I had to spend some time learning the table structure and finding them. Currently working on this and have come up with T-SQL query to get data. Will likely do a feed into an oracle table to make it easier to work with the data and format output.
Posted by wendlerb at 2:41 PM | Comments (0)