« Weekly Report: Fix County Codes | Main | Weekly Report: Scarf Finaid, Workstudy »
November 22, 2005
Weekly Report: Swarous Report
I spent a little time this week figuring out how the swarous report worked, what tables it was getting the data from, and so on. This is a report that displays admissions statistics such as ethnicity, resident, non-resident, international and then further broken down by grade level,etc. The last page of this report tallys the undegraduate transfers and supposed to give the number of students transferred from OUS institutions,Oregon Community Colleges, Oregon Independant, and Out of state. But for some reason, the majority of students were grouped under "Transfer source unknown". After looking further into the code, it uses the tables sobsbgi,stvsbgi,sorpcol and some decoding logic to determine if its an OUS/Oregon or out of state college. The table sobsbgi contains the location of the institution. This is were the code is failing to determine the location because few institutions are populated with state codes. The table stvsbgi contains the type of institute and description. And the table sorpcol matches the student to the institution in stvsbgi.
Posted by soukupm at November 22, 2005 03:46 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.)