« Weekly Report: Swarous Report | Main | Weekly Report: Scarf, Gpa project »
December 01, 2005
Weekly Report: Scarf Finaid, Workstudy
This week I've been validating the financial aid numbers from scarf for last year. I loaded in the registration data from last year's reports into the table scarf.reg for use of validating these numbers and to have an archive of the old scarf reports. The table looks like this:
Name Type Nullable Default Comments
-------- ----------- -------- ------- --------
TERM VARCHAR2(6) Y
CRN VARCHAR2(5) Y
PIDM NUMBER(8) Y
CHRS NUMBER(4,1) Y
GRADE NUMBER(3,1) Y
REG_STAT NUMBER(1) Y
The data is keyed by term code/pidm/crn and can be used for headcounts, credit hours, grades, courses, etc.
I also been working on getting workstudy data into the scarf report. I need to report workstudy for all of last year so I've been working with Financial Aid and Payroll on getting those numbers. Currently the scarf report does not include workstudy so I've been working on a function to include them.
Posted by soukupm at December 1, 2005 01:21 PM
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.)