« November 2006 | Main | January 2007 »
December 28, 2006
Cron and Sleep/Wake
Look - Cron job that moves shrediy output out of jobs directory and into approriate locations on spruce.
FTP - Corvallis job to handle ftp
Wouwrlss - Cron job that notifies students and telecom when their wireless service expires.
ABHolds - Cron job that places Account Balance holds on student accounts.
Gwrclen - Cron job that cleans inactive records out of various tables.
Sfrpini - Cron job that launches 3 pipes for Capp
Sgrsprt - Cron job that list athletes with less that 12 hours
Shredir - Cron job that loads acknowledgement of EDI transcript into Banner.
Shrediy - Cron job that outputs EDI transcript files
Smpcprg - Cron job to to purge students' records from the CAPP tables of a degree audit.
Swbrdll - Cron job to load direct loans
Swbrdll_notify Cron job that notifies direct loan resultd
Swbrpfd - Cron job to load powerfaids
Swbuglf - Cron job for nightly FIS feed
Swirbut - Cron job for budget report
Swiurch - Cron job that creates research table
Swrardf - Cron job that list web address changes
Swrrep2 - Cron job that creates m report
Swrrtrl - Cron job that creates nightly transcript log
Swsprdl - Cron job to track spriden deletes
Swwxweb - Cron job for web section tally tables
Szasftp - Cron job that ftp files from SmartEdi to spruce
Szfafsa - Cron job to load fafsa on file table for Ryaofax
Szpsftp - Cron job to ftp Shrediy files to SmartEDI
Szpofax - Cron jon that loads ofax data into banner
Szpvpad - Cron job to update HR VP address records from SIS
Szrbads - Cron job that lists SSN records with null spriden change ind
Tgrclos - Cron job to close cashier sessions
Pinmail - Sleep/wake that emails password for change in student web pin.
Swbrchk - Sleep/wake student check
Swrrsc2 - Sleep/wake student schdule pintout
Posted by wendlerb at 10:18 AM | Comments (0)
December 26, 2006
Back from vacation
Seaside was great. We weren't sure we'd get in on Monday because power was out along the coast from the storm. It was slick going over on 26 and you could see several spots that had a lot of falling trees. First thing that happens is we get to do the fire drill dance. This is the 3rd time I think. Anyway, Tuesday was great. We walked the beach and it was almost spring like. Next night we got the big storm with our chairs bouncing around the deck out on the 7th floor. Christmas was good and the load wasn't quite as bad as I thought back here at work.
Posted by wendlerb at 2:45 PM | Comments (0)
December 15, 2006
Tuition promise (cont)
Set up 3 table tiggers (saradap and sarappd tables) into production because I found updating data on saradap and inserting a record into sgrchrt to be a big headache after the fact. So, 200701 UG residents are getting BAS07 rate and put in TP07 cohort.
Started coming up with some logic for program to deal with students when promise expires. Created a tablr prom_term to help calulate number of terms since admit decision. Transfer students are unique in that you have to figure out how many terms they're entitled to depending on the hours transfered. Once they go past the 4 year limit, they are supposed to go up 1 year at a time. 5 year students are still a question.
Posted by wendlerb at 2:01 PM | Comments (0)
December 12, 2006
Fwpchkp
We've had an issue with AP checks and multiple invoices for a long time. Every once in awhile the listing of multiples repeats itself on the check printout. Never happens consistently. The check amount and totals are fine. We put the mod in to handle multiples so they'd print out so it's definately our problem. I don't know why I would have tried just using a distinct statement in the select. I have a feeling I did and it caused some other problem but I will soon know. We tried it out in wotr and it seemed ok so I'm putting into production.
Posted by wendlerb at 10:25 AM | Comments (0)
December 5, 2006
Credit Card - Touchnet
Corvallis ETS has decided to go with a Touchnet Payment Gateway to replace the iPayment server thet are using now. They should have a test server set up some time in January. This is necessary because right now Banner only unofficially supports iPayment and doesn't even have documentation for it.
For us it means some changes to the student web credit card setup. Mostly this will be parameter settings and gtvsdax settings. There are some mods to packages that I'm not sure yet how they will need to be changed.
The admissions app will have some changes as well. Looking at the Banner baseline code for TPG, it looks like the returning authorization string is the same. Jpay still gets called so the building the url may not require much change either.
Posted by wendlerb at 9:50 AM | Comments (0)