PeopleSoft HRMS Reporting

ISBN-10: 0130216127

ISBN-13: 9780130216120

Edition: 2000

List price: $60.00 Buy it from $26.61
eBook available
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


Thousands of companies are investing millions of dollars in PeopleSoft systems -- and a crucial factor in the success of these systems is careful database and report design. Now, for the first time, PriceWaterhouseCoopers consultant Adam Bromwich presents comprehensive, authoritative guidance on the successful design of PeopleSoft HRMS databases, tables, and reports for maximum value and effectiveness. Bromwich begins with a detailed overview of how the PeopleSoft database is organized, functionally and technically. Review the database's key tables, and the tools PeopleSoft provides for finding the table you need. Throughout the book, Bromwich focuses on the most efficient approach to retrieving PeopleSoft data: using SQL to access the database directly, rather than going through menus and panels. You'll review table design and reporting in HR, Payroll, and Benefits; and master the Structured Query Reports (SQR) language, PeopleSoft's most powerful reporting tool. You'll learn proven methods for designing both primary and secondary data tables for maximum performance, simplicity, and ease of data retrieval. Bromwich also demonstrates how to avoid common pitfalls in PeopleSoft table design -- including costly errors specific to multinational organizations. For all PeopleSoft developers and power users who will be creating databases and data tables to be accessed through PeopleSoft.
Used Starting from $38.50
eBooks Starting from $47.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Italian Grammar Online content $4.95 $1.99
Add to cart
Study Briefs
Portuguese Grammar Online content $4.95 $1.99
Add to cart
Study Briefs
Spanish Grammar Online content $4.95 $1.99
Add to cart
Study Briefs
German Grammar Online content $4.95 $1.99
Customers also bought

Book details

List price: $60.00
Copyright year: 2000
Publisher: Prentice Hall PTR
Publication date: 9/9/1999
Binding: Paperback
Pages: 464
Size: 6.75" wide x 9.00" long x 1.25" tall
Weight: 1.936
Language: English

Series Foreword
Understanding the Basics: PeopleTools vs. the Application
Application Designer
Thinking Vanilla
Online Modifications
Process Modifications (COBOL)
Interfaces and Reports
Realizing the True Savings of a PeopleSoft Implementation
PeopleSoft Basics
PeopleSoft HRMS: The Basics
An Introduction to the PeopleSoft HRMS Database
Types of Tables
Base Table (i.e., PS_PERSONAL_DATA, PS_JOB)
Control Table (i.e., PS_EARNINGS_TBL)
Views (i.e., PS_BENEFITS_VW)
Reporting Tables (i.e., PS_EMPLOYEES)
Application Tables (i.e., PSTREENODE)
The Non-Table: Sub-Records
The Core Base Table
Using the Application Designer To Find Table Definitions
Querying Tables
Cross-Referencing Fields
Cross-Referencing Panels and Tables
Looking for Comments
Searching the Code
PeopleSoft Processes
Dissecting a PeopleSoft Table
Identifying the Elements: A Look at a Table
PeopleSoft HRMS Basics: A Review
Effective Dating
The Effective Date Defined
Considering the Desired Results when Using Effective Dates
The Basic Effective-Date Sub-Query
Using an As-Of Date To Exclude Future Rows
Using Additional Criteria with A Sub-Query
Understanding Control Tables
Structure of a Control Table
Adding a Control Table of A Query
Using Effective Status
Merging Effective Dated Data across Tables (Point-in-Time Queries)
Finding Translate Values
Reporting Tables--An Overview
Reporting Tables--An Overview
The Employees Table (PS_EMPLOYEES)
The Benefits Plan Data Table (PS_BEN_PLAN_DATA)
The Benefits Personal Data Table (PS_BEN_PER_DATA)
The Employees Table
Improving the PS_EMPLOYEES Table
The Benefits Tables
Using the Benefits Tables Together: PS_BENEFITS_DATA
Enrollment Date
Keeping a Level Head: Positives and Negatives
Views You Can Use
System-Wide Key Structure
The PeopleSoft Business Unit
Using Business Units With SetIDs
The Set ID
Relational Requirements
Determining the Appropriate SetID in a Query
Human Resources
Personal Information
Personal Data
Identifying Employees: The Employee ID
The PeopleSoft Name Format
The Resident Address and Phone
Non-Employees on PS_PERSONAL_DATA
Original Hire Date
Birth Information
Education Status
Citizenship Status
Strange, but Important Fields
Personal Data for Other Countries
Understanding Effective-Dated Personal Data
Name Differences
Using Social Security Numbers In PeopleSoft
The NID Table and Identifiers
National IDs
Querying the National ID
The Job Table
Identifying Jobs On PS_JOB
Storing History: Effective Sequence
When Did It Happen? Tracking Actions
Actions and Action Reasons
Overlapping Changes
Job Table Flags
Linking Employees to Common Data
Entry Dates
Human Resources Settings
Payroll Settings
Company and Paygroup
Tracking Hourly Employees and FTE
Other Payroll Identifiers
Benefits Settings
Benefits Status
Benefits Base Rate
Custom Fields
FLSA Status
The Employee Status Field
The Status Date
Finding the Date of the First Action
The Long-Term Disability Issue
Using Two Job Table Rows
Simplifying Job Table Data with a Modification
Compensation History
Determining the Rate
Detecting Changes in Pay
Position/Job History
The Jobcode Table
Major Fields on the JobCode Table
JobCode History
Position Management
Position Tables and the Job Table
Corporate Hierarchy
Understanding the Use of Departments
The Department Table
Basic Department Settings
Manager ID
General Ledger Account Number
The Department Tree
Behind the Scenes
Queries That Use the Tree
PeopleSoft Query Method
Tree Navigation Alternative
Storing Department Tree History
Employment Information
The Employment Table
Multiple Sets of Employment Data
Multiple Benefits Selections
Employees on Global Assignments
Dates of Employment
Hire/Rehire Date
Length of Service
Expected Return from Leave of Absence
Using Termination Date and Last Day Worked
Pay Increases
Probation Date
Position Management Fields
Business Title
Reports-To Position Number
Supervisor ID
Phone Subrecord
Payroll Settings
Deductions and Deduction Subsets
Paycheck Distribution
Paycheck Name
Payroll System
Benefits Administration Flag
Background Information
Competencies vs. Accomplishments
Accomplishment Values
Identifying an Accomplishment
Employee Accomplishments
Linking Accomplishments By Category
Working with Payroll Data
Payroll Tables
Looking at a Specific Payroll Run
Using the Paycheck Table with Payroll Queries
Payroll Keys
The Current Payroll
Pay Run ID
Payroll Dates
Multiple Jobs
Taking Deductions
General Ledger
The Payroll Process
Payroll Calculation
Payroll Confirmation
Error Resolution
Identifying Payroll Process Achievements
Batch Processing Payroll Data
Associating Batch Requirements with Payroll Dates
Accumulators and Buckets
The Paycheck
How Do Checks Get Created?
The Paycheck Table
The Rest of the Payroll Keys
Alternate Keys for Finding a Check
Delivering Paychecks
Paycheck Accounting
How Much Did I Get?
Different Kinds of Paychecks
Online Check
Manual Check
Final Checks
Defining Earnings
Earn Codes
Defining an Earning: The Earnings Table
Retrieving Earnings for an Employee
The Pay Earnings Table
Feeding PeopleSoft
Getting to Know Deductions
Deduction Code and Class
Defining a Deduction: The Deduction Table
Enrolling Employees in Deductions
The General Deduction Tables
Verifying Eligibility
Retrieving Deductions
The Pay Deduction Table
The Query
Tax Locations
State and Locality
The Other States
Tax Location Code
Defining a Tax
Tax Class
Local Taxes
State and Federal Taxes
Tax Type/Rates
Employee Tax Elections
Special Withholding/Allowances
W-2 Settings
State Settings
Local Settings
Retrieving Taxes
The Pay Tax Table
Setting up Garnishments
Employee Garnishment Specifications
Retrieving Garnishments
The Pay Garnish Table
An Accounts payable interface
Year-End Processing: The W-2
The W-2 Design
W-2 Parameters
Auditing Data Using Delivered Reports
Limitations and Multiple W-2s
Using W-2 Tables
Navigating Benefits
An Introduction to Benefits
Understanding Benefits Administration
Basic Benefits Terminology and Setup
Benefit Plans and Plan Type
Benefits Programs
Defining a Benefit Program
Defining Plan and Plan Type Settings for a Program
Linking Plans with a Program Using Options
Specifying Benefit Plan Settings
Special Plan Type Rows
Retrieving Common Benefit Plan Characteristics
Benefit Program Costs
Benefits Control Tables
Base Benefits Control Tables
Benefits Administration Control Tables
A Control Table Summary: Looking at Benefits ID Fields
The Benefits Administration Process
BAS Activity/Manual Entry
On-Demand Event Maintenance
Tracking PeopleSoft Benefits
Benefits Interfaces
Benefits Reports
Health and Life Plan Elections
Health Enrollments
Determining the Current Enrollments
Finding the Most Recent Transaction Date
Finding the Enrollment Date
Locating a 'Termination'
Life Plans
Determining Coverage Amounts
Coverage Groups
Dependents and Beneficiaries
How Are Dependents and Beneficiaries Stored?
Locating All Dependents for a Participant
Using Dependent/Beneficiary Type
Specifying relationships
The National ID
Determining Dependent Coverage
Dependent Enrollment Date
Rate Tables
Flat Rate
Service Steps
Calculation Rules
Looking Up a Rate
Query and SQR Tools
PeopleSoft Query
Query Basics
Accessing and Setting Up Query
Creating a Query
Outputting/Viewing the Query
Advanced Query Topics
Aggregating Totals
Finding Distinct
Custom Sub-Queries
Joining Tables with Unions
Using PeopleSoft Trees
Issues (status records, others)
Using SQR with PeopleSoft
Other References
Why SQR?
Using SQR with PeopleSoft
Considering Validations
Types of SQRs
Basic SQR Nested Query
Understanding Delivered SQR Programs
Common Modules
Basic Common Module Calls
Running Delivered SQRs
Delivered Parameter Processing
Common Modules to Build
Debugging SQR Programs
Advanced SQR Features
Understanding the Printing Process
Dynamic SQL Clauses
Reporting Tables
Missing Fields
PeopleSoft Query Performance/Fast Security
Query Security Overview
Operator Classes
Why Queries Take So Long
The Fast Security Solution
PeopleCode Modifications
Delivered SQR Common Modules
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.