« December 2006 | Main | February 2007 »

January 30, 2007

Work Report

Here's some of the things I've been working on lately:

I changed the classrst package so that phone numbers are in the priority LO,CU,PR (before it was just getting LO).

I moded financial aid's package wou_finaidload2 so that email addresses will print to the file when they run the end of term admissions report.

Did several reports -
Counts of Pre-Eduction majors for Education.
Count of grades for the past 5 years for Registrar's Office.
Native American report for Multicultural Students.
Labels for Student Leadership.
First term freshman reports for Student Affairs.
Labels and lists for Medical holds for Health Center.
Student Level and full-time/part-time status report for Registrar.
Earned hours report for Registrar.

I spent a lot of time last week working on 2006 finaid factbook from OUS, comparing numbers with what I sent them from the scarf report and what we have in Banner currently and what Financial Aid had in their database. I re-wrote part of the scarf_verify package so that it displays through dbms_output instead of through a webpage (report takes too long and eventually times out on the web). I added workstudy numbers to the scarf_verify report and an option to get the entire year's worth of workstudy totals to the p_workstudy report.

I added some new code to the scarf report so that it will report the correct instructional method for courses.

I fixed a problem with grades in the scarf report after comparing numbers with the grade report I wrote for the Registrar's Office. Our B and B+, C and C+, D and D+ were flip-flopped in the scarf report.

I made a change to the scarf report so that the acad_std_future (end of term academic standing) will map to D (disqualified) per OUS request.

Posted by soukupm at 10:19 AM | Comments (0)

January 25, 2007

Instructional Method for Courses

I meet with the Registrar's Office this week about identifying online computer-based, correspondance and video-based courses in Banner. We came up with a solution to identify these courses in the form SSASECT in the Instructional Method field. I populated the form GTVINSM with these values:

COR - Correspondance instruction
ONL - Online computer-based instruction
TRA - Traditional in-person instruction
VID - Video-based learning courses

When a new course is created, one of these four options will be available to select from in SSASECT. Since Spring 2007 courses were already in Banner, I did a non-standard update and set all the part of term 1 courses to TRA. The registrar's office will go through and change any other courses to ONL,COR,or VID where appropriate.

This new method will help us identify these types of courses much easier for SCARF, IPEDS, and any other reporting needs.

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

January 22, 2007

Work report

Some of the things that I've been working on for the past 2 weeks:

Fixed the Degree Verify report for Clearinghouse. The formatting for the flat file needed to get updated (the online documentation showed a much different format with a lot more fields). I added new data to the report ( major 2, minor 1, minor 2, concentration 1,
concentration 2, concentration 3).

The Scarf Fall end of term is just about complete. The "W" grades have been fixed and now I'm just validating the numbers. I fixed the script so that it pulls grades from history (shrtckg) instead of from sfrstcr. I also fixed a problem where the script was grabbing the highest SAT scores and not every test score. I'll be loading the data for this term in our scarf reg table soon.

I'm working on the Scarf Degree Supplemental (2003-2006) right now. So far I have the 2004-05 problems fixed and I'm waiting for reports back for 2003-04 and 2005-06.

I installed EDExpress 07-08 and Powerfaids 12.1 for Financial Aid.

I moded SZRFORN job submission and added enrollment status, ISS base and A063 detail code amounts to the report.

I finished up a first time freshman report for the Admissions Office for 2001-2006. This report had a lot of statistics on first time freshman including earned hours, gpa, academic standing, enrollment status, gender, ethnicity, citizenship,high school gpa, SAT/ACT scores.

I fixed the online transcripts and transfer articulation so that all faculty can view them now.

I changed the online class rosters so that it will get addresses in the priority of LO,CU,PR.

I ran the OUS second week report and I'm filling out the spreadsheet now.

Posted by soukupm at 09:06 AM | Comments (0)

January 05, 2007

Dual Enrollment and Clearinghouse

I modified the clearinghouse script so that it gets the total credit hours from the ryrofax table (dual enrollment table) instead of from sfrstcr (only WOU credits). The student must be registered at WOU for at least 1 credit hour for the term and WOU must be specified as the home institution, otherwise it will only report WOU credit hours.

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