PeopleSoft Object Definition Tables
PSACTIVITYDEFN
PSAESECTDEFN
PSAESTEPDEFN
PSAESTEPMSGDEFN
PSPCMPROG
PSSQLTEXTDEFN
PSAEAPPLDEFN
PSMENUDEFN
PSPNLDEFN
PSPNLGROUP
PSBCDEFN
PSBUSPROCDEFN
PS_APPR_RULE_HDR
PSCHNLDEFN
PSEVENTDEFN
PSFLDFIELDDEFN
PSFILEREDEFN
PSINDEXDEFN
PSIODEFN
PSKEYDEFN
PSMPDEFN
PSMSGAGTDEFN
PSMSGCATDEFN
PSMSGDEFN
PSDBFIELD
PSDDLDEFPARMS
PSGATEWAY
PSIDXDDLPARM
PSRECDEFN
PSPACKAGEDEFN
PSPNLGRPDEFN
PSPRDMDEFN
PSPROJECTDEFN
PSPRSMDEFN
PSPRUFDEFN
PSPRUHDEFN
PSQRYDEFN
PSROLEDEFN
PSSQLDEFN
PSSQLTEXTDEFN
PSSTEPDEFN
PSSTYLEDEFN
PSSTYLSHEETDEFN
PSSUBDEFN
PSTOOLBARDEFN
PSTREEDEFN
PSCLASSDEFN
PSURLDEFN
PS_AE_TEMPREC_VW
PS_AE_TEMPLOCK_VW
PS_DATA_FIND_BASE
PS_MSG_CATLG_VW
PeopleSoft Security Tables
PSROLECLASS
PSROLEUSER
PeopleSoft Login Details and Authorization
PSACCESSLOG
PSACCESSPRFL
PSCLOCK
PSOPRDEFN
PeopleSoft Audit Tables
PSAUDIT
PeopleSoft Version Details
PSRELEASE
PSSTATUS
PeopleSoft Language Details
PSLANGUAGES
PeopleSoft Modules Listed
PS_INSTALLATION
PeopleSoft Process Type Details
PS_PRCSDEFN
PSPRCSLOCK
PeopleSoft Process Status
PSPRCSQUE
PSPRCSRQST
PS_CDM_LIST
PS_CDM_AUTH
PeopleSoft Report Node Details
PS_CDM_DIST_NODE
PS_CDM_DISTSTATUS
PeopleSoft Batch Server Details
PS_SERVERDEFN
PSSERVERSTAT
PeopleSoft RenServer Details
PSREN
PeopleSoft Translate Value Details
PSXLATDEFN
PSXLATITEM
PeopleSoft Object Versions
PSLOCK
PSOPTIONS
PSVERSION
Activity definitions are stored
Stores the application engine section definitions
Stores the application engine step definitions
Stores the messages of the AE programs
Peoplecode programs stored
Application engine sql
Application engine program name
Menu names
Page names
Stores Component definitions
Stores component interface names
Stores Business process definitions
Stores Approval rule set definitions
Stores channel definitions
Changing the column value of active to 0 leads to disabling activities
Filelayout stored
File reference stored
Index information stored
Stores business interlink information
Stores the index key information
Contains info about mobilepages
Refers to the activity object
Related to Messages – Message catalogs
Stores Application Message definitions
Contains field definitions
This table holds the storage structure of the tables for db platforms
This table hold the gateway url.
This table holds the storage structure of the indexes for db platforms
This table holds the information of all the peoplesoft records.
This table holds the application packages definitions
Contains Panel group definitions
Contains the portal information
Contains project definitions
Detailed information of the portal objects
Information about portal objects
Information about portal objects
Holds the query definitions
Role definitions
SQL object definitions are stored
SQL object’s text are stored
Contains stepnames with reference to the activity
Contains the styles definitions
Contains the stylesheet definitions
Conatins Message subscription definitions
Holds a single row provided by PS, which helps to view the toolbar
Contains the treename
Gives info abt the peoplesoft permission lists
To see which URL’s are used as fileservers for the file attachments
Tracks all temporary tablenames and their descriptions
Tracks how many locks are currently in effect for a particulartemporary table
Used as search record for the panel. SHould always be empty.
Contains text for all error messages and warnings.
Provides the permission lists associated to each role
Gives info abt the roles assigned to the Oprid’s
Authorization
Login and logout information of the users
Contains the symbolic id,accessid/password details.
Login fails if the table is empty
This table holds the peoplesoft Oprid’s/passwords info with symbolic id.
This table holds all the changes for panel/record modifications
This table holds the application release details
This table gives the peopletools information
Contains 1 for the column INSTALLED against the columnLANGUAGE_CD.
List the modules in the database
Contains process type and process names
Contains a single record, this gets updated when a process is submitted
Holds the process rqst details should be in synch with psprcsrqst.Should be in synch with PSPRCSRQST
This table holds the process submitted details
Contains the process instance details.Should be in synch withPS_CDM_AUTH
Contains the process instance details
This table holds the report node information which contains the reportrepository details
Contains the definition of report status
Contains the server definitions
Gives information about the batch server status
Holds the portnumber details of a renserver configured domain
Holds the translate fieldname and version number for caching
Holds the translate fieldname and their values
This table is used for version control
This table is used to turn off or on the change control enabling feature
This table holds the version number details
