PeopleSoft Query 2: Intermediate Query HCM

Current Status
Not Enrolled
Price
$2,354.00
Get Started
This course is currently closed

Advanced Query Topics

Adhoc analysis, data sources, and reporting

  • Manual joins
  • Expressions
  • Subqueries
  • Outer joins
  • Unions
  • Connected queries
  • Composite query
  • Pivot Grids
  • Security

PeopleSoft Query is the data source for many PeopleTools features, such as Pivot Grids, BI Publisher, and Elastic Search

On-Demand

60-days access
$2,354 USD

Live-Virtual

Two days
$2,354 USD

Subscribe

This Activity Guide is included
$6,700 USD

Topics Covered

  • Automatic joins
  • Manual joins
  • Expressions
  • Criteria expressions
  • Prompts in expressions
  • Aggregates in expressions
  • Concatenation expressions
  • Drilling URLs
  • List-of-values subqueries
  • Exists subqueries
  • Outer joins
  • Unions
  • Connected queries
  • Composite queries
  • Pivot grids
  • Query security trees

Who Should Attend?

  • Functional analysts
  • Functional users
  • PeopleSoft Developers
  • Administrators

Course Content