« December 2007 | Main | February 2008 »

January 31, 2008

Removed all_rows compiler hint from applications

I removed all the spriden /*+ all_rows */ compiler hint from our applications yesterday (Pro C, Perl, SQL, PL/SQL). These are no longer needed because of the database consolidation since spriden is no longer a view on SIS. All of the applications I modified are listed in the file I:\Staff\Programmers\Banner_Stuff\consolidation\all_rows_hint.txt just in case we need to put the hint back on. All of the programs I tested seemed to work well and some ran faster with the hint removed.

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

January 30, 2008

Updated SGRSPRT for Athletic Aid Indicator for 2007-08

I did a non-standard update to the table SGRSPRT today and set the sgrsprt_athl_aid_ind = 'Y' for student athletes that received athletic aid in Fall 07 and Winter 08. I worked from a spreadsheet that I received from Health and PE.

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

January 28, 2008

Updated SGRSPRT for Athletic Aid Indicator for 2006-07

I did a non-standard update to the table SGRSPRT today and set the sgrsprt_athl_aid_ind = 'Y' for student athletes that received athletic aid in the 2006-07 school year. I worked from a spreadsheet that I received from Health and PE.

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

January 24, 2008

New job submission: SZRMREP

I put a new job submission into production today called SZRMREP that is a replacement for the old mreport SWRREP2. It includes new,transfer, and continuing freshman categories and many fixes to the A and C reports. The report has 4 parameters: term code, part of term, report, and version. Here's a list of available reports:

Report A version 1&2: List of all students and all statistics
Report B version 1: List of all students (no statistics)
Report B version 2: List of No Pay students
Report C version 1: All Statistics
Report C version 2: First page statistics ( this is the version on the web http://www.wou.edu/mreport)

Statistics reports include:
Credit Hour Statistics
Age Statistics
Enrolled Graduate Students
Enrollment Analysis by Age
Student Credit Hours by Course Level
FTE Enrollment Analysis
Term Enrollment Report
Institutional Enrollment Analysis
Enrollment Analysis by Geographic Source

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

January 16, 2008

SCARF: Changed finaid category code for repay detail codes

I changed the way the scarf financial aid category query calculates the total amount for the term for students. Several new detail codes were added this last year that are repayments and the total was not calculating correctly. The old code did a sum(tbraccd_amount) and didnt take into account that these new codes are actually payments and should be subtracted from the total amount. So now it decodes whether its a charge or a payment: sum(decode(tbbdetc_type_ind,'C',tbraccd_amount,tbraccd_amount*-1))*-1 to come up with the correct results.

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

January 10, 2008

Updated null county codes in SOBSBGI

I did a non standard update on SOBSBGI (source institution address table for schools) to populate county codes that were null for all Oregon schools. I used the banner table gtvzipc to update the county codes since there is already a county-to-zip code translation. The reason for the update was that the report SWARSCH wasn't very accurate because there were too many counties missing in SOBSBGI.

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

January 9, 2008

New job submission: SZPINTL

I created a new job submission for Banner this week called SZPINTL. This job will add and remove registration holds for International students for the term. It has 2 parameters: term code (gets all registered International students for the term specified), and run_mode ( A to add holds, R to remove them all). When holds are on, they will show up on SOAHOLD as an "IE" type hold with a reason "IE Registration Hold". The reason this job submission was created was to prevent International students from dropping credit hours during the term, especially below 12 credit hours (some are required to have at least 12 credits).

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

January 1, 2008

Scarf Note: Added virtual campus code

I added a some logic to the scarf script to set the campus code to "98" (virtual campus) when the delivery method for the course is set to U (online).

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