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 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) |