« January 2007 | Main | March 2007 »
February 27, 2007
Credit Card - Feb error rates
Out of 426 transactions for the admit package we had an error rate of 1.6 %. This is a substantial drop from last month. Still not comfortable with whether the pipe id uniqueness lack was the cause of our problems. The problems with the no return to wouprd seem so clustered that next month we may get another one and drive up the error rate. I'll just have to continue to monitor.
Posted by wendlerb at 2:00 PM | Comments (0)
February 26, 2007
shatatr missing connector
Found aprroximately 150 records missing a value in the connector field on multiple equivilencies in shrtatc table. Used following script:
select x.shrtatc_sbgi_code,
x.shrtatc_subj_code_trns,
x.shrtatc_crse_numb_trns
from shrtatc x,
shrtatc y
where x.shrtatc_connector is null
and x.shrtatc_sbgi_code = y.shrtatc_sbgi_code
and x.shrtatc_subj_code_trns = y.shrtatc_subj_code_trns
and x.shrtatc_crse_numb_trns = y.shrtatc_crse_numb_trns
and x.shrtatc_subj_code_inst = y.shrtatc_subj_code_inst
and x.shrtatc_term_code_eff_trns = y.shrtatc_term_code_eff_trns
and x.shrtatc_crse_numb_inst != y.shrtatc_crse_numb_inst
and x.shrtatc_crse_numb_inst like '1XX'
and x.shrtatc_seqno = '2'
and y.shrtatc_seqno = '1'
;
select x.shrtatc_sbgi_code,
x.shrtatc_subj_code_trns,
x.shrtatc_crse_numb_trns
from shrtatc x,
shrtatc y
where x.shrtatc_connector is null
and x.shrtatc_sbgi_code = y.shrtatc_sbgi_code
and x.shrtatc_subj_code_trns = y.shrtatc_subj_code_trns
and x.shrtatc_crse_numb_trns = y.shrtatc_crse_numb_trns
and x.shrtatc_subj_code_inst = y.shrtatc_subj_code_inst
and x.shrtatc_term_code_eff_trns = y.shrtatc_term_code_eff_trns
and x.shrtatc_crse_numb_inst != y.shrtatc_crse_numb_inst
and x.shrtatc_crse_numb_inst like '2XX'
and x.shrtatc_seqno = '2'
and y.shrtatc_seqno = '1'
;
select x.shrtatc_sbgi_code,
x.shrtatc_subj_code_trns,
x.shrtatc_crse_numb_trns
from shrtatc x,
shrtatc y
where x.shrtatc_connector is null
and x.shrtatc_sbgi_code = y.shrtatc_sbgi_code
and x.shrtatc_subj_code_trns = y.shrtatc_subj_code_trns
and x.shrtatc_crse_numb_trns = y.shrtatc_crse_numb_trns
and x.shrtatc_subj_code_inst = y.shrtatc_subj_code_inst
and x.shrtatc_term_code_eff_trns = y.shrtatc_term_code_eff_trns
and x.shrtatc_crse_numb_inst != y.shrtatc_crse_numb_inst
and x.shrtatc_crse_numb_inst like '3XX'
and x.shrtatc_seqno = '2'
and y.shrtatc_seqno = '1'
;
select x.shrtatc_sbgi_code,
x.shrtatc_subj_code_trns,
x.shrtatc_crse_numb_trns
from shrtatc x,
shrtatc y
where x.shrtatc_connector is null
and x.shrtatc_sbgi_code = y.shrtatc_sbgi_code
and x.shrtatc_subj_code_trns = y.shrtatc_subj_code_trns
and x.shrtatc_crse_numb_trns = y.shrtatc_crse_numb_trns
and x.shrtatc_subj_code_inst = y.shrtatc_subj_code_inst
and x.shrtatc_term_code_eff_trns = y.shrtatc_term_code_eff_trns
and x.shrtatc_crse_numb_inst != y.shrtatc_crse_numb_inst
and x.shrtatc_crse_numb_inst like '4XX'
and x.shrtatc_seqno = '2'
and y.shrtatc_seqno = '1'
;
select x.shrtatc_sbgi_code,
x.shrtatc_subj_code_trns,
x.shrtatc_crse_numb_trns
from shrtatc x,
shrtatc y
where x.shrtatc_connector is null
and x.shrtatc_sbgi_code = y.shrtatc_sbgi_code
and x.shrtatc_subj_code_trns = y.shrtatc_subj_code_trns
and x.shrtatc_crse_numb_trns = y.shrtatc_crse_numb_trns
and x.shrtatc_subj_code_inst = y.shrtatc_subj_code_inst
and x.shrtatc_term_code_eff_trns = y.shrtatc_term_code_eff_trns
and x.shrtatc_crse_numb_inst != y.shrtatc_crse_numb_inst
and x.shrtatc_crse_numb_inst not like '4XX'
and x.shrtatc_crse_numb_inst not like '3XX'
and x.shrtatc_crse_numb_inst not like '2XX'
and x.shrtatc_crse_numb_inst not like '1XX'
and x.shrtatc_seqno = '2'
and y.shrtatc_seqno = '1'
;
Posted by wendlerb at 9:20 AM | Comments (0)
February 22, 2007
Tuition Promise and Saaadms
We crated a process to populate an end term for every student using the tuition promise plan.Ttuition promise
This populates the table szrchrt which has the end term. We needed staff to be able to insert, update, or delete records on this table so I decided the best thing to do was add a tab to the form SAAADMS with the required fields. It does mean another form to maintain but I figured it was the best functional place to put it. I will wait till we move to the 10.1.2 server befoore sticking it out there as well.
Posted by wendlerb at 9:42 AM | Comments (0)
February 21, 2007
State Student ID
All students in Oregon will be getting a 10 digit id number assigned to them in grade school that will get tracked all the way through high school. We will soon be required to track it in banner as well. OSU put in a request with SCT to add a field to Banner but hasn't had a positive response. So OSU has created a table and added a field to the Spaiden form in the biolography tab. We got the form and table creation code from OSU, created the table sybssid under baninst1, and added this block to Spaiden. I am going to wait till we move to the new 10.1.2 form server before sticking it out in production.
Posted by wendlerb at 9:43 AM | Comments (0)
February 16, 2007
SZPWART
Must be Capp week this week. Registrar Office asked for a report that would list all records in transfer articulation for a user entered inst (WOU) subj and crse numb. I created this and put it in job submission (szrwart)
So the next request is to be able to change all records with the given subj and crse to a new subj and crse. This proved to be very challenging because you can have multiple course attributes and multiple course equivilances besides the given one for a particular effective term. We also wanted to pull new attributes from the catalog.
For instance:
shbtatc can have the CS 131 transfer record for a sbgi
shrtatc can have CS 160 and CS 1XX as the equivalent
shrtrat can have 2 attributes for each course
Want to change the CS 160 to CS 161
First shot at this put in a new CS 161 record with a new eff term on shrtatc with 2 attributes but lost the CS 1XX. Need to insert both.
Did this with a double select loop and boolean logic to prevent trying to insert records into shbtatc twice when you have multiple equiv courses and shrtatc twice when you have multiple attributes.
Still a question of whether hours are defaulting in correctly on new records.
Posted by wendlerb at 3:11 PM | Comments (0)
February 14, 2007
7.3.1.1 patch
File pcms-dfct75219_stu70301.trz
All wou_sis_mods affected removed so we are at baseline.
Directory WOUP:[000000.GENERAL.C]
SMRCMPL.H;21 13-FEB-2007 12:54:28.65 (RWED,RWED,RE,RE)
Total of 1 file.
Directory WOUP:[000000.GENERAL.EXE]
SMRBCMP.EXE;29 13-FEB-2007 13:34:03.82 (RWED,RWED,RWED,RE)
SMRCMPL.EXE;35 13-FEB-2007 13:33:59.80 (RWED,RWED,RWED,RE)
SMRCMPL.OBJ;27 13-FEB-2007 13:33:54.26 (RWED,RWED,RE,RE)
SMREVAL.OBJ;26 13-FEB-2007 13:28:14.54 (RWED,RWED,RE,RE)
SMRGEVL.OBJ;26 13-FEB-2007 13:26:58.19 (RWED,RWED,RE,RE)
SMRJOBS.OBJ;20 13-FEB-2007 13:31:58.72 (RWED,RWED,RE,RE)
SMRRULE.OBJ;26 13-FEB-2007 13:30:11.84 (RWED,RWED,RE,RE)
SMRSELS.OBJ;19 13-FEB-2007 13:33:31.53 (RWED,RWED,RE,RE)
Total of 8 files.
Directory WOUP:[000000.STUDENT.C]
SMRCMPL.PC;21 13-FEB-2007 12:54:23.36 (RWED,RWED,RE,RE)
SMREVAL.PC;21 13-FEB-2007 12:54:23.38 (RWED,RWED,RE,RE)
SMRGEVL.PC;21 13-FEB-2007 12:54:25.27 (RWED,RWED,RE,RE)
SMRJOBS.PC;17 13-FEB-2007 12:54:26.41 (RWED,RWED,RE,RE)
SMRRULE.PC;22 13-FEB-2007 12:54:27.02 (RWED,RWED,RE,RE)
SMRSELS.PC;15 13-FEB-2007 12:54:28.47 (RWED,RWED,RE,RE)
Total of 6 files.
Posted by wendlerb at 3:18 PM | Comments (0)
February 13, 2007
Web parking purchase
I renamed the package wou_park in SIS to wou_park_sis and created the webtailor entries. Student web now points to wou_park_sis. This was necessary because wou_park also exists on FIS/HR but has different mods. I will remove the old wou_park package from SIS when I know wou_park_sis works ok.
Posted by wendlerb at 3:21 PM | Comments (0)
February 9, 2007
CLM and student holds
Client Loan Managers latest patch 2.4.0 added the ability to place holds on the Banner Student System. This is the first time we've made a connection from a SQL Server 2003 database to an Oracle database directly. It is done with the msadora provider. This required that we set up Oracle Client on the CLM box and added a tnsnames.ora file.
Prerequisites: This feature needs to be activated in Office Management / System Configuration Parameters / Student System Interface Configuration. There are two sections on this page; ADO parameter settings for access to the Banner system and default settings for the manual and automatic processing by loan type. The ADO section information will require the assistance of the Banner System DBA
Posted by wendlerb at 3:20 PM | Comments (0)
February 8, 2007
Fee Assessment Bug
We had some web drops which happened when the refund percent went to 0 (SFARFND)and before the last day to drop on the web where the penalty was not getting charged on tsaarev. The drops the day before the 0 percent went into effect worked normally. The last day on the 5th record is set to Dec 31, 2099. After some invetigation we found out that it worked if you changed the date to 2009 so I suspected some kind of problem with a cursor using date. There is a procedure p_set_rbt_variables in the package sfkfees that makes use of the date range. It uses some library function to format the date which apparently doesn't work right with web drops. It worked ok from SFAREGS. I changed the procedure to use a standard to_date(variable,'DD-MON-YYYY') and the web drop worked correctly.
This wouldn't show up as a bug in baseline because you don't get to web drop with web fee assessment turned on in baseline anyway.
Posted by wendlerb at 9:38 AM | Comments (0)
February 5, 2007
Banner Javaclient Upgrade
Banner forms will be moving to Oracle forms 10.1.2 which will no longer support jinitiator. These new forms work best with the newest java client 1.6 There are some programming consequences to this (require newest forms developer which is not backwards compatable. There is a conversion utility) The biggest thing campus will see is this requirement to change to java client 1.6 It's possible to set up the forms server to automatically download 1.6 if no previous version exists on the client machine. However, I'm thinking most people are going to have a 1.5x version on their machine. The thin clients will be easy to deal with. The rest of campus may require the Chinese fire drill. It's been awhile since one of those. We have until early March to come up with a plan so have scheduled a Banner team meeting to figure out how best to deal with it.
I've been running 1.6 along with the rest of the Banner team for a couple of months so we can do this before the forms switch. The advantage of the 1.6 is it fixes the loss of mouse focus.
Posted by wendlerb at 9:14 AM | Comments (0)
February 2, 2007
Admit app Credit card
We've been struggling with the credit card payment for the inhouse admissions app ever since it was brought up a few years and a couple of programmers ago. It's had essentially two kinds of errors. One is when it double charges the student. We put code in to try and prevent double mouse clicks and warnings about using the back button. Still, applicants still use the back key. Cashiers has had trouble recently with the verisign web page itself doing the same thing. The other problem is worse. The home admissions app makes a call to the same package Banner uses to do credit cards:bwgkjpay. For some reason, once in a while when making this call from the admissions app, it never returns back to the admit app from this call to the credit card server. Banner baseline works flawlessly.
We've been under a lot of pressure from the admissions office to get this to work and we've tried a lot of things. However, the error rate continues to run about 6% on this app. This has been frustrating because I just want the app to work for the kids and avoid a lot of extra work for the cashiers.
I set up the stuff for baseline Banner so I know it pretty well. I looked at the call on the admit app and the call on the baseline Banner stuff and noticed one difference. Banner passes student id in a variable whereas the admit app passes a constant. This variable gets used inside bwgkjpay to name the return pipe. That makes the name of the return pipe unique in the banner baseline but not in the admit app. Could that be the problem? I read what I could on Metalink about dbms_pipe and all the examples always add a session id to the name making it unique. So, I changed the admit app from passing a constant to passing the applicant's last name.
Will it make a difference? I'll have to wait a month of use to see.
Posted by wendlerb at 8:32 AM | Comments (0)