Skip to content

Working easier with Peopletools Tables

July 20, 2010

1. Introduction to PeopoleSoft application table structure

Peopletools-based applications are table-based systems. All objects created in Peoplesoft (using Peopletools like Application Designer) are stored as information in Peopletools Tables. What appears in the IDE-App Designer is a mere view of what information is contained in these Peopletools Tables.
To say it in a line: A field could be created even without logging into the App Designer just by inserting some information in one such Peopletools Table.
A database for a Peoplesoft application contains three major sets of tables:
· System Catalog tables store physical attributes of tables and views, which your database management system uses to optimize performance.
· Peopletools tables contain information that you define using Peopletools.
· Application Data tables house the actual data that your users enter and access through PeopleSoft application pages.
Tables in a PeopleSoft database

PeopleTools tables are nothing, but Meta-data tables. Every time that you create a new definition using PeopleTools, the system inserts rows of data into various PeopleTools tables The entries in these tables determine the online processing of the system and what happens during imports. PeopleSoft maintains the structure of these tables.

The knowledge of Peopletools tables can be of help in looking at Peoplesoft Objects in a different perspective, unlocking very precious information at times. It can be of help in business scenarios like locating customizations more efficiently, auditing, documentation etc.

2. Peopletools Tables

The Peopletools tables are used by Peoplesoft to retain the details of all the objects in Peoplesoft system. The list of Peopletools tables is present in the ‘PPLTOOLS’ project in the App Designer. The data in the Peopletools table are useful in many respects. Some of the Peopletools tables are:

2.1 Fields
PSDBFIELD
PSDBFLDLABL

2.2 Records
PSRECDEFN
PSRECFIELD

2.3 Pages
PSPNLDEFN
PSPNLDFIELD

2.4 Components
PSPNLGRPDEFN
PSPNLGROUP

2.5 Peoplecode
PSPCMNAME
PSPCMPROG

2.6 Menu
PSMENUDEFN
PSMENUITEM

2.7 Project
PSPROJECTDEFN
PSPROJECTITEM

2.8 Application Engine
PSAEAPPLDEFN
PSAESECTDEFN
PSAESECTDTLDEFN
PSAESTEPDEFN
PSAEAPPLSTATE
PSAEAPPLTEMPTBL
PSAESTMTDEFN

Advertisements

From → PeopleSoft

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: