Header Ads

  • Recent Posts

    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

    1 comment:

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad