PS Query & SQL

 View Only
  • 1.  PeopleSoft Query Tool Comparison

    Posted 07-10-2025 10:54 AM

    Good Morning All 

    Dan Labrecque and I presented on Composite Query about two weeks ago, and I have been (slowly) trying to respond to questions.  Some of the most common questions include: when is it appropriate to use Composite Query, what is the difference between Connected Query and Composite Query, and when is regular query a better choice.  

    I created a document to help answer these questions, and have posted it to the PS Query & SQL Library.  It attempts to answer these questions, and is a comparison of Query, Connected Query and Composite Query.  

    PeopleSoft Query Tool Comparison 

    I hope this is helpful, and I am interested in any comments folks might have on this document, particularly on additional data information that might be helpful .  



    ------------------------------
    Tom Johnson
    Sr Business Systems Analyst
    Duke University
    tom.johnson@duke.edu
    "None of us is as smart as all of us"
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: PeopleSoft Query Tool Comparison

    Posted 07-11-2025 05:41 PM

    Thank you Tom for posting this. Great webinar also from you and Dan. 



    ------------------------------
    Shawn Trauntvein MPA
    PeopleSoft System Analyst for Financial Aid
    Brigham Young University
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!