Audience :

Super Users within PeopleSoft Campus Solutions
End Users within PeopleSoft Campus Solutions
Managers within PeopleSoft Campus Solutions
  • Super Users within PeopleSoft Campus Solutions
  • End Users within PeopleSoft Campus Solutions
  • Managers within PeopleSoft Campus Solutions

Topics :

Technology Overview
What is PeopleSoft Query
Why should I use PeopleSoft Query
Using the Query Manager
Searching for Existing Queries
Organizing Queries
Creating My Favorite Queries
Editing Existing Queries
Creating a Query
Selecting Query Output
Editing Query Properties
Filtering Output with Criteria
Adding Criteria to Queries
Refining Criteria
Using Multiple Criteria Statements
Using the Effective Date Field in Criteria
Filtering Output with Runtime Prompts
Describing Runtime Prompts
Creating Runtime Prompts
Editing Runtime Prompts
Working with Multiple Tables
Describing the Purpose of Joins
Describing Predefined Joins
Using Record-Hierarchy and Related-Record Joins
Using Summary Calculations
Describing Aggregate Functions and Having Criteria
Adding Aggregate Functions
Using the Having Criteria
Creating Expressions
Understanding Expressions
Adding Query Runtime Prompts
Implementing Any Joins
Understanding Any Joins
Identifying a Cartesian Join
Working with Unions
Explaining Unions
Creating a Union
Using Literals as Placeholder Fields
Using Subqueries
Explaining Subqueries
Describing Single-Value and In List Subqueries
Using Exists or Does Not Exist Subqueries
Drilling URL’s
Understanding Drilling URL’s
Using Drilling URL’s and Connected
Performing Administrative Tasks
Using the Reporting Console
Describing Administrative Tasks for PSQuery
  • 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
  • Working with Unions
  • Outer Unions
  • Using Subqueries
  • Drilling URL’s
  • Administrative Tasks
  • Introduction to Pivot Grids