Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
If you are new to Peoplesoft, you will hear about PS queries. It is nothing but a reporting tool. It is mainly used for running simple or complicated SQL queries to get information from PeopleSoft records. PS query can be accessed from the PIA. So any functional user can access a PS query without having database access, but records need to be added to the tree for access . For creating PS query involves 4 steps
Go to the navigation Main Menu > Reporting tools > PS Query > Query Manager and click on the link ‘Create a New Query’ to open the below page:
Now we need to select the list of fields that need to for the query
In PS query, there are two types Public queries. (This query can be accessed by anyone. So there will be no issues in finding the view sql.) and private queries (This query cannot be accessed by anyone apart from the owner.) .
In order to make private queries to public, you need to run the below SQL
In this case, first we can find the owner of that ID and ask them to assign a new owner.
Select qryname , lastupddttm, createoprid from psqrydefn where qryname = ‘your_query_name’;
By this way, we can find the ownerID and access the query
Go to PeopleTools > Utilities > Administration > Query Administration
In order to access the custom record, they need to add it to the tree
Navigation :Peopletools >security > query security >selecting access group > add child record.
There are multiple PS records which have listed below
Thanks
Kindly comment to us if you have clarifications in PeopleSoft . If you want to know about roles and permission list click here
[…] If you want to learn about How to create PS query you can click here . […]