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