« Weekly Report: Faculty Transcripts, Minimum Credits for Athletes, New version of Powerfaids | Main | Weekly Report: Quickadmit Application, Scarf degree report, Powerfaids upgrade, ICS 101 Project 2 »
January 13, 2006
Weekly Report
Since the recent holidays and the term starting, I fell a little behind on my weekly reports so I'll list them all on this blog.
I've been working on fall term scarf report getting all the corrections made. It seems that the report is not counting the correct financial aid offered amount and only counting what has been disbursed into banner. So I met up with Financial Aid and we've been working on a solution to get the numbers I need for scarf. I wrote a script scarf_fincat.sql that outputs a fixed format file with vnumbers that financial aid will load into powerfaids so that they can run a report off of only those vnumbers. Also, I'm having the business office double check the financial aid detail codes from banner to make sure I have all the codes listed in the scarf-xwalk table so that we're getting all of the financial numbers.
I'm also working on scarf supplimental degree submission. This year OUS wants all the degrees from 2003-summer 2005. This will take a while to get all the problems corrected for this amount of students.
There's a problem with the quick admit application on the web that I've been trying to resolve for the past 2 days. It should return with a signature page but it comes up with a "page cannot be found" error page. I have it traced down the procedure sakqadm.p_quick_admit and I'm going through line by line to find out where it's failing.
I wrote a script for financial aid and the business office that will display a list of students that have less than 12 hours and received aid. It'll be used prior to the start of the term to identify those students.
I loaded a new version of Edexpress and a patch to the new powefaids for Financial Aid. We tested the Admission load from Banner and it works great. Financial Aid plans on going live on the new powerfaids next week or so.
Other work done during the holiday:
Wrote a job submission szrcnsc that reports the cancelled sections by term,division and subject for LAS.
Reloaded the faculty transcripts back on woutst (from a refresh) and made more mods to it.
Reloaded the 12 credit minimum mod to registration, made a few mods. Just need to fully test it before putting into production.
Moded the job submission swkrpst so that it now accepts part of term 5 and 6.
Added 2 more entries (SATV,SATR scores) to biquery model for wouprd virtual data warehouse for Admissions.
Wrote the rest of the code needed to get the transfer articulation to work for faculty. I added the same mods to this app as the faculty transcripts so that it checks the status of advisor.
Fixed the job submission swirbut so that it now agrees with the credit hours that scarf reports.
Posted by soukupm at January 13, 2006 03:21 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)