The Payroll/Personnel Decision Support System (PPS DS) is the web-based reporting system giving departments, dean's offices and central offices access to their employees appointments, payroll expenses and staffing information. Pre-defined reports give on-line access to the payroll data with the ability to customize the reports with different selection criteria, report layout flexibility and sorting options as well as the ability to create spreadsheets. The set of reports consists of expense, personnel, and staffing reports with other reports in development to follow. The report menus and selection criteria are very similar to the DaFIS Decision Support System (DaFIS DS) with the access security mirroring the PPS system. This system was introduced to the campus mid-July 1998 following a beta test with participants from departments, dean's offices and central offices.
There has been some confusion about the different Payroll/Personnel systems in how they relate to each other and what can be done through the different systems. If you have questions, please follow the links for more system information.
| PPS Inquiry and Entry/Update: | These screen inquiry and entry/update systems access the
Production Payroll system at Office of the President. These systems use
TELNET3270 secure software
to connect to the IBM mainframe. Changes made through the Entry/Update screens can be
viewed immediately. The On-Line Time Reporting System (OPTRS) is part of this system. |
| PPS Web Inquiry: | This system access the Production Payroll system at the Office
of the President. This application is web-based and is available in the
Production Region only. The PPS Web Inquiry System is like
the PPS on-line system; the difference is you only can inquiry information. Unlike PPS, the
Web-based PPS Inquiry access only accepts alpha and numeric characters in the password.
If you are using any additional symbol like %, $, #, etc. please change your password in
PPS prior to logging on to the new web-based system. The same log on and user rules apply
to this web-based system as the PPS system. |
| PPS Decision Support: | The Decision Support system uses the PPS Data Warehouse data
to create its reports. The same usercode can be used for either the PPS Data Warehouse or
PPS Decision Support. If you have further questions, please use the link to Email the
support team. |
| PPS Data Warehouse: | The local PPS Data Warehouse is a copy of the payroll data
from Office of the President. No changes can be made to this data. Access to this system
requires a usercode, a query tool (such as Microsoft Access) and
knowledge of the data
structure. |
FOR MORE INFORMATION, PLEASE SEE:
Last Updated: February 15, 2006
A Payroll/Personnel Decision Support System, currently under construction, is scheduled to be available to campus departments by the middle of July. Like the DaFIS Decision Support System, this system will be accessed through a Web browser, and users will be able to select and execute pre-defined reports from a menu of query options. It will incorporate a security system which will allow authorized users access to employee and expense data for their department(s).
The initial release will include expense and personnel queries. These query types were identified through two information sessions with key campus business managers and users conducted jointly by Office of Administration, Accounting and Financial Services, and Information Technology staff. Payroll liens queries, the third priority identified at these sessions, will be implemented at a later date. A beta test of the system and queries will be conducted during the month of June.
A class on the Payroll/Personnel Decision Support system, currently under development, will cover the security of Payroll information, and policy regarding accountability, accessing the system, navigating menu options, and executing the queries.
The local Payroll/Personnel Data Warehouse, the source of information for this PPS Decision Support System, was initially rolled out to the campus during the summer of 1996. The system was designed to allow users to access a payroll database using SQL-based query tools to create reports and data extracts. It contains over 50 tables of information with personnel and expense data from UCD's employee database at Office of the President. The Payroll/Personnel Data Warehouse is currently being enhanced to provide additional data for the PPS Decision Support System. Current Data Warehouse users will not need to change their login accounts to access the new system.
