skip page navigationOregon State University
OSU HomeCalendarFind SomeoneMapsSite Index

OSU Data Warehouse

Human Resource Information System (HRIS) Data Warehouse


OSU's Human Resource Information System (HRIS) data warehouse contains data extracted from Banner HRIS and reorganized a bit to enhance accessibility. It is designed primarily for ad hoc querying and unofficial reporting by staff in the various departments at OSU.

The HRIS Data Warehouse contains the following general subject areas (current or last known status since 1/99, except as noted):

  • Persons
  • Employees
  • Positions
  • Budget for Position Labor Distributions (two current years)
  • Jobs (history, too)
  • Job Labor Distributions (history, too)
  • Benefits and Deductions (two current years; RESTRICTED ACCESS)
  • Pay (three current years)
  • Skill codes recording Employee Training

This data is refreshed nightly, except for the Pay and Benefits objects, which are refreshed each weekend, and occasionally during the week as necessary.

Additional resources relating to the HR Data Warehouse:


This page last modified on Tuesday, 23-Oct-2012 08:41:27 PDT