« September 2008 | Main | November 2008 »
October 28, 2008
Report for the week
Some of the things I've been working on lately...
Scarf 4th week report - fixing errors,added nursing students to headcount, finishing report for final certification.
fixed swbrdt5 - pulls ssn from spbpers now.
created 4th week research table, new freshman cohort, saved copy of student tables for 4th week (from scarf_4th.sql).
fixed szrdeps - subject totals now correct.
Service requests
DBMS_LDAP - gathering more info about it.
Currently working on -
AAS degree with ASOT attribute trigger problem.
WOUCHEK mod
Vendors with 5000 activity
New schedule for clearinghouse
-Reports-
Department of Revenue
Course catalog with cipc for budget/payroll
Swirbut fall 2007
Graduate lists for Education
Non-standard update to fix KDM nation code
Fixed szrmrep3 in wouupg
MMR holds for health center
Ethnicity report for multicultural students
Health insurance for Business Office
New admits list for Admissions for 4th week
Posted by soukupm at 9:20 AM | Comments (0)
October 27, 2008
Scarf_4th script
I made some changes to the scarf_4th script and updated the temporary table names it used. Some of the tables got renamed when we consolidated the databases and this script was never updated until now. The tables are named scarf.scarf_bannertablename and hold student infomation used by the old scarf script (not really used much these days except in a couple scripts or if your looking for specific 4th week data).
Posted by soukupm at 2:22 PM | Comments (0)
October 17, 2008
WOU_FA package mod
I added the current date to the update statement for the aiddecision table when aid is declined. This will help financial aid keep track of changes to aid when aid is declined (and was previously marked undecided). They run SZRDAID to get a report of changes.
Posted by soukupm at 11:13 AM | Comments (0)
October 14, 2008
New job submission SZRDEPS
I created a new job submission called SZRDEPS this week. It's a section tally report for DEP that lists their course for the term. The parameters are term code. The output is a list of courses for the term including enrollment numbers.
Posted by soukupm at 11:19 AM | Comments (0)