How to find all the records and fields within PeopleSoft Page and PeopleSoft Component?

Are there SQL queries to find the records used in a page, component?

Are there SQL queries to find fields used in record, page or component?

Yes, we can find these information using SQL queries.

1. SQL Query to find all the record names where a field is used:

SELECT DISTINCT recname,
                fieldname
FROM   psrecfield
WHERE  fieldname = :1 --Field Name;

2. SQL Query to find all the records and fields used in a PeopleSoft page:

SELECT recname,

       fieldname

FROM   pspnlfield

WHERE  pnlname = :1 --Page Name;

3. SQL query to find all the page names where a field is used from a particular record:

SELECT pnlname

FROM   pspnlfield

WHERE  recname = :1 --Record Name

       AND fieldname = :2 --Field Name;

4. SQL Query to find all the fields from various records used in a PeopleSoft Component:

SELECT cp.pnlgrpname,

       cp.market,

       cp.descr,

       cpg.pnlname,

       cpg.itemlabel,

       pg.descr,

       pgf.fieldtype,

       pgf.lbltext,

       pgf.recname,

       pgf.fieldname

FROM   pspnlgrpdefn cp,

       pspnlgroup cpg,

       pspnldefn pg,

       pspnlfield pgf

WHERE  cp.pnlgrpname = :1 --Component Name 

       AND cp.market = :2 --Market 

       AND cp.pnlgrpname = cpg.pnlgrpnam

       AND cp.market = cp.market

       AND pg.pnlname = cpg.pnlname

       AND pgf.pnlname = pg.pnlname; 

5. SQL Query to find all the records used in a Component:

I have blogged this SQL query sometime back, and here is a link to that post - SQL Query to Retrieve all Records associated with a PeopleSoft Component