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;
SELECT DISTINCT recname, fieldname FROM psrecfield WHERE fieldname = FieldName;
SELECT pnlname FROM pspnlfield WHERE recname =RecordName AND fieldname = FieldName;