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.
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.
0 Comments