People Tools catalog 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 (record types)
- PSRECFIELD — Fields in the record (subrecords not expanded)
- PSRECFIELDALL — Fields in the record (subrecords expanded)
- PSKEYDEFN — Indexes
- PSTBLSPCCAT — Tablespaces
- PSRECTBLSPC — Records’ tablespace assignments
Pages
(Note: Pages still have the name panels in the PeopleTools table names)
- PSPNLDEFN — Page header table
- PSPNLFIELD — Page controls (field types/FIELDTYPE)
- PSPNLHTMLAREA — Static HTML Areas on Pages
- PSPNLCNTRLDATA — stores additional attributes for Page controls
- PSPNLFIELDEXT — stores additional attributes for Page controls
- PSPTPNLRTEDITOR — new PeopleTools 8.50 table that stores attributes relating to the rich-text editor for long character fields.
Components
(Note: Components still have the name panel group in the PeopleTools table names)
- PSPNLGRPDEFN — Component header table
- PSPNLGROUP — Pages in the components
Component Interface
- PSBCDEFN — header record; one row for each component interface
- PSBCITEM — one row for each property
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
- PSAUTHBUSCOMP — Access to Component Interfaces
Process Scheduler
- PS_PRCSDEFN — Process Definition Header
- PS_PRCSDEFNGRP — Process Group
- PS_PRCSDEFNPNL — Component
- PS_PRCSJOBDEFN — Job Header
- PSPRCSRQST — Process Request Instances
- PS_PRCSJOBITEM — Job Processes
Portal
- PSPRSMDEFN — Content References and Folders
- PSPRUHTABPGLT — Portal User HP Tab Pagelet
- PSPRUHDEFN — Homepage definition (from here)
- PSPRUHTAB — Homepage Tab (from here)
- PSWEBPROFNVP — Web Profile Settings
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 (action types)
HTML Definitions
- PSCONTDEFN — header record; last update time, etc.
- PSCONTENT — stores actual text in the HTML definition
SQL Definitions
- PSSQLDEFN — header record; last update time, etc.
- PSSQLTEXTDEFN — stores actual text in the SQL 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
- PSWORKLIST — list of work items for each user
- PS_WF_INSTSTATUS — description of the status
Timings
(thanks to PeopleSoft Tipster –see his blog)
- BAT_TIMINGS_LOG
- BAT_TIMINGS_DTL
- BAT_TIMINGS_FN