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:

• FIS/HRIS Cooperative Learning Group
• FreeStyle Data Warehouse Reports Cooperative Learning Group
• HRIS Data Warehouse FAQ