PS Query & SQL

 View Only

  • 1.  I need help with a PeopleSoft query

    Posted 08-06-2026 09:35 AM

    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.
    ------------------------------
    HEUG ANZ - Brisbane, 9-10 September 2026


  • 2.  RE: I need help with a PeopleSoft query

    Posted 08-07-2026 12:31 PM

    Hi Sherran,

    I believe what you're looking for is the unintuitive use of the Course Component.  The SSR_COMPONENT - Course Component on CLASS_ASSOC is the graded section for a class, and on CLASS_TBL, it is the course component of the specific section.  The screenshots are how I would find sections that are set up in Class Associations as the graded section, and those same components have an Associated Class of 9999.



    ------------------------------
    Ross Nolan
    Data and Reporting Analysis
    University of California-Berkeley
    rvnolan@berkeley.edu
    ------------------------------

    HEUG ANZ - Brisbane, 9-10 September 2026


  • 3.  RE: I need help with a PeopleSoft query

    Posted 08-07-2026 12:45 PM

    Thanks very much for your reply.

    Unfortunately, that's exactly how our query is set up but what it actually returns are the lectures with an association of 9999 in a course that also includes graded lectures.  We have a number of courses that include both 9999 lectures and standalone lectures that have associations that are not 9999.  Even if those courses are correctly set up with the non-9999 lectures being graded and the 9999 lectures not being graded, the query returns the 9999 lectures because they're part of a course that has a graded lecture somewhere on the Class Associations table. 

     

    Here are the criteria for our query.

     

    L Sherrán Pak (she/her)

    University of Wisconsin Madison

    Office of the Registrar

    333 East Campus Mall, Suite 11101

    Madison, WI 53715

    (608)262-4411

    sherran.pak@wisc.edu

     




    Original Message
    HEUG ANZ - Brisbane, 9-10 September 2026


  • 4.  RE: I need help with a PeopleSoft query

    Posted 08-07-2026 03:07 PM

    Thanks to everyone who has responded so far.

     

    I imagine there are many different ways of setting up courses among institutions so, just in case this is helpful, here's an Adjust Class Associations view of one section of one of our courses that has 9999 lectures.  This course consists of three lectures, two of which have the 9999 association, and one that has a "real" associated class number, let's say it's "2".  We always want the lecture to be the graded component for non-9999 lectures so the "2" lecture does have LEC as the graded component.  We do not want (and PeopleSoft often balks at) LEC as the graded component for any 9999-association lectures, so they should have DIS as the graded component.  Even if the graded components are correctly set up for all associations of this course, lectures 001 and 002 are going to show up in our query results because they are 9999 sections and they're sections of a course that has LEC as the graded component for one of the associations.

    For the association in the screenshot, discussion 302 is associated with either of the 9999 lectures shown at the bottom of the page. (The graded component is correctly set as Discussion in this case.)

     

     

    You'd think, or at least I did, that the 9999 lectures being listed right there at the bottom of the Adjust Class Associations page, along with their class numbers and section numbers, would mean that I could find those fields in the Class Associations page.  However, they're coming from a Class Table view. 

     

    Sorry this is so complicated but, if it were easy, we'd already have the query we want.

     

    L Sherrán Pak (she/her)

    University of Wisconsin Madison

    Office of the Registrar

    333 East Campus Mall, Suite 11101

    Madison, WI 53715

    (608)262-4411

    sherran.pak@wisc.edu

     




    Original Message
    HEUG ANZ - Brisbane, 9-10 September 2026


Related Content