PeopleTools Tables

Object	Object Definition table	Description
Project	PSPROJECTDEFN	Project header table
	PSPROJECTITEM	Definitions in the project
Fields	PSDBFIELD	Fields in the system
	PSXLATITEM	Translate Values
	PSPNLFIELD	Fields on a panel/page
	PSRECFIELDDB	Record field
	PSDBFLDLABL	Field label
Records	PSRECDEFN	Record header table
	PSRECFIELD	Fields in the record (sub-records not expanded)
	PSRECFIELDALL	Fields in the record (sub-records 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
	PSPSWDHINT	Password hint
	PSPURGEPERMLIST
	PSUSERATTR	Password hint response
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
Change Control	PSCHGCTLHIST	shows history of locked definitions with project name, incident, and description
	PSCHGCTLLOCK	shows definitions that are currently locked
Application Engine	PSAEAPPLDEFN	App engine definition
	PSAEAPPLSTATE	App engine State records
	PSAEAPPLTEMPTBL	App engine temp tables
	PSAESECTDEFN	App engine Section definition
	PSAESTEPDEFN	App engine Step definition
	PSAESTEPMSGDEFN
	PSAESTMTDEFN	App engine Action definition
	PS_AETEMPTBLMGR	App engine temp tables manager
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	PSACTIVITYDEFN	Activity definition
	PSBUSPROCDEFN	Business Process definition
	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
Archival tables	PSARCHOBJDEFN	Archive object definition
	PSARCHTEMPLATE	Archive template definition
Channel	PSCHNLDEFN	Channel definition
Colour	PSCOLORDEFN	Colour definition
Diagnostic plug-ins	PSDIAGREG	Diagnostic plug-ins definition
File references	PSFILEREDEFN	File references definition
Field format	PSFMTDEFN
Mobile pages	PSMPDEFN
Integration Broker	PSMSGDEFN	Message definition
	PSMSGNODEDEFN	Message node definition
	PSNODETRX	Node definition
	PSRELATCONTACT
	PSRELATIONPROP
	PSRELATIONSHIP
	PSRELATIONTRX
	PSROLEDEFN_RMT
	PSSUBDEFN
Run control ID	PSPRCSRUNCNTLS
Portal	PSPRDMDEFN	Portal/structure & content definition
Portal details	PSPRUFDEFN	Portal definition
Welcome message setup	PSPRUHDEFN
PS Query	PSQRYDEFN	PS Query definition
Style	PSSTYLEDEFN	Style definition
	PSSTYLSHEETDEFN	Style sheet definition
Tree	PSTREEDEFN	Tree definition
	PSTREESTRCT	Tree structure definition
Code/development	PSTYPECODEDEFN
	PS_STRINGS_TBL	Strings table
URL	PSURLDEFN	URL definition
Message Catalogue	PSMSGCATDEFN	Message Catalogue definition
Others	PSDSSCHEMA
	PSHOLIDAYDEFN
	PSIMPDEFN
	PSIODEFN
	PSOPTMODEL
	PSOPTPRBTYPE
	PSPACKAGEDEFN
	PSPCMPROG
	PSPERMLIST_RMT
	PSPMAGENTFILTER
	PSPMMONITORGBL
	PSPMSYSDEFAULTS
	PSPMSYSDEFN
	PSPRCSRUNCNTL
	PSTOOLBARDEFN
	PSUSEROPTNDEFN