Skip to main content

Discoverer: Student Caseload

Login Website

Banner INB Login website: Select Oracle Discoverer Viewer [ODSP]. 

How to Request Access

Complete the ODS [Operational Data Store] Access Request Form. Submit the completed form to Enterprise Systems, Susan Himes, HUS 202. Instructions for completing ODS Access Request Form. Advisors need to complete the following sections:

  • Section 1: Applicant/ODS User Profile Information
  • Section 2: Supervisor
  • Section 3A: Access to the ODS (Select: Basic ODS Access; Personal Information; Address/Phone)
  • Section 3D: Access to Student Data in ODS



Instruction Manuals


Instructions for Running a Caseload Report

  1. Login to Oracle Discoverer Viewer [ODSP] with your BANNER INB User Name and Password.
  2. Select the "+" sign next to either:
    1. TS - GUAA - Case Load
      1. Then select Case Load by Advisor OR Case Load Mailing by Advisor (includes student phone/address info)
    2. TS - GUAA New Students
      1. Then select All New Students
  3. Select a value for the Academic Period (the term you wish to query your caseload) and the click GO. For example: 
  4. Once your query has been executed (this may take several minutes), select the Primary Advisor Name in the drop-down list.
  5. Choose from the possible Actions in the upper left-hand corner:
    1. Rerun query
    2. Revert to saved
    3. Printable Page
    4. Export. Select an export file format, options include:
      1. Excel Workbook (*.xsl)
      2. PDF (*.pdf)Comma delimited (*.csv)
      3. GIF Image (*.gif)
      4. PNG Image (*.png)
      5. Text (Tab delimited) (*.txt)
    5. Send as email
    6. Worksheet options
  6. Select Export on the right side of the page.
  7. Click to View or Save the file.

Information You Can Access

Lists your Banner Caseload: undeclared students coded to you in SGAADVR who are currently enrolled. The list will include some students who are not enrolled, but this is not a reflection of ALL of your students who were enrolled the previous quarter and currently not enrolled. Instructions for using SGAADVR.

Caseloads include student name, EWUID, registration status for the quarter, class standing, quarter credits, cumulative GPA, academic standing, major, advisor name and more.

Please note:

  • You can request an Advisee List in EagleNET, however, this is a list of EVERY student who as ever been coded to you in SGAADVR (includes students who declared, graduated, and who are no longer enrolled at EWU).
  • FACULTY ADVISORS, also note that your Banner Caseload is only a list of those students coded to you in SGAADVR, not a list of students in your courses (as found in EagleNET). 

© 2018 Eastern Washington University
EWU expands opportunities for personal transformation through excellence in learning.