« November 2007 | Main | January 2008 »

December 28, 2007

Consolidation note: 3 digit county codes now

During the database consolidation, the county codes were switched from 2 digits to 3 digits. Keep this in mind when your looking at old programs because some of them may still be using 2 digit codes. I ran into one of these today when I was modifying SWARSCH.

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

December 20, 2007

Consolidation gotcha: hardcoded directories in scripts

We have 2 scripts that had the old mods.com directory hardcoded. Wou_finaid.pm uses a flatfile to load for the scarf script so it has the directory hardcoded. The other one is prt_ctrl.pl which is used in Banner to do special print options. It loads a flatfile which contains special printer control characters.

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

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 10:15 AM | Comments (0)

December 18, 2007

Recompiling Variables for Population Selection

After the merge some of the population selections stopped working and it turned out to be that the variables for the admissions application needed to be recompiled ( we were getting an error when running CANPHON under GLBLSEL). To do this, go into GLRVRBL and select the application (in this case ADMISSIONS) and select the variable that needs to be recompiled (*ID was our problem variable). Then make a slight change in the form (put a space or something and delete it). When you save changes, Banner will recompile the variable fo you.

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

December 5, 2007

New Job Submission: SZRSTRK

I created a new job submission called SZRSTRK that is used for the clearinghouse StudentTracker system. The output is a fixed format data file that you upload to the Clearinghouse. It has 3 parameters: term code, cohort code and search date. The term code and cohort code are used for identifying specific cohorts in the SGRCHRT table (first-time freshman) and search date is the date that the clearinghouse will look for subsequent enrollment. After you upload a file, Clearinghouse will return a report that shows what schools those students last attended. It can be used for finding out where students transferred to when they left WOU.

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