« March 2007 | Main | May 2007 »
April 27, 2007
CAS online
Course Applicability System
This is the development site for Atlas Right now we are overriding the articulation to point to the wou web articulation package. Eventually we need to load the courses into their database. Supposed to be a meeting next week via phone
Posted by wendlerb at 1:46 PM | Comments (0)
April 24, 2007
Grad Plus Loans
A new loan type has sprung up and the first time it went through the direct loan load process it went on every load giving multiple records. I investigated and found the detail code field on the direct_pre_memo table wasn't getting populated when swbrdll runs. Therefore, it wasn't matching to the record already on memo and would load again. It turms out this new loan has a new loan type G. There is no crosswalk for it on direct_type_xref table so I added it. Type G now crosswalks to a new detail code FDLG.
Posted by wendlerb at 2:09 PM | Comments (0)
April 19, 2007
Email on student web
There are several web for student forms on the faculty menu that have an email button associated with each person on a roster. These are packages bwlkadvr and bwlkfcwl. These fill in the to field header on an email with the student's email address. The problem is that the default email client on the machine comes up which may not be supported by UCS. I modified the forms to display the email address on the form.
Posted by wendlerb at 1:52 PM | Comments (0)
April 18, 2007
IDTS
IDTS
Corvallis sent us a preview of the biquery model they designed for the electronic high school transcripts. I set up the tables behind it on Aero and gave it the IDTS scheme. Had to do a little editing on the model to change the database name on all the objects.
Posted by wendlerb at 10:36 AM | Comments (0)
April 17, 2007
SIS BiQuery Model
Mike and I came up with a fairly basic sis model for BiQuery since we were having so many problems with Jeremy's old one. We have an accounts receivable module and a admissions module. Admissions has been most affected by the loss of Jeremy's model so we used his functions and logic to create views on wouprd and then brought them into the model. The user logs into wouprd using normal Banner password.
Ran into some problems with access for normal users so ETS had to grant these users additional priviledges than normal. Found they could see a table with no problem but couldn't see a view. Response time to the admission piece has been much quicker. Using th sis spriden view slows things way down since there is no way to join with the compiler hint. Suspect this won't be a problem after the database merge.
Posted by wendlerb at 8:39 AM | Comments (0)
April 13, 2007
Shrediy prob
Shrediy hadn't been working as a cron job for quite a while. Found that out this week. Tried several things to get it to work. The problem is using sysdate in the address date parameter when running from command line like a cron job does. Running out of job submission directly works fine. I had to modify the source to handle sysdate as input.
Posted by wendlerb at 9:59 AM | Comments (0)
April 12, 2007
GJAJOBS
The gjajobs.com is different between FIS/HR and SIS so we will need to merge them. It was suggested at the last consolidation meeting that we keep seoerate files for each system which would get run depending on the job. This was turned over to WOU programmers because of time constraints. I merged both into one and have run it on wotr and woudev ok. Will try some checks.
Posted by wendlerb at 2:14 PM | Comments (0)
April 9, 2007
Banner problems this am - student checks
Banner was freezing up during logins starting around 8:30 am this morning and ETS had to restart the oracle listener several times for banner. Looks to be related to the listener on Aero which gets hit everytime someone tries to get into the student warehouse. Looking into Aero logs.
In the meantime the business office ran batch student checks before we figured out what was going on. So I had 22 student checks in la la land. The process completed but made a 0 block lis file. I looked further and found these records stuck in the collector table TGRZCHP. I had to temporarily modify the check program to comment out the sessionid stuff on the collector select. Then I ran the program to create the list file and then went into the tgrzchp table and removed the records manually. Reset the code back and things appear back on track.
Posted by wendlerb at 2:27 PM | Comments (0)
April 4, 2007
Ryaofax
I've changed the load to include multiple terms and have tested it out ok. Not sure yet if our community college is inputing multiple terms on their end.
Posted by wendlerb at 11:26 AM | Comments (0)
Web grading
I've added a menu choice to the faculty menu to maintain the web grade change request queue. I've given access to it to user roles registrar and webtailor.
Posted by wendlerb at 11:24 AM | Comments (0)