« October 2005 | Main | December 2005 »
November 28, 2005
AP momeymachine
AP check printer dimm lost all it's files this afternoon so the check run didn't come out right. I noticed the missing files on the file directory so I took the printer over to my desk and tried to reload the files. I got a disk operation error on the front of the printer. I reinitialized the dimm and tried again. This time the files copied and stayed on there after powering down the machine and turning it back on. We finished the check run but I'm not sure what knocked the dimm out of whack in the first place.
Posted by wendlerb at 3:52 PM | Comments (0)
November 23, 2005
SWKRPSB
This is a baselinr accounts recievable report that is supposed to show charges and paymrnts for the catagories:TUI,FEE,HOU,MEA,RFN. The logic in the program for charges looked good but the numbers for paid were inaccurate. The code was summing any detail record that had a code with an indicator of P. It needed to pull payments toward the charges so it needed the TSIAPPL tables. I pulled a sum off the tbrappl table where it matched the charge detail record but found I was having problems with tuition changes from add and drops. I had to sum the negative amounts on detail and subtract from the sum of the tbrappl_amount.
Posted by wendlerb at 11:28 AM | Comments (0)
November 18, 2005
DML_SPRIDEN change to fix GENERATED problem
Made a change to the dml_spriden package today. Every once in awile on the student side we get errors caused by generating an id because a spriden record with GENERATED already exists. There's a post insert trigger on the spaiden form that deletes the GENERATED record so I'm not certain exactly why a GENERATED record gets left on the system. Anyways I fixed it so the existance of such a record won't cause problems with any new records till it gets deleted like before. This is all related to the fact that the call to the API for a spriden creation returns a rowid and that doesn't work in student because we're looking at a view.
Posted by wendlerb at 2:26 PM | Comments (0)
November 16, 2005
Catalog, sect, and histoy HIS subj attributes
We needed to add attributes to HIS subject courses. Li's script worked in a limited fashion for one of the areas but could not handle muliple attributes on one course because of a function he wrote that returned only one attribute from a table he created. I modified that stored procedure and made 2 others based on it to handle the 3 areas of history, section, and course
add_more_ssrattr
add_more_shrattc
add_more_scrattr
I had to change the get_attr function in there to return one record in the case of multiples so this script actually has to be run twice. Run once with select min(attr_code) in code and again with select max(attr_code).
This was run in production 16-NOV-2005
Posted by wendlerb at 1:40 PM | Comments (0)
November 15, 2005
No Go
It doesn't look like it will be necessary to do a point upgrade for the 1098-T stuff this year in Dec. The main stuff in this point release seems to be related to acedemic transcripts and the swapping in fee assessment. We don't use swapping so I'm thinking we may not decide to do the point release. Several other schools have not gone to 7X yet so I'm not sure if that will force us if they decide to do 7.2 when they upgrade.
Posted by wendlerb at 9:46 AM | Comments (0)
November 10, 2005
Wouprd stuff
ETS needs us to refresh woutst so we needed to put changes we did to data in woutst to wouprd so they aren't lost. Ran Li's 2 capp insert procedures in production and then ran szpfatt to fix records on several different dates descried in Faye's email plus the day I reran Li's scripts. Ran a script for Faye to list 100Ts that do not have a graduation record and cut it down to about 27 records from several thousand. Script is called shrtatc_tmix if I need it again. I also ran the shatatr and shatrns scripts to update attribures on split courses. These will have an activity date of today in case a problem arises.
Posted by wendlerb at 10:50 AM | Comments (0)
November 7, 2005
More direct loan
Removed duplicate records on direct_pre_memo and added crosswalk info to tbrmemo entries that were done by hand.
Posted by wendlerb at 2:58 PM | Comments (0)
November 2, 2005
Direct loan feed 10/31/05 cont
Well, what a mess. I removed records in tbrmemo and direct_pre_memo for all the multiples in list that financial aid gave me. Next morning feed put one record back instead of multiples but financial aid said it didn't look right. So I removed all records created on 10/31/05 because I couldn't be sure of their integrity. Turns out they were good but removing them the second time meant they would no longer load through swbrdll unless I individually removed records out of direct_pre_memo. Just as fast to enter data into tbrmemo via a banner form so that's what we are doing. The cron job had multiples running simultaneously.
Posted by wendlerb at 4:12 PM | Comments (0)
November 1, 2005
Prelim look
Student
Forms:
GOQRPLS
TSAAREV
TSASPAY
GUASYST
SAADCRV
SAAQUIK
SFAREGS
SFAREGQ
SFASLST
SHATAEQ
SOILCUR
SPAIDEN
SRAQUIK
Packages:
BWGKOGAD
BWGKOADD
BWLKFCWL
SAKMTCH
SAKVAPL
SFKFEES
SHKROLS
SHKTAEQ
BWSKOACC
Posted by wendlerb at 3:56 PM | Comments (0)
Direct loan feed 10/31/05
Some kind of problem with spruce time change caused cron job to run 20 times. This fouled up records on tbrmemo and direct_pre_memo. Trying to fix by hand....
Posted by wendlerb at 11:17 AM | Comments (0)