Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Nov 4, 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