List of PeopleSoft Tables

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.

Integration Broker Setup Tables

PSMSGNODEDEFN	Tools table that holds definitions for Message Node objects
PSNODEURITEXT	Associated table is PSMSGNODEDEFN. This table is comprised of long text field NODE_URITEXT which is a long text field. The data in NODE_URITEXT is used by the Portal Registry.
PSAPMSGDSPSTAT
PSAPMSGDOMSTAT	IB Domain Status
PSCONN	Connector Definition
PSCONNPROP	Connector Properties
PSCONNPROPLANG	Registered Integration Server Connector Properties Protocols and attributes
PSGATEWAY	Integration Broker Connector Gateway
PSIBSVCSETUP	IB Service setup
PSNODECONPROP	Registered Integration Server Connector Properties Protocols and attributes
PSIBRTNGSUBDEFN	IB Routing Sub Definition
PSRTNGDFNPARM	IB Routing Parameter View
PSIBRTNGDEFN	IB Routing Definitions

Web Profile Setup Tables

PSWEBPROFBROW;	Web Profile Browsers
PSWEBPROFCOOK	Web Profile Cookies
PSWEBPROFDEF	Web Profile Defaults
PSWEBPROFILE	Web Profile
PSWEBPROFPROP	Web Profile Custom Properties
PSWEBPROFNVP	Web Profile Name/Value Pairs
PSWEBPROFHIST	Web Profile History

Process servers

PS_SERVERCLASS	Server Defn - Process Types
PS_SERVERDEFN	Server Defn
PS_SERVERDEFN_LNG	Server Defn
PS_SERVERNOTIFY	Server Notification
PS_SERVERMESSAGE	Server Defn