Structure of Student Data

The UW Student Database (SDB), also known as Keynes, is a university-wide system for managing student records and student data. This is the system from which all other data resources (EARS, MyPlan, etc.) pull information. Using Keynes, advisers can access student information. Keynes also allows advisers to add and remove holds, register students, or make DARS exceptions.

The UW Electronic Academic Record System (EARS) enables authorized UW staff to access official student record information in a web format. Typically advisers use EARS to get a quick and easy overview of a particular student’s information. EARS also has a notes function that many advisers across campus use to write notes about student appointments. Advisers can also use EARS to make DARS exceptions.

The Enterprise Data Warehouse (EDW) is a set of databases that hold all the business information for an organization and make it accessible across an institution. At UW, the EDW includes administrative data across the following subject areas: Students/Academic, Finance, Research Administration, and Human Resources and Payroll. The EDW is optimized for analysis and reporting on administrative data for compliance purposes as well as analytics. Users consume EDW data directly through database queries and indirectly through enterprise reports, data visualizations, and data cubes.

In BI Portal you can access data stored in the Enterprise Data Warehouse via reports and visualizations.

Getting Access

For instructions on accessing SDB visit the SDB administrative systems access page. For instructions on accessing EARS please visit the EARS webpage.

Notes on FERPA

Before viewing student data, please make sure you are familiar with the Family Educational Rights and Privacy Act for Students.

EARS will help you see important information about a student quickly. In EARS you can:

• Search for students by name
• Review important demographic data
• See a student's academic record
• Run degree audits
• Make degree audit exceptions
• See transfer credits
• Write and read adviser notes

To learn how to use EARS, you can take the EARS training course. In addition, the links below review the functionality of each tab/screen in EARS:

• Locator Screen
• Overview Screen
• Transcript Screen
• Transfer Credit Screen
• Degree Audit Screen
• Notes Screen

To learn best practices for writing notes please review the EARS Notes Guidelines Document.

Access and Training

To learn how to access and use SDB, please complete the training on the registrar’s website. This training will show you how to:

• Gain access to SDB
• Login to SDB
• Complete actions within screens
• Navigate to different screens

Need help troubleshooting? Try these resources:

• Troubleshooting SDB Login
• Navigating SDB: Important Key Commands
• SDB Screens Quick Look Up
• SDB Hints and Tips

What can I find in SDB that is not in EARS?

There are many reasons that advisers need to use SDB. The most common reasons are:

• Placing and removing holds
• Some DARS exceptions have to be in SDB
• Enrollment confirmation
• Viewing admissions information (high school attended, intended major)
• Registering students
• Faculty codes
• Add codes

Common SDB Screens for Advisers

While each adviser needs in SDB are different, here are some of the screens advisers commonly use:

• SRF630: This screen is where an adviser can add or remove holds
• SRF234: Faculty code screen
• SRF245: Add codes
• SRF104: Registration
• SRF120: View student registration transactions
• SRF130: Class Listing
• SRF203 and 204: Time Schedule Screens
• SRF500: Student search
• SRF 305: Admissions information screen

Note: Many advisers also use SDB for curriculuar purposes. We will not go into detail on this page, but for more information please see the Curriculum Page on the registrar's website.

Below you will find use case studies that illustrate how SDB and EARS can be used together to assist a student or find needed information.

Did a student add/drop a course and when did the transaction happen?keyboard_arrow_down

Situation

During Spring quarter, a student comes in and says that they don’t know why they are being charged $20 for having dropped a class, since they dropped it on April 7th. April 7th is the last day to make changes via MyUW without being assessed a $20 Fee and possible tuition forfeiture.

Solution

You open up SDB, find your way to the Registration Transaction Screen SRF120 and see that they students dropped her course at 1:09 Am on April 8th. Now, you can explain to the student that since they made changes after April 7th, they have been charged accordingly.

Student needs to add a class, but the system is not recognizing the prerequisite.keyboard_arrow_down

Situation

A student comes in and says they can’t register for Math 125 even though they’ve completed Math 124 with a 2.9 gpa.

Solution

You open up EARS and check their transcript to see that they’ve received at least a 2.0 gpa in Math 124, the prerequisite for Math 125. After confirming the students has completed the necessary prerequisite for the courses they’d like to add, you can log into SDB, and add the student into the course using the SRF104 screen. Once you’ve successfully added the student into the course, you should log into EARS and leave a note saying you completed an override into Math 125.

Questions about interactions with other advisers on campus.keyboard_arrow_down

Situation

A student shares that a departmental adviser has told them that they cannot take courses within the department they’ve been admitted to, this quarter. The student is upset because they feel they should be able to access the courses offered for majors-only.

Solution

You open up EARS to find the appointment notes that the departmental adviser has left. You open up the notes and the adviser states that the student has been admitted to the department but can’t begin taking courses until the following quarter, as senior students preparing for graduation, have already filled up the majors-only courses. The adviser wrote in the notes that the student will still need more credits after completing the major courses, to reach the 180 in order to graduate. You then use this information to have a conversation with the student about pursuing a possible minor or taking elective courses, as they will still need more credits to graduate, after completing the major requirements.

A student has a question about how a course was transferred in from a previous institution.keyboard_arrow_down

Situation

A student believes that there are credits missing on their UW transcript, which were transferred from a community college. The student shares that she took 4 anthropology courses.

Solution

You log into EARS, click on the “transfer credit” tab and then click “ evaluated courses”. You see that all 4 courses have been evaluated. You check her transcript in EARS and all 4 anthropology courses are on her transcript, but they say ”Anth 1XX”, ”Anth 2XX”, ”Anth 2XX”, and ”Anth 3XX”. You explain that the student has received appropriate credit and general education requirements, but has not received an exact equivalency because we do not offer that specific anthropology course on our campus.

Department chair asks for a class listingkeyboard_arrow_down

Situation

The chair of your department asks you for a class list for a specific course.

Solution

You log into SDB and using the SRF130 screen, locate the list of students registered for that particular course.

A student needs a hold from your office removedkeyboard_arrow_down

Situation

A student sent you an email asking for a Satisfactory Progress hold to be removed. It was placed because the student was not in their major. In the email, they have sent you the confirmation email they received about being accepted into their major.

Solution

You log into SDB Hold Update Screen SRF630, enter the students Identification number, and press ‘enter’. You see that the hold is in the first row, so you write a “D” (drop) in the Action column and press ‘enter’. Once the screen shows that the hold has been dropped, you confirm that the hold has been removed by logging into EARS and checking their “overview” tab.

What is a student registered for currently and in the future?keyboard_arrow_down

Situation

You and your student have discussed not taking too many STEM courses at once. This has caused the student too much stress and a very low gpa in the past.

Solution

You log into EARS and click on the “overview” tab. You scroll down until it shows their current class schedule and next quarter’s class schedule. You see that a student is registered for 3 STEM courses, all with labs. You use this information to start a discussion this with the student while you’re having your appointment.

What day did a student withdraw?keyboard_arrow_down

Situation

A student is coming in for an appointment with you. To prepare you look at their record on EARS and notice that the withdrew from their courses. In order to gain more context you would like to know when the withdrew.

Solution

Log in to SDB and view the SRF120 screen to see the date in which the student withdrew.

Viewing transcriptskeyboard_arrow_down

Situation

The note that a student provided when scheduling an appointment said, “ My schedule was too easy last quarter, so I need to take way more difficult classes next quarter."

Solution

You log into EARS and click on the “transcript” tab to see that the student was taking 3 courses to equal 13 credits and received a 2.8 gpa last quarter. You will discuss what academic success looks like in college at the next appointment with this student.