« Weekly Report: Class Email List, Scarf Data Warehouse | Main | Weekly Report: Swarous Report »
November 18, 2005
Weekly Report: Fix County Codes
I wrote a procedure this week that will fix the "GO" addresses that have null county codes for the scarf report. There's a table in banner called gtvzipc that contains a crosswalk for zip codes,cities, and counties. I used this table to match up the county code by using the zip code and city from the list of null county addresses. Banner automatically adds the county code if the zip code is within Oregon but for some reason these records never did.
Posted by soukupm at November 18, 2005 02:48 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.)