Peoplesoft Table
Peoplesoft Table.
Table of HTML AREA
SELECT * FROM PSPNLHTMLLANG WHERE PNLNAME = ‘NAME’
Table of Record
SELECT * FROM PSPNLFIELDLANG WHERE PNLNAME =’NAME’
Table of Translate Value
SELECT * FROM PSXLATITEM
Table of Translate Value Languages
SELECT * FROM PSDBFLDLABLLANG
Table of Label of Field
SELECT * FROM PSDBFLDLABL where FIELDNAME=’NAME’
Table of Database Owner
SELECT DBNAME from PSDBOWNER
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 table names and their descriptions |
| PS_AE_TEMPLOCK_VW | Tracks how many locks are currently in effect for a particular temporary 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 |
Ref : http://peoplesofttutorial.com/complete-list-of-peoplesoft-tables/