« February 2012 | Main | April 2012 »

March 30, 2012

SZRFACR - modification

I added a new column to the report SZRFACR (Financial Aid's credit hour report that loads into powerfaids). The column is student's last academic standing based on the term. If an academic standing record doesn't exist, it will return "00" for good standing (Banner also does this).

Posted by soukupm at 9:59 AM | Comments (0)

March 23, 2012

Degreeworks in progress audit flag problem

I submitted a ticket to Sungard for the in progress classes being flagged as audit courses last week. I got an update on the ticket this week and it seems that Degreework automatically flags courses that have a gmod of "A" to audit. I'm working with sungard on a workaround to get this fixed since all of our normal A-F graded courses have a gmod of "A".

Posted by soukupm at 2:08 PM | Comments (0)

Merged view: student

I added indexes to the local student tables for the merged view for student data. The performance was really bad without them. I added all of the logic to create the local tables in a procedure called p_create_local_tables. I updated the p_createstudent procedure and added a faculty or staff flag to the stusum table.

Posted by soukupm at 2:01 PM | Comments (0)

March 16, 2012

Developer directory cleanup

I did some cleaning up of our developer directory on the VMS system for Banner in preparation for the move to Linux. I made a backup copy of the files I removed and put them in \Staff\Banner_Information\Linux Migration\VMS backup and my directory \Banner\vms_backup. A lot of the files were old txt files from reports that were run long ago. I also removed some directories from staff that left a while ago.

Posted by soukupm at 1:56 PM | Comments (0)

Powerfaids email issues

Financial Aid has been having problems sending email through our mail relay server because of a recent change. I did some research and found that you can configure smtp settings within powerfaids. When you login to powerfaids, go to tools, administration. Then select view, campus info, basic parameters,smtp settings. There you can specify the smtp server, user name,password, and other options. I changed the smtp server to google mail so that it no longer goes through our smtp server. So far it seems to be working well.

Posted by soukupm at 1:47 PM | Comments (0)

March 9, 2012

Degreeworks - aborting on some students

I submitted a ticket to Sungard for help with a problem in degreeworks where an audit is aborting for some students. It comes up with an error "DAP32 failed with status = 267".

Posted by soukupm at 2:12 PM | Comments (0)

Merged view - students and faculty

I created two new tables that have summary data for students and faculty. These tables will be used by our programmers for their own applications. I wrote the update procedure for both of these tables and I'll be testing it next week.

Posted by soukupm at 11:12 AM | Comments (0)

March 2, 2012

Degreeworks - added link for holds

I added a link to the registration holds web page on the worksheet student view for Degreeworks. It took me a while to figure out where to put the mod. I put a file "WOU Degreeworks setup.txt" in our \Staff\Banner_Information\Degreeworks directory that has the location of the file just in a case we ever need to make changes again.

Posted by soukupm at 3:42 PM | Comments (0)

TSRCBIL - billing statement mod

I made a modification to TSRCBIL to change the street address lines to 60 characters. Baseline had it set to 30 characters. The street column is actually 75 characters in the table spraddr. I would have set the street address to 75 inTSRCBIL but that would of required a major modification to the program.

Posted by soukupm at 3:30 PM | Comments (0)