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
Product
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.