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
