PeopleSoft Wiki

Peoplesoft record hierarchy with navigation. is to understand the dataflow using peoplesoft prompt tables. this query works only in oracle datatabse it takes few minutes to execute as the query has to go through n number of tables.

This is useful in understanding the data flow between tables. specially in instances where peoplesoft is heavily customised. Currently it works with oracle database. CSGC_CMPRND_TBL replace by your record name.

Once we create pages and component for multilanguage application. we can missout on related language tables. here is the trick to do that. Sql is currently for oracle.

Peoplesoft related language tables with their key structure. This is extemely useful in tools data conversion. Or move from one version to another

We can document records in Peoplesoft project using following sql. We can use screen shots also but they are not helpful if want to perform some kind of search for info.

Once we have created our projects its difficult to document every thing. Like object invloved etc. we can leverage the sql below to do that.

Compare objects of peoplesoft project. Useful when applying patches. or when making a major release to make sure that we are not over riding other customisation.

SQL TO GENERATE INSERT SCRIPT FOR A PEOPLESOFT RECORD. replace the PSMSGCATDEFN with your record. Run in oracle SQL tool. It will give a select statement add where or filter clause to it to generate insert statements

Sql to find complete navigation and permission list, roles etc for a given component .

comma separated list of roles for each user. Note that this will only work on Oracle databases

list of all pages in a given component including subpages

This is useful when we want to get different translate values. instead of using peopleosft PIA just through a query

Parent child relationship in peoplesoft tables. This is extremely useful in analyzing if you change key in parent record, respective child records affected

/************************ ***********************/ /************************ PeopleTools objects modifiable in Application Designer ***********************/ /************************ ***********************/ /* Written for MS SQL Server */ /* Linked server to DMO database required for some object types.*/

The below SQL will help you determine all the AE programs that have TRACE enabled. It will be useful to use this SQL in your monitoring scripts if you notice developers enabling trace using the process definitions and getting the program with its process definition migrated all the way to production or if your analyst or DBA have the tendency to enable the trace and forget about it

Its useful in cases where field position specified are over lapping are not in correct order

Print AE Program Flow Layout from AppDesigner. This is useful particularly in large app engine.