PeopleTools Tables

A quick guide to PeopleTools Tables:
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.

Sources: - http://psst0101.wordpress.com/peopletools-tables/ & - mvprdexp.dms