You are here:

Available Data within the Student Data Warehouse

  Description Load Schedule
Graduation Pipeline

One row per major, one row per minor for undergraduate students applied for graduation.

Daily

Student Class
Registration Snapshot

One row per enrolled/withdrawn class per student per term per snapshot date.

Snapshot dates:

  1. Open Enrollment
  2. Start of Term
  3. Census
  4. End of Term
  5. Updated End of Term
  6. Live Data
Student Snapshot One row per "eligible to enroll or leave-of-absence" student per career per term per snapshot.

Snapshot dates:

  1. Open Enrollment
  2. Start of Term
  3. Census
  4. End of Term
  5. Updated End of Term
  6. Live Data
Undergraduate Domestic
Leave Requests
One row per leave request per undergraduate domestic student. Daily

*Reminder: Any data in the Student Data Warehouse prior to Summer 2014 only has the “Updated End of Term” snapshot information included. Trying to pull any other snapshots (i.e., Open Enrollment, Start of Term, Census, etc.) prior to  Summer 2014 will result in an error message stating that there is “No data to retrieve.”

Standard Report Library - Summary of Reports

For more detail on the use of each report, please view the meta data tab found on the corresponding report in the SDW.

Name of Report Description Reporting Details Prompts

All Grade Semester Report

 

 

Displays grades received for all courses for the specified subject(s) and term.

View:

Class Registration Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data at the updated end of term snapshot.

Course Subject: Identifies the course subject to show courses from.

Academic Term: Identifies the term you would like to see data for.

Course Subject: Allows specification of which course subject(s) to include in the report. courses under the specified subject will be included in the report.

Academic Term: Grades will be displayed for the selected term and subject/courses specified above. details will be reported for this term based on the ‘updated end of term’ snapshot.

Class Instructional Method (optional): Narrows the classes included in the report to the method(s) specified in this prompt.

Class Enrollment Stats

 

Provides statistics on class registration with the ability to compare stats across several terms.

View:

Class Registration Snapshot

Filters:

Course Subject College Formal Name: Limits stats to all courses offered by the specified College(s).

Enrollment Term and Snapshot: Specifies which term and snapshot combination to query for enrollment data. are then grouped by term and compared in the report.

College: Determines which college to generate statistics for, multiple selections are allowed.

Enrollment Term and Snapshot (optional): will specify which term and snapshot combinations to include, which will then allow stats to be compared per those terms. : A Fall “updated end of term” snapshot in the past can be compared to a current “open enrollment” to gauge where registration is at for that term.

Convocation Contact List

Business Question:

Who are the upcoming graduates? What is their contact information?

List of upcoming graduates and their contact information. The student IDs serve as a link to the individual Student Detail report.

View:

Graduation Pipeline

Filters:

Major Applied Field of Study: Identifies the major field of study of the graduating students included in the report.

Expected Graduation Term: Narrows the students in the report to those expected to graduate at the specified term.

Expected Graduation Term: Identifies the term you would like to see data for.

Course Retention Report

 

Selects students that are active in a given major and displays their grades for the specified courses. purpose is to track progress through a series of course or curriculum and identify where there are gaps.

View:

Class Registration Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data at the updated end of term snapshot.

Filter by Enrollment Status As of Any Specified Term/Snapshot: Applies prompt select for Enrollment Status to the query results.

Course: Specifies the courses you want to see retention for.

Student Number In List: This is a subquery to pull students based on their current major as specified in the prompt. subquery allows us to display all of the students majors, not just those in the specified college.

Term/Snapshot Combo: Allows selection of one or more term/snapshots combinations. is used to assemble a list of students that were active in a major as of a certain time, specified in the prompt.

Enrollment Status: Allows specification of which enrollment status should be considered as active in a major. is used with the Term/Snapshot combo above to determine who was active in a major as of the specified terms.

Course: Specifies which courses the report will query for enrollment data.

All Current Major College: Determines which college to run the data for. in a major under this college will be included in the report.

Department Level Retention Report

Business Question:

What is the current status of our students?

This report shows what major students were in during the specified terms and snapshot, which allows you to track changes in majors over time. The report only lists students that are active in a given major that declared during the same term.

View:

Student Snapshot

Filters:

Student Snapshot Term and Snapshot: Specifies the terms and snapshots to use for viewing each student’s major.

All Current Major Field of Study: Identifies the current major of the students you are tracking.

Term Code: Identifies the first term these students declared for the given major, thus grouping them together.

Student Snapshot Term and Snapshot: The terms and snapshots to use for viewing a student’s major during the specified terms. It is recommended to use the updated end of term snapshot.

All Current Major Field of Study: The major of the group of students you would like to track.

Enrollment Pattern

 

This report lists students in a given   major and shows their enrollment    status across the specified terms. You can include all students active in the major, or specifically those enrolled in classes.

View:

Student Snapshot

Filters:

Filter by Enrollment Status as of any specified term/snapshot:: student data based on the enrollment status specified in the prompt

Updated End of Term Snapshot Data: All data is report is based on the Update End of Term Snapshot data.

All Current Emphasis: Specifies the current major and emphasis of the student’s you are tracking in the report.

Student Career: Specifies whether or not to include undergraduate semesters, graduate semesters, etc.

Academic Term: Selects the terms to show enrollment data for. Leaving this blank will include all the terms with enrollment data for the students included in the report.

Term/Snapshot Combo: Identifies the term and snapshot that will be used to check for

enrollment status of the students to be included in the report.

Enrollment Status: Specifies whether to include students who are enrolled, not enrolled, taking a leave of absence, or to include all.

Terms: Selects the terms to show enrollment data for. Leaving this blank will include all the terms with enrollment data for the students included in the report.

Student Career (optional): Specifies whether to include data for undergraduate semester, graduate semester, etc.

All Current Major/Emphasis: Identifies the current major of the students to be included in the report.

General Math Writing and ESL

 

This report lists active students in a given college and displays their enrollment and grading statistics for ESL 1040, 1050, 1060, WRTG 1010, 2010, HONOR 2211, MATH 990, 1010, 1030, 1050, 1100, and 1210.This allows you to track progress through these courses and identify gaps.

View:

Class Registration Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data using the “Updated End of Term Snapshot”.

Filter by Enrollment Status as of any specified term/snapshot: Limits data to students that have the specified enrollment status (from the prompt) as of the specific term and snapshot (also

specified in the prompt)

Course: Specifies the courses you want to track the students’ progress for.

All Current Major Name: Identifies the current major of the students to be included in the report.

All Current Major Name: Filters to students that are of the specified major(s), based on the most current data available (not necessarily the specified term and snapshot in the prompt)

Term/Snapshot Combo: Identifies the term and snapshot that will be used to check for

enrollment status of the students to be included in the report.

Enrollment Status: Specifies whether to include students who are enrolled, not enrolled, taking a leave of absence, or to include all.

Course: Specifies the courses you want to track the students’ progress for.

All Current Major Name: Identifies the current major of the students to be included in there port.

GPA Ranking Report

 

This report lists active students in a given college and ranks them according to their GPA.

View:

Student Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data using the “Updated End of Term Snapshot”.

Academic Term: Narrows results to the term you would like to see GPA ranking for.

Major College: Specifies the major college you would like to see GPA ranking for.

Minor Field of Study: Specifies which minor field of study you would like to narrow the results to(optional).

Academic Term: Identifies the term you would like to see GPA ranking for.

Minor Field of Study (optional): which minor field of study you would like to narrow the results to.

Major College: Specifies the major college you would like to see GPA ranking for.

Graduation Figures by Term

Business Question:

What are the demographic characteristics of our students by Major Awarded Field of Study and Conferred Term?

This report lists student graduation details. Best if run by a single college.

View:

Graduation Pipeline

Filters:

Conferred Count: Limits graduation data to only degrees that were actually awarded (ie: ignore students that applied to graduate only).

Major Awarded Name: Identifies the major awarded  at graduation.

Conferred Term: Identifies the term a students degree was conferred.

Major Awarded Name: Identifies the major of the student’s included in the report.

Conferred Term: Identifies the term a students degree was conferred.

Graduation Pipeline

Business Question:

When did students apply to graduate, and how many degrees were conferred?

 

This report contains various graduation and academic statistics for the specified major and graduation term. The report shows data such as average GPA and the number of students being awarded a particular degree for the specified term.

View:

Graduation Pipeline

Filters:

Expected Graduation Term: Narrows the students in the report to those expected to graduate at the specified term.

Major Applied Name: Identifies the major of the student’s included in the report.

Minor Awarded Name: Further narrows the results to include a specific minor in addition to a major for the students included in the report.

Student Key: Used to link the list of students between the two queries.

Show Most Recent Student Snapshot Data Available: Uses the snapshot with the most recent data.

Expected Graduation Term: Narrows the students in the report to those expected to graduate at the specified term.

Major Applied Name: Identifies the major of the student’s included in the report.

Minor Awarded Name (optional): Further narrows the results to include a specific minor in addition to a major for the students included in the report.

Honors Historical Data

Business Question:

What are the enrollment and graduation statistics of a particular cohort of Honors Students?

