« June 2005 | Main | August 2005 »
July 27, 2005
Sraquik and Saaquik
Version 7.1 mod has post-insert trigger added to spriden and generate id changed to work like Spaiden.
Posted by wendlerb at 10:49 AM | Comments (0)
July 22, 2005
Mass Time
Payroll still uses excel spreadsheets to manage student time. Mike Ellis has written an interface that several departments use on campus but the end result is still a time sheet created by payroll. Once time has been run in Banner, this sheet is manipulated so that only the columns: ssn,name,earn,hours,rate,index,acct remain. The file gets saved as a comma delimited file, time.csv Data entry errors are common. Some of the things to watch out for are a blank space accidentally entered on an index. The file is loaded into wops with command: sqlload username/pwd control = time.ctl Once loaded into the table pwrtime, run the script badtime to pull out records that don’t have time info yet and give to payroll. Run the c program, pzpltim, to load the records into the mass time table, phrmtim, in Banner. Let payroll know and then wait for them to complete final checks. Then run the pro C program, pzpmtim, to complete the mass time process. This puts the records into PHAHOUR
Note: Pzpltim has been replaced with Pzpttim
Posted by wendlerb at 9:22 AM | Comments (0)
July 19, 2005
SFVSTMS
Looks like Banner 7 has a few new views. This one is used by form SRAREGQ. Had to add compiler hint to it and form seems to run ok now.
Posted by wendlerb at 2:35 PM | Comments (0)
July 18, 2005
Web testing
Testing
Web for Faculty
Ran into some timeout issues with detail schedule but think it was more to do with bandev server
Did some web grading and it seemed to work ok
Student academic lookup worked just fine.
Section tally stuff was ok.
Did have to modify package nadintl which is behind Display student with IE hold. Changed to twbk…. From twgk…
Web for Student
Detail schedule worked ok
Registered for a Fall 2005 class and then dropped it.
Parking didn’t work but there’s no link to Wilbur so it wouldn’t
Print credit and wireless looked ok.
Address update worked
Web for Employee
Address update worked
Posted by wendlerb at 4:00 PM | Comments (0)
July 14, 2005
Goremal duplicate records
Since we moved to banner 7, Mike Staats ran into a problem when he tried to do a refresh which has implications when we go live. Duplicate email records in the table goremal caused the migration script to bomb out. The table now has unique constraints in Banner 7.1 so we had to remove these duplicate records from production. A script, DEDUP_GOREMAL.SQL, generates another script (dedup_email.sql) which deletes records based on rowid. You can see what records will be deleted by running dedup_email_list.sql and spooling the output. I suspect the new table constraint on goremal will have some effects on several student procedures that add email addresses to Banner.
Posted by wendlerb at 2:47 PM | Comments (0)
July 5, 2005
Banner Down
Next Admin council meeting should be fun.
Posted by wendlerb at 10:59 AM | Comments (0)