PeopleTools Tables

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.