PeopleTools Tables - The Important Ones
By Chris Malek | Wed, Oct 13, 2010
List of Key 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
- PSTBLSPCCAT - Tablespaces
- PSRECTBLSPC - Records’ tablespace assignments
Pages
- PSPNLDEFN - Page header table
- PSPNLFIELD - Page controls
- PSPNLHTMLAREA - Static HTML Areas on Pages
Components
- 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 - CI Authorizations
- PSAUTHWS - Service operation authorizations
PeopleCode
- PSPCMPROG
- PSPCMNAME
- RECNAME
- REFNAME fields.
Every time you create some PeopleCode your code is parsed and a line inserted into PSPCMNAME for every reference to a Tools object.
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
- PSPRUFDEFN - Portal user favorites
- PSPRSMPERM - Portal CREF Permissions (Local)
- PSPRSMPERM_RMT - Portal CREF Permissions (remote nodes)
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)
AE_STMT_TYPE Xlat Values:
- H = Do When
- N = Do Until
- C = Call Section
- W = Do While
- X = XSLT
- M = Log Message
- S = SQL
- P = PeopleCode
- D = DoSelect
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
Integration Broker
- PSOPERATION - Service Operation Defn
- PSSERVICEOPR - Service to Service Operation Mapping
Workflow
- 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
Timings
- BAT_TIMINGS_LOG
- BAT_TIMINGS_DTL
- BAT_TIMINGS_FN
More Information
Another site with some good information from www.go-faster.co.uk.Article Categories
Author Info
Chris Malek
Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.
About Chris Work with ChrisLooking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)
Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.
Book
Integration Broker - The Missing Manual
I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.