PeopleSoft - PeopleTools Configurations Records or Meta Tables

-

PeopleSoft - PeopleTools Configurations Records or Meta Tables

PeopleSoft records/metadata tables, often referred to as "meta tables," store information about various PeopleSoft objects and configurations. 

1. Object Definition Tables:

  • PSRECDEFN: Contains definitions of records (tables) used in the application, including details like record type and description.
  • PSDBFIELD: Stores field definitions, detailing the attributes of each field such as data type and length.
  • PSPNLGROUP: Holds information about components, which are collections of pages that function together.
  • PSPNLDEFN: Contains definitions of pages (interfaces) within the application.
  • PSMENUDEFN: Stores menu definitions, organizing how components are presented to users.

2. Security Tables:

  • PSOPRDEFN: Maintains user profile information, including user IDs and associated roles.
  • PSROLEDEFN: Defines roles that group together permissions for easier security management.
  • PSCLASSDEFN: Holds permission list definitions, specifying access rights to various application parts.

3. Application Engine Tables:

  • PSAEAPPLDEFN: Stores metadata about Application Engine programs, including program names and properties.
  • PSAESECTDEFN: Contains definitions of sections within Application Engine programs.
  • PSAESTEPDEFN: Details steps within Application Engine sections, outlining the sequence of actions.

4. Query Tables:

  • PSQRYDEFN: Holds definitions of PS Queries, including query names and properties.
  • PSQRYFIELD: Lists fields used within queries, specifying which data elements are retrieved.
  • PSQRYCRITERIA: Stores criteria applied in queries, defining filters and conditions for data retrieval.

5. Portal Tables:

  • PSPRSMDEFN: Manages portal registry structures, organizing how content is displayed in the portal.
  • PSPRSMPERM: Controls permissions for portal content, determining user access levels.

6. Workflow Tables:

  • PSWFDEFN: Contains workflow definitions, outlining automated processes within the application.
  • PSWFACTION: Stores actions associated with workflow steps, detailing tasks to be performed.

7. Translate Values Table:

  • PSXLATITEM: Maintains translate values for fields, providing lists of valid values for specific fields.

These meta tables are integral to the configuration and customization of the PeopleSoft applications, enabling administrators and developers to tailor the system to organizational needs. Understanding these tables is essential for effective PeopleSoft system management and development.

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.

 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.

PeopleSoft Security Tables
PSROLECLASS Provides the permission lists associated to each role
PSROLEUSER Gives info about 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 column LANGUAGE_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_LISTContains 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
PSSERVERSTATGives 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

Comments

Post a Comment

Popular posts from this blog

PeopleSoft Meta Tables

-
Application Engine Meta Data PSAEAPPLDEFN AE header record; 1 row per app engine PSAEAPPLSTATE AE state records (shows which one is the default) PSAEAPPLTEMPTBL AE temp tables assigned PSAESECTDEFN AE sections: public or private PSAESECTDTLDEFN AE section: descriptions, market, DB Type, EFFDT, EFF_STATUS, and auto commit PSAESTEPDEFN AE steps within section: description, market, DB Type, EFFDT, EFF_STATUS PSAESTMTDEFN AE actions within AE step: Step type (SQL, Do Select, etc.) with SQLID. PSAESTEPMSGDEFN AE message (parameters in each step) AEREQUESTPARM AE request parameters table behind the AE run control page. Find All Records Referenced in App Engine 1. Find the Temp Records (TAO) that are used: SELECT RECNAME FROM PSAEAPPLTEMPTBL WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME' 2. If there are records, find the number of instances: SELECT TEMPTBLINSTANCES FROM PSAEAPPLDEFN WHERE AE_APPLID = 'MY_APP_PROGRAM_NAME...
Read more

Peoplesoft Application Package, Application Class and Application Method Implementation

-
Application Classes in PeopleSoft Defining and Importing packages or classes in PeopleCode <Pacakge name>:<Subpacakge name>:<…>:<Class name or wild card> Class Extensions represents the “is-a” relationship.   When a class extends another class, it’s called a subclass of that class. No Multiple inheritances or Concept of interface in Application classes. Instance variables in the class are accessible in all the objects of that class. Application programs generally pass parameters by value, which is not the same as for existing functions. Parameter passing with object data types is by reference. When the objects are passed to method and it reassign the object with new object it will not reflected in the calling method. Application Programs use the out specifier to pass a parameter by reference. Method increment (&Value as number out); rem passed by reference.   Create is the key word used to create the class object.  ...
Read more

Peoplesoft Application Package - Application Class/Application Package peoplecode and Calling them anywhere

-
Peoplesoft Application Package - Define Application Class and Calling Application class and Application Class Method from any Peoplecode event:  Step 1: Create New Application Package - MYPACKAGE Step2: Add a new application class in it. - MyClass Step 3: Defining Class and methods inside (Public or Private) 1. We can define classes here 2. We can define methods here 3. We can define Class Property Code to write inside a class to define class and its method: class MyClass method MyMethod (&smyInput as String, &nmyInput as Number) returns string; private method MyPrivateMethod (&sInput as String) returns boolean; property string &sVar; property number &nVar; end-class; method MyMethod /*+Method Body+*/ returns &sVar; end-method; method MyPrivateMethod  /*+Method Body+*/ returns &bVar; end-method; Code to write call a class and run its method: import MYPACKAGE:MyClass; Local string &sGetMethodData; Local MYPACKAGE:MyClass &oClassObjectVar...
Read more