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

(Note: Pages still have the name panels in the PeopleTools table names)

  • PSPNLDEFN — Page header table
  • PSPNLFIELD — Page controls 
  • PSPNLHTMLAREA — Static HTML Areas on Pages

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
  • PSUSEREMAIL--- Email addresses for users.
  • PSOPRCLS - Roles link together permission lists, which are the security objects that define access to components, pages, and other areas of the system. This view returns the permission lists that a user has access to via their roles. Note that prior to PeopleTools 8, permission lists were synonymous with classes and most of the security tables still use this convention.
  • PSAUTHPRCS ---The link between permission lists and process groups
  • PSAUTHSIGNON --- The link between permission lists and signon times
  • PSAUTHWEBLIBVW -- A view linking permission lists and access to web libraries (really just Menus in PSAUTHITEM that begin with WEBLIB_).
  • PSAUTHWS -- - The link between permission lists and web services (service operations)
  • PS_SCRTY_ACC_GRP -- The link between permission lists, trees and query access groups



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
  • PSPRUHTAB — Homepage Tab
  • 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 



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
(thanks to jasper–see the comments)

  • 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



Mapping the user’s role to a CI is stored in PSAUTHBUSCOMP