« January 2007 | Main | March 2007 »
February 22, 2007
Work Report
It seems that since I moved the virtual data warehouse to Aero, the very last record seems to repeat for some reason. I spoke with Jeremy about this and he's familiar with this problem so we'll take a look at it as soon as we get access to the perl script for testing. He seemed to think it had something to do with the difference in Oracle versions.
I contacted OSU about the SSID (Oregon ID number) mod they had in Banner and got a copy of the form and the table structure. This number will be used in our scarf report and the OUS High School Transcript Database Project when it's complete. We have approval to put the mod in when we go to the new forms version around march. The SSID number will be in the Biographical tab in SPAIDEN. Admissions will enter these numbers when they receive high school transcripts.
Scarf Report modifications: Added Dual Enrollment, Non-primary Instructors
I made some changes to the scarf report this week and added dual enrollment data to it. Prior to this I was using excel to add the data since we didn't have a table structure created at that time. Last term we only had a few students but this term we're up to 30 and more than likely going to climb when other schools are added. So I figured I better get this logic in now before it creates a huge task to report them.
I added a new subroutine to scarf called scarf_instructors that gets all of the instructors for a course for the term. The reason for this change is that the old subroutine had a problem where it would only report primary faculty. I had a suspicion that the old subroutine is used in some old reports so I didn't want to modify it. At that time I didn't feel very comfortable modifying perl scripts so I built a separate pl/sql procedure to do it. But now that I have this in, it will save me some work and one less thing I need to remember to do when I run the scarf report.
I modified SZRFORN for the Business Office and added level code and it excludes credit hours from students that withdrew from classes.
I modified SZRRESD for the Budget/Payroll office and added a new parameter "report type". S is for standard report (this is the basic residency/level/credit hour report) and F is for Foreign student report (this is level/residency/rate code/credit hour report).
Posted by soukupm at 3:18 PM | Comments (0)
February 16, 2007
Work Report
Some of the things that I've worked on lately...
I fixed a problem with the minimum credit hours mod on registration because it was counting credit hours for courses that students dropped after the 4th week (rsts code 'DZ') and allowing athletes to drop below 12 credit hours.
I met with the Registrar's office to come up with a way to differentiate online courses that don't require a lab and to fix a problem where students register for a lab when it's not required (PE 131 for example). We decided to identify these courses with a course number 'E'(for electronic) at the end (so PE 131E would be the new course). These will be setup in catalog and will not have the lab requirements like the standard classes.
Labs for Honors courses were not being grouped in with the other Honors courses on the online schedule of classes. These labs didn't start or end with an 'H'. So I met with the Registrar's Office and we decided to put the word "HONORS" in the title so that these could be identified in the query. This mod is in production now.
I worked on Scarf Degrees this week cleaning up problems and I came across a problem where we were reporting duplicate records for two different endorsements (basic mathmatics and advanced mathmatics). These both map to the same cipc code 131311 in scarf and created these duplicate records when the script runs. I contact OUS about this and I'm waiting for a solution to resolve this problem (this will probably require a change to the scarf data dictionary at OUS).
I tracked down a problem where a student's transcipt wouldn't articulate in Banner and comes up with a trigger error. It turned out to be an invalid equivalent course in shatatr. It seemed to be missing parenthesis (possibly from a crash).
Since the last time Via Warp (credit card app) was upgraded, the receipts haven't been printing out correctly in the cashiers office and DEP. I spent a little bit of time and found a solution to fix this. When you print a receipt, go to page setup and set the top margin to .68 and bottom margin to 1.56 and it'll print out correctly. It seems to save this setting when you restart too.
Registration for Spring and Summer terms are setup and ready to go. Emails have been sent out this week.
Did several reports:
Seniors list with parents name and address for Alumni Association
International Studies majors for Social Science Dept
Enrolled students report for Registrar's Office (I added degree code to job submission SZRENR2 so now the Registrar's Office can run this report for themselves).
Ran SOIL report
Ran Health Insurance report for ESL students.
List of D,W,Fs for several courses over 3 years for Registrar's Office.
New freshman Fall 2006 retention report for Admissions.
State and National statistics for Registrar's Office from scarf report.
Posted by soukupm at 3:18 PM | Comments (0)
February 9, 2007
Work Report
Here's some of the things I've been working on lately:
Did a Powerfaids 10.1NA upgrade for Financial Aid last week.
Moved Financial Aid's Netpartner website off of Wolfman to Winchester with the help of Joe.
I spent some time finding a solution for storing Military leave cohorts in Banner. I met with the Registrar's Office and we plan to go live fairly soon with this solution. I'll post a blog on it when it's ready.
Fixed the SIS virtual Data Warehouse with the help of Mike Ross, Jeremy and Ron.
Verified Scarf Fall 2006 End of term report.
I'm currently working on the Scarf Degree Supplemental Report 2003-2006.
Did several reports:
Pychology Grads report for Psychology.
Earned Hours report for Admissions.
Added Spring and Summer terms to the online schedule of classes.
Schedule of classes report for Provost Office.
Health Insurance report for Business Office.
Sent Clearinghouse report for Winter term.
Health Eduction degrees report for Education.
Ran Department of revenue report for Feb.
I added a new function to WOU_MISC for getting parent's names (f_get_parents_name(p_pidm,p_relation)) while I was working on a graduation alumni report for the Registrar's Office.
Posted by soukupm at 3:07 PM | Comments (0)
February 7, 2007
Virtual Data Warehouse
The Virtual Data Warehouse is a program that we use to provide real-time student data for our SIS BI-Query clients on campus. It's a fairly complex process that involves both our local DB server (as a listener) and our remote SIS database. It uses embedded perl code to fetch real-time data from the SIS database. It recently broke and since a few of staff and I spent a good amount of time trying to get it going again I figured I'd write up an overview and some technical notes on how it runs. You can find the documentation and a backup of of important files in this directory: I:\Programmers\Banner SIS\oracle_obj_srvr\
Posted by soukupm at 9:33 AM | Comments (0)
February 1, 2007
SZRADMT - Admitted students by Term/Level
I finished up a new job submission for Banner this week called SZRADMT. This report will mostly be used by the Admissions Office but could be used for other things too like getting a count of new admits for the term. The output looks like this:
V
Vnum,lname,fname,mname,admit code, admit decision, rate code, cohort_code (for tuition promise), end term (for tuition promise), and enrolled for the term (Y/N).
Posted by soukupm at 11:04 AM | Comments (0)