Yale University Home Search Yale sites Calendar of Events SFAS home page
 

 

 

 

 



SFAS Support

WHAT WE DO

The Student Information Technology Services (SITS) within SFAS supports Yale staff who require access to student data. Banner is the database that is used for student records, course data, academic history and all admissions data. Most data is entered using Banner forms. Data can be retrieved into a variety of formats using BrioQuery tools (BrioQuery 9) and Oracle report software.


Banner Training

Two types of Banner training are available. A two-hour introductory class, Banner Basics and Name Searching, covers navigating Banner forms and how to search for names in a Banner database. NOTE: This class is required if you will be creating SPRIDEN (person) records.
More individualized training and documentation is available for specific Banner departmental requirements, such as using Admissions forms. Click here to request Banner training.

Brio Reporting


Brio Training Schedule

Brio training is offered in our Training Room at 246 Church street. All classes will now be offered in BrioQuery9. There are three levels of classes available, plus some workshops:

Brio Level I: This is an introduction to the Brio environment. The class covers how to run existing Brios, how to manipulate data in the Results section, and pivot tables.

Brio Level II: For experienced Brio users. This class covers how to change existing Brios, table joins, calculations and pivot table functions.

Brio Writing and Reporting: How to write basic Brios and create formatted reports.

Using Brio with Word Mail Merge: How to export results from a Brio query into Excel and merge those results with Word letters, labels and emails.

Current Training Schedule (at 246 Church Street)*
Brio Level I

Wednesday, December 9, 9:30-11:30

Brio Level II

Tuesday, December 15, 9:30-1130

Brio Writing/Reporting
Per request

* Updated 6/9/2009

Click here
to sign up for one of these Brio classes or a future class, or to request specialized training.

Room Scheduling/Resource25

Resource25 (R25) is the room scheduling system that interfaces with our Banner database. All course room assignments made in Banner are downloaded into Resource 25 each term.

Resource25 is also being used for non-academic classroom scheduling (e.g. film showings or student meetings).

Using Resource 25 requires a Banner ID and password, plus R25 access. Terminal server access is also required if you are using Spedbook. Click here for documentation on accessing the terminal server.

ACCESSING STUDENT INFORMATION

Student and applicant data is maintained in Banner for Yale College and the Graduate and Professional Schools. All access to student and applicant data is restricted and follows the guidelines of the Buckley Amendment, which guides the University's policy on the rights of students regarding their educational records. Any staff member who requests Banner access must sign an Acceptance of Responsibility Regarding Confidentiality as part of the Banner access request paperwork. Forms are available below.

Anyone accessing data must be familiar with FERPA and all policies governing student data access. Click on the link below for more information:

Policy on Release of Student Information


DOWNLOADABLE SFAS FORMS

There are multiple forms available for requesting access to student information. The descriptions of each form should help in determining which one to use. Access may be requested by the individual user or the supervisor, but all access must be approved by a supervisor.

The following forms can be downloaded and FAXed to SFAS at 203-432-2787.

Form
Description
Use this form to request access to Banner forms for querying and/or updating applicant or student data or access to Banner-related tables via Brio reporting or a custom application.
If you are a DGS or proxy in a Graduate School department, or a Professional School using Faculty Student Advising, and you will only be using FSA, use this form.
If you are a faculty member who needs access to input or view grades, use this form.
If you are a department chair or proxy and need access to online course evaluations, use this form.
If you will be using Resource 25 for scheduling events into campus rooms, use this form whether or not you are also requesting general Banner access..

CONTACT INFORMATION

Who
E-mail
Telephone
Joan Rawlings joan.rawlings@yale.edu 436-1932
Anthony Costanzo anthony.costanzo@yale.edu 432-5860
Sharyn Wilson sharyn.wilson@yale.edu 432-8167
Mary Lee (Fin Aid) mary.lee@yale.edu 432-0367
Kellie Webb kellie.webb@yale.edu 432-4199

 

SITS Director: Jill Carlton 432-4461

FAX: 203-432-2787

LOCATION: Our offices and training room are on the 3rd floor of 246 Church Street.

 

DOCUMENTATION

Documentation for using Banner is maintained on the N: drive under Sfas/Banner/User Documents/Yale Documentation. Check there for general information on using Banner forms, doing name searches, mapping a drive and other general topics. For documentation specific to Registrars or Admissions offices, look under the specific folder.


BACK TO TOP

Last updated: 10/20/2009