Projects
PSPROJECTDEFN — Project header table PSPROJECTITEM — Definitions in the projectFields
PSDBFIELD — Fields in the system PSXLATITEM — Translate ValuesRecords
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 assignmentsPages
(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 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 componentsComponent Interface
PSBCDEFN — header record; one row for each component interface PSBCITEM — one row for each propertyMenus
PSMENUDEFN — Menu header table PSMENUITEM — Items (components) on the menuSecurity
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 InterfacesProcess Scheduler
PS_PRCSDEFN — Process Definition Header PS_PRCSDEFNGRP — Process Group PS_PRCSDEFNPNL — Component PS_PRCSJOBDEFN — Job Header PSPRCSRQST — Process Request Instances PS_PRCSJOBITEM — Job ProcessesPortal
PSPRSMDEFN — Content References and Folders PSPRUHTABPGLT — Portal User HP Tab Pagelet PSPRUHDEFN — Homepage definition PSPRUHTAB — Homepage Tab PSWEBPROFNVP — Web Profile SettingsChange Control
PSCHGCTLHIST — shows history of locked definitions with project name, incident, and description PSCHGCTLLOCK — shows definitions that are currently lockedApplication 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 — actionsHTML Definitions
PSCONTDEFN — header record; last update time, etc. PSCONTENT — stores actual text in the HTML definitionSQL Definitions
PSSQLDEFN — header record; last update time, etc. PSSQLTEXTDEFN — stores actual text in the SQL definitionFile Layout Definitions
PSFLDDEFN — header record; last update time, etc. PSFLDSEGDEFN — stores the segments for each layout PSFLDFIELDDEFN — stores the fields for each layoutWorkflow
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 statusTimingsBAT_TIMINGS_LOG
BAT_TIMINGS_DTL BAT_TIMINGS_FN也可以在$PS_HOME/scripts 中找到mvprdexp.dms ，其中包含了所有catalog tables。
原文地址:http://psst0101.wordpress.com/peopletools-tables/
