PeopleSoft Database Comprises of Application, PeopleTools and RDBMS Tables

A PeopleSoft database comprises of three components, the RDBMS Catalog,  PeopleSoft system catalog (or PeopleTools) and the application data. The PeopleTools, similar in purpose to the Oracle system catalog, is a repository for the application (record, fields, pages, PeopleCode, etc.).


Application table start with PS_ and PeopleTools Table start with PS with quite few exception and RDBMS catalog depends on database selection. (e.g sys.databases - SQL Server , all_tables - Oracle)

Application Data
The Application Data layer houses the actual user-entered data in the database
PS_NAMES
PS_TERM_TBL
PS_LEDGER
PeopleTools
The PeopleTools layer houses the tools used for development of the application
PSRECDEFN
PSAUTHITEM
PEOPLECODE
RDBMS Catalog
The RDBMS Catalog houses the core structures that make up the database
DBA_USERS (oracle)
SYSUSERS (Sybase/ SQL-Server)
SYSUSERAUTH (DB2)