« Weekly Report | Main | Weekly Entry #1 »
August 19, 2005
Weekly Entry #2
I finally figured out the major problem with the scarf degree report. It has to do with the table stvmajr, which holds all the codes for majors and minors and several other fields. After querying this table, I found that none of the minor codes have a cipc code. And several other majors and concentrations don't have cipc codes either. I'm working with Nancy and Faye to get those entered and then I'll send another report to OUS this next week to see how many errors this fixes.
I ran a report for Marilyn today that creates a data file for health insurance for students attending fall term. The process takes quite a while to run because you have to connect to the object server and type in a query, save the output to a file, run a sqlplus session, run another query, run a perl command to clean up the files, ftp the files to a unix computer and run another perl script, then ftp/or email it to a windows computer and import into excel. I think you get the idea...
Seems like a awful lot to do just to get an excel report. So I'm putting this on my list of things to re-code when I get some free time.
Posted by soukupm at August 19, 2005 02:59 PM
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.)