TRAINING (PS-2) - Different table types (Catalog) and databases in PeopleSoft

Different Table Types (Catalog) in PeopleSoft Application Database: 

1.) System Catalog Tables > Keep track of all of the objects that reside in the database instance. > Are created by and owned by the RDBMS. > Are often described as system metadata. > For example DBA_Tables & V$Views 2.) PeopleTools Metadata Tables > Define the structure of all object definitions (such as records, fields, pages, PeopleCode, and security etc) that make up an application. > Use the same table structure for all applications (HCM, CRM, ELM, PA etc). > Contain data that is added and updated only when the application is installed, or when using development tools such as PeopleSoft Application Designer or Data Mover. > Generally prefixed with PS keyword. > For example PSSTATUS, PSOPRDEFN etc. 3.) PeopleSoft application data tables > Application data tables store data entered through a PeopleSoft online application (offline till PeopleTools 8.22). > The specific tables and their structures vary by application (HCM, CRM, ELM, PA etc).  > Application data tables contain day to day transactional data entered and updated by users. > They are empty prior to data entry (except the demo databases). > Generally prefixed with PS_ keyword. > For example PS_JOB, PS_PERSON etc.

Different Type of PS Databases: Based on Usage:

System: The System database has no company specific data, and can be used to load your data and begin development of your production database.

Demo: The Demo database contains data for a sample company, and can be used immediately for demonstration, for testing, and as a development reference.

Tools Only: Only System and People Tools tables.

TRAINING (PS-1) - PeopleSoft In General & PIA Architecture

PeopleSoft Internet Architecture (PIA):

PeopleSoft Core Components:

1.) End User Workstation

A basic computer with PS supported browser for any user of PS application.

2.) PeopleTools Development Workstation

A high end workstation with 2-tier and 3-tier connectivity to the applications. Primarily used for development and administration purposes.

3.) File Server

A file repository for PeopleTools development environment including PS executables, common files, Upgrade & change assistant.

4.) Database server

A server grade machine to host the RDBMS for the application.

5.) Batch Server (Process Scheduler)

A server grade machine to run PS processes.

6.) Application Server

A server grade machine to host the application server software. The app  server connects web server to the RDBMS.

7.) Web Server

A high end machine to host the web server software.

PeopleSoft Supported Platforms:

1.) Web Browsers

Internet Explorer, Netscape Mozilla, Firwfox, Apple Safari

2.) PeopleTools Development Workstation
Windows XP, Windows Server 2003

3.) RDBMS
Oracle, MSSQL Server, DB2, Sybase, Informix

4.) Web Server
Oracle Application Server, BEA Weblogic, IBM Websphere

5.) Application Server
BEA Tuxedo

PeopleSoft Applications & Modules: