« Recompiling Variables for Population Selection | Main | Consolidation gotcha: hardcoded directories in scripts »
December 19, 2007
Scarf Financial Aid EOY
I added some new code to the scarf script for the Financial Aid EOY report. This year I needed to include students all students that received aid including students not enrolled (this would only be workstudy aid). First thing I did was load the cohort:
-- make sure to end the cohort with a 'FA', otherwise you'll stomp on existing term records.
insert into scarf.reg (pidm,term_code,crn) (select distinct tbraccd_pidm,'200600FA','0'
from tbraccd
where tbraccd_term_code = '200600'
and tbraccd_detail_code IN
(select detail_code
from scarf.finaid_xwalk ))
Then add any students from scarf.ws_2006 (backup of the workstudy table) that had any workstudy (sum(xxmonthearnings) > 0) and no sfrstcr record exists. There was a couple few of these mostly in summer term. Once that's all done, enter the cohort code into the special_cohort variable when running the scarf job submission. The scarf filename should be SCARF20-70-YYYYYY-TQ.DAT, YYYYYY is year T is term.
Posted by soukupm at December 19, 2007 10:15 AM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)