Oracle PeopleSoft Query is an end user reporting tool. With PeopleSoft Query, you can extract the precise information that you're looking for using visual representations of the PeopleSoft database without writing SQL statements. The queries that you write can be as simple or as complex as necessary; they can be one-time queries or queries that you use repeatedly.


This module explains the basic concepts of selecting data, designing simple queries, and sending query results to other reporting tools.


To take full advantage of the information covered in this module, you should be comfortable using Microsoft Windows and should have a basic familiarity with relational database concepts and SQL. In addition, this module assumes that you have a basic understanding of how to use PeopleSoft applications and are familiar with PeopleTools.


Upon completion of this module, you will be able to:

• Create and run simple queries.

• Define selection criteria.

• Modify, schedule, and organize queries.

• Work with advanced query options.

• Create workflow queries.

• Describe PeopleSoft Query Security.

• Describe Query Administration.

Table of Contents