Holds the portnumber details of a renserver configured domain Gives information about the batch server status PeopleSoft Batch Server Details PS_SERVERDEFN This table holds the report node information which contains the reportrepository details PeopleSoft Report Node Details PS_CDM_DIST_NODE This table holds the process submitted detailsĬontains the process instance details.Should be in synch withPS_CDM_AUTH Holds the process rqst details should be in synch with psprcsrqst.Should be in synch with PSPRCSRQST PeopleSoft Process Type Details PS_PRCSDEFNĬontains a single record, this gets updated when a process is submitted
PeopleSoft Modules Listed PS_INSTALLATION This table gives the peopletools informationĬontains 1 for the column INSTALLED against the columnLANGUAGE_CD. This table holds the application release details This table holds all the changes for panel/record modifications This table holds the peoplesoft Oprid’s/passwords info with symbolic id. Login and logout information of the usersĬontains the symbolic id,accessid/password details. PeopleSoft Login Details and Authorization PSACCESSLOG Gives info abt the roles assigned to the Oprid’s
Provides the permission lists associated to each role SHould always be empty.Ĭontains text for all error messages and warnings. Tracks how many locks are currently in effect for a particulartemporary table Tracks all temporary tablenames and their descriptions To see which URL’s are used as fileservers for the file attachments Gives info abt the peoplesoft permission lists Holds a single row provided by PS, which helps to view the toolbar This table holds the application packages definitionsĭetailed information of the portal objectsĬontains stepnames with reference to the activityĬonatins Message subscription definitions This table holds the information of all the peoplesoft records. This table holds the storage structure of the indexes for db platforms This table holds the storage structure of the tables for db platforms Stores the application engine step definitionsĬhanging the column value of active to 0 leads to disabling activities Stores the application engine section definitions PeopleSoft Object Definition Tables PSACTIVITYDEFN 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. 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. I could not find this else where and hence, I decided to build one myself – a complete list of PeopleSoft tables.
0 kommentar(er)
