search for books and compare prices
Tables of Contents for Peoplesoft Developer's Handbook
Chapter/Section Title
Page #
Page Count
Introduction
xiii
 
PART 1 PEOPLESOFT APPLICATION ENVIRONMENT REVIEW
1
32
PeopleSoft Environment Review
3
22
Definitions of Key PeopleSoft Elements
4
1
Navigation
4
10
Signing on to PeopleSoft
5
1
Menu Navigation
5
3
Business Process Navigation
8
6
Actions
14
2
Add Action
16
1
Update/Display Action
16
1
Update/Display All and Correction Actions
17
3
Scroll Areas
20
1
Data Validation
20
5
Prompt Table
21
1
Translate Table
21
4
Application Designer Review
25
8
The Project Workspace
26
1
The Object Workspace
26
2
The Output Window
28
5
PART 2 OUR EXAMPLE APPLICATION
33
14
A Warehouse Ordering Example
35
6
Internal Order
36
3
External Order
39
2
A Relational View of the Warehouse Request Example
41
6
The Main Tables in Our Example
42
1
The Prompt Tables (Lookup Tables) in Our Example
43
4
PART 3 CREATING PEOPLESOFT DATA OBJECTS
47
444
Fields
49
48
Definition of a Field
50
1
Types of Fields
50
1
Steps in Creating Fields with PeopleSoft
50
6
The Fields of the Warehouse Ordering Example
56
41
Getting Started by Creating a Project
58
2
Creating Our Warehouse Objects
60
34
Project Workspace with All Fields
94
3
Records
97
150
Record Definitions
98
11
Field Display
98
1
Use Display
99
4
Edits Display
103
3
PeopleCode Display
106
3
Record Build Options
109
3
SQL Table Records
112
2
View Records
114
7
Subrecords
121
3
Derived Records
124
2
Example Record Definitions
126
121
Employees Record
127
11
Buyer_VW Record
138
8
Items Record
146
10
Locations Record
156
7
Vendors Record
163
12
Units_Measure Record
175
6
Int_Order Record
181
15
Int_Order_Lines Record
196
20
Ext_Order_VW Record
216
31
Panels
247
116
Definition of a Panel
247
1
Types of Graphical Control on a Panel
248
1
Steps in Creating a New Panel with PeopleSoft
249
1
Three Ways to Insert Controls onto a Panel
250
6
Selecting File, Insert from the Toolbar
251
1
Inserting Controls by the Drag-and-Drop Method
252
2
Inserting Controls Using the Panel Definition Toolbar
254
2
Steps for Inserting Each Type of Control onto the Panel
256
58
Edit Box
256
7
Long Edit Box
263
5
Drop-Down List
268
3
Check Box
271
4
Radio Button
275
3
Push Button
278
4
Images
282
4
Text Controls
286
1
Frames
287
4
Group Box Controls
291
3
Static Image Controls
294
1
Subpanel Controls
295
3
Scroll-Bar Controls
298
3
Secondary Panels
301
6
Grid Controls
307
7
Example Panels
314
49
Employees Panel (Employees_PNL)
316
4
Buyer Panel (Buyer_PNL)
320
3
Items Panel (Items_PNL)
323
3
Locations Panel (Locations_PNL)
326
1
Units of Measure Panel (Unit_Measure_PNL)
327
1
Address Subpanel (Add_SBR_PNL)
328
2
Vendors Panel (Vendors_PNL)
330
2
New Internal Order Panel (Int_New_ORD_PNL)
332
8
Internal Order Panel (INT_Order_PNL)
340
8
External Order Panel (EXT_Order_PNL)
348
15
Panel Groups
363
20
Definition of a Panel Group
363
4
Example Panel Groups
367
16
Employees Panel Group (EMP_PNL_GRP)
367
2
Buyer Panel Group (BUY_PNL_BRP)
369
1
Items Panel Group (Items_PNL_GRP)
370
3
Locations Panel Group (LOC_PNL_GRP)
373
1
Units of Measure Panel Group (Units_PNL_GRP)
374
1
Vendors Panel Group (Vendors_PNL_GRP)
374
3
New Internal Order Panel Group (NINT_PNL_GRP)
377
1
Warehouse Internal Order Panel Group (WINT_PNL_GRP)
378
1
Buyers External Order Panel Group (Bext_PNL_GRP)
378
5
Menus
383
44
Menu Groups and Standard Menus
384
11
Opening a Standard Menu Definition
384
2
Menu Properties
386
5
Bar Item Properties
391
1
Menu Item Properties
392
3
Popup Menus
395
4
Opening a Popup Menu Definition
395
1
Menu Properties
395
4
Creating New Menus
399
11
Steps for Creating Standard Menus
400
6
Steps for Creating Popup Menus
406
4
Example Menus
410
17
Employees Menu Item
410
2
Buyers Menu Item
412
1
Items Menu Item
413
1
Locations Menu Item
413
3
Units of Measure Menu Item
416
2
Vendors Menu Item
418
1
New Internal Order Menu Item
418
2
Warehouse Internal Order Menu Item
420
2
Buyers External Order Menu Item
422
2
Our Example Menu Properties
424
3
Granting Access to the User
427
34
Security Administrator
428
15
Viewing an Existing Operator Security Definition
428
12
Creating a New Operator
440
2
Creating Class Definitions
442
1
Using Class Definitions
443
1
Example Operators and Classes
443
18
Administrator Class
443
1
End User Class
444
5
Warehouse User Class
449
1
Buyer Class
450
2
Administrator Operator
452
1
End User Operator
453
2
Warehouse User Operator
455
1
Buyer Operator
456
5
Application Overview
461
14
Development Steps
462
13
Introduction to People Code
475
16
PeopleSoft Event Model
476
2
PeopleCode Language Syntax
478
4
Comments
479
1
Variable Data Types and Scope
479
1
Control Statements
480
1
Functions
481
1
PeopleCode Example
482
9
Counter Record
482
1
Function Library
483
4
Record Modification
487
4
PART 4 QUERY AND REPORTING TOOLS
491
76
Query, Crystal Reports, and nVision
493
16
PeopleSoft Query
493
11
Running an Existing Query
495
1
Creating a Query
495
4
Running the Newly Created Query
499
4
Formatting Query Output on the Result Tab
503
1
Crystal Reports
504
2
Exporting Queries to Microsoft's Excel
506
3
Process Scheduler
509
20
Use Menu
510
19
Process Types
511
3
Process Definitions
514
8
Process Servers
522
1
Process Job Definitions
523
1
Process System
524
5
SQR
529
38
SQR Defined
529
1
Executing SQR Programs
530
2
Executing SQR from the Command Line
530
1
Executing SQR from the PeopleSoft Submenu
531
1
Executing SQR from the Process Scheduler
532
1
Output from an SQR Program
532
1
Programming in SQR
532
35
SQR Variables
532
2
SQR Sections
534
2
SQR Print Command
536
5
SQR Database Access
541
2
Control Structures
543
4
More Commands
547
8
Arrays
555
2
On-Break
557
3
Multiple Reports
560
1
Flat Files
561
6
Appendix A Configuration Manager
567
22
Startup Tab
567
1
Display Tab
568
2
Crystal Tab
570
1
Nvision Tab
571
2
Process Scheduler Tab
573
3
Online Help Tab
576
1
Trace Tab
576
1
Common Settings Tab
576
2
Other Tab
578
1
Import/Export Tab
579
2
Client Setup Tab
581
1
Remote Call Tab
582
1
Database Tab
583
2
Workflow Tab
585
2
Application Servers Tab
587
2
Appendix B Application Designer in Upgrade Mode
589
4
Index
593