« June 2007 | Main | August 2007 »
July 30, 2007
Employee sequence reset
Need to remember to delete the table pwbpark which is the one for payroll deduction. Otherwise you get constraint violations.
Posted by wendlerb at 3:13 PM | Comments (0)
July 25, 2007
CAS/Atlas
There are new tables and packages going into wouprd in order for the program catalog to work. The fll under cassmgr schema. It rquires tables named the same as banner tables but is specific to cassmgr. In addition, the program uses the existing compliance pipes. Sfrpipe has been modified to handle this with OSU code. I'm attempting to test in woutst on just a regular compliance to make sure it didn't break it.
Posted by wendlerb at 11:43 AM | Comments (0)
July 23, 2007
Ofax stuff
The ofax stuff has been giving me fits. I was having problems with inserting mutiple reocrds in the table ryrofax. At first I just deleted all records for a parameter entered term code and then reloaded the term with each szpofax run. This caused problems when doing a back term. You can't pull matching data from Chemekada for the prior term unless they first load it in ofax.
So I tried looking for an existing record and inserting if it didn't exist or just updating if it does. Had a heck of a time matching the temp table course and number to the ryrofax course and number. Turned out blank characters causing problem so rtrim seems to have solved. The 00 in 003209 is still sometimes there and sometimes not.
Posted by wendlerb at 9:41 AM | Comments (0)
July 12, 2007
Tuition Promise - rollover cont
Ok, I made a trigger off of sfrstcr instead (sfrstcr_insert_row). It is a pre-insert trigger that I hope doesn't foul things up. I tested it on myself in woudev and the trigger fired and put the BAS08 rate code in but I didn't do a fee assessment properly. Might be because BAS08 rate insn't set up in woudev. I will have to wait for a refresh before trying some more.
Posted by wendlerb at 8:22 AM | Comments (0)
July 10, 2007
Inactive student accounts
Phase I of inserting new sgbstdn inactive record on graduated students completed in wouprd.
Posted by wendlerb at 8:42 AM | Comments (0)
July 9, 2007
Tuition Promise - rollover
I was looking at some of the endterms populated this term and saw that the closest term was 200803. Started thinking about what happens if studen takes a class in 200900. Current process, szpexpp, only picks up students past their endterm who registered for 200900. Problem is that if fee assessment is turned on for web reg, they initially get assessed at old rate (BAS07). I can't tell anysooner with a job submission program. So I started thinking I need a pre insert trigger on the tablr sgbstdn that checks to see if current term is past the endterm and if so insert the next rate.
Still need to increment a new szrchrt record as well and probably think about adding new cohort code as well.
Update: Doesn't work. Sgbstdn only gets inserted by user manually. Tried sfrstcr and that won't work either. Can insert new cohort code and endterm but not rate.
Posted by wendlerb at 1:40 PM | Comments (0)
July 2, 2007
Web Drop
Business office mentioned they were getting a lot of calls of people trying to drop last class. Web is set up to not let you do this depending on setting in gtvsdax. An error message shows on bottom of page but students didn't notice it. I added a pop up box to p_dropcrse in BWCKREGS. We already moded this to allow drops with fee assessment enabled anyway.
Posted by wendlerb at 10:38 AM | Comments (0)