« Work Report | Main | Work Report »
November 29, 2006
Work Report
Here's some of the things I worked on last week and this week.
We were missing SAT test scores in our scarf 4th week submission and it turns out that the new students are now reporting SATR scores. I modified the scarf script to collect these scores. Right now the scores are being mapped as SATV scores (OUS wants them mapped to this for now). I did a resubmit of our 4th week scores to OUS.
Since I had to report test scores only for the 4th week students, I added a new parameter to the scarf job submission called "special_cohort". This parameter is a term code in the scarf.reg table (where I've been storing our scarf registration data). Basically it'll grab all pidms in the table with that specific term code. So for the 4th week students, I plugged in '20064W' and it ran a scarf report for only those specific students.
I updated our scarf_fincat_xwalk table to add the new voyager fee remission, SMART grant and ACG grant. OUS wants a resubmit of all financial aid records for 2005 and summer 2006. I'm currently working on that now.
I added a new column "high school" to the job submission SWAFREC (recruit records). This is in production now.
Biquery broke last week when maverick_nt was taken offline. I worked with Ron to move the old oracle software from maverick_nt to the v:\biquery directory. We have a new registry in the V:\BIQuery\orawin6b directory to fix these problems.
I worked with Ron to get Financial Aid access to the old dept_data directory that they used for their admission load.
There was a bug in the print credit app on Banner Web that was returning an incorrect login ID for some users. This is fixed and seems to be running correctly now.
I built 2 new research tables for 2005 4th week (research_200501_4th) and 2006 4th week (research_200601_4th) from the scarf files I saved. These can be used for reporting our official numbers for 4th week. I also built full-time first-time freshman cohorts for 2005 and 2006 4th week. The cohort codes are F05F and F06F.
I'm currently working on IPEDS graduation rate survey for Fall 2000 cohorts.
Posted by soukupm at November 29, 2006 02:49 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.)