How do I find queries in PeopleSoft?

Access the Query Access Manager page (PSTREEMGRACC) (PeopleTools, Security, Query Security, Query Access Manager). Use the Query Access Manager page to create query trees or search for existing query trees. PeopleSoft provides sample trees with all of its applications.

Table of Contents

What is a PeopleSoft query view?

Query Viewer is a PeopleSoft end user reporting tool. With Query Viewer you can access preexisting queries or requests for information created by other users. A user who creates queries may place the results in a public file that can be viewed by other users.

How do you create a PS query in PeopleSoft?

In PeopleSoft Query, we refer to the record definitions as records. To select a record in the Records page: Find the record upon which to base the query….To access the Records page:

Select Reporting Tools > Query > Query Manager.
Click the Create New Query link.
Click the Search button.

How do I run a report in PeopleSoft?

1. Log in to PeopleSoft through either the Human Resources or Financials login and navigate to the report you want to run. 2. Once the Run Control ID and associated criteria are entered, and the report has been run, click the Process Monitor link.

What is PS Query in PeopleSoft?

PS query is a powerful tool for end users to fetch data from PeopleSoft application and users can create public and private queries. Although public queries can be viewed by anyone having access to Query Viewer or Query Manager but private queries can only be seen by the user who created them.

What is PeopleSoft Query Manager?

PeopleSoft Query is an end user reporting tool. With PeopleSoft Query, you can extract the precise information that you are looking for by using visual representations of your PeopleSoft database, without writing SQL statements.

How do I create a query in PeopleSoft query Manager?

Use these steps to access the Query page:

Select Reporting Tools, Query, Query Manager.
Click the Create New Query link.
Click the Search button to find an existing record.
Click the Add Record link for the desired record. The Query page appears.

What is a PeopleSoft run control?

The PeopleTools Run Control table stores information that is required by PeopleSoft Process Scheduler, such as output type, format, distribution, file dependency, and destination.

What is PeopleSoft query Manager?

Why are queries used?

Using a query makes it easier to view, add, delete, or change data in your Access database. Some other reasons for using queries: Find specific quickly data by filtering on specific criteria (conditions) Calculate or summarize data.

How do I create a query manager in query?

2) Create New Query

From the Reporting Tools page, click the Query folder to access the Query Manager.
Click the ‘Query Manager’ navigation link to go to the Query Manager page, where you can create, edit, save, and export queries.
Click the ‘Create New Query’ link.