Introduction

PeopleSoft : 
  • Founded in 1987 by David Duffield and Ken Morris.
  • PeopleSoft, Inc. was a company that provided 
    • Human Resource Management Systems (HRMS)(Released in 1988).
    • Financial Management Solutions (FMS)
    • Supply Chain (SCM) 
    • Customer relationship management (CRM)
    • Enterprise Performance Management software (EPM)
    • Campus Solutions
    • Portal
  •  It is acquired by Oracle Corporation in 2005.
  • PeopleTools includes many different components used to create web-based applications.
People tools can be categorized as
  1.Development Tools
  2.Administration Tools
  3.Analytic Tools
  4.Integration Tools
  5.Life Cycle Management Tools
In these tools we discuss the following
  1.Development Tools
    a)PeopleSoft Application Designer.
    b)PeopleCode.
    c)PeopleSoft Application Engine.
  2.Administration Tools
    a)PeopleSoft Data Mover.
  3.Analytic Tools
    a)PeopleSoft Query.
    b)SQR for PeopleSoft.
  4.Integration Tools
    a)PeopleSoft Component Interfaces.


PeopleSoft Internet Architecture:



PeopleSoft Database:
PeopleSoft Database contains three types of tables
1.System Catalog tables
2.People Tools Tables (These are prefixed with "ps")
3.Application Tables (These are prefixed with "ps_")