正如完好的PeopleSoft工具表名。PeopleTools Catalog Tables

以找不顶另外地方产生相对完好的PeopleSoft表名,因为自身自己总了同等客。

于此地品尝提供一个庞然大物之PeopleSoft表列表,以便当您想快速访问PeopleSoft工具表时候,可以高速的查这篇稿子。

Projects

PeopleSoft Object Definition Tables

  • PSPROJECTDEFN — Project header table
  • PSPROJECTITEM — Definitions in the project

PSACTIVITYDEFN Activity definitions are stored

Fields

PSAESECTDEFN Stores the application engine section definitions

  • PSDBFIELD — Fields in the system
  • PSXLATITEM — Translate Values

PSAESTEPDEFN Stores the application engine step definitions

Records

PSAESTEPMSGDEFN Stores the messages of the AE programs

  • 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

PSPCMPROG Peoplecode programs stored

Pages

PSPCMTXT Peoplecode programs stored

(Note: Pages still have the name panels in the PeopleTools table names)

PSSQLTEXTDEFN Application engine sql

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

PSAEAPPLDEFN Application engine program name

Components

PSMENUDEFN Menu names

(Note: Components still have the name panel group in the PeopleTools
table names)

PSPNLDEFN Page names

  • PSPNLGRPDEFN — Component header table
  • PSPNLGROUP — Pages in the components

PSPNLGROUP Stores Component definitions

Component Interface

PSBCDEFN Stores component interface names

  • PSBCDEFN — header record; one row for each component interface
  • PSBCITEM — one row for each property

PSBUSPROCDEFN Stores Business process definitions

Menus

PS_APPR_RULE_HDR Stores Approval rule set definitions

  • PSMENUDEFN — Menu header table
  • PSMENUITEM — Items (components) on the menu

PSCHNLDEFN Stores channel definitions

Security

PSEVENTDEFN Changing the column value of active to 0 leads to disabling
activities

  • 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

PSFLDFIELDDEFN Filelayout stored

Process Scheduler

PSFILEREDEFN File reference stored

  • PS_PRCSDEFN — Process Definition Header
  • PS_PRCSDEFNGRP — Process Group
  • PS_PRCSDEFNPNL — Component
  • PS_PRCSJOBDEFN — Job Header
  • PSPRCSRQST — Process Request Instances
  • PS_PRCSJOBITEM — Job Processes

PSINDEXDEFN Index information stored

Portal

PSIODEFN Stores business interlink information

  • PSPRSMDEFN — Content References and Folders
  • PSPRUHTABPGLT — Portal User HP Tab Pagelet
  • PSPRUHDEFN — Homepage definition
  • PSPRUHTAB — Homepage Tab
  • PSWEBPROFNVP — Web Profile Settings

PSKEYDEFN Stores the index key information

Change Control

PSMPDEFN Contains info about mobilepages

  • PSCHGCTLHIST — shows history of locked definitions with project
    name, incident, and description
  • PSCHGCTLLOCK — shows definitions that are currently locked

PSMSGAGTDEFN Refers to the activity object

Application Engine

PSMSGCATDEFN Related to Messages – Message catalogs

  • 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

PSMSGDEFN Stores Application Message definitions

HTML Definitions

PSDBFIELD Contains field definitions

  • PSCONTDEFN — header record; last update time, etc.
  • PSCONTENT — stores actual text in the HTML definition

PSDDLDEFPARMS This table holds the storage structure of the tables for
db platforms

SQL Definitions

PSGATEWAY This table hold the gateway url.

  • PSSQLDEFN — header record; last update time, etc.
  • PSSQLTEXTDEFN — stores actual text in the SQL definition

PSIDXDDLPARM This table holds the storage structure of the indexes for
db platforms

File Layout Definitions

PSPROJECTITEM Project info

  • PSFLDDEFN — header record; last update time, etc.
  • PSFLDSEGDEFN — stores the segments for each layout
  • PSFLDFIELDDEFN — stores the fields for each layout

PSRECDEFN This table holds the information of all the peoplesoft
records.

Workflow

PSPACKAGEDEFN This table holds the application packages definitions

  • 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

PSPNLGRPDEFN Contains Panel group definitions

Timings
BAT_TIMINGS_LOG

