« April 2007 | Main | June 2007 »

May 31, 2007

Report for the week

Some of the things I've been working on lately -

I fixed a problem with the term_admits view where it was dropping out transfer students because some didn't have any high school information in banner. I also added SAT, ACTN, and ACTS scores to the view.

I added new logic to szrcrbk and swrcrbk so that it now displays appropriate end term dates in the format YYYYMM. If an end term doesn't exist, it defaults to 999999 ( CAS default end term ).

I made some changes to the transfer articulation by course so that it displays the term description (i.e. Spring 2007) rather than the CAS date format (200704).

I finished up our NCAA reporting for this year and I'll be submitting our final numbers today.

I added 2 new columns to szrttui and szrfees that calculate the percentage of fees and tuition based on their tbracct_percent value. SZRTTUI is in wouupg and woutst for further testing.

I'm working with Financial Aid to get lists of students that received athletic aid for the 03-06 school years so that I can populate the sgrsprt table with the athletic aid indicator.

I'm currently working on Spring term Scarf report problems. I fixed a problem in the script where the ID type was not populating for dual enrolled students.

Reports I've worked on lately -
Enrollment numbers for Natural Science
Admitted students for 2002-2006 for Admissions

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

Transfer Articulation By Course

The Transfer Articulation by Course is now in production and can be found at https://banweb.ous.edu/wouprd/owa/wou_web.p_trans_artic_course
This is used for the CAS website for students to be able to find courses at other institutions that map to our courses.

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

May 18, 2007

SZRTTUI

I wrote a new job submission for the Business Office called SZRTTUI. It's a list of tuition by several detail codes/account codes that are stored in a crosswalk table called szrttui_xwalk. It has one parameter: term_code.

Posted by soukupm at 5:37 PM | Comments (0)

May 16, 2007

SZRCRBK - Atlas Course Bank

I put a new job submission into Banner called SZRCRBK. This is the Atlas Course Bank report used by the CAS system. This is a replacement for the older OUS report SWRCRBK ( this had a few problems, but I keep it around for reference ). The output is a list of courses from catalog (from the form SCACRSE). It has 4 parameters: term code, college code, department code, subject code.

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

May 9, 2007

Report for the week

I fell a little behind on my blogs so I'll catch up on what I've been doing lately.

I added a new parameter to the job submission SWEFADP2 (Advisee List by Advisor) called "Primary Advisor Only". Put in a Y for primary advisors listing, N for non-primary advisors. This report actually uses 2 different scripts, one for printing to a printer and the other for printing to the database. The second script is called swefadp3.pl.

The Hawaii student registration on saturday the 28th went well. There was bit of prep work I had to do for it though and I had to put all our current students into a bogus registration group so that no one couldn't register early besides the hawaii students.

I finally got access to the studentinfo website so I updated the reminders page and the lab hours.

Added some info text to bwskrsta.P_RegsStatusDisp to check back for updated dates for fall term registration. I moded the schedule of classes to display the same message.

I've been working on NCAA graduation rates reporting. It covers the 2000-01 cohorts, 2000-01 athletes, and 2005 enrolled. Just like before, we're missing data on athletic aid so Health and PE has been helping me on this. I've been adding in the data into Banner as soon as I receive it so that we can use it in future reports.

I've also been working on a course lookup webpage for the CAS system. This is a project from OUS for the Atlas project. How this page works is a student logs into the cas system and selects WOU. Then they type in a subj and course from our institution and this piece will return a list of institutions and courses that are equivalent to our course. It's sort of a reverse lookup of our transfer articulation webpage in banner web.

I did some non-standard updates to fix some nation and state codes for the consolidation project.

Registration for Fall 2007 is setup, the emails were sent out today. I'll be work on Early Bird registration as soon as I get a list from Admissions.

Last but not least, I've been working a web app for the Tuition Promise so that students can select if they want to join the Tuition Promise program or continue with the old tuition program. This app will appear when the student registers for Fall 2007.


Reports I've done:
Students from specific zip codes for the President's office.
Parents of students age 25 or less.
Updated list of enrolled students for Student Affairs.
Business major report for Business department.
Commencement address list for Registrar.
Clearinghouse for May.
Schedule of Classes for Provost Office.

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