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.
