PEOPLESOFT HRMS REPORTING
Ouvrage 0-13-021612-7 : PEOPLESOFT HRMS REPORTING
Make your company's PeopleSoft investment pay off!
Create the accurate, insightful reports you need, first time,
every time, with PeopleSoft HRMS Reporting-the only
complete guide to PeopleSoft reporting. The Complete
and Authoritative Guide to Retrieving Data from
PeopleSoft's Human Resource Management System
PeopleSoft specialist Adam Bromwich presents
authoritative guidance on the successful design of PeopleSoft
HRMS databases and reports for superior
performance, ease of use, and value. Learn how the PeopleSoft
database is organized-functionally and technically;
review its key tables; and understand how PeopleSoft's online
capabilities are linked to the relational database
beneath them.
Discover how you can: Access your data directly,
using Structured Query Language (SQL) and via PeopleSoft's
powerful Structured Query Reports (SQR) language
Design better tables and reports for HR, Payroll, and Benefits
Construct more comprehensive queries Avoid
expensive pitfalls in PeopleSoft table design
Bromwich reveals the hidden decisions PeopleSoft HR
developers must make. How does calculating a payroll
affect paycheck data? When does an effective dated
table cause major headaches? Where is the accurate data
stored and which tables should be left alone?
You'll find common routines for retrieving functional data,
techniques for slashing costly debugging and
maintenance, and much more.
PeopleSoft HRMS Reporting is the only independent
guide to real-world PeopleSoft reporting. And it's based on
the unmatched experience of one of the world's
leading PeopleSoft experts.
Adam Bromwich is a consultant specializing in
PeopleSoft implementations. He has participated in "big bang"
implementations of PeopleSoft HR, benefits, and
payroll modules at Fortune 100 corporations with employee
populations exceeding 100,000.
Table of Contents
Series Foreword
Foreword
Preface
Acknowledgements
Part I: Peoplesoft Basics.
1. PeopleSoft HRMS: The Basics.
2. Effective Dating.
3. Understanding Control Tables.
4. Reporting Tables_An Overview.
5. System-Wide Key Structure.
Part II: Human Resources.
6. Personal Information.
7. The Job Table.
8. Status.
9. Compensation History.
10. Position/Job History.
11. Corporate Hierarchy.
12. Employment Information.
13. Background Information.
Part III: Payroll.
14. Working with Payroll Data.
15. The Paycheck.
16. Earnings.
17. Deductions.
18. Taxes.
19. Garnishments.
20. Year-End Processing: The W-2.
Part IV: Benefits.
21. Navigating Benefits.
22. Health and Life Plan Elections.
23. Dependents and Beneficiaries.
Appendix A: Reporting Tables
Appendix B: PeopleSoft Query Performance/Fast
Security
Appendix C: Delivered SQR Common Modules
Index
Auteur : BROMWICH
Editeur : PRENTICE HALL
Nombre de pages : 428
Date de publication : 11 1999
Toute la sélection
Toutes les sélections
Toute la sélection
Site réalisé en partenariat avec Courbis
(Courbis - alternate link), acteur de l'Internet depuis 1988...
Le Monde En Tique