OAS / Data Warehouse

Objective

• To provide information about the data available in the Oracle Analytics Suite Data Warehouse

Scope

• One of the sources of data used by OAS is our Data Warehouse.  This document outlines the process for requesting access to the Data Warehouse, along with an overview of the data currently in the Data Warehouse

Environment

• 737842: Oracle Analytics Server (OAS)

Getting Access

The following authorized OAS client administrators may request changes to OAS accounts or to request new OAS accounts:

• Student Financial Assistance: Leigh Mondello-Garrett
• Enrollment Management (Admission): Glenn Ellerbe 
• Advancement Services: Amy Shaiman, Tim Jones
• Institutional Research: Michael Light
• Academic Personnel: Becky Sander, Ruth Groom
• Registrar: Carol Jones, Alicia Current
• Bursar: Kriss Cassano
• Finance and Business Services: Sarah Persinger, Angeline Poling, George Salem 
  • Submit requests via FBS Divisional Help from FBS-IT
• Human Resources: Sarah Persinger, Angeline Poling, George Salem
  • Submit requests via FBS Divisional Help from FBS-IT
• Budget: Jeff Pidcock
• Student Affairs: Drew Davis
• Provost: Lindsay Carpenter
• Regionals: Oliver Davis

BI Data

The Data Warehouse currently has the below listed data areas. Not all data is available to all users. This article has a list of authorized client administrators who can help you get access, if you need it.

• Student:
  • Cohort
  • Retention
  • Degree Attempted/Awarded
  • Major Attempted/Awarded
  • Courses Enrolled
  • G.P.A.
• Campaign
• HR
• Finance/GL
• ID Card
• Program Review
• Responsibility Centered Management
• Course Revenue

Notes 

• To find out more about the user roles for OAS, read this Knowledge Base article
• For information about the tools that comprise OAS, read this Knowledge Base article