PeopleTools Tables
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 Authorications
- 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 ChrisProduct
PeopleSoft Simple Web Services (SWS)
Do you need a quick way to create web services?
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.