PeopleSoft-系统表

PeopleTools是PeopleSoft各种应用的开发工具集合，常用的包括AppDesigner,PeopleCode，DataMover等等。
PeopleTools的各种工具与业务无关，PS各种应用比如Finance, HCM, SCM, SRM, Campus等都是用PeopleTools开发而成。
PeopleTools的各种定义都存储在数据库里。既然是存在数据库里，那都有哪些表来存储呢？
本文适合从事PS开发的技术人员、对PeopleTools感兴趣的读者，PAAS平台架构师等等。

按照PeopleTools对象的类型有如下列表：

Projects:工程
PSPROJECTDEFN — Project header table
PSPROJECTITEM — Definitions in the project
PS_PTOBJECTTYPES — Object types list

Fields:字段
PSDBFIELD — Fields in the system
PSDBFLDLABL — Field Labels
PSDBFIELDLANG
PSXLATITEM — Translate Values
PSXLATITEMLANG
PSDBFLDLABLLANG

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
PSRECDEFNLANG — language Record

Pages:页面
(Note: Pages still have the name panels inthe PeopleTools table names)
PSPNLDEFN — Page header table
PSPNLFIELD — Page controls (fieldtypes/FIELDTYPE)
PSPNLHTMLAREA — Static HTML Areas on Pages
PSPNLCNTRLDATA — stores additionalattributes 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 longcharacter fields.

Components:组件
(Note: Components still have the name panelgroup 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 bypermission lists
PSROLEDEFN — Role header table
PSROLECLASS — Permission Lists in roles
PSOPRDEFN — User ID header table
PSROLEUSER — Roles granted to users
PSAUTHBUSCOMP — Access to ComponentInterfaces
PSAUTHWEBLIBVW — Access to just WebLibraries
PS_SCRTY_ACC_GRP — Query Security AccessGroups
PSOPROBJ — Definition security (connects apermission list to a definition group)

Tree:树
PSTREENODE

Process Scheduler 进程
PS_PRCSDEFN — Process Definition Header
PS_PRCSTYPEDEFN — Process Type DefinitionHeader
PS_PRCSDEFNPNL — Component
PS_PRCSJOBDEFN — Job Header
PSPRCSRQST — Process Request Instances
PS_PRCSJOBITEM — Job Processes
PSREN — stores REN server ports (from here)
PS_SERVERCLASS — Server Class
PS_PRCS_CAT_TBL — Process Categories
PS_SERVERCATEGORY — Server Categories
PS_SERVERDEFN — Server Definition Header
PSPRCSQUE — Process Queue
PSRF_FLIST_TBL — Folder Definition

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 lockeddefinitions with project name, incident, and description
PSCHGCTLLOCK — shows definitions that arecurrently locked
PSCOMPOBJDIFF — I think this shows comparereport from a Project Compare
PSPROJECTMSG — messages from a project copy

Application Engine:进程
PSAEAPPLDEFN — header record; 1 row per appengine
PSAEAPPLSTATE — state records assigned toapp engines
PSAEAPPLTEMPTBL — temp tables assigned toapp engines
PSAESECTDEFN — sections
PSAESTEPDEFN — steps
PSAESTEPMSGDEFN
PSAESTMTDEFN — actions (action types)
PSAESECTDTLDEFN — section details
PS_AEONLINEINST — should be 100 rows in thetable
PS_AEINSTANCENBR — should be 100 rows inthe table
PS_AELOCKMGR — should be 100 rows in thetable
PRCSRUNCNTL_SBP –进程sub页面
PRCSRUNCNTL – 进程subpage recodr name

HTML Definitions
PSCONTDEFN — header record; last updatetime, etc.
PSCONTENT — stores actual text in the HTMLdefinition

PeopleCode:代码
PSPCMPROG — PeopleCode program
PSPCMTXT — The plain text of the PeopleCodeprograms

SQL Definitions
PSSQLDEFN — header record; last updatetime, etc.
PSSQLTEXTDEFN — stores actual text in the SQL definition
PS_SQLSTMT_TBL — stores SQL statemernts for COBOL

File Layout Definitions
PSFLDDEFN — header record; last update time, etc.
PSFLDSEGDEFN — stores the segments for eachlayout
PSFLDFIELDDEFN — stores the fields for eachlayout

Query
PSQRYDEFN — Query Definition Header
PSQRYBIND — Query bind variables/parameters
PSQRYRECORD — Query records
PSQRYFIELD — Fields
PSCONQRSDEFN — connected query
PSCONQRSMAP — connected query: list ofchild queries
PSCONQRSFLDREL — connected query
PSCONQRSRUNCNTR — connected query
PSCONQRSRUNPRM — connected query

Workflow
APPR_RULE_DETL – Approval Rule Defn Details
APPR_RULE_FIELD – Approval Rule Defn RouteCntl
APPR_RULE_AMT – Approval Rule Amounts
RTE_CNTL_LN – Route Control Profile Line
RTE_CNTL_RUSER – RoleUser Route CntlProfiles
RTE_CNTL_TYPE – Route Control Type
RTE_CNTL_HDR – Routing Control Type
PSWORKLIST — list of work items for eachuser
PS_WF_INSTSTATUS — description of thestatus
PSACTIVITYDEFN — Activity Definition
PSBUSPROCDEFN — Business Process Definition
PSEVENTDEFN — Event Definition
PSEVENTROUTE — Event Route

Timings
BAT_TIMINGS_LOG
BAT_TIMINGS_DTL
BAT_TIMINGS_FN
File References
PSFILEREDEFN — File references (keys:FILEREFNAME,FILEREFTYPECODE)

EDI Manager
PS_ECINMAPFILE — Records
PS_ECINMAPREC — Records
PS_ECMAPDEFN — EDI Map Definition
PS_ECINMAPFLD — Fields in the Records
PS_ECINMAPRECFLD — Fields in the Records
PS_ECOUTMAPREC
PS_ECOUTMAPFLD

Feeds
PS_PTFP_FEED
PS_PTFP_DATATYPE
PS_PTFP_DTYPE_IBSO
PS_PTFP_DTYPE_ATTR
PS_PTFP_ATTRS
PS_PTFP_SETTINGS
PS_PTFP_PARMS
PS_PTFP_SECURITY
PS_PTFP_PVALS
PS_PTFP_ADMN_PREF
PS_PTFP_USER_PREF

Integration Broker
PSMSGPARTS — Message Parts
PSMSGVER — Message Version
PSMSGREC — Message Record
PSOPERATION — Operation
PSOPRVERDFN — Operation Versions
PSSERVICEOPR — Service Operations
PSOPRHDLR — Operation Handlers
PSIBRTNGDEFN — Routings
PSMSGNODEDEFN — Message Nodes
PSRTNGDFNPARM — Routing Parameters
PSOPRVERDFNPARM
PSQUEUEDEFN
PSIBSCMADFN
PSOPERATIONDMS

Message Catalog 消息目录
PSMSGSETDEFN — Message Set — the header for that message set
PSMSGCATDEFN — Individual messages inthe message catalog/message set
SQR Strings
PS_STRINGS_TBL — String definition (sqrtarns.sqc)
PS_STRINGS_LNG_TBL — Translated String (sqrtarns.sqc)

Audit 系统审计表
PSACCESSLOG - 用户登录审计表
PS_AUDIT_OPRDEFN - 用户概要审计表
PS_AUDIT_ROLEUSER - 用户角色授权审计表