Understanding the Benefits of PeopleSoft Query Manager


Concept


Steps:

  1. This diagram illustrates the tables (records), columns (fields), and rows (field data) that you find in database.

    Step 1
  2. This diagram illustrates how PeopleSoft Query accesses PeopleSoft databases and how queries are exported to other file types.

    Step 2
  3. Use PeopleSoft Query Manager to extract information using Query's visual representations of the PeopleSoft database, without having to write SQL statements.

     

    After retrieving the data, you have the option of exporting the data to  various report formatting applications.

     

    Both the browser-based Query Manager and windows-based Query Designer use the same method to retrieve data from the database.

    Step 3
  4. In a PeopleSoft database:

    •  Query definitions (metadata) are stored in the PeopleTools tables.

    •  The data values of the selected fields are stored in the application tables.

    Step 4

You have reviewed the Benefits of PeopleSoft Query Manager topic.

Table of Contents  Start Topic