110 likes | 210 Views
PeopleSoft Data Extraction & Web Reporting . University of Iowa Session # W1-1025 Presenter’s Larry Meyer Elaine Haddy. Background. Implementation 7/1/99 Payroll, Benefits, Basic HR,Position Management 20,000 employees, 6,000 non-employees Multiple jobs
E N D
PeopleSoft Data Extraction & Web Reporting University of Iowa Session # W1-1025 Presenter’s • Larry Meyer • Elaine Haddy
Background • Implementation 7/1/99 Payroll, Benefits, Basic HR,Position Management • 20,000 employees, 6,000 non-employees • Multiple jobs • Monthly/Bi-weekly payroll • Fiscal, academic year and short term appointments • 3 union contracts
HRIS Support • Function of VP Human Resources 6 FTE’s • Eliminated IT programming support
Architecture • Oracle • Unix • Web PHP Microsoft Access Excel Lotus Notes
System Demo • Transaction processing • Reporting Internal & External Consistency • Ad Hoc Query/Data Extraction • Self-Service
Transaction Processing Elimination of paper No pre-printed forms Data entered once for multiple forms Data validation at time of entry Ease of use Electronic processing
Transaction System/Output • Appointment Form • Terms & Conditions • Blood Borne Statement • I-9 • Federal W-4 • State W-4 • Direct Deposit • Address • Immigration validation data
Reporting • Pro-active Management tool • Elimination of paper reports • Distribution • Real time • User control • Anytime/Anywhere • Rapid Report Development
Query/Data Extraction • No knowledge of PeopleSoft required • Table relationships pre-defined • Anytime/Anywhere • Pro-active management tool • Reduces Central HR/IT support • User defines inputs and outputs
Self Service • Reduces phone/walk-in traffic • Employee access to personal information • Anytime/Anywhere • Changing data • Eliminates pre-printed forms
PeopleSoft Data Extraction & Web Reporting University of Iowa Session # W1-1025 Presenter’s • Larry Meyer (larry-meyer@uiowa.edu) • Elaine Haddy(elaine-haddy@uiowa.edu)