| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Dec 2, 2024 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Jan 27, 2025 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Feb 10, 2025 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Mar 10, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Apr 7, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| May 12, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Jun 9, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Jul 14, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Aug 18, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Sep 15, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Oct 20, 2025 | 09:00 | 05:00 | EDT | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Nov 17, 2025 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
| Dec 8, 2025 | 09:00 | 05:00 | EST | Live Virtual Class | 3 | $3,600 USD | Purchase |
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.
Duration: 3 Days
Prerequisites
- Understanding basic navigation and PeopleSoft concepts
Audience
- 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
Topics
- 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
