PeopleSoft Query Reporting Tools



Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Nov 13, 202309:0005:00ESTLive Virtual Class3$3,600 USDPurchase
Jan 29, 202409:0005:00ESTLive Virtual Class3$3,600 USDPurchase
Mar 18, 202409:0005:00EDTLive Virtual Class3$3,600 USDPurchase
May 13, 202409:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Jul 15, 202409:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Sep 23, 202410:0006:00EDTLive Virtual Class3$3,600 USDPurchase
Nov 4, 202409:0005:00ESTLive Virtual Class3$3,600 USDPurchase


PeopleSoft Query Reporting Tools

This PeopleSoft Query Reporting Tools training teaches you how to design and run query reports using PeopleSoft Query, Composite Query, and Connected Query in a PeopleTools environment. You learn how to create queries, filter and refine output, run and download query data to popular output formats, and more. Those on 8.54, 8.55, 8.56, and 8.57 can benefit from taking this class.

Duration: 3 Days


  • Programming experience, preferably in an object-oriented language
  • Working knowledge of the PeopleTools development environment
  • PeopleSoft PeopleTools I
  • PeopleSoft PeopleTools II
  • Experience developing PeopleSoft applications (suggested)


  • Developers
  • End Users
  • Managers

Learning Objectives

  • Filter output with criteria and runtime prompts
  • Work with multiple tables and summary calculations
  • Perform PeopleSoft Query administrative tasks
  • Create expressions, drilling URLs, standard joins and left outer joins
  • Use aggregate functions, subqueries, and unions
  • Run and download query data to popular output formats, including HTML, Microsoft Excel, XML, and CSV formats
  • Schedule queries to run at specified times
  • Perform PeopleSoft Query administrative tasks
  • Filter output with criteria and runtime prompts
  • Work with multiple tables


  • Working with PeopleSoft Query
  • Creating a Simple Query
  • Filtering Output with Criteria
  • Filtering Output with Runtime Prompts
  • Working with Multiple Tables
  • Using Summary Calculations
  • Performing PeopleSoft Query Administrative Tasks
  • Creating Expressions
  • Drilling URLs in PeopleSoft Query
  • Implementing Standard Joins
  • Using Subqueries
  • Working with Unions
  • Performing Left Outer Joins
  • Using Composite Query
  • Using Connected Query
Right Menu IconMENU