SQL Query to find Records and Fields used in a PeopleSoft Page

Many a times you come across a situation when you need to find records behind a page or records associated with a field and so on. Most of such situations arise from the need to debug an issue and find a resolution for the same.

In this article you will find a few helpful SQL queries, which will come handy in such situations.

1. SQL Query to find all the Records and Fields used in a PeopleSoft page:


SELECT recname, fieldname
FROM   pspnlfield
WHERE  pnlname = PageName;
* Replace PageName with the actual Page name you want to reference
2. SQL Query to find all the Records where a particular PeopleSoft field is used:
SELECT DISTINCT recname, fieldname 
FROM   psrecfield 
WHERE  fieldname = FieldName;
* Replace PageName with the actual Page name you want to reference
3. SQL query to find all the page names where a field is used from a particular record:
SELECT pnlname
FROM   pspnlfield
WHERE  recname =RecordName
AND fieldname = FieldName;
* Replace RecordName and FieldName with the actual record name and field name respectively. You can also remove the and condition if needed.
These three SQLs are usually enough for me to get the information I am looking for. If you have any particular SQL you would like to seek help on or if you have any suggestions, please let us know in the comments box below.
Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

Click Here to Leave a Comment Below 0 comments