« January 2011 | Main | March 2011 »

February 25, 2011

Linux migration update

I'm very happy to say that ldap authentication to Banner (on linux) is now working! With a little help from our DBAs and a little bit of tweaking on my end, we were able to get it working successfully. Now it's time to tackle the portal/single sign on piece.

Posted by soukupm at 4:45 PM | Comments (0)

Student email load into Banner

I made some modifications to the student email loading process this week. I created a local table to build the student pidm population (to cut down on dblink traffic) and a local table for current student email addresses in Banner. These tables are populated prior to the student email load process. So far it seemed to speed up the process (it cut the time down in half... from 10 minutes to 5 minutes).

Posted by soukupm at 4:38 PM | Comments (0)

February 18, 2011

Finaidload mod

I added a degree plan field (sgbstdtn_site_code) to Financial Aid's admissions load program this week. I tested it out with Financial Aid and it seems to load into powerfaids ok.

Posted by soukupm at 4:18 PM | Comments (0)

Linux Migration

I've been working on the linux migration this week and so far I've gotten wolf web to work using ldap. I'm still working on the INB single sign on, I seem to be hitting every road block (firewalls,listeners not working,etc). I can get a login prompt but there's a problem with the oracle pipes that's hanging it up now. I'm hoping by next week, I'll have it running smoothly.

Posted by soukupm at 4:09 PM | Comments (0)

February 11, 2011

SZRRTLY Mod

I made a change to SZRRTLY so that it calculates a student's class (FR,SO,JR,SR) based on the term code parameter. Prior to this modification, a student's class was calculated based on overall earned hours (which is constantly updated each term). The report would be accurate if it was ran in the current term but inaccurate if ran for a prior term.

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

February 9, 2011

New Job Submission - SZRSPRT

I created a new job submission this week called SZRSPRT. This will be used by Health & PE. The report lists student athletes in Banner for the term. The input is term code and sport code. The output is vnumber,name,sport code, and athlete attributes from SGRSPRT.

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

February 4, 2011

New Job Submission - SZRIMEX

I created a new job submission this week called SZRIMEX. This is a report of students that have an immunization exemption. This will be used by the Health Center. The input is term_code and output is vnumber,student name, and contact information.

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

New Cron - SZPMINH

I created a new cron job this week called SZPMINH. This script uses the Banner API's to determine the correct minimum credit hours for students for the term. If there is a difference in the minimum hours between the API and the student's enrollment record, the script will update the student's minimum credit hours automatically. Minimum hours that are manually entered for the student are skipped but will appear on the report. If there is a discrepancy in minimum and maximum hours (min is greater than max hours), the script will report these.

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