PeopleSoft Query Reporting Tools

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Nov 4, 202409:0005:00ESTLive Virtual Class3$3,600 USDPurchase
Jan 27, 202509:0005:00ESTLive Virtual Class3$3,600 USDPurchase
Feb 10, 202509:0005:00ESTLive Virtual Class3$3,600 USDPurchase
Mar 10, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Apr 7, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
May 12, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Jun 9, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Jul 14, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Aug 18, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Sep 15, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Oct 20, 202509:0005:00EDTLive Virtual Class3$3,600 USDPurchase
Nov 17, 202509:0005:00ESTLive Virtual Class3$3,600 USDPurchase
Dec 8, 202509:0005:00ESTLive Virtual Class3$3,600 USDPurchase


PSQR8.55

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. 

Duration: 3 Days

Prerequisites

  • Understanding basic navigation and PeopleSoft concepts

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
Right Menu IconMENU