« February 2013 | Main | April 2013 »
March 29, 2013
Updated prior_college logic in scarf
I did some clean up this week in the scarf script and removed the advanced credit records from the prior_college table (CBE,CLEP,AP) and added some advanced credit records (MIL,IB) that were missing. I also fixed the AFP (Armed Forces Personnel) special rate code logic.
Posted by soukupm at 4:04 PM | Comments (0)
Renamed Job submission GZRDEMGR to GZREMGD
We didn't have an object for GZRDEMGR (emergency notify delete process) in Banner but we did have an object for GZREMGD so I renamed my script and added a job process in GJAJOBS. The job runs successfully now.
Posted by soukupm at 3:58 PM | Comments (0)
March 22, 2013
TZPFAID and SZRFACR sftp server change
I changed the sftp server for the financial aid upload for TZPFAID and SZRFACR.
Posted by soukupm at 3:48 PM | Comments (0)
EDI server change
I worked with our Unix admins today to change the ftp server for incoming EDI transcripts. The registrar's office will now access the files from the J: drive instead of a special windows share.
Posted by soukupm at 3:42 PM | Comments (0)
March 15, 2013
SWBRPAY modification
I made some changes to the SWBRPAY report ( List of payable accounts). I added some new columns (PL-plus loan,CC-visa,CCC-cash payment,3rd-3rd party payment,trust- trust payment,drops-dropped credits, and WC-withdrawn) so that the output is similar to the szpbchk report (checks printed report).
Posted by soukupm at 1:39 PM | Comments (0)
Degreeworks daily usage report
I created a scheduler job this week that sends an email to the Registrar's office about the usage in Degreeworks. The job is named job_dworks. It connects to the Degreeworks database at night and sends the total students and faculty that accessed Degreeworks that day. The code is in the wou_dworks package.
Posted by soukupm at 1:18 PM | Comments (0)
March 8, 2013
Registration problems
We been encountering lots of registration errors this week. It's do to an Oracle bug that causes a "ORA-04068: existing state of packages string has been discarded" error. As a workaround the DBAs set this command:
alter system set "_disable_fast_validate"=true scope=both;
Recompile the package and leave it alone.
Posted by soukupm at 3:21 PM | Comments (0)
Waitlisting temporary fix
The logic that selects the term code for the waitlisting program (szrbwlp, szrbwlp2) was failing to select the correct term so I hardcoded the term for now until I get some time to fix the logic.
Posted by soukupm at 3:06 PM | Comments (0)