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: 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

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

Test Framework

PeopleTools Test Framework Tables from blog.greysparling.com.

More Information

Another site with some good information from www.go-faster.co.uk.

Article Categories