OUS Data Warehouse Models

The Oregon University System Data Warehouse contains a subset of the information available in the OUS administrative databases. The Data Warehouse utilizes many data models optimized for data retrieval and reporting.

The OUS Data Warehouse group supports five data models on this site:

Information Services at Oregon State University provides functional and technical support for the OUS Data Warehouse models. IS also designs, develops, and supports enhancements. You can download the OUS Data Warehouse software via the OUS/OSU BI Software Distribution page.

Information Security Policy for OUS

The Oregon University System maintains their Information Security policy at http://www.ous.edu/dept/cont-div/fpm/genl-56-350. It is each user's responsibility to read and understand this policy as it pertains to issues including, but not limited to, information identification and data classification; the handling of personal information; and incident response.

OUS Budget Mart

The Budget Mart has data and functions that have been tailored for very specific needs. It is designed primarily for preparation of reports to the State Board or Higher Education, DAS, the legislature and for ad hoc use by Budget Directors at OUS institutions. It's defined and managed by Budget And Management of the Chancellor's Office in coordination with Budget Representatives from each campus.

Budget Mart features include:

  • Provide a basis for reporting accurate and consistent:
    • FTE (budget and current)
    • Salary (budget, current and projections)
    • Labor Distributions
    • Filled and Vacant position data
    • Actual vs. Projected payroll expenses
  • Match PICS calculations for pay adjustment and roll up costs for the biennial budget process
  • Provide many budget related reports, ready to be refreshed with the latest status
  • Project and report Future Salary Costs (based on a snapshot of selected HR data)

Budget Mart data is based on reportable Job and Position data extracted from an HR Data Store. Snapshots of this HR data, as of the end of each month, are kept in the Budget Mart.

OUS Finance Data Warehouses

These warehouses contain essentially unmodified Banner FIS data, although they've been reorganized a bit to enhance accessibility. They are designed primarily for ad hoc querying and reporting by staff at OUS institutions (e.g. some campuses use them for official internal financial reporting). Content and structure are defined and managed by the FIS Data Warehouse User Groups with representatives from each campus and the Chancellor's Office.

FIS Data Warehouses contain detailed data about the following general subject areas (since FY 96, except as noted):

  • General Ledger
  • Operating Ledger
  • 5-Site Transaction Ledger (2002 forward)
  • Payroll Ledger
  • Fixed Assets
  • Approval

These data are available from any one of the Banner FIS instances in the OUS system (or all of them together, in which case data is tagged by institution and refreshed monthly).

  • EOU, SOU, WOU, OIT and CO snapshots occur each workday night
  • PSU, OSU and UO snapshots occur each month

OUS Human Resources 5th Site

This data store contains essentially unmodified Banner HRIS data that have been reorganized slightly to enhance accessibility. It is designed primarily for ad hoc querying and reporting by staff at OUS regional institutions. Content and structure are 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 are 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)

These data are available from any one of the regional Banner HR instances in the OUS system (EOU, SOU, WOU, OIT, Controllers Office) and are refreshed each work night.

OUS Human Resources Aggregate Site

This data store contains essentially unmodified Banner HRIS data that have been reorganized slightly to enhance accessibility. It is designed primarily for ad hoc querying and reporting by staff at OUS and OSU. Content and structure are 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 are 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)

These data are available from systemwide Banner HR instances (UO, OSU, PSU, EOU, SOU, WOU, OIT, Controllers Office) and are refreshed each Sunday night.

OUS Space Utilization Data Mart

The Space Utilization Data Mart has data and functions that have been tailored for very specific needs. It is designed primarily for preparation of reports about the use of instructional facilities for Facilities Management, OUS Administration, State Board of Higher Ed, DAS, the Legislature, and for ad hoc querying by campus facilities management staff. It's defined and managed by Budget & Management Division of the Chancellor's Office in coordination with Space Analysts from each campus.

Space Utilization Data Mart Documentation

Space Mart data includes:

  • Location data – information about instructional space on each campus as provided by the Space Analyst at each institution
  • Summary Room data – summarizes Event data by building code and room number
  • Student FTE data – information by student level, from the Chancellor’s Office
  • Event data – information about individual classes scheduled by term which is drawn from all OUS Banner Student Information Systems via the Chancellor's Office (SCARF)

It also provides many standard reports, ready to be refreshed with the latest data. These reports cover topics like:

  • Scheduled occupancy (of student stations, by hour, by day, etc.)
  • Rooms scheduled by hour
  • Student Stations scheduled by hour
  • Space optimization (detail and summaries, by rooms, etc.)