« May 2007 | Main | July 2007 »
June 28, 2007
TGRFEED
I noticed in a test of the feed that the fdoc numbers started over back at 1 instead of the next number from the last feed in the sis database.
Looks like when finance is installed, tgrfeed is written to do things a little differently.
Fdoc numbers and state 1099 numbers come from fobseqn.
There is also a grant billing that gets done.
Posted by wendlerb at 11:17 AM | Comments (0)
June 27, 2007
Tuition Calculator
We were able to get the source for PSU's tuition calculator. I was able to modify the source to fit the WOU model by adding a choice for the promise. Our Web master then put in in the WOU template and it looks pretty good.
Posted by wendlerb at 8:15 AM | Comments (0)
June 18, 2007
BS Information Systems
Four years ago my wife talked me into going back to school for a post bacc degree. I didn't do it kicking and screaming but it was pretty close. It was one class a term while I worked. One term I did two math courses and that was tough. Never thought I'd be taking college courses with kids less that half my age. Anyway, it's nice to have a degree in the field I'm actually working in now. It's a long way from a biology degree in liberal arts and sciences as well as the masters in oceanography. None of it would be possible without support of wife and kids and an institution that allowed me to work and go to school. So, thanks everyone.
Posted by wendlerb at 2:42 PM | Comments (0)
June 13, 2007
SWBUGLF cont
Need to make sure fabinvh_match_required is set up with a default of 'U' or else FWRAPAY errors out on an insert statement. Sucessfully ran feed in wouupg. Removed the creation of the report zjrbaas along with copiying to archive. This is a report created by EOU. In the future, posting has to be going before swbuglf us run. Otherwise Fgrtrni won't do anything.
Posted by wendlerb at 2:50 PM | Comments (0)
June 11, 2007
SWBUGLF
I have a combined SIS/FIS filw that I've put in the woux path. Kicked it off this morning and looks lik the SIS half ran ok. I've run into problems with the set up of the FIS jobs for job submission on wouupg. Either the files not there or the object is not created, I had Jim move over the exe and obj files to woux. Need Faye to create fwriapp and fwrckno objects and access on wouupg. We also want this created on wouprd so it comes over in the merge. Have to talk to Jim about how to handle the directories.
Posted by wendlerb at 1:42 PM | Comments (0)
June 7, 2007
IDTS Status
IDTS is the OUS wide project to transfer high school transcripts from the high school to the college via EDI. Overall, the high school sends a transcipt that goes to an OUS sever which in turn sends it to an EDI server in Texas which sends it to us. The second part of this project is a Bi-Query model (IDTS) that lets you query high school transcript records. Here is where we are at today:
We have sucessfully recieved a transcript sent from an Oregon high school via EDI.Smart and sent an acknowledgement. These will show up with Nathan's normal college transcripts.
I have installed the model tables locally on aero and have sucessfully loaded them with test data from OUS. We are in the process of setting up a nightly cron job to do this automatically. The Bi-Query model is on the V drive next to the others. The connect file for it is aero.con This model uses Bi-Query version 9.0.1 and will not work with older versions. Currently, Dorothy is the only user with the 9.0.1 installed. Let me know who will be using the IDTS model and we'll install 9.0.1 on their machine. The HR and FIS models still require 7.0 OSU is looking for someone to inspect the quality of the data for the next month or so.
Posted by wendlerb at 9:08 AM | Comments (0)
June 4, 2007
Szrsoil
The CLM database is on a Microsoft SQL Server 2003 box. This makes it a huge pain to generate a soil file. I have to start query analyzer to run a script to grab the data, save it, and move it over to an Oracle table under wouprd. Szrsoil is the program to generate a soil file sent to the state. The logic in it deletes the records off this szasoil table for a particular ssn when a delete record case happens. This was a pain because I can't rerun the program to pick up the deletes more than once. So I created another table called szasoil_deletes so at least I can put them back if need be.
Posted by wendlerb at 2:04 PM | Comments (0)