« March 2013 | Main | May 2013 »
April 25, 2013
Reverse Transfer Degree Program
WOU and Chemeketa are piloting a new reverse transfer degree program where a student will be awarded an Associates degree from Chemeketa if they meet certain conditions. I started writing a query to pull these student from our database so that we can send this information to Chemeketa. I'm planning on using this query as a population selection in banner so that the Registrar's office will be able to send EDI transcripts using the population selection.
Posted by soukupm at 2:12 PM | Comments (0)
SWEFADP2 modification
I made some changes to the report SWEFADP2 (advisee list by advisor) because it was picking up the wrong advisor when the advisee record is ended for a term. The code was not picking up the correct sgradvr_term_code_eff so I also fixed that.
Posted by soukupm at 2:06 PM | Comments (0)
April 17, 2013
Update to SZPASHD
I added two new columns to SZPASHD (academic standing holds) this week:
Academic Standing - will be used to determine if student is on Academic warning or academic probation.
Email Address - to notify students.
Posted by soukupm at 2:37 PM | Comments (0)
Added FT06 cohort
The first time freshman cohort was run late in 2006 and it seems to be missing some students. I went ahead and created a new cohort that can be used as reference (FT06 First time freshman 2006).
Posted by soukupm at 2:31 PM | Comments (0)
April 10, 2013
Fixed bug in research table script SWIURCH
I fixed a bug in the research table script swiurch that reported the wrong admit code for non-admits (NU,NG). The script was originally pulling from the admit table saradap but for non-admits, they either do not have a record in that table or the application was denied. The script now pulls from sgbstdn table (general student record) for the non-admits.
Posted by soukupm at 2:24 PM | Comments (0)
New job submission SZPASHD
I created a new job submission this week called SZPASHD. This job places "AS" holds on students that are on academic warning (P1). The input parameters are:
Term code
Hold date
Mode: A (Audit)/U (Update)
The output is a list of students that are on academic warning for the term and will have a hold placed on their account.
Posted by soukupm at 2:16 PM | Comments (0)
April 5, 2013
Banner PDF printing
I setup a new print queue in our test database for pdf printing (wou_pdf). A user can select wou_pdf from the list of printers from job submission and the output will be sent to the users home directory. So far the testing has gone well and I'm hoping to get it in production next week.
Posted by soukupm at 2:49 PM | Comments (0)
Banner single sign on testing successful
After a few bumps and hurdles, I was able to successfully login through single sign on through our test database (it's running oracle forms 11 with fusion middleware). There's still a few more glitches that need to be ironed out (fonts incorrect, keymapping incorrect and unable to connect with a Mac).
Posted by soukupm at 2:40 PM | Comments (0)