This report  contains a  list of  honors students in a single cohort, with their graduation information. The report will track the students defined in the      cohort, even if they are not in the     specific cohort when they graduate.

View:

Student Snapshot/Graduation Pipeline

Filters:

 

Student Admit Term:  The term which the students in the report were admitted.

Enrollment Status : Specifies whether to include students who are enrolled, not enrolled, taking a leave of absence, or to include all.

Incoming Conditional Admit Report

 

This report displays a list of incoming students to a specified college according to a particular term. The students included in this report are admitted conditionally.

View:

Student Snapshot

Filters:

Student Snapshot Term and Snapshot: Narrows the report data to the selected term and snapshot used for viewing the incoming student’s status.

Major Field of Study: Identifies the major field of study of the incoming students included in the report.

Student Admit Term: Limits results to students that have an admit term value matching the term specified in the prompt when the report is run.

Student Conditional Admit Indicator: Narrows the data in the report to include only students who are conditionally admitted.

Major Field of Study: Specifies the major field of study of the incoming students included in the report.

Student Snapshot Term and Snapshot: The term and snapshot to use for viewing the incoming student’s status. It is recommended to use the open enrollment snapshot.

Incoming Honors Student

Business Question:

What background data is available for our incoming honors students?

This report lists incoming honors students to a specified college according to a particular term.

View:

Student Snapshot

Filters:

Student Admit Term: Identifies the term which the students in the report were admitted.

Academic Term: This filter is used to show student data from the ‘student snapshot’ for the term they were admitted (ex: what their major was the term they were admitted)

Filter by Snapshot Type:  determines which snapshot will be used for the specified term to display data.

Major: Identifies the major field of study of the incoming students included in the report.

Snapshot Type: Specifies the snapshot to use for selecting the data at the admit term.

Student Admit Term: The term which the students in the report were admitted.

Major: Identifies the major of the incoming students included in the report.

Incoming Student Report

 

This report lists all incoming students to a given college / major according to the specified term.

View:

Student Snapshot

Filters:

Student Snapshot Term and Snapshot: Narrows the report data to the selected term and snapshot used for viewing the incoming student’s status.

Major Field of Study: Identifies the major field of study of the incoming students included in the report.

Student Admit Term: Identifies the term which the students in the report were admitted.

Major Field of Study: Identifies the major college that the incoming students belong to.

Student Snapshot Term and Snapshot: The term and snapshot to use for viewing the incoming student’s status. It is recommended to use the open enrollment snapshot.

Incoming Student Report—With Transfer Data

 

This report lists incoming students to a given major college according to the specified term. Only students with transfer data will be included in this report.

View:

Student Snapshot

Filters:

Student Snapshot Term and Snapshot: Narrows the report data to the selected term and snapshot used for viewing the incoming student’s status.

Major Field of Study: Identifies the major field of study of the incoming students included in the report.

Student Admit Term: Identifies the term which the students in the report were admitted.

Major Field of Study: Specifies the major field of study of the incoming students included in the report.

Student Snapshot Term and Snapshot: The term and snapshot to use for viewing the incoming student’s status. It is recommended to use the open enrollment snapshot.

List of Students by Major (Declared and/or Enrolled)

 

This report lists students with majors in the selected college as of the specified term and snapshot. The report contains basic information on each student listed.

View:

Student Snapshot

Filters:

Filter by Snapshot Type: Specifies which snapshot to use to pull data into the report.

Academic Term: Narrows the results to the term you would like to see data for.

Minor Field of Study: Specifies which minor field of study you would like to narrow the results to (optional).

Major: Specifies which major you would like to see data for.

Snapshot Type: Identifies the snapshot (time frame) to use for pulling the data.

Academic Term: Specifies which term you would like to use to view the students at.

Minor Field of Study (optional): Allows you to narrow the students even further by including a minor field of study criteria.

Major: Identifies the major of the students to be included in the report.

Repeat Course Attempt

Business Question:

How many times has a student repeated a course?

This report lists students that have repeated a course offered at the University of Utah from a particular course department. This only includes University of Utah courses.

View:

Student Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data at the updated end of term snapshot.

Course Department: Specifies which course department to show repeated courses for.

Class Registration Count: Filters the results to include only courses with a class registration count of 2 or higher.

Class Grade: Specifies which grades to exclude from being counted as a repeat.

Course Department: Specifies which course department(s) / college to show repeated courses

for.

Class Grade to Exclude (optional): Specifies which grades to exclude from being counted as a repeat. : if ‘W’ is included, a student who has withdrawn from a course will not be considered a ‘repeated attempt’ for the purposes of this report.

