« November 2005 | Main | January 2006 »

December 23, 2005

Weekly Report: Faculty Transcripts, Minimum Credits for Athletes, New version of Powerfaids

This week I worked on Web for Faculty Transcripts. I made several mods to the baseline transcript app on test so that it only allows a student's current advisor to view their transcripts. It also blocks viewing of transcripts of students that are marked confidential or who have a transcript type hold on their account. The last change I made was to allow the student's advisor's department to view them. I just need to fully test it and get it approved for production from the Registrar's office.
I made some changes to the minimum credit hours for athletes code and put in on test server. I moded the registration package sfkedit to make it all work. It seems that its working correctly but I want to test it out a little more to make sure there's no problems or side effects from the moded code. If it all works out, I'll put it in production Winter term. This code can also be used for setting any type of minimum credit hours if we choose to do so.

I loaded a new version of Powerfaids for the Financial Aid Office this week so that they can get familiar with the software and test it out before we load it into production sometime in Winter term.

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

December 19, 2005

Another Moded Package

While I was looking at the baseline package for transcripts (for faculty), I ran into another package that was timing out. The package is called bwlkadvr and it's used for displaying advisee lists. I moded three cursors in this package with the spriden hint.

Posted by soukupm at 01:30 PM | Comments (0)

December 15, 2005

Weekly Blog: Grades, WUE, BI-Query, Setting minimum amount of credits

We just recently finished rolling grades, so I ran the typical end of term grade reports: honor roll, president's list, suspension list. I also finished up the ICS 101/integrated seminar report for the provost office (just needed this terms grades and gpa). I ran a (pre) end of fall term scarf report to clean up problems before I submit the official report this next week (it helps to run it well before its due so that I have enough time to fix them).
I met with admissions and fixed a few more things with the WUE report and its now in production. I got a request to add a few more fields in bi-query to the term_appls and term_admits query. I worked on it today and added an "enrolled" field to term_appls.
I contacted one of the programmers from OSU about setting minimum number of credit hours for athletes and they already had something written up that does this. The code looks like it'll work for us too so I'm going to load it on the test database to test it out.
I moded the Banner Web package twbkwbis.p_wwwlogin so that the "Forgot PIN?" goes to our custom pin reset page. There's comments in the code that identify where I made the mod.

Posted by soukupm at 03:49 PM | Comments (0)

December 09, 2005

Weekly Report: Scarf, Gpa project

I got all the workstudy numbers from last year and resubmitted all of last years financial aid data to scarf. Now all I need to do is verify the numbers when I get the report back from OUS.
The other project I've been working on is related to the ICS project that I did before for the provost office. This time the populations changed a bit so I'm modifying my code a bit to include these new populations.

Posted by soukupm at 03:27 PM | Comments (0)

December 01, 2005

Weekly Report: Scarf Finaid, Workstudy

This week I've been validating the financial aid numbers from scarf for last year. I loaded in the registration data from last year's reports into the table scarf.reg for use of validating these numbers and to have an archive of the old scarf reports. The table looks like this:
Name Type Nullable Default Comments
-------- ----------- -------- ------- --------
TERM VARCHAR2(6) Y
CRN VARCHAR2(5) Y
PIDM NUMBER(8) Y
CHRS NUMBER(4,1) Y
GRADE NUMBER(3,1) Y
REG_STAT NUMBER(1) Y

The data is keyed by term code/pidm/crn and can be used for headcounts, credit hours, grades, courses, etc.

I also been working on getting workstudy data into the scarf report. I need to report workstudy for all of last year so I've been working with Financial Aid and Payroll on getting those numbers. Currently the scarf report does not include workstudy so I've been working on a function to include them.

Posted by soukupm at 01:21 PM | Comments (0)