11/18/11

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.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month