« August 2005 | Main | October 2005 »
September 30, 2005
Staff search on the web
"Why am I not showing up on the web search for faculty?"
The package which handles this is sitting on Aero under the directory schema. However, the data comes from a load which takes place that gets data from Banner and puts it on a local table. This is located in WOU_WEB schema. The key components to the load are such that the person must have a SC address type record, a non_terminated pebempl record, and a primary nbrjobs record with no end date or a future end date. Until they do, they will not show up in this search. So until HR finishes up with their setup, new employees won't show.
Posted by wendlerb at 11:34 AM | Comments (0)
September 29, 2005
Powerfaids problem
Discovered that when two records are loaded into the direct_pre_memo table for the same pidm with identical detail codes and a record already exists in tbrmemo with the same detail that's been zeroed out, the load proocess did one of two things. I believe it updated the zeroed out record with the new total and inserted a new tbrmemo record with the new total at the same time. The net effect is the person has 2 records in tbrmemo with aid instead of one. This is a load problem and unrelated to the online aid release. I looked at the code and selected a sum(amount) in the pre_memo select in SWBRPFD. This caused a problem the next day load because there's an update direct_pre_memo statement in there which matches each record in pre_memo with amount. I commented that out so hopefully both records will get updated and program won't bomb.
Posted by wendlerb at 3:25 PM | Comments (0)
September 28, 2005
Spaiden - Non person
This caused all kinds of problems. Put mods back in.
Posted by wendlerb at 3:53 PM | Comments (0)
September 22, 2005
Spaiden Non-person
It looks like mods to GB_IDENTIFICATION package were not needed. We could not generate a non-person correctly on this form. The V# ended up with a spriden_change_ind = 'I' no matter what while the person generated id stuff worked fine. The insert table trigger on the spriden table works differently on person vs non-person so I thought it was that. However, it's set up to expect an id beginning with X and handle the rest. The generate id code was commented out of the 6x spaiden form. All that got moved to the package GB_IDENTIFICATION so I figured it needed to be commented out there as well. It turns out commenting it out caused me a lot of extra code in DML_SPRIDEN and it actually works ok anyway. So, GB_IDENTIFICATION is back to baseline with the generated_id code in and DML_SPRIDEN is much closer to baseline. Non-person generated ids now works.
Posted by wendlerb at 2:01 PM | Comments (0)
September 20, 2005
Training
I've taken a class or two each term for the last couple of years in Wou's Information Systems program.
Posted by wendlerb at 1:19 PM | Comments (0)
September 19, 2005
Merrit increase
We successfully used mass time to push out the merrit increases retroactive to the start of the fiscal year. I had to mod the pzpltim program a little bit to add more sequence possibilities and Sally had to use codes which did not error out on phrderr report. I'll probably just leave the changes in there since they aren't hurting anything.
Posted by wendlerb at 2:10 PM | Comments (0)
September 16, 2005
SZZDCRV
Admissions needs to change an admit decision once in a while and the baseline form does not allow this. I created a mod and renamed the form so as to avoid any confusion. Only the specific person requiring the mod has access to this form. It stopped working after the upgrade because the code setting a sequence number was removed from the pre-insert trigger. The error message we were getting indicated the value in the seq field was null. Hopefully this fixed the problem.
Posted by wendlerb at 10:06 AM | Comments (0)
September 14, 2005
Grade Rolls (cont)
We also get some om invalid field of study. It appears the SCT script we ran for the 4 modules didn't catch everybody. The work around for the form SFASLST involves finding the student major or field of study that is causing the problem, going to the STVMAJR form, validating the code, rolling the grade, and then going back to STVMAJR and restoring the code like it was previously. Once the individual rolls he will roll fine in other classes even though the major code is back to invalid. The mass roll is another problem. Any invalid code will abort the process. I propose we activate all codes, do the roll, and then restore the table.
Posted by wendlerb at 11:49 AM | Comments (0)
September 13, 2005
Grade Rolls
We're having a problem with some individuals with an invalid major doing a grade roll from the form SFASLST. They get the API error message:Invalid Field of Study major code. This particular person won't work in production or test so it's not something didn't get updated correctly in a package. I have brought up other CRN's in test, invalidated the majors of the students, and had them roll just fine. So why is this guy different? Jeremy and I are both looking at it and actually registered the guy for a different class in test and had it work.
Posted by wendlerb at 10:34 AM | Comments (0)
September 9, 2005
WOU Mods
I've set up a folder under the usc/programmers directory for placing wou mods to Banner forms, packages, triggers, and views. I hope this makes it easier for us to track changes we've made the next time an upgrade comes along. It is, however, only as good as we make it.
Posted by wendlerb at 8:29 AM | Comments (0)
September 7, 2005
TGRFEED
The feed (SWBUGLF) aborted last night in the middle of TGRFEED, the worst possible place to abort. It turns out it started at about 8 pm and was still going at 2 am when the system came down. The reason was traced to a view, SPVADDS, and a good old spriden select. I added the compiler hint and it seems to have sped things up. Currently dealing with data from abort. We followed the SCT faq and reset the table gjbprun so TGRFEED could run again. Picked up the SWBUGLF com file from there.
Posted by wendlerb at 3:17 PM | Comments (0)
September 2, 2005
Phone Directory
The programmers somehow picked up responsibility for generating a pdf file complete with pictures for the student/faculty/staff directory. We have set up a checkbox on the update address form on the web where people can indicate whether or not they want their home address or phone listed in the directory. In addition, telecom sends out a memo asking the same thing. These are combined in an oracle table to record choices. There is a program in FIS/HRIS and another in SIS to generate a file containing address info which checks these flags.
Telecom and HR have handled taking employee pictures in the past generating jpeg images that we convert to tiff files for the phone book program. I have had to match these pics to a V number, crop the image, and then run a batch job in Adobe Photoshop 7.0. The resulting images have to be moved into a specific ucs directory for the perl script which creates the end product to find them. Note that if the files are not the proper size, the program will leave a blank where the image is supposed to go. See Hickerson’s notes for the directory.
Posted by wendlerb at 1:43 PM | Comments (0)
September 1, 2005
Fee Assessment (The crowd goes wild)
Ok, we got a fix. Required mods to 2 packages bwckregs and sfkfees.
First problem involved drops and fee reassessment. We finally discovered (with Jeremy's help) 3 tui detail codes that didn't have rules set up in SFARGFE for hrs 9, 10, and 11. We also had to set flags correctly in STVRSTS for drop codes. Now dropping on the INB form charges penalty and does new hours correctly and calcs penalty correctly 100% of time. The new fee assessment flag and withdrawl flag in rsts has to be on for penalty to work.
Second problem involved web drops. First there was logic in bwckregs that prevented drops if fee assessment flag was on. We commented it out. Then we found that penalty wasn't being charged. We found by investigating that penalty would be charged if student had a DC or DD already on their sftregs records for the term but not if they had none. The web drop removes records on this table before doing feeassessment. The sffkfees package has a p_post_rbt_penalties procedure that checks if a drop exists on the table before kicking off. Since the record was already removed, it never executed. We removed logic and let the process kickoff regardless.
Posted by wendlerb at 11:58 AM | Comments (0)