Peoplesoft Tables

Peoplesoft Tables Lists.

Projects

PSPROJECTDEFN — Project header table
PSPROJECTITEM — Definitions in the project

Fields

PSDBFIELD — Fields in the system
PSXLATITEM — Translate Values

Records

PSRECDEFN — Record header table (record types)
PSRECFIELD — Fields in the record (subrecords not expanded)
PSRECFIELDALL — Fields in the record (subrecords expanded)
PSKEYDEFN — Indexes
PSTBLSPCCAT — Tablespaces
PSRECTBLSPC — Records’ tablespace assignments

Pages

(Note: Pages still have the name panels in the PeopleTools table names)
PSPNLDEFN — Page header table
PSPNLFIELD — Page controls (field types/FIELDTYPE)
PSPNLHTMLAREA — Static HTML Areas on Pages
PSPNLCNTRLDATA — stores additional attributes for Page controls
PSPNLFIELDEXT — stores additional attributes for Page controls
PSPTPNLRTEDITOR — new PeopleTools 8.50 table that stores attributes relating to the rich-text editor for long character fields.

Components

(Note: Components still have the name panel group in the PeopleTools table names)
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 — Access to Component Interfaces

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
PSPRUHDEFN — Homepage definition (from here)
PSPRUHTAB — Homepage Tab (from here)
PSWEBPROFNVP — Web Profile Settings

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

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
PSWORKLIST — list of work items for each user
PS_WF_INSTSTATUS — description of the status

Timings

BAT_TIMINGS_LOG
BAT_TIMINGS_DTL
BAT_TIMINGS_FN

 

Reference: http://peoplesofttechops.blogspot.com/2016/06/useful-stuff-for-peoplesoft-upgrade.html