Student Academic Summary/Grades/Class Schedule

 

This report displays a particular student’s academic summary, enrollment detail, and class schedule details.

View:

Student Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data at the updated end of term snapshot.

Student ID: Identifies the student to pull data for.

Conferred Count:: Limits graduation data to only degrees that were actually awarded (ie: ignore students that applied to graduate only)

Student ID: Identifies the student you would like to create the report for.

Student Course Enrollment Summary

 

This report displays all the courses a student has taken and the grade they received for each course. report is linked to from the Repeat Course Attempt Report.

View:

Class Registration Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data at the updated end of term snapshot.

Student Number: Identifies the student you would like to see course enrollment data for.

Course Catalog Number: Allows you to choose a specific class to see enrollment data for.

Course Subject Code: Goes with the above prompt to select a class.

Student Number: Identifies the student you would like to see course enrollment data for.

Course Catalog Number (optional): Allows you to choose a specific class to see enrollment data for. Leaving this field blank will return data for all courses a student has taken.

Course Subject Code (optional): Goes with the above prompt to select a class.

Student Detail

 

This report displays in-depth information about a particular student including contact, ethnicity, and academic information

View:

Student Snapshot/ Class Registration snapshot

Filters:

Academic Snapshot Type Description: Specifies what snapshot to use when pulling data into the report.

Student ID: Identifies the student to use in the report.

Student Number: Identifies the student to use in the report (you can use this instead of ID).

Student Number (optional): Identifies the student to pull data for (you can use this or ID).

Academic Snapshot Type Description: Specifies what snapshot to use when pulling data into the report.

Student ID: Identifies the student to pull data for.

Student List by Major

Business Question:

Who are our majors? What is their contact information?

This report lists students with majors in the selected college as of the specified term and snapshot. The report contains basic information on each student listed.

View:

Student  Snapshot

Filters:

Filter by Snapshot Type: Specifies which snapshot to use to pull data into the report.

Academic Term: Narrows the results to the term you would like to see data for.

Minor Field of Study: Specifies which minor field of study you would like to narrow the results to (optional).

Major: Specifies which major you would like to see data for.

Snapshot Type: Identifies the snapshot (time frame) to use for pulling the data.

Academic Term: Specifies which term you would like to use to view the students at.

Minor Field of Study (optional): Allows you to narrow the students even further by including a minor field of study criteria.

Major: Identifies the major of the students to be included in the report.

Student Population Trends

Business Question:

What are the current demographic characteristics of our students within the organizational hierarchy of the selected Major College? How have those demographic characteristics changed over time?

A list of student populations according to the selected Major College and Academic Terms.

View:

Student Snapshot/ Class Registration snapshot

Filters:

Filter by Snapshot Type: Specifies which snapshot to use to pull data into the report.

Minor Field of Study: Specifies which minor field of study you would like to narrow the results to (optional).

Major: Specifies which major you would like to see data for.

Academic Term: Narrows the results to the term you would like to see data for.

 

Snapshot Type: Identifies the snapshot (time frame) to use for pulling the data.

Minor Field of Study (optional): Allows you to narrow the students even further by including a minor field of study criteria.

Major: Identifies the major of the students to be included in the report.

Academic Term: Specifies which term you would like to use to view the students at.

Undergraduate GPA Rankings

 

This report lists undergraduate students active in a given college for a particular term, and ranks them based on their cumulative GPA.

View:

Student  Snapshot

Filters:

Updated End of Term Snapshot Data: Selects data at the “Updated End of Term” snapshot.

Academic Term: Identifies the term to show statistics for.

Major College: Identifies the major college of the students in the report.

Minor Field of Study: Further narrows the results to only show students with a particular minor.

Student Career: Specifies whether or not to include students from undergraduate, graduate, etc.

Academic Term: Identifies the term to show statistics for.

Minor Field of Study (optional): Further narrows the results to only show students with a particular minor.

Major College: Identifies the college to show students from.

High School Data Comparison

Business Question:

How does a student’s high school performance correlate with college performance?

A list of students with their first semester GPA at the U, and any applicable High School data.

View:

Student Snapshot

Filters:

Academic Snapshot Type Description: Specifies what snapshot to use when pulling data into the report.

Student Current Primary Major:

Cumulative UofU Number of Enrolled Terms:

Academic Term: Identifies the term to show statistics for.

Student Admit Term: Limits results to students that have an admit term value matching the term specified in the prompt when the report is run.

Student Honors Indicator:

Students Honor Indicator:

Student Admit Term: The term which the students in the report were admitted.

Student Current Primary Major:

 

Last Updated: 7/3/17