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
  • 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 Chris
Looking 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.