« June 2010 | Main | August 2010 »

July 28, 2010

Staff Development

For my staff development this week, I watched 8 of the getting started tutorial videos for Adobe Flash CS4. So far it seems pretty cool.

Posted by soukupm at 2:40 PM | Comments (0)

Garden 2010

Pictures of my garden...

Posted by soukupm at 2:12 PM | Comments (0)

July 23, 2010

Scarf changes for 6/30/2010

I made the following changes to the scarf script for the 6/30/2010 update:
Set student.ethnic to null
Set degree.ethnic to null
Staff benefit ssn field is vnumber now
Added IELT test score

Things to do:
Go over new FA detail codes with the business office and map them to scarf fiaidcat codes.
Add aid_year to finaid_cat
Add logic to allow multiple finaid records per student
Add fafsa_status flag
Add aid_year to finaid

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

Perl code updated with new race/ethnicity

The following perl code has been updated with the new race/ethnicity code:

wou_recruits.pm
wou_recruits_new.pm
wou_ar.pm
wou_person.pm
szrmrep.pl
szrmrep3.pl
szrawou.pl
szrceth.pl

Posted by soukupm at 2:28 PM | Comments (0)

July 16, 2010

SQL scripts that have been updated with new race/ethnicity

The following SQL scripts have been updated with the new race/ethnicity code:

SWAFREC
SWARAPN
SWIRCHT
SWNRNAB
SWNRNA3
SWIURCH
SWIURCH_CREATE

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

Pro C programs updated with new race/ethnicity

The following Pro C programs have been updated with the new race/ethnicity code:

PZRAFFM
PZRPSUP
SWARSCH
SWGRGPA
SWGRLIS
SZRHOBS
SZRVIKI

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

July 9, 2010

Veteran's data

The veteran's data is stored in SGRVETN. The vetc_code determines if a student is veteran,national guard,child or spouse (veteran's benefits are assignable).

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

f_get_ethnicity and f_get_race

I updated the wou_misc.f_get_ethnicity and wou_misc.f_get_race functions so that they use the new race/ethnicity table. The input is pidm and output is race code.

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

July 2, 2010

Research table script updated with new race code

I updated the research table script so that it pulls from the new race tables. The query is a lot more complex because the new race table allows multiple races to be saved per person. It also checks to see if the hispanic/latino flag is set on spbpers_ethn_cde and returns a "H" race code if found. For people that have multiple races, it returns an "X" code which identifies them as more than one race. For unknown or null race codes, it will return a "D" code for "declined to respond".

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

Upcoming Add/Drop fees change

There will be a change to the add/drop fees for Fall term. We have a trigger on sfrstca that charges these fees. This trigger will need to be modified so that it charges for every add and drop (the current process only charges once per day for drops and doesn't include adds). The trigger is named st_sfrstca_before_insert_row.

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