« 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)