« April 2007 | Main | June 2007 »
May 31, 2007
IDTS Bi- Query Model
The spruce directory is ftp$disk:[hstr_wou] The disk logical is /$1$/dga139/hstr_wou/ The actual box is Ash. This is the directory containing the datafile to load into the model. The model tables are located on Aero.
Posted by wendlerb at 9:07 AM | Comments (0)
May 23, 2007
Address filter
The old address update section on web for student had a filter on it that is a local function (f_standardize_name_addr) that looked at upper/lower case corrections on entered addresses. I added this filter to the quick start app and the admissions credit card package. We added some additional filtering. Commas are now removed and replaced with a space unless the next character already is a space. Periods are removed unless the character in front of it is a number. This was done inside the logic already written. The modified filter is in production
Posted by wendlerb at 11:44 AM | Comments (0)
May 22, 2007
High School Transcripts - IDTS
The idts/ project requires the EDI receiving of high school transcripts. OUS has sent out several test which we did not receive on 009190. Turns out we can't get it if indicator is set to test but will if set to production. Now getting like everyone else although everyone is getting an error which stil needs to be worked out. I've seen the transcript but haven't played around much with downloading into the Bi-Query Model
Posted by wendlerb at 10:09 AM | Comments (0)
May 15, 2007
Tuition Promise -- insert saradap trigger
We discovered that tis trigger stopped working correctly some time last Feb. I updated records since then to the correct rate code and then started to track down what happened to the trigger. Turns out one of the patches we installed changes the way the student level gets populated on saradap. The trigger used UG as one of its boolean keys. New.saradap_levl_code used to be UG but it is now null. I can't key off it. So I switched from using that to new.saradap_admt_code := 'FR' . The logic seems to be working again as long as I can use 'FR' as a key.
Added TR and FT as well
Posted by wendlerb at 2:31 PM | Comments (0)
May 14, 2007
New check format
OUS has requested a change in formats of WOU checks as per a reuirement from US Bank. All trailing and leading asteriks need to be removed from amounts and USD or Dollars has to be added to long printout. WOU is currently only school using FWPCHKP. The other schools use a third party vendor. Now, they are moving back to job submission. However, their check stock prints the check on the bottom and not the top like ours so we agreed to continue to support our own mod. I have made the changes by mosifying the cents variable and changing add_comma procedure along with the lpad procedure.
Update: 6/07/07
Checks approved by treasury and US Bank. Mods moved to production
Posted by wendlerb at 9:28 AM | Comments (0)
May 11, 2007
ID creation
Spent a fair amount of time figuring this out.
Packages:
GB_COMMON returned to baseline
GB_BIO use FIS mod
GB_IDENTIFICATION use FIS MOD
DML_SPRIDEN modified specifically for merged. Do not use FIS or SIS
Table triggers:
ST_SPRIDEN_INSERT_ROW modified specifically for merge
ST_SPRIDEN_DELETE_ROW modified specifically for merge
ST_SPBPERS_INSERT_ROW dropped in merge
FT_FTVVEND_INSERT_ROW return to baseline
Sequence:
GENERAL.PIDM_SEQUENCE set to number higher than max(spriden_pidm)
BANINST1.WOU_ZSPRIDA_SEQ set to number in wodv
Notes:
We are keeping the table generated V number to handle outside banner applications such as credit card admissions that create a person in Banner.
Tested generated person and generated coportation in PPAIDEN and SPAIDEN. Tested name change in PPAIDEN and SPAIDEN. Tested SSN entry in PPAIDEN and SPAIDEN. Have not tested SRAQUIK yet .
The spriden table trigger no longer makes use of SWBPIDM. There is logic now to see what form inserts the spriden record and then updates or inserts a spbpers record if coming from a student form. PPAIDEN does the insert automatically and will throw an error without this logic on the trigger. PPAIDEN has a problem if the pidm sequence is less than max pidm. It increments to an unused pidm but grabs some email info from the first attempt pidm and saves it with the latter one. SPAIDEN doesn't have that problem. Setting the seq above max takes care of it.
Posted by wendlerb at 11:10 AM | Comments (0)
May 4, 2007
Menus
Inserted gurobjs records into FIS/HR that were in SIS but not already in FIS/HR.
Inserted guraobj records into FIS/HR that were in SIS but not in FIS/HR
Added rights to new objects via Bansecr to class FINCORE
Built student menus on FIS using GUTGMNU.
Posted by wendlerb at 9:23 AM | Comments (0)
May 2, 2007
Banner front menu
So, the front menu on Banner suddenly was missing menu items today even though they were set up correctly in GUTGMNU. Turns out to be a known bug that kicks in the first time somebody rebuilds the menu hierarchy. All the local menus disappear under the menu you are changing. The work around is to put the locals in twice.
Posted by wendlerb at 1:33 PM | Comments (0)