17

Complete List of PeopleSoft Tables

I could not find this else where and hence, I decided to build one myself – a complete list of PeopleSoft tables. Often a times when working on something like a PeopleSoft issue or a PeopleSoft upgrade, you feel the need to have a handly list of PeopleSoft tables.

What we’ve tried here is to provide a huge list of PeopleSoft Tables so that when you want to have quick access to PeopleSoft Tools Tables and their usage, then you can simply head over to this post.

 

 

PeopleSoft Object Definition Tables

PSACTIVITYDEFN	Activity definitions are stored
PSAESECTDEFN	Stores the application engine section definitions
PSAESTEPDEFN	Stores the application engine step definitions
PSAESTEPMSGDEFN	Stores the messages of the AE programs
PSPCMPROG	Peoplecode programs stored
PSSQLTEXTDEFN	Application engine sql
PSAEAPPLDEFN	Application engine program name
PSMENUDEFN	Menu names
PSPNLDEFN	Page names
PSPNLGROUP	Stores Component definitions
PSBCDEFN	Stores component interface names
PSBUSPROCDEFN	Stores Business process definitions
PS_APPR_RULE_HDR	Stores Approval rule set definitions
PSCHNLDEFN	Stores channel definitions
PSEVENTDEFN	Changing the column value of active to 0 leads to disabling activities
PSFLDFIELDDEFN	Filelayout stored
PSFILEREDEFN	File reference stored
PSINDEXDEFN	Index information stored
PSIODEFN	Stores business interlink information
PSKEYDEFN	Stores the index key information
PSMPDEFN	Contains info about mobilepages
PSMSGAGTDEFN	Refers to the activity object
PSMSGCATDEFN	Related to Messages –  Message catalogs
PSMSGDEFN	Stores Application Message definitions
PSDBFIELD	Contains field definitions
PSDDLDEFPARMS	This table holds the storage structure of the tables for db platforms
PSGATEWAY	This table hold the gateway url.
PSIDXDDLPARM	This table holds the storage structure of the indexes for db platforms
PSRECDEFN	This table holds the information of all the peoplesoft records.
PSPACKAGEDEFN	This table holds the application packages definitions
PSPNLGRPDEFN	Contains Panel group definitions
PSPRDMDEFN	Contains the portal information
PSPROJECTDEFN	Contains project definitions
PSPRSMDEFN	Detailed information of the portal objects
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

Though we tried to compile a comprehensive list of all PeopleSoft tools tables but we may have missed some of those. If you know of any other important tables which are not present in above list, please do share with us in comment section below.