« November 2006 | Main | January 2007 »
December 28, 2006
Work Report
Here's some of the projects I've been working on for the past 2 weeks.
Scarf - We had a few instructors using a "W" grade for some students this term which is not a valid grade option. Somehow the mod that we had on the grading package wasn't working correctly so this will need to get it fixed by next term. For now, I need to wait to finish up the report until the instructors submit new grades for those students.
Fixed a problem with the term gpa for SZRACAD.
Moded transcript and articulation packages so that the confidentiality link opens up in a new window instead of the current window.
Worked with Ron getting the dept_data folder permissions fixed (should be finally fixed now).
Sent in last clearinghouse report for this term.
We can now use cougar.wou.edu as the smtp host for our email apps in Banner (it's working again now).
Ran labels for health center for new winter term students, sent a report of enrolled students to the Dept of Army, wrote a report for top 10%, top 7.5% gpa for Phi Kappa Phi.
I did a non-standard update to sfrstcr to update records for students that were registered for the new campus code 6 and 7 courses (used in new mreport swrrep3). Since students that were already registered for the courses prior to the catalog changes, it was using the old campus codes and they needed to be updated so that SWRREP3 would work correctly for winter term.
I moded SWRREP2 and SWRREP3 so that the report name appears at the top of the page when you print. I removed the requestor text and added campus code to SWRREP3.
I moded disability service's servicematch app so that it displays the full vnumber instead of the 4 digit truncated number.
I'm currently working on some discrepancies with academic history when a student's status is changed to "RA" (Academic Suspension/Reinstate).
Posted by soukupm at 12:56 PM | Comments (0)
December 15, 2006
Work Report
Things have been really busy lately and I was out sick last week so I haven't had much time to keep up with my blog lately. But here's a list of things I've worked on the past two weeks.
I had to rerun all of the scarf finaid resubmissions last week because of currupted files. For some reason when I transferred them to the server, part of the files got truncated and caused the script to calculate incorrectly. The only way I could fix this was to delete all the copies from the server and upload the files again and rerun the script. These are all complete now and I sent a copy to OUS. I just need to verify the numbers now.
I spent a great deal of time working on the College Board questions with Nancy. I used some of the scripts in the developer.cohort,developer.provost.common_data_set directories along with the research tables I created last week to answer the questions. I also wrote several scripts to complete some of the questions which we didn't have a script for. Right now I have them stored in my directory in a "sql/projects" folder. Here's a list of them:
College Board - number of class sections with UG enrollment (also includes sql for subsections).
IPEDS student life (F1) questions - This has code for full time freshman cohorts and undergrads. There's lots of sql in this script and covers items such as students living in the dorms, living off campus, average age,age 25 or older, non-residents.
IPEDS count of freshman completing year in good standing (B24).
IPEDS graduation rates
online courses
There's many other scripts I wrote within the last month or two to answer some of these IPEDS questions. These are all stored in my sql/projects folder.
I worked a lot with Ron trying to diagnose the utl_file problems with the finaid admissions load application. I think we now have this solved as long as no one deletes the FINAID_LOAD.CSV file or changes permissions.
I updated the term code for email_update_from_reg_admit cron.
I added a primary key to the scarf.reg table to speed it up a bit. The primary key is term_code,crn,pidm.
SCHOL_LETTER job submission mod is now in production. It's using the new scholarship criteria for this year.
I rewrote the president list and honor roll scripts so that they use the function wou_misc.f_get_address for addresses now. The old scripts only used 3 address types and sometimes left a student off the list because they didn't have a 'DO','LO','CU" address type (I had to manually add students after I ran the script).
The new version of banner bookshelf 7.3 is out on our website now.
I got a question from OUS about an increase in enrollment for female grad students this term (roughy 50% increase). I traced it down to some grad level courses that were offered this term (crn 11333 with 163 students enrolled and crn 11334 with 75 students enrolled). The increase is legitimate, but it sure shot up a red flag for them.
Posted by soukupm at 10:32 AM | Comments (0)