PSPRDMDEFN Contains the portal information

  • BAT_TIMINGS_DTL
  • BAT_TIMINGS_FN

PSPROJECTDEFN Contains project definitions

呢可以在$PS_HOME/scripts 中找到mvprdexp.dms 
,其中饱含了所有catalog tables。

PSPRSMDEFN Detailed information of the portal objects

初稿地址:http://psst0101.wordpress.com/peopletools-tables/

PSPRUFDEFN Information about portal objects

PSPRUHDEFN Information about portal objects

PSQRYDEFN Holds the query definitions

PSROLEDEFN Role definitions

PSSQLDEFN SQL object definitions are stored

PSSQLTEXTDEFN SQL object’s text are stored

PSSTEPDEFN Contains stepnames with reference to the activity

PSSTYLEDEFN Contains the styles definitions

PSSTYLSHEETDEFN Contains the stylesheet definitions

PSSUBDEFN Conatins Message subscription definitions

PSTOOLBARDEFN Holds a single row provided by PS, which helps to view the
toolbar

PSTREEDEFN Contains the treename

PSCLASSDEFN Gives info abt the peoplesoft permission lists

PSURLDEFN To see which URL’s are used as fileservers for the file
attachments

PS_AE_TEMPREC_VW Tracks all temporary tablenames and their
descriptions

PS_AE_TEMPLOCK_VW Tracks how many locks are currently in effect for a
particulartemporary table

PS_DATA_FIND_BASE Used as search record for the panel. SHould always
be empty.

PS_MSG_CATLG_VW Contains text for all error messages and warnings.

PeopleSoft Security Tables

PSROLECLASS Provides the permission lists associated to each role

PSROLEUSER Gives info abt the roles assigned to the Oprid’s

PeopleSoft Login Details and Authorization

PSACCESSLOG Login and logout information of the users

PSACCESSPRFL Contains the symbolic id,accessid/password details.

PSCLOCK Login fails if the table is empty

PSOPRDEFN This table holds the peoplesoft Oprid’s/passwords info with
symbolic id.

PeopleSoft Audit Tables

PSAUDIT This table holds all the changes for panel/record modifications

PeopleSoft Version Details

PSRELEASE This table holds the application release details

PSSTATUS This table gives the peopletools information

PeopleSoft Language Details

PSLANGUAGES Contains 1 for the column INSTALLED against the
columnLANGUAGE_CD.

PeopleSoft Modules Listed

PS_INSTALLATION List the modules in the database

PeopleSoft Process Type Details

PS_PRCSDEFN Contains process type and process names

PSPRCSLOCK Contains a single record, this gets updated when a process is
submitted

PeopleSoft Process Status

PSPRCSQUE Holds the process rqst details should be in synch with
psprcsrqst.Should be in synch with PSPRCSRQST

PSPRCSRQST This table holds the process submitted details

PS_CDM_LIST Contains the process instance details.Should be in synch
withPS_CDM_AUTH

PS_CDM_AUTH Contains the process instance details

PeopleSoft Report Node Details

PS_CDM_DIST_NODE This table holds the report node information which
contains the reportrepository details

PS_CDM_DISTSTATUS Contains the definition of report status

PeopleSoft Batch Server Details

PS_SERVERDEFN Contains the server definitions

PSSERVERSTAT Gives information about the batch server status

PeopleSoft RenServer Details

PSREN Holds the portnumber details of a renserver configured domain

PeopleSoft Translate Value Details

PSXLATDEFN Holds the translate fieldname and version number for caching

PSXLATITEM Holds the translate fieldname and their values

PeopleSoft Object Versions

PSLOCK This table is used for version control

PSOPTIONS This table is used to turn off or on the change control
enabling feature

PSVERSION This table holds the version number details

BI publisher Info

PSXPRPTDEFN Report definition view for BI Publisher (trans)
(XPRPTDEFN_VW)

PSXPRPTTMPL Defines association between report definition and template
definition.

PSXPTMPLDEFN This table stores template (including sub-template)
definition for BI Publisher. Template definition has eff-dated template
files as a child object.

PSXPTMPLFILEDEF This table stores per template file definition.

尽管本人想将一卖最完全的,但是生或还见面产生遗漏,欢迎补充~

本身之大众号:

图片 1

相关文章