PeopleSoft Query Reporting Tools

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