By | 13 October 2010

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