« SWRCRBK Course bank file | Main | New views for SIS Biquery model »
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 April 12, 2007 10:18 AM
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.)