|
Introduction to PeopleSoft
PeopleSoft Architecture
- Two tier architecture
- Three tier architecture
- Web Architecture
ORACLE SQL Fundamentals
- Development Tools Used in PeopleSoft Application Designer
- Fields
- Records
- Pages
- Components
- Menus
- Registering a component
- Portal Structure and Content
- Providing User Access to the Application
PeopleSoft Field Definition
- Field Types
- Field Properties
- Translate values
- Identify and Create Custom Fields
PeopleSoft Record Definition
- Creating a Record Definition
- Defining Record definition Properties
- Define Record Field properties
- Building Tables
- Record types
Prompt Record
- Creating and Using Prompt Records
- Principles of prompt Records
- Prompt Records with single search key
- Prompt Records with effective Dates
- Effective Date Concept
- Prompt records with Multiple Search Keys
- Dynamic Prompt Records
- Creating and maintaining translate Values
Search Record
- Creating and using search records
- Search records without keys
- Search records with search Keys
Derived/Work Records
- Using derived records on Pages
- Using Derived record to display messages
- Other uses of Derived Records
PeopleSoft Page Definition
- Assembling record Fields in a Page
- Defining Page Field Properties
- Checking the Page Layout
- Define Page Properties
- Saving Page Properties
Advanced Page Design features
- Working with Scrolls/Grid
- Parent-Child Relationship on Scrolls/grid
- Working with Sub Pages and Secondary Pages
- Related Field and Display Control field
- Deferred Processing/Interactive Processing
- Push buttons
PeopleSoft Components
- Creating Components In PeopleSoft
- Define Component Properties
- Registering a Component
- Providing the Permissions to the Component
PeopleSoft Security
- Permission List Concept
- Roles Concept
- User Profile Concept
- Row level security
People code
- People Code Events
- Add Processing
- Save Processing
- Temporary Variables
- System Variables
- Basic People code Built-in-Functions
- Component Buffer
- Conversion Functions
- Date/Time Functions
- Effective Date/Sequence Functions
- Logic Functions
- Math Functions
- Application Packages
- Page Buffer Functions
- Page Control Functions
- Save/Cancel functions
- String Functions
- Page Transfer functions
- Debugging and Tracing
- People Code with Components
Messages and Error Handling
- Using the Message Box Function
- Using the Win Message Function
- Error and Warning
SQL using in People code
- The SQLEXEC function
- Create SQL ()
- Using the inline bind variables
- Dates and Meta SQL
- Scroll functions
Application Engine
Basics of Application Engine
- Types
- State Records
- Sections, Actions/Steps
- Temporary Tables
- Parallel Processing
- Debugging and Tracing
- Process Scheduler Concept
SQR
- Basics of SQR
- SQC
- Writing Procedures – Both Global and Local
- Flow Control Commands
- Built-in Functions &Variables
- Debugging Strategies for SQRs
- Fundamentals of SQR Reporting
- Illustration of Program using SQR
Crystal Report
PS Query
- Creating PS Query
- Query Security
XML Publisher
Report Manager
Component Interface
- Properties
- Collection
- Methods
- PS Message
Data Loading Features
- Excel To CI
- File Layout
- Data Mover
Workflow
- Workflow Development
- Workflow Design
- Business Process/Activity/Events and Routings
- Worklist Definitions
- Roles and Role users
- AWE Framework
| 