PeopleSoft Database

PeopleSoft Databases Tables

Tables in PeopleSoft databases comes under three Categories: 

1. System Catalog Tables
2. PeopleTools Tables
3. Application Data Tables

System Catalog Tables

These tables record information about the database and its contents. The type of information that is stored in these tables includes table names, column names, and index names and contains database metadata. These tables:

• Track all objects in the entire database.
  
• Are analogous to a table of contents.
  
• Vary based on platform. 
  

Ex:

DBA_OBJECTS, DBA_INDEXES in Oracle DB

SYSIBM.SYSTABLES, SYSIBM.SYSINDEXES in DB2

sysobjects,sysindexes in SQL Server

PeopleTools Tables

These tables record information about the definitions that make up a PeopleSoft application. The type of information that is stored in these tables includes page names, record names, and component names. 

PeopleTools tables contain metadata about the PeopleSoft application that is installed on the database. PeopleTools tables:

• Are structured consistently between applications.
• Can be modified by PeopleTools such as PeopleSoft Application Designer.
• Use the naming convention PS*; for example, PSRECDEFN.  

Application Data Tables

These tables store data that is directly pertinent to an individual company. The type of information that is stored in these tables includes ledger names, inventory items, employee names, and payroll data. 

• Application data tables hold the data that users enter into the database.
• Specific tables are determined by the application. Developers can create more of these tables.
• Content is modified through the user interface.
• Tables use the naming convention PS_*; for example, PS_VOUCHER.