« January 2013 | Main | March 2013 »

February 28, 2013

SZRERIQ

I added some debug code to the szreriq shell script so that I can verify that the files were transferred successfully.

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

SWRRCDE job submission

I was notified by the registrar's office that the job submission swrrcde was not working so I rewrote it in perl (it was in pro c). It was a fairly simple program that lists students with a specific registration code for the term.

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

February 22, 2013

SZRSPRT job submission modification

I made some changes to the SZRSPRT report this week and added some new data to the report. These are the new data elements added to the report:
site_code
level
overall_gpa
hours_earned
hours_gpa
gpa_points
term_gpa
The report now prints out in CSV format instead of printed fixed format. This will make it easier for the Health and PE to import into Excel.

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

Early IQ Cron

I setup a scheduler job to upload our data to the Early IQ system this week. The job runs at 7:30am M-F and the job name is job_szreriq.

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

February 14, 2013

wou_echeck real time payment mod

I made a change to the real time payment procedure for echeck (P_Accept_Pay_Confirmation). The term code that is used for the convenience fee is the term code a student is applying for (if it's an admissions app payment) or the term code specified in tbbdetc.

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

Non-standard update to ssbsect and ssrmeet

The Registrar's Office entered the wrong course end date for 39 courses for Spring term. In order to fix this, they would of had to remove the instructor and class meeting times for each course. This would have taken a while to do so they requested that I do a non-standard update to correct these dates. I updated the ssrmeet_end_date and ssbsect_end_date for these courses.

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

February 8, 2013

Web registration time tickets change

By request from the Registrar's office, the Honor Program students will get priority registration before all undergraduate students. I changed the build_groups script to handle this by inflating their credit hours by 500 credits.

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

E-disburse Holiday workaround for TZPEDRF

I made some changes to the TZPEDRF script so that if we don't receive a response file from the bank (i.e. on holidays), a generic file will be copied to the e-disburse folder so that the e-disburse response table doesn't lock up with an oracle error. We use an external table to access the file from the bank.

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

February 1, 2013

Merging SWBUSAP into SWBRPHN

SWBRPHN and SWBUSAP essentially do the same thing ( loading student telephone charges into Banner) but SWBUSAP had two extra error reports that it produced. I'm going to merge all of the code into one script SWBRPHN so that the business office only needs to run one process to load the charges.

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

Non-standard update to remove AH holds from inactive students

I did a non-standard update on the table SPRHOLD today to remove all advising holds (AH) from students that are no longer active. This was requested by the Advising Center director. I'm going to add some code to SZPSTDN (the process that inactivates students that have left the institution) and will automatically remove the AH holds.

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