PeopleSoft Query Reporting Tools

Overview

Applies to 8.57

This PeopleSoft Query Reporting Tools training covers the following PeopleSoft query reporting tools:

• Simple Query
• Composite Query
• Connected Query

Learn To:

• 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.

Audience

• Developer
• End User
• Manager

Suggested Prerequisites

• Working knowledge of the PeopleTools development environment
• PeopleSoft PeopleTools I (suggested not required)

Topics

• Technology Overview
• 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