List of Common PeopleSoft Tables

Below are the commonly used PeopleSoft tables which i used in my daily work. Please comment if any important table is missed.

Pages

* PSPNLDEFN — Page header table

* PSPNLFIELD — Page controls (field types/FIELDTYPE)

* PSPNLHTMLAREA — Static HTML Areas on Pages

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

Components

* PSPNLGRPDEFN — Component header table

* PSPNLGROUP — Pages in the components

Projects

* PSPROJECTDEFN — Project header table

* PSPROJECTITEM — Definitions in the project

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

Process Scheduler

* PS_PRCSDEFN — Process Definition Header

* PS_PRCSDEFNGRP — Process Group

* PS_PRCSDEFNPNL — Component

* PS_PRCSJOBDEFN — Job Header

* PSPRCSRQST — Process Request Instances

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

Portal

* PSPRSMDEFN — Content References and Folders

* PSPRUHTABPGLT — Portal User HP Tab Pagelet

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)

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