« Weekly Report: Labels, Email Address Update,Faculty Evaluations | Main | Health Insurance Report »
February 09, 2006
Sectall duplicating problem
Sectall is a section tally web app that displays the current enrollment per class based on term and division code. There's two different versions of this app that exist: one on Aero (http://www.wou.edu/facultyinfo) for staff and one on Banner Web for faculty.
It seems that this app has been duplicating classes on both reports. There's a cron that runs in the morning called swwxweb that builds a table for this application. This is where the duplicates were happening. I traced it down to the table slbrdef, which contains the information about buildings/rooms. This table is now using a term code effective so we'll want to select the max(term_code_eff) to get a single row.
Posted by soukupm at February 9, 2006 03:59 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.)