A Peoplesoft database is expression which point out a database containing Peoplesoft objects. For Oracle and only for Oracle, Peoplesoft consists in 3 schemas namely:
- PS (PSDBOWNER table owner),
- PEOPLE (for connection checking) and
- SYSADM (by default), the last one contains all the objects/data.
One of the database objects is connected with single Oracle schema, and all processes that connect to the database use the standard PSFT login procedure. PSFT login is used because to refer to the collection of tables in the administrative schema within an Oracle database. Every process that makes a 2-tier connection to the database identifies itself with a PSFT user or operator ID. Hence the interaction goes.