« March 2006 | Main | May 2006 »

April 27, 2006

Weekly Report

This week I worked on various degree reports for the Registrar's office for teaching and non-teaching degrees, health & PE majors, and several lists of minors.

I spent some time figuring out how the cascaded style sheets work in Banner Web so that we can modify how some of the reports display for the Capp degree evaluation and the overall appearance. I'm going to write up a readme file on how to upload the files and some helpful hints on what to look for when your trying to change a certain elements in a report.

I added a new function, f_get_degree that returns a student's degree in the wou_misc package. I needed degree info for a report that I wrote for disability services this week but this function can be used for anytime we need a quick report. :)

I worked on the minimum credit hour mod and fixed a glitch where it was allowing students that already had less than 12 credit hours to go ahead and drop more.

Posted by soukupm at 04:16 PM | Comments (0)

April 21, 2006

Weekly Report: Credit hour report, mreport (job submission)

There's a credit hour by subject report called prov_year_4trm_ch.sql under wou_common.provost that Jeremy recently modified and another one called prov_year_4trm_ch2 that breaks credit hours further by course level. I ran it a few times this week for HR but depending on the usage of this report, I might put this job submission.

The mreport in job submission seems to have been broken for a while because a schema and temporary tables were missing for some reason. I had Jim restore them today and the report seems to be working.

I've been working with BIQuery Admin lately to get more familiar with creating a data models. So far I have a very crude SIS data warehouse that uses the banner tables directly. Performance seems to be very good compared to the virtual warehouse but its missing a lot of the data/queries that the virtual warehouse does. I'm going to continue working with it when I have time and try to improve it.

Posted by soukupm at 04:10 PM | Comments (0)

Scarf meeting

I went to Univerity of Oregon yesterday for the Scarf meeting. It went pretty good and looks like there's going to be a few changes that will be needed for the script when summer comes around. Some of the changes have to do with the degree file. I'll have to add new columns for Name, SID, SSN and birthday. These will be used to better identify students in the OUS warehouse. There will be another change that will occur when we upgrade to Banner 7.3 or higher. SCT is changing the Race/Ethnicity tables so that it matches the federal 2 question Race/Ethnicity format. Once this comes into effect, I'll have to start reporting it in the scarf report.

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

April 14, 2006

Weekly Report: honor roll, pres list, residency list, etc

Some of the things I did this week:

I updated the Honor Roll List (hr_senate.sql) and President's List (pres_list_senate.sql) so that they now include Geographic Origin "GO" addresses and changed the order of addresses to PR,LO,DO.

Updated Powerfaids to 11.1NE, update Edexpress 2006-07 to version 2.0.

Changed a bunch of web links that were going to banner web via http when they needed to go to https. This also affected some custom apps we had. These are all fixed now.

Updated wou_misc.f_get_address so that it now accepts 4 address types. The 4th parameter defaults to null so you actually don't need to put 4. I did the same update to wou_misc.f_get_phone_no.

I wrote a query for financial aid to display the number of residents, non-residents for first time freshman and residents, non-residents for all students over multiple terms.

Transfer Articulation and Transcripts are now in production.

Submitted OUS 2nd week report and Scarf report.

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

April 12, 2006

Transfer Articulation and Transcripts for Faculty,

I changed the way error conditions were being displayed on the transfer articulation so that they can be easy modified through web tailor if needed by using the built-in function of Banner. A good example on how to do this in your code is in the package wou_trans_art (look for the word "error"). When you encounter an error condition, it'll look in information text table (twgrinfo) for that error condition and display the text. To add these error conditions, go into the wtailor menu and select "Customize a Set of Information Text". Then select the procedure you want to modify and add a new entry.

We're just about ready to go into production on the Transcipts for faculty. This is a baseline web app (bwlkftrn) with a few modifications so that it only allows current advisors to view student's records, checks confidentiality, and checks for holds. This web app displays a lot more information than the currently used transcript app in production. Some of the items it displays: changes in major, degrees, attempted hours,passed hours, earned hours, quality points,level, academic standing, and in-progress courses.

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

April 07, 2006

Scarf Workstudy, szrgrad, transfer articulation and transcripts

This week I wrote a procedure that collects the workstudy numbers for the scarf report (wou_scarf.p_workstudy). Its using the DB link to aero to get access to the workstudy table and collects the amounts that student's earned for the term.
I moded the SZRGRAD report so that it now accepts a level code for students. You can use 'UG','GR', or % for all students.

I made some changes to the transfer articulation and transcript pages for faculty on the test server. It has logic built in to give access only for primary advisor for the student or the advisor's department. But after meeting with the Registrar, we're going to allow all active advisors to view them. These just need to be quickly tested and they'll be ready for production.

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