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

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

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
Query
  • 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
——–
  • PSACTIVITYDEFN — Activity Definition
  • PSBUSPROCDEFN — Business Process Definition
  • PSEVENTDEFN — Event Definition
  • PSEVENTROUTE — Event Route

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)
EDI Manager
  • 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
Feeds
  • 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)

Share