OUS Data Warehouse

Human Resources Data Mart - Aggregate Site

This data store contains essentially unmodified Banner HRIS data – reorganized slightly to enhance accessibility. It is designed primarily for ad hoc querying and reporting by staff at OUS and OSU. Content and structure is defined and managed by the HRDS User Groups with representatives from each campus and the Chancellor’s Office.

• Detail data about the following subject areas. Data is current except as noted:
• Employees (history too)
• Persons
• Positions
• Position Labor Distributions
• Jobs (history too)
• Job Labor Distributions
• FTE
• Earnings (history only)
• Deductions (history too)
• Bargaining Unit
• Leaves
• Reviews
• Faculty (Unclassified)
• This data is available from systemwide Banner HR instances (UO, OSU, PSU, EOU, SOU, WOU, OIT, Controllers Office) and is refreshed each Sunday night.