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 (good reference @ Go Faster Consultancy)
• PS_PTOBJECTTYPES — Object types list

Fields

• PSDBFIELD — Fields in the system
• PSDBFLDLABL — Field Labels
• PSDBFIELDLANG
• PSXLATITEM — Translate Values
• PSXLATITEMLANG
• PSDBFLDLABLLANG

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
• PSRECDEFNLANG — language Record

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
• PSAUTHWEBLIBVW — Access to just Web Libraries
• PS_SCRTY_ACC_GRP — Query Security Access Groups
• PSOPROBJ — Definition security (connects a permission list to a definition group)

Process Scheduler

• PS_PRCSDEFN — Process Definition Header
• PS_PRCSTYPEDEFN — Process Type Definition Header
• PS_PRCSDEFNGRP — Process Group
• PS_PRCSDEFNPNL — Component
• PS_PRCSJOBDEFN — Job Header
• PSPRCSRQST — Process Request Instances
• PS_PRCSJOBITEM — Job Processes
• PSREN — stores REN server ports (from here)
• PS_SERVERCLASS — Server Class
• PS_PRCS_CAT_TBL — Process Categories
• PS_SERVERCATEGORY — Server Categories
• PS_SERVERDEFN — Server Definition Header
• PSPRCSQUE — Process Queue
• PSRF_FLIST_TBL — Folder Definition

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
• PSCOMPOBJDIFF — I think this shows compare report from a Project Compare
• PSPROJECTMSG — messages from a project copy

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)
• PSAESECTDTLDEFN — section details
• PS_AEONLINEINST — should be 100 rows in the table
• PS_AEINSTANCENBR — should be 100 rows in the table
• PS_AELOCKMGR — should be 100 rows in the table

List Log Messages

HTML Definitions

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

PeopleCode

• PSPCMPROG — PeopleCode program
• PSPCMTXT — The plain text of the PeopleCode programs

SQL Definitions

• PSSQLDEFN — header record; last update time, etc.
• PSSQLTEXTDEFN — stores actual text in the SQL definition
• PS_SQLSTMT_TBL — stores SQL statemernts for COBOL

File Layout Definitions

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

• PSQRYDEFN — Query Definition Header
• PSQRYBIND — Query bind variables/parameters
• PSQRYRECORD — Query records
• PSQRYFIELD — Fields
• PSCONQRSDEFN — connected query
• PSCONQRSMAP — connected query: list of child queries
• PSCONQRSFLDREL — connected query
• PSCONQRSRUNCNTR — connected query
• PSCONQRSRUNPRM — connected query

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

File References

• PSFILEREDEFN — File references (keys: FILEREFNAME, FILEREFTYPECODE)

• PS_ECINMAPFILE — Records
• PS_ECINMAPREC — Records
• PS_ECMAPDEFN — EDI Map Definition
• PS_ECINMAPFLD — Fields in the Records
• PS_ECINMAPRECFLD — Fields in the Records
• PS_ECOUTMAPREC
• PS_ECOUTMAPFLD

• PS_PTFP_FEED
• PS_PTFP_DATATYPE
• PS_PTFP_DTYPE_IBSO
• PS_PTFP_DTYPE_ATTR
• PS_PTFP_ATTRS
• PS_PTFP_SETTINGS
• PS_PTFP_PARMS
• PS_PTFP_SECURITY
• PS_PTFP_PVALS
• PS_PTFP_ADMN_PREF
• PS_PTFP_USER_PREF

Integration Broker

• PSMSGPARTS — Message Parts
• PSMSGVER — Message Version
• PSMSGREC — Message Record
• PSOPERATION — Operation
• PSOPRVERDFN — Operation Versions
• PSSERVICEOPR — Service Operations
• PSOPRHDLR — Operation Handlers
• PSIBRTNGDEFN — Routings
• PSMSGNODEDEFN — Message Nodes
• PSRTNGDFNPARM — Routing Parameters
• PSOPRVERDFNPARM
• PSQUEUEDEFN
• PSIBSCMADFN
• PSOPERATIONDMS

Message Catalog

• PSMSGSETDEFN — Message Set — the header for that message set
• PSMSGCATDEFN — Individual messages in the message catalog/message set

SQR Strings

• PS_STRINGS_TBL — String definition  (sqrtarns.sqc)
• PS_STRINGS_LNG_TBL — Translated String  (sqrtarns.sqc)