« October 2005 | Main | December 2005 »

November 22, 2005

Weekly Report: Swarous Report

I spent a little time this week figuring out how the swarous report worked, what tables it was getting the data from, and so on. This is a report that displays admissions statistics such as ethnicity, resident, non-resident, international and then further broken down by grade level,etc. The last page of this report tallys the undegraduate transfers and supposed to give the number of students transferred from OUS institutions,Oregon Community Colleges, Oregon Independant, and Out of state. But for some reason, the majority of students were grouped under "Transfer source unknown". After looking further into the code, it uses the tables sobsbgi,stvsbgi,sorpcol and some decoding logic to determine if its an OUS/Oregon or out of state college. The table sobsbgi contains the location of the institution. This is were the code is failing to determine the location because few institutions are populated with state codes. The table stvsbgi contains the type of institute and description. And the table sorpcol matches the student to the institution in stvsbgi.

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

November 18, 2005

Weekly Report: Fix County Codes

I wrote a procedure this week that will fix the "GO" addresses that have null county codes for the scarf report. There's a table in banner called gtvzipc that contains a crosswalk for zip codes,cities, and counties. I used this table to match up the county code by using the zip code and city from the list of null county addresses. Banner automatically adds the county code if the zip code is within Oregon but for some reason these records never did.

Posted by soukupm at 02:48 PM | Comments (0)

November 17, 2005

Weekly Report: Class Email List, Scarf Data Warehouse

I wrote a web app that displays student email addresses from Banner based on term code, subject and course(optional). It'll be used mostly by the Liberal Arts and Sciences Office, UCS and staff. The app is pretty straight forward. If you want an email list of all students taking a Psychology course, just type in the term code and the subject code "psy". If you want to get specific courses number, you can type in a course number to display only students taking that course "psy" "101".

I started loading the scarf registration section into a table (mini scarf data warehouse) in Banner so that I can run queries on the data for the budget office for a credit hour report. Eventually, I'd like to have the entire scarf reports stored in the database so that we can look back at the data we've sent. Some of the data would be redundant with the current research tables we have, but there's a lot more information in the scarf report, especially data on courses,faculty and financial aid.

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

November 14, 2005

Weekly Report; Wue report, banner web roles

I spent the greater part of last week working on the Wue report for admissions. This time I added transfer students to the report along with their gpa and hours earned. There was a few bugs with the test scores that I fixed (handling of null values for test scores, matching correct test scores). I also optimized the test score code so that the lookup is a lot quicker. I had to change the entire report from comma separated values to pipe (|) separated values after finding a few commas in the data that was displaying.

I added the Wue report to banner web and created a new role called admiss for the admissions staff. To add a new role, you just have to insert a new record into the table twtvrole. Once that's done, go to the customize web menu or procedure option and select the procedure you want. Down at the bottom, you should see your newly created web role down at the bottom where it says associated roles. Just check the box, and now only the people belonging to that role will be able to run the program.

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

November 04, 2005

Weekly Blog: Web Registration, Medical Holds, Email Update

I loaded the web registration groups this week for winter registration. That all went fine except for a few email addresses that bounced back. I had the registrar's office send those back to me so that I can update them. It seems that the email notification automatically grabs the next best email address if they don't have a preffered email address set. When I add them to Banner, I always set this flag since this is the address we want to use. So if there's a bounce back, chances are their WOU email address is not in banner.
I loaded medical holds for student health services and ran labels for them for winter term.
There was some last minute changes in the WOU directory, so I ran those through for Telecom and TRC.

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

Weekly Report: Scarf, Wue report, ICS 101 report

This week I worked on Scarf 4th week report. There was various problems with it as usual but 4th week seems to be the hardest to correct because you can't just simply rerun and new report (4th week is a snapshot, 1 time deal). The only way to correct them was to manually edit the file and do lots of copy and paste. And I did tons of those, including fixing problems that were caused by fixing other problems.
I met with admissions to go over what I had so far for the WUE report. Its looks like what I got so far is good. I need to add a few more test codes to the list and change the logic on which test scores to pull.
I finished up the ICS 101 project from the provost office. I have a prior blog on this that describes what it does.

Posted by soukupm at 10:55 AM | Comments (0)