PeopleTools常用表

纵横四海

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
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



该贴已经同步到 纵横四海的微博

qjcjerry

支持一下，

meadville2009

{:soso_e179:}多一些ps相关表信息就好了

kevinrao0101

好东西，这样能从high level的看下表结构了

ERP_wjtcxte

谢谢分享 先顶了···

apollo5643

学习了，谢谢 LZ！真的帮助很大

godbelieve

谢谢楼主分享，赚点努力值

sjgsjgsjg123

对学习peoplesoft的很有帮助