When we have a course that consists of a lecture associated with multiple discussions or labs, we assign the lecture the associated class number 9999 and the discussions or labs are each given a unique non-9999 association.
We have a query that finds courses that contain both a graded lecture and a lecture with the 9999 association even if those are different lectures within the course. I'd like to improve it by making it identify specific lectures that are both graded and have a 9999 association (since we don't allow that and will need to correct it) but the obstacle I'm running into is that I can't find a field to identify the same lecture in Class Associations, where the graded component is indicated, and in Class Table, where the 9999 lecture is indicated. Have any of you created a query like the one I'm describing? If so, how did you do it?
Thanks.
P.S. I'm using the query tool within PeopleSoft, not SQL.
------------------------------
Sherran Pak
Program Specialist
University of Wisconsin - Madison
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------