« March 2007 | Main | May 2007 »

April 27, 2007

Tnsnames and Osshe domain expiring

The osshe domain name will expire on july 2007. We updated the tnsnames on the v: drive to reflect these changes. If anyone has a local install of the Oracle client, they may need to update their tnsname.ora file and change it to ous.edu or just copy it from V:\BIQuery\orawin6b\NET80\ADMIN

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

April 20, 2007

Directlending Cron

Last week the directlending cron stopped working. I believe it may have had to do with permissions and/or drive mapping not occuring. I got it fixed now and added some new debugging code that writes more information to a log file just in case it stops working again. The log file is in J:\Financial_Aid-Business\directlending.

Posted by soukupm at 2:22 PM | Comments (0)

New views for SIS Biquery model

I created 3 new views for our new SIS Biquery model.

Term_enrolled - List of distinct students enrolled for the term.
Term_admit - List of students admitted for the term.
Term_appls - List of applicants for the term.

Posted by soukupm at 2:18 PM | Comments (0)

April 12, 2007

Report for the week

I finished up the winter 2007 end of term scarf report and loaded the registration data into the scarf.reg table. There was a problem with the dual enrolled students at the end of the term because the ryrofax table was being switched over to the new term so data on them was lost. So I added some new logic for the dual enrolled students query so that it if it didn't find data for the student in ryrofax, it would get it from the attribute table sgrsatt.

I worked on another OUS report for athletic aid for 2005-06 enrolled students.

I added some new code to the schedule of classes so that it would not display fees for CEOS courses.

I ran a non-standard update on GO and PR addresses that had missing county codes if the state = OR and zip code was present for scarf report corrections. The code for this is in wou_scarf.p_fix_county. It does a match with zip codes from the table gtvzipc.

Powerfaids upgrade to 12.2NB for Financial Aid.

I made a small adjustment to the db_compare script for the consolidation project so that it included all schemas on both systems (SIS and FIS/HR).

The data warehouse for SIS stopped working this week because of a new patch to oracle that was done during the OSU monthly maintenance. I worked with Jeremy and Jim on this but we didn't resolve the problem. Being that we don't have an expert on campus to support and maintain it, Brian and I are working on a new solution that uses views and the functions that I wrote in the wou_misc package. For the meantime, I'm writing the reports that admissions needs until this new BI Query model is semi-complete.

I fixed a problem with the schedule of classes where courses with duplicate crns would lose the Saturday and Sunday meeting days.

Reports I worked on:
Clearing House W07,SP07
Degree Verify W07
GPA list for Phi Kappa Phi
Fall 2006 readmits for Registrar's Office
Winter 2007 grade statistics broken down by department and division for Registrar's Office
W07 Courses with 0000 division for Registrar's Office
Hawaii admits for Admissions
Honors admits for Admissions
Ethnic admits for Admissions

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

April 6, 2007

SWRCRBK Course bank file

I put a new job submission into production called SWRCRBK. This job submission creates a flat file to be used with the CAS system (for Atlas). In essence, it outputs all of the active courses we have defined in Banner. It was originally written by OUS but I modified it a little to work with our data.

Posted by soukupm at 11:36 AM | Comments (0)