Peoplecode: How to find records/fields within page

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.

 

For me to easy tracking.. this is very useful. Thanks Mr Google. 

Its may be as your references too.