| Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
|---|---|---|---|---|---|---|---|
| Apr 10, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| May 8, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| Jul 10, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| Sep 18, 2023 | 09:00 | 05:00 | EDT | Toronto - In Class or by Video Conference | 3 | $3,600 USD | Purchase |
| Nov 13, 2023 | 09:00 | 05:00 | EST | Toronto - In Class or by Video Conference | 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. Those on 8.54, 8.55, 8.56, and 8.57 can benefit from taking this class.
Duration: 3 Days
Prerequisites
- 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)
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
