Design and Deliver PeopleSoft Enterprise Resource Planning Solutions
Develop data-driven Oracle PeopleSoft applications and business intelligence reports with help from the expert advice in this Oracle Press guide. PeopleSoft Developer's Guide for PeopleTools & PeopleCode shows you how to build and enhance PeopleSoft modules that maximize return on investment. Set up PeopleSoft Pure Internet Architecture, create PeopleCode projects, integrate HTML and Web features, and create reports with Oracle XML Publisher. You will also learn how to use COBOL, SQR, PeopleSoft Application Engine, and Middleware integration.
Install and configure PeopleSoft Pure Internet Architecture
Work with PeopleCode components, objects, and classes
Build pages and modules using the PeopleTools application designer
Add HTML and Web elements in PeopleCode
Implement code on the middle tier tools and work with process manager
Execute powerful batch processes with application engine
Generate detailed reports using Oracle XML Publisher and SQR
Debug, secure, and optimize your PeopleSoft applications
About this product: Adam Bromwich's objective in PeopleSoft HRMS Reporting is to synchronize the perspectives of technical people (PeopleSoft designers and administrators) and functional people (managers who use PeopleSoft). If technicians know what managers need and managers know what technicians can do, more productive enterprises will result. Bromwich succeeds admirably, explaining the human resources, payroll, and benefits aspects of the PeopleSoft HRMS database. Taking a table-by-table approach to the information PeopleSoft stores, the book explains each field in many of the most useful tables and details unusual formatting where it's an issue. He also explains how various pieces of data relate to one another and how best to access them. In one sense, this is a guided tour of a great big relational database.
What's neat about Bromwich's style is his frequent inclusion of workaday tricks and shortcuts for getting things done quickly and easily. These aren't the contrived "hints and tips" that characterize so many software books. Rather, they're practical procedures that the author has learned on the job as a consultant. He's also quick to clarify confusing aspects of PeopleSoft's interface, explaining, for example, that a pay run ID is not the same as a user run ID or a run control ID. He's also careful to explain how PeopleSoft has changed through its revisions, documenting how what used to be a straightforward record of U.S. Social Security numbers is now a more complex facility for handling many countries' citizen-identification systems. --David Wall
Topics covered: The structure and contents of three major PeopleSoft databases: human resources, payroll, and benefits. Detailed attention goes to dates, control tables, personal information tables, department trees, payroll runs, tax issues, and query design with the SQR language.
The newest addition to the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Author, Kurtz, is a field expert and thus, provides answers to common questions that arise when using PeopleSoft on an Oracle database.
Kurtz begins the book with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Kurtz transitions smoothly between subsequent chapters, explaining database structures, connectivity, keys and indexing, the PeopleSoft DDL, and tablespaces. Kurtz gives appropriate weight to advanced topics as well, like schemas, performance metrics, performance monitoring utilities, and SQL optimization techniques. And the final chapters provide crucial, advanced information about Tuxedo.
A PeopleSoft expert reveals how to combine PeopleSoft's PeopleTools with modern languages, technologies, and methodologies
PeopleSoft PeopleTools Tips & Techniques helps you to hone intermediate to advanced PeopleSoft development skills. This Oracle Press guide contains a comprehensive array of examples and documentation that cannot be found in any other source. You’ll work through a series of development scenarios that increase in complexity, ending with examples and documentation that will challenge, inspire, and educate even the most highly skilled PeopleSoft developers.
PeopleSoft PeopleTools Tips & Techniques:
Contains undocumented techniques not available elsewhere
Is written by one of the foremost experts on PeopleSoft development worldwide
Covers Java, JavaScript, and Ajax
Includes tips for improving the PeopleSoft development process with Test Driven Development (TDD)
Authoritative content from Oracle Press: Core PeopleTools Concepts; Application Classes; Test Driven Development; File Attachment API; Approval Workflow Engine; Pagelet Wizard; Extend the User Interface; Iscripts; Your First JavaScript Modification; Ajax; Creating Custom Tools; Java; Extend PeopleCode with Java; A Logging Framework for PeopleCode; Supplementing Java with PeopleCode; Integration; Java on the Web Server; Best Practices; Fusion Middleware for PeopleSoft; Design Patterns
About this product: --Used by thousands of companies, PeopleSoft is an invaluable software tool for HR, financials, and other business functions, and this is the comprehensive guide you've been looking for. --You can feel confident in this expertly written book, penned by the leading PeopleSoft consultants of Ernst and Young, one of the Big 5 consulting companies. --Geared towards IS managers, implementers, and project team leaders, this indispensable guide covers such topics as planning, implementation and testing, configuring the modules, and setting up tech support.
About this product: SAMS Teach Yourself PeopleSoft in 10 Minutes focuses on the end-user by covering general tasks including basic navigation skills, working with master data and running reports. This book covers the general PeopleSoft functions that every end-user of PeopleSoft-based applications must know. You will learn all the essential tasks for running PeopleSoft-based applications smoothly and easily. Using concise 10-minute lessons, you will learn how to log on to PeopleSoft, access the PeopleSoft modules, use basic navigation skills, work with master data, generate reports, read and interpret common error messages, and access extensive online help features.
About this product: Are you new to PeopleSoft? Experienced, but somewhat baffled by PeopleSoft Security? Just wondering what the heck a Primary Permission List does anyway? Well, The Expert Guide to PeopleSoft Security is for you.
The Expert Guide to PeopleSoft Security provides all the information you need to successfully implement and administer security in PeopleSoft 8. Covering specifics for PeopleTools versions 8.1, 8.2 and 8.4, it is the first book to provide an in-depth look at one of the most important aspects of the PeopleSoft System. The Expert Guide to PeopleSoft Security provides knowledge and insight for Administrators, Managers, Developers and Users alike.
The Expert Guide to PeopleSoft Security covers the topics essential to your success, including: Security Design, User Profile Setup, Role & Permission List Setup, Process Security, Query Security, Row Level Security (for HR and Financials), Portal Security, Security Migrations, Definition Security, LDAP Authentication, Password Controls, Dynamic Role Creation and more. Additionally it provides an indispensable reference to PeopleSoft Security Tables as well as SQL scripts to query the security information most requested from the system.
All in all The Expert Guide to PeopleSoft Security provides a comprehensive look at one of the most misunderstood but essential parts of the PeopleSoft System. Is your system properly secured?
About this product: This is a text which offers the information required to implement PeopleSoft Financials. It covers every stage of PeopleSoft implementation, from organizing the implementation SWAT team, to prototypes and customization, and using production systems for financial reporting. It shows how to customize PeopleSoft to work with business processes, or to help re-engineer them. The book teaches readers how to prototype the PeopleSoft system and then move it into production. Finally it advises on the critical keys to success.
About this product: This book is the only administrator's resource for PeopleSoft and covers not only the latest version, 7.5, but earlier ones as well. PeopleSoft installations are notoriously difficult to administer, and this book has everything administrators need to know, whether they are using the Human Resources, Financials, or other modules. Coverage includes setting up the system, security, performance tuning, dealing with upgrades, disaster recovery, troubleshooting advice, and planning for the future. The book also covers the development tools that an administrator must know about, because 90 percent of an administrator's problems are data-related. Bilbrey is a Human Resources IS manager and internal systems consultant for a large insurance company in the southeast. He has administered PeopleSoft systems for three years.
About this product: SQR in PeopleSoft and Other Applications fills a big gap in the enterprise computing marketplace. For starters, this book explains (beginning from near zero) how to program with Structured Query Report Writer (SQR). It discusses the peculiarities of writing SQR software to interact with PeopleSoft databases. Readers are shown how to integrate SQR programs with the Process Scheduler and how to take advantage of the PeopleSoft API. There's coverage of SQC files and the mechanics of calling SQR code from PeopleSoft online panels, plus appendices that document command-line flags and built-in functions.
The authors' approach to the topic reflects their considerable experience as SQR and PeopleSoft consultants. SQR in PeopleSoft--particularly its more advanced sections--contains lots of code that feels like it came only slightly modified from a consulting job. One particularly neat element is an SQR program that uses a flat file to provide an interface between PeopleSoft and IBM/Lotus cc:Mail. Though there's no companion CD-ROM, you can download all the code from the publisher's Web site. The code is well organized and serves as a fine base for the tutorial provided. --David Wall
Topics covered: SQR data elements fundamentals, pages, programs, and procedures; query and reporting capabilities; advanced SQR capabilities; graphics (including bar coding); Internet integration; and complex data structures.