Decision Support

EDW - HR - Payroll

Description
The Payroll Universe contains historical records of payroll runs. This includes the gross pay, employer paid benefits, earnings transfers, re-issued checks, as well as the C-FOAPAL pay has been posted to for each employee.

Also contained is this universe is position and job information. Address and phone data for employees in contained in the Universe. Unlike the bulk of the data in this universe, address, phone and email data is limited to current records only.

Universe Guides
Find out how to use the Payroll universe to create custom reports:
Solution Library
The Solution Library contains step-by-step instructions on how to create commonly requested reports, including a report template to get you started.  Examples of what you’ll find in the Solution Library:
Query Clearinghouse
Query Clearinghouse is a web-based repository of sample BO reports, SQL code, and report templates available for shared use by UI report developers. The Query Clearinghouse sample reports should give you a great start to developing the reports you need to meet business needs in your office.  Examples of sample reports you’ll find in Query Clearinghouse: