| Enterprise management suite. PeopleSoft is built to interact with with practically
any database software - Oracle, SQL Server, DB2 as well as
others.
It utilizes client server architecture to integrate processing
and storage - so it allows a process to be initiated and processed on either
a production server as a three tier process via communication with
an application server or run on a client machine two tier .
There are three major sets of tables when dealing with
PeopleSoft and what they contain.
- System Catalog Tables
- Stores indexes and characteristics of tables views and columns.
Database specific information.
- PeopleTools Tables
- PeopleSoft Record Definitions (PSRECDEFN)
- PeopleSoft Panel Definitions (PSPNLDEFN)
- Contains the information dealing with the user interface.
Changes and updates to the system are stored here
- Application Data tables
- Database Table Data
- The PeopleSoft application data. (usually starts with PS_)
On a personal opinion :Business software Used by certain companies to completely screw up their entire business process. Used as a database front end and customizable to insane proportions. Database front end for dummies.
| 
