PeopleSoft Query Reporting Tools

Overview

This course teaches participants how to create SQL queries using basic and advanced features of the PeopleSoft Query tool. Students will learn the fundamentals of Query Manager, including how to retrieve information from multiple tables, define criteria, use aggregate functions, and accept data input by users for filtering results. Students will also learn how to create various types of joins, expressions, subqueries, and unions. The hands-on activities in this course are created using real-world examples and data.

Audience

• Developer
• End User
• Manager

Suggested Prerequisites

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

Topics

• Technology Overview
• Using the Query Manager
• Creating a Query
• Filtering Output with Criteria
• Filtering Output with Runtime Prompts
• Working with Multiple Tables
• Using Summary Calculations
• Creating Expressions
• Implementing Any Joins
• Outer Joins
• Using Subqueries
• Drilling URLs
• Introduction to Pivot Grids
• Connected Query
• Composite Query
• Administrative Tasks