This session was presented at BLUEPRINT 4D 2026.

If you’re a PeopleSoft HCM technical or functional user that is looking to learn some tips and tricks of Query Manager: this session is for you. If you are confident in your ability to write queries to retrieve transactional information about employee/admin data; and are looking for ways to be more sophisticated in your data retrieval: then this is the session is also for you! We will begin with some basic tips and tricks for query writing: and then move to some more complicated topics: like creating smart prompts: or using expressions wisely. Finally: we discuss some advanced topics such as using query manager administration and performance management. We will review query capabilities in latest PUM and PeopleTools version of Oracle/PeopleSoft HCM. Topics Covered will include: 1. Query Manager Tips – Demo 2. Understanding Joins 3. Manipulating Data with Expressions 4. Aggregating Data 5. Sub Queries 7. Drilling URLs 8. Tips and Tricks 9. Query Admin and Performance enhancement Learning Objective #1 Learn Tips and Tricks for Query Manager, with specific from PeopleSoft HCM Application Learning Objective #2 Understand opportunities to build queries and enhance skills to understanding data presentation with queries. Learning Objective #3 Review query capabilities in latest PUM and PeopleTools version of Oracle/PeopleSoft HCM


This session is eligible for the following CPE Credit: NASBA, SHRM

Speaker: Rahul Nori, State of Minnesota