PEOPLESOFT ARCHITECTURE
Internet Architecture(PIA)
Database Architecture
Portal Architecture
APPLICATION DESIGNER
Application Designer Structure
Creating Field Definitions
Creating Record Definitions
Creating Page Definitions
Creating Component Definitions
Creating Record Definitions
Registering a Component or iScript
APPLICATION ENGINE
Application Engine Overview
AE Program Elements
Understanding State Records
Understanding Temporary Table
Understanding Restart Concept
Understanding set processing
Debugging AE Program
Running of A.E (Different ways)
FILE LAYOUT & CI
Understanding File Layout
Component interface attributes
Testing Component interface
Exercise on File layout & CI
CONTENTS FOR PEOPLE CODE
Recurrence Definitions
People code Overview
Component Processor Flow
Data Types, Comments and Variables
Understanding Objects and Classes in People Code
Debugging
File Attachments
Methods and Built-In Functions
Accessing the Data Buffer
Referencing Data in the Component Buffer
PROCESS SCHEDULER
Run Control ID
Creating Run Control Page
SQR Introduction
Building your first SQR program
SQR columns, variables and literals
Predefined SQR variables
List Variables
Arithmetic commands
The move command
String manipulation
The Let command
Built-in functions
File-related functions
Date functions
String functions
SQR page
How SQR processes the source program
Five sections of an SQR program
Program section
Setup section
Explicit and implicit printing
Heading section and Footing section
Procedure section
Loops and decision logic
Print command
Formatting your output
Break logic
Run-time and compile-time
Variables
Working with arrays
Multiple Reports
SQR
Generate Letters
Flat Files & Examples
Debugging Techniques
How to run an SQR program in different ways with suitable SQR architecture
Database support structured query language
PSQUERY
CRYSTAL REPORTS
PSQUERY
