|
SFAS
Support
ANNOUNCEMENTS
No new announcements at this time.
Reported problems for Brio users
Users have been reporting problems with
receiving an "Oracle error -1"
when attempting to run a Brio. The message occurs when upon
entering your credentials. The most frequent cause appears
to be an outdated version of the Oracle client (must be at
Oracle 10g). This can only be rectified by your DSP or the
Help desk (contact the Help Desk at 203-432-9000). Managed
desktop prevents our group from being able to install an Oracle
client.
Another error, "SQL*NET Not Loaded
successfully" appear to be related to problems with the
Oracle client as well.
The central brio group has documented
these problems, and solutions, in FAQs from the following
link:
http://www.yale.edu/its/software/brio/faq%204-28-09.html
Banner 8 has now been in place since mid-July
and most outstanding issues have been resolved. We appreciate
your diligence in reporting any problems and your patiience
as they've been resolved.
As you may recall, most of the upgrade
revolved around a change to the underlying character set in
the Oracle tables: the migration to UTF-8 which supports international
characters.
For users, the look and feel of Banner
will remain much the same as Banner 7, however, there are
some important new features, including better support for
international data:
- Searching for international names will be easier
because Banner 8 will use the SEARCHNAME feature in
Extended Name searches. Names with diacriticals, or
spaces, will no longer require as much guesswork with
wildcards.
|
- This improved SEARCHNAME functionality should also
result in more consistent matches in the admissions
data loads, along with fewer duplicate records.
|
- Banner 8 will support a separate country code for
international phone numbers. This will be phased in.
|
- More forms will have tabs for easier navigation.
Both SSASECT and SYASECT have tabs for entering
meeting times and instructors.
|
- Better tracking of Banner users.
|
- Better documentation of forms.
|
If you have any upgrade-related questions,
contact joan.rawlings@yale.edu.
For any Banner access problems, contact
anthony.costanzo@yale.edu.
WHAT
WE DO
Student Information Services (SIS)
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 Refresher: NEW!
This is intended to be an open session where we will work
with users to answer brio questions or provide help on running
specific brios. Intended for experienced brio users.
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 |
January 18, 2012 Time: 9:30-11:30AM
|
Brio Level II |
TBD
|
| Brio Refresher |
|
| Brio Writing/Reporting |
Per request |
* Updated 10/19/2011
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 |
|
General Banner Access |
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. |
|
Faculty Student Advising (FSA) |
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. |
|
Faculty Grading System (FGS) |
If you are a departmental proxy or course director who needs access to view grades, use this form. |
|
OCEV Chair Self Service |
If you are a department chair or proxy and need access
to online course evaluations, use this form. |
|
Access to Resource 25 |
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
Support Email Address: sis.support@yale.edu
SIS Director: Joan
Rawlings 203-436-1932
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: 02/21/2011
|
