May 26, 2005
Testing Forms
WOU SIS databses are linked to WOU FIS/HR.
WOUTST and WODV are set up presently for testing Banner 7x.
In addition, ETS has set up an Oracle 10G form server that we have links to.
You can get the links from the Banner team if you require one.
Presently, I have developer for forms90 set up on a machine next to my desk.
You can view and test compiling with this.
Moving or getting forms from the ETS server is done through a secure web form which
secure ftps source forms from a folder in shared. I have passwords to do the operation.
Posted by wendlerb at 11:37 AM | Comments (0)
Banner 7 notes
Packages may be named the same between FIS/HR and SIS but the mods in them are
specific to fis/hr or sis. You can't load the package for dml_spriden
from sis and put it in fis/hr.
FIS/HR side
Table trigger on spriden changed to reflect new columns on table. Banner
passes info into spriden as a record type now so need new columns on trigger
for it to work. Wodv trigger has mod and works correctly
The package GB_IDENTIFICATION has a WOU mod on it. We want table trigger to
generate V number and not this package. Once again, Wodv has wou mod on it.
The packages DML_SPRIDEN and DML_FTVVEND have commit added to insert. See
Wodv Also GB_BIO modified
The form PPAIDEN has WOU mods on it clearly labeled. Search for WOU.
The form FTMVEND has OUS and WOU mods
The form GUAGMNU to fix scrolling problem. 1024 x 768 screen may allow
a return to baseline
Packages for Web for Employee address update, BWGKOGAD and BWGKOSDR, has WOU mods.
SIS side
The packages GB_IDENTIFICATION and DML_SPRIDEN have WOU mods on them.
DML_SPRIDEN is quite heavily modified. See Woutst
The form SPAIDEN has a number of WOU mods clearly labeled. Search for WOU
Forms GOQRPLS - this is a lib that has compiler hint added so typing in a ssn
doesn't take forever to change to v number in banner forms
Forms WOUCHEK,SFAREGS,TSAAREV,TSASPAY,SRAQUIK,SZZDCRV,SAAQUIK,GUAGMNU,GUASYST
Trying to return to baseline: SAADCRV,SFASLST,SHATAEQ
Web for Student address update packages, BWGKOGAD and BWGKOADR, have WOU mods
Packages NADINTL (twk... to twb...)
Packages BWSKOACC,BWCKGENS,SAKDCSN,SAKVAPL,SFKCURS,TTKFUNC,BWLKFCWL have LIX/Hick mods
Function f_format_name
General notes: You might run into an error that goes something along the
lines of "signature of package sys.dbms.... has been changed" It has to do
with baseline stuff needing to be compiled in the instance you are in.
Contact Mike Staats.
Posted by wendlerb at 8:41 AM | Comments (0)