PeopleSoft Customization Tips and Tricks for developers

PeopleTools Tables
Here I am providing the list of system tables used for specific definitions in application designer.

Projects:


* PSPROJECTDEFN — Project header table
* PSPROJECTITEM — Definitions in the project


Fields:


* PSDBFIELD — Fields in the system
* PSXLATITEM — Translate Values



Records:


* PSRECDEFN — Record header table
* PSRECFIELD — Fields in the record (subrecords not expanded)
* PSRECFIELDALL — Fields in the record (subrecords expanded)
* PSKEYDEFN — Indexes


Pages - (Named as Panels in the PeopleTools Tables Names)


* PSPNLDEFN — Page header table
* PSPNLFIELD — Page controls
* PSPNLHTMLAREA — Static HTML Areas on Pages



Components - (Named as Panel Group in the PeopleTools Tables Names)


* PSPNLGRPDEFN — Component header table
* PSPNLGROUP — Pages in the components




Menus:


* PSMENUDEFN — Menu header table
* PSMENUITEM — Items (components) on the menu


Security:


* PSCLASSDEFN — Permission List header table
* PSAUTHITEM — Menu items granted security by permission lists
* PSROLEDEFN — Role header table
* PSROLECLASS — Permission Lists in roles
* PSOPERDEFN — User ID header table
* PSROLEUSER — Roles granted to users



Portal:


* PSPRSMDEFN — Content References and Folders



Change Control:


* PSCHGCTLHIST — shows history of locked definitions with project name, incident, and description
* PSCHGCTLLOCK — shows definitions that are currently locked



Application Engine:


* PSAEAPPLDEFN — header record; 1 row per app engine
* PSAEAPPLSTATE — state records assigned to app engines
* PSAEAPPLTEMPTBL — temp tables assigned to app engines
* PSAESECTDEFN — sections
* PSAESTEPDEFN — steps
* PSAESTEPMSGDEFN
* PSAESTMTDEFN — actions



HTML Definitions:


* PSCONTDEFN — header record; last update time, etc.
* PSCONTENT — stores actual text in the HTML definition



Process Scheduler Related Tables:


* PSPRCSRQST
* PSPRCSQUE
* PSPRCSPARMS
* PS_PRCSRQSTDIST
* PS_MESSAGE_LOG
* PSPRCSRQSTTEXT
* PS_MESSAGE_LOGPARM
* PSPRCSRQSTXFER
* PS_CDM_LIST
All these tables should be in sync.

free hit counter