« September 2012 | Main | November 2012 »

October 26, 2012

Banner Upgrade

The FIS/HR/AR banner upgrade will be on Nov 3rd. I ran a feed to finance test in our test environment and it worked all the way up to the check feed. It aborted at this point because there was another check process running at that time. I reran it again and it completed successfully. I documented the changes to the feed to finance programs. The document can be found in \staff\Banner_Information\Banner_8\Upgrade\8.5 point release\Feed to finance updated programs.xls

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

Trigger on GJBPRUN

I put a trigger on the table GJBPRUN to find out when our scheduler job parameters are being deleted over the week. It automatically sends me an email when a row is deleted.

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

October 19, 2012

EarlyIQ

I fixed a couple bugs in szreriq this week and added some logic to include student residence halls. I uploaded the data to connectedu this week. They are now processing the data. I still need to configure the job for job submission in Banner, setup a scheduler job and automate the sftp process.

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

Degreeworks single sign on for Faculty/Advisors

I configured the Degreeworks single sign on for Faculty/Advisors this week. Faculty and Advisors have a link within Wolf web that will take them directly to the Degreeworks web without having to login separately. The link is located under Faculty Menu->Advisors Menu. Each staff member needs an account in Degreeworks to be able to access the system.

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

October 11, 2012

Clearinghouse change

I made some changes to the clearinghouse script szrclrh.pl because the clearinghouse now allows us to send student ID numbers instead of SSN for international students. In the past international students dropped off the list because they did not have a valid SSN which was required by the clearinghouse. International students will be able to use the clearinghouse services starting next month (enrollment certificates, order transcripts).

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

EarlyIQ - SZRERIQ

This week I've been working on a job submission that will be used for the EarlyIQ system. The job is named SZRERIQ. There is no input parameters (it automatically selects the current term). The output is made up of seven different files:
Student Data File
Staff Data File
Term Schedule
Course Data
Student list by course
Staff Relationship file
The file names will follow this pattern: (file_type)-westernoregonuniversity-earlyiq-(todays_date).csv.
I'll be setting this job up so that it automatically sftp's the file once a day.

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

October 3, 2012

NCAA ATS data import

I've been training Bruce this week on the NCAA Academic Tracking System data import. We use NCAA's compliance assistant to load the student athlete data. The athlete data consists of credit hours per term, gpa and major declared for the year.

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

Banner 8.5 upgrade

I've been working on the Banner 8.5 upgrade for FIS and HR this week. I'm putting all of our mods under \Staff\Banner_Information\Banner_8\Upgrade\8.5 point release\Wou_mods.

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