Peoplesoft Fundamentals

David Lewis10/18/02(adapted from Psoft Training Materials)

PeopleSoft Internet Architecture Any web enabled device can access

Peoplesoft Servers can be on one or more machines No code written on the client Provides dynamic hyperlinks, like any

webpage http://comwebserver.uml.edu:8080/psp/

Benefits of Internet Architecture Easy Access Platform Independence Look and Feel Low Bandwidth Access Maintenance/Deployment

Cost effective

Metadata Driven Architecture Peoplesoft Application Designer: Allows

you to create Peoplesoft Applications: fields, records, pages, components.

When you define a page for example, this definition is stored in the metadata file.

Metadata: data about data When executed, looks for latest version

Metadata Architecture

Development Environment Developers (those creating the

Peoplesoft pages) and Administrator (those maintaining the system) Do not need Internet access Use more powerful machines Use a Two-Tier connection End users use Three-tier connection

Development Environment

PeopleSoft Internet Architecture Four components

Internet access device Web Server Application Server Database Server

Similar to other others: ex. Amazon

PeopleSoft Internet Architecture

Architecture issues No software to install on the clients No plugins necessary Simple, open architecture

Web Server Purpose

Relay data from Browser to Application Server

Handle encryption Serve up the image Connection between Browser and

Application Server

Web Server

Application Server Where the PeopleSoft logic resides Brain of the Internet application Generates the HTML which shows up

in the browser Two pieces

Tuxedo: handles communication between client and Peoplesoft

Jolt: connections to Java applets

Application Server

Database Server

Database server Contains 3 sets of tables (files)

System Catalog Tables: store indexes and physical characteristics of tables

PeopleTools Tables: store object-related data pertaining to the online processing of the system and the activities that occur during import• Supplied by the system

Database server (cont.)

Application data tables: contain data created by the user

Peoplesoft and UML UML (as part of UM) is implementing

HR (March 2002) Financials (july 2002) Student administration (with Dart and

Bos) Currently changing over from old to

new Financial System

PeopleSoft and UML COM: received a grant (with 2Million)

from PeopleSoft Currently: Full Financials package Goal: Use as an ERP “tool” (PP, Access) Called: End User Training Also, Application Development available Here: Intro to Navigation and Report

Writing May see in later classes

Relational Database Basics

Adapted from PeopleSoft Training MaterialsOct 2002

Basic Characteristics Standard for efficient data

organization Store data based on true

characteristics Looks at how data items relate to

each other Each item stored just once

Relational Databases Files called tables in PeopleSoft Key fields: uniquely identify a row

(record) Indexes of keys make data storage

and retrieval more efficient

PeopleSoft Record

PeopleSoft Data Models These are set up by PeopleSoft One model for each function Samples next page

Data Models Shows relationships between entities An entity is a person, place, or thing Items listed inside the boxes are fields The lines drawn between the boxes

represent the relationship between entities

The etchings at the ends represent the relationships

Data Relationships

Let’s Go Try ERP!