PeopleTools Tables

During one of my PeopleTools classes, a student asked for a quick list of the PeopleTools catalog tables. Here is an attempt at this list. The list is organized by type of PeopleTools Defintion:

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
• PSTBLSPCCAT — Tablespaces

Pages

(Note: Pages still have the name panels in the PeopleTools table names)

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

Components

(Note: Components still have the name panel group in the PeopleTools table 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
• PSOPRDEFN — 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

File Layout Definitions

• PSFLDDEFN — header record; last update time, etc.
• PSFLDSEGDEFN — stores the segments for each layout
• PSFLDFIELDDEFN — stores the fields for each layout

Workflow
(thanks to jasper–see the comments)

• APPR_RULE_DETL - Approval Rule Defn Details
• APPR_RULE_FIELD - Approval Rule Defn Route Cntl
• APPR_RULE_AMT - Approval Rule Amounts
• RTE_CNTL_LN - Route Control Profile Line
• RTE_CNTL_RUSER - RoleUser Route Cntl Profiles
• RTE_CNTL_TYPE - Route Control Type
• RTE_CNTL_HDR - Routing Control Type