« February 2006 | Main | April 2006 »
March 30, 2006
Swrrmet
Early this week I rewrote the swrrmet report in perl so that it would display TBA and ONLINE courses correctly. The old script was writted in SQL and didn't quite display what the users wanted. It either gave too much data or too little. Plus the old script didn't handle null room numbers too well either so I broke it up into a seperate query when searching for an individual room number.
Posted by soukupm at 04:00 PM | Comments (0)
March 23, 2006
Weekly Report: Winter Term Scarf, Majors/Minors/Concentrations
This week I sent in a winter term scarf report test to get some of the errors cleaned up before the official submit next week. I found a problem in the code where it was nulling out institutional earned hours when there was a discrepancy between institutional earned hours and institutional gpa hours. The discrepancy is fine because "pass/nopass" hours are not figured into gpa.
I wrote several new functions in the wou_misc package for collecting majors,minors, and concentrations, using the new curriculum tables. I also wrote a function for getting the major code descriptions. These come in really handy when someone wants one of those "quick reports".
I fixed the output on the label report (swgrlbl) so that it no longer skips the first row of labels. When I fixed the report, it broke the label to flatfile script because it was looking for a blank row at the begining of the page, but I got it fixed.
Posted by soukupm at 03:25 PM | Comments (0)
March 17, 2006
Weekly Report: Database Consolidation, swrrmet
Some of the things I worked on this week:
Consolidation project - I looked at several shared tables between sis/fis/hr earlier in the week in preperation for our banner meeting. I took some print screens of possible problems and wrote down some notes of things to be concerned with when we merge them.
SWRRMET - This is a building/room job submissions by course/crn/term. This report had some problems and was not reporting the correct data and had some missing data but I was able fix with a few adjustments to the query.
Quick report on JR's and SR's for the provost that had gpa,sat scores,addresses,phone,email.
I rewrote the financial aid scarf fincat script that I used for financial aid awarded for the year. I had some temporary workarounds that I wanted to clean up before scarf reporting next week.
Posted by soukupm at 04:26 PM | Comments (0)
Research Table
Just when I thought I had the code perfectly written to grab the correct major for the research table, a new problem arose. Some of the curriculum records are being back dated to a prior term so the logic failed on those students because it was collecting the records with the highest lcur_seqno. Now I have it grabbing the highest term code, with the highest lcur_seqno for that term, and the highest sorlfos_seqno with the same lcur_seqno and term code as above as long as it has a priority number of 1. I tested it out today and it works perfectly! Now I just need to update my f_get_major function and I'll be set.
Posted by soukupm at 04:03 PM | Comments (0)
March 08, 2006
Financial Aid Category Update - Yearly Offered Amount
The financial aid offered amount in the scarf report wasn't giving accurate amounts for the year because it was getting that data from Banner. The amount in Banner is actually the amount disbursed to the student and not the amount financial aid offered for the student. So I rewrote the section of the script to now get that infomation from a flat file provided by Financial Aid. I'll update the readme file for scarf on how to upload this file so that it can be used when running scarf.
Posted by soukupm at 04:21 PM | Comments (0)
March 02, 2006
Weekly Report: Banner 7.2 Web Testing
I've been testing banner 7.2 web apps this week and so far all of them are working fine. I did find another package that needed the special spriden hint ( /*+ driving_site(spriden) */.
BWLKFFGD - This package does web grading.
All of our custom web apps are working fine: classrst,sectall,wou_park,wou_wrlss, wou_print,acadhist.
Posted by soukupm at 02:53 PM | Comments (0)