Cover image for PeopleSoft developer's handbook
Title:
PeopleSoft developer's handbook
Author:
Gillespie, Richard, 1967-
Personal Author:
Publication Information:
New York : McGraw-Hill, [1999]

©1999
Physical Description:
xiv, 601 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.)
General Note:
Includes index.

Accompaning CD-ROM contains a PeopleSoft application developed step by step with screen cams.
Language:
English
ISBN:
9780071349727

9780071349734
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.755 .G55 1999 Book and Software Set Central Closed Stacks
Searching...

On Order

Summary

Summary

The first comprehensive PeopleSoft developer's guide, the PeopleSoft Developer's Handbook gives you the tools you need to master application development for PeopleSoft's PeopleTools environment. Using a "from scratch" approach, the Gillespies--both veteran software consultants--lead you through developing PeopleSoft applications, one command at a time. This book teaches you material that would cost thousands of dollars to obtain through PeopleSoft training.


Table of Contents

Introductionp. xiii
Part 1 PeopleSoft Application Environment Reviewp. 1
Chapter 1 PeopleSoft Environment Reviewp. 3
Definitions of Key PeopleSoft Elementsp. 4
Navigationp. 4
Signing on to PeopleSoftp. 5
Menu Navigationp. 5
Business Process Navigationp. 8
Actionsp. 14
Add Actionp. 16
Update/Display Actionp. 16
Update/Display All and Correction Actionsp. 17
Scroll Areasp. 20
Data Validationp. 20
Prompt Tablep. 21
Translate Tablep. 21
Chapter 2 Application Designer Reviewp. 25
The Project Workspacep. 26
The Object Workspacep. 26
The Output Windowp. 28
Part 2 Our Example Applicationp. 33
Chapter 3 A Warehouse Ordering Examplep. 35
Internal Orderp. 36
External Orderp. 39
Chapter 4 A Relational View of the Warehouse Request Examplep. 41
The Main Tables in Our Examplep. 42
The Prompt Tables (Lookup Tables) in Our Examplep. 43
Part 3 Creating PeopleSoft Data Objectsp. 47
Chapter 5 Fieldsp. 49
Definition of a Fieldp. 50
Types of Fieldsp. 50
Steps in Creating Fields with PeopleSoftp. 50
The Fields of the Warehouse Ordering Examplep. 56
Getting Started by Creating a Projectp. 58
Creating Our Warehouse Objectsp. 60
Project Workspace with All Fieldsp. 94
Chapter 6 Recordsp. 97
Record Definitionsp. 98
Field Displayp. 98
Use Displayp. 99
Edits Displayp. 103
PeopleCode Displayp. 106
Record Build Optionsp. 109
SQL Table Recordsp. 112
View Recordsp. 114
Subrecordsp. 121
Derived Recordsp. 124
Example Record Definitionsp. 126
Employees Recordp. 127
Buyer_VW Recordp. 138
Items Recordp. 146
Locations Recordp. 156
Vendors Recordp. 163
Units_Measure Recordp. 175
Int_Order Recordp. 181
Int_Order_Lines Recordp. 196
Ext_Order_VW Recordp. 216
Chapter 7 Panelsp. 247
Definition of a Panelp. 247
Types of Graphical Control on a Panelp. 248
Steps in Creating a New Panel with PeopleSoftp. 249
Three Ways to Insert Controls onto a Panelp. 250
Selecting File, Insert from the Toolbarp. 251
Inserting Controls by the Drag-and-Drop Methodp. 252
Inserting Controls Using the Panel Definition Toolbarp. 254
Steps for Inserting Each Type of Control onto the Panelp. 256
Edit Boxp. 256
Long Edit Boxp. 263
Drop-Down Listp. 268
Check Boxp. 271
Radio Buttonp. 275
Push Buttonp. 278
Imagesp. 282
Text Controlsp. 286
Framesp. 287
Group Box Controlsp. 291
Static Image Controlsp. 294
Subpanel Controlsp. 295
Scroll-Bar Controlsp. 298
Secondary Panelsp. 301
Grid Controlsp. 307
Example Panelsp. 314
Employees Panel (Employees_PNL)p. 316
Buyer Panel (Buyer_PNL)p. 320
Items Panel (Items_PNL)p. 323
Locations Panel (Locations_PNL)p. 326
Units of Measure Panel (Unit_Measure_PNL)p. 327
Address Subpanel (Add_SBR_PNL)p. 328
Vendors Panel (Vendors_PNL)p. 330
New Internal Order Panel (Int_New_Ord_PNL)p. 332
Internal Order Panel (Int_Order_PNL)p. 340
External Order Panel (Ext_Order_PNL)p. 348
Chapter 8 Panel Groupsp. 363
Definition of a Panel Groupp. 363
Example Panel Groupsp. 367
Employees Panel Group (EMP_PNL_GRP)p. 367
Buyer Panel Group (BUY_PNL_BRP)p. 369
Items Panel Group (ITEMS_PNL_GRP)p. 370
Locations Panel Group (LOC_PNL_GRP)p. 373
Units of Measure Panel Group (UNITS_PNL_GRP)p. 374
Vendors Panel Group (VENDORS_PNL_GRP)p. 374
New Internal Order Panel Group (NINT_PNL_GRP)p. 377
Warehouse Internal Order Panel Group (WINT_PNL_GRP)p. 378
Buyers External Order Panel Group (BEXT_PNL_GRP)p. 378
Chapter 9 Menusp. 383
Menu Groups and Standard Menusp. 384
Opening a Standard Menu Definitionp. 384
Menu Propertiesp. 386
Bar Item Propertiesp. 391
Menu Item Propertiesp. 392
Popup Menusp. 395
Opening a Popup Menu Definitionp. 395
Menu Propertiesp. 395
Creating New Menusp. 399
Steps for Creating Standard Menusp. 400
Steps for Creating Popup Menusp. 406
Example Menusp. 410
Employees Menu Itemp. 410
Buyers Menu Itemp. 412
Items Menu Itemp. 413
Locations Menu Itemp. 413
Units of Measure Menu Itemp. 416
Vendors Menu Itemp. 418
New Internal Order Menu Itemp. 418
Warehouse Internal Order Menu Itemp. 420
Buyers External Order Menu Itemp. 422
Our Example Menu Propertiesp. 424
Chapter 10 Granting Access to the Userp. 427
Security Administratorp. 428
Viewing an Existing Operator Security Definitionp. 428
Creating a New Operatorp. 440
Creating Class Definitionsp. 442
Using Class Definitionsp. 443
Example Operators and Classesp. 443
Administrator Classp. 443
End User Classp. 444
Warehouse User Classp. 449
Buyer Classp. 450
Administrator Operatorp. 452
End User Operatorp. 453
Warehouse User Operatorp. 455
Buyer Operatorp. 456
Chapter 11 Application Overviewp. 461
Development Stepsp. 462
Chapter 12 Introduction to PeopleCodep. 475
PeopleSoft Event Modelp. 476
PeopleCode Language Syntaxp. 478
Commentsp. 479
Variable Data Types and Scopep. 479
Control Statementsp. 480
Functionsp. 481
PeopleCode Examplep. 482
Counter Recordp. 482
Function Libraryp. 483
Record Modificationp. 487
Part 4 Query And Reporting Toolsp. 491
Chapter 13 Query, Crystal Reports, and nVisionp. 493
PeopleSoft Queryp. 493
Running an Existing Queryp. 495
Creating a Queryp. 495
Running the Newly Created Queryp. 499
Formatting Query Output on the Result Tabp. 503
Crystal Reportsp. 504
Exporting Queries to Microsoft's Excelp. 506
Chapter 14 Process Schedulerp. 509
Use Menup. 510
Process Typesp. 511
Process Definitionsp. 514
Process Serversp. 522
Process Job Definitionsp. 523
Process Systemp. 524
Chapter 15 SQRp. 529
SQR Definedp. 529
Executing SQR Programsp. 530
Executing SQR from the Command Linep. 530
Executing SQR from the PeopleSoft Submenup. 531
Executing SQR from the Process Schedulerp. 532
Output from an SQR Programp. 532
Programming in SQRp. 532
SQR Variablesp. 532
SQR Sectionsp. 534
SQR Print Commandp. 536
SQR Database Accessp. 541
Control Structuresp. 543
More Commandsp. 547
Arraysp. 555
On-Breakp. 557
Multiple Reportsp. 560
Flat Filesp. 561
Appendix A Configuration Managerp. 567
Startup Tabp. 567
Display Tabp. 568
Crystal Tabp. 570
Nvision Tabp. 571
Process Scheduler Tabp. 573
Online Help Tabp. 576
Trace Tabp. 576
Common Settings Tabp. 576
Other Tabp. 578
Import/Export Tabp. 579
Client Setup Tabp. 581
Remote Call Tabp. 582
Database Tabp. 583
Workflow Tabp. 585
Application Servers Tabp. 587
Appendix B Application Designer in Upgrade Modep. 589
Indexp. 593

Google Preview