Please enable javascript to view this page in its intended format.

Queen's University

PS Query for Human Resources

This self-study course provides participants with an in-depth study of PeopleSoft query development. Topics include use of the PeopleSoft Query developer pages and utilities, query development and deployment, and details regarding key HR Tables and Data structures.

The PS Query for Human Resources course will demonstrate:

  • Overview of PS Query development
  • Building and Deploying Queries
  • Adding Criteria and Prompts
  • Joining Tables
  • Using Expressions, Unions, and Sub-queries
  • Using PS Query to Determine Table Structure
  • Key HR Tables and Data Structures

Download the slide presentation for the PS Query for Human Resources course

Download the data structures guide for the PS Query for Human Resources course

Recommended Prerequisites: Introduction to PeopleSoft Navigation (online tutorial); Introduction to PeopleSoft for Human Resources

Queen's Human Resources
Fleming Hall, Stewart-Pollock Wing
Kingston, Ontario, Canada. K7L 3N6.
T: 613.533.2070 | F: 613.533.6196