« Weekly Report: Quickadmit Application, Scarf degree report, Powerfaids upgrade, ICS 101 Project 2 | Main | Email Cleanup »
January 25, 2006
Scarf Degrees
The scarf degree report is a job submission in Banner that saves the degrees awarded for the year in a file in the spool directory. To get the degrees for 2004-2005 school year, you would put in 2004 for the year and Y for end of year and SCARF20-60-200405-0Q.DAT for the file name.
For the most part, the report is very accurate except there's a problem in the licensure logic that I've been working on that occurs when a student receives a continuing license but doesn't have any authorizations or endorsements in Banner. Unlike the typical degrees, these licensures are stored in the table shrevnt as codes with effective dates. Authorizations are stored as 3XX numbers, endorsements are stored as 2XX, and continuing licenses are stored as 308. To get the licensures for the year, you would select shrevnt_even_code like '3%' and like '2%' with an effective date between 8/31/2004 and 8/31/2005 for the 2004-5 school year.
For the scarf degree report, we have a record for every student/license(initial/continuing)/authorization/endorsement combination. One of the conditions is that every record needs at least one authorization. If we used the code above to get the licensures for the year, we would definitely get all the students but we run into problems with the continuing licensures. Not every continuing licensure student receives an authorization in the same year. So they have to be seperated out of this group and a new query needs to run so that we collect their prior authorizations and endorsements (any authorizations or endorsements with an effective date <= 8/31/2005).
I finished the logic above and it does collect their prior authorizations/endorsements. I'm up to the point where a student doesn't have any prior authorizations/endorsements. I will label these in the report as problems that have to be manually corrected.
Posted by soukupm at January 25, 2006 08:49 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.)