« January 2012 | Main | March 2012 »

February 24, 2012

SZRVETC - added WR registration code

I added some logic to SZRVETC so that it doesn't ignore the WR registration code. This is a withdrawn code that auto-assignes a W grade. By default, the program ignored registration entries that have a grade assignment (so that emails about registration changes don't go out when end of term grading occurs).

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

Degreeworks - loaded new population of students

I removed all of the existing students from Degreeworks and added students that are Business and Econ majors. The Registrar's office requested this update so that they can work on a subset of students at a time. The Registrar's office noticed that only advisors were showing up when you do a general student search in degreeworks. I removed the advisors for the meantime so that they don't show up in the list. I believe they were showing up because they have a general student record. I'm going to research this further and see if there's a way to suppress advisors from showing up on the search list.

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

February 17, 2012

SQL for Degreeworks current students

I create a script for selecting current students that will have access to DegreeWorks when we go to production. The script is named bannerstudents.sql and it resides in our \Staff\Banner_Information\Degreeworks directory.

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

Registration Holds for Time Ticket Email

I added registration holds to the registration time ticket email sent out to students. The time ticket email uses a view named ZPVPERS so I added a new column REG_HOLDS. This column uses the function wou_misc.f_get_reg_holds() to display hold information for a student.

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

February 10, 2012

Registration time tickets for incoming transfer students

I added some new code to the reg_timeticket.p_create_time_ticket procedure so that it adds new transfer students to the time ticket group "NEWTR". The registrar's office is allowing new transfer students to register for classes on the 3rd day of registration week. The NEWTR group allows them to register at that time.

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

Degreeworks training

I went to DegreeWorks training this week and learned quite a bit about how to configure the system. I configured Banner self service so that students and faculty can login to DegreeWorks from there. I created a folder \Staff\Banner_Information\Degreeworks and put all of the documentation and scripts needed to setup self service for DegreeWorks.

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

February 3, 2012

Mods - hris32,PZRDUES,SWBXCOT

I made some modifications this week to a few scripts/programs.

HRIS32 - added some logic to not insert a record if there is a record with the same effective date to avoid constraint errors.
PZRDUES - added 'U2C','U2D','UDA' codes to the classified report.
SWBXCOT - added logic so it accepts lowercase "v" for vnumbers.

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

Degreeworks - Misc logins

I was able to create a generic login in Degreeworks by copying an existing account and modifying these fields:
shp_access_id - put the new login name here
shp_box_id - put the new login name here
unique_id - use a low number because this comes from a sequence number
unique_key - copy from existing account and change one digit,
shp_access_code - new password

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