« December 2005 | Main | February 2006 »

January 27, 2006

Email Cleanup

I did an email cleanup this week to fix various problems with some of the baseline and custom apps on Banner Web. We had some duplicates in the class roster page, missing email links in the baseline class list, some students didn't have an email address listed on some of these pages.

I created a stored procedure called wou_email.email_cleanup on SIS that will fix these problems. It has 3 different functions depending on what problems you want to fix.
Parameters:
(1) Cleans up email addresses that have more than one preferred email address set in goremal. Baseline apps use the preferred email address to send mail so you only want 1 preferred address, otherwise banner may send the email to an incorrect address.

(2) Turns the preferred indicator on for active STDN addresses that are currently turned off.

(3) Turns the display on web indicator on for active STDN addresses that are currectly turned off.

Posted by soukupm at 08:49 AM | Comments (0)

January 25, 2006

Scarf Degrees

The scarf degree report is a job submission in Banner that saves the degrees awarded for the year in a file in the spool directory. To get the degrees for 2004-2005 school year, you would put in 2004 for the year and Y for end of year and SCARF20-60-200405-0Q.DAT for the file name.
For the most part, the report is very accurate except there's a problem in the licensure logic that I've been working on that occurs when a student receives a continuing license but doesn't have any authorizations or endorsements in Banner. Unlike the typical degrees, these licensures are stored in the table shrevnt as codes with effective dates. Authorizations are stored as 3XX numbers, endorsements are stored as 2XX, and continuing licenses are stored as 308. To get the licensures for the year, you would select shrevnt_even_code like '3%' and like '2%' with an effective date between 8/31/2004 and 8/31/2005 for the 2004-5 school year.

For the scarf degree report, we have a record for every student/license(initial/continuing)/authorization/endorsement combination. One of the conditions is that every record needs at least one authorization. If we used the code above to get the licensures for the year, we would definitely get all the students but we run into problems with the continuing licensures. Not every continuing licensure student receives an authorization in the same year. So they have to be seperated out of this group and a new query needs to run so that we collect their prior authorizations and endorsements (any authorizations or endorsements with an effective date <= 8/31/2005).

I finished the logic above and it does collect their prior authorizations/endorsements. I'm up to the point where a student doesn't have any prior authorizations/endorsements. I will label these in the report as problems that have to be manually corrected.

Posted by soukupm at 08:49 AM | Comments (0)

January 20, 2006

Weekly Report: Quickadmit Application, Scarf degree report, Powerfaids upgrade, ICS 101 Project 2

I spent the better part of this week figuring out why the quickadmit application was not working. I had to step through line by line, keeping track of variables and such, but finally narrowed it down to a value in the table sarerul. Faye changed it and documented what needs to be setup.

I've been working on the Scarf degree report this week fixing problems. Some are data entry errors, some need to be manually fixed in the file itself. I also sent the OUS second week report in today.

I upgraded Financial Aid's powerfaids database to version 11.0NG today. The old database is still in tact and they will be using it for query only since the new version doesn't allow you to query beyond 3 years. This was something that was supposed to be fixed in the software but up to this patch, it still is not available. Since the database changed, I updated their website to connect to the new database and loaded a patch so that it works correctly with the new version.

I finished up another Integrated Seminar/ICS 101 project for the provost office for data on returning freshman (attended fall and returned winter term). I wrote several functions in the wou_misc package for this report that can can be used by other reports.
f_get_gpa <- retrieves Gpa of student.
f_get_tests <- retrieve SAT scores.
f_get_hsgpa <- retrieves high school gpa.

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

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 03:21 PM | Comments (0)