To better serve our customers’ needs, we will develop Tableau data sources that allow users to access curated data behind the enterprise dashboards. This will enable you to create customized reports and dashboards tailored to your business requirements. Once granted access to the enterprise dashboards through the Federated Authorization process (Student Mart), you will have access to the enterprise data sources and Tableau Web Edit.

Users can utilize the Tableau Web Edit functionality to create custom views or purchase a Tableau Desktop license for full development capabilities.

Note, student data is complete going back to the implementation of PeopleSoft in Fall 2005. For students who graduated prior to Fall 2005, records are recreated in PeopleSoft on-demand, meaning the student data predating Fall 2005 is incomplete.

Additional data sources will be released through FY2025.

Active Student

Active Student contains personal and academic data for any student enrolled or eligible to enroll as of today's date. It reports current, next, and second-upcoming term data, such as enrollment appointment times and assigned advisor(s).

The data source is updated Every Monday-Saturday at 7:30 AM (UTC-05:00) America/New York.

The data source does not have historical data or class-specific enrollment data.

The data captures only “active students” (those enrolled within the last three terms). The “active” status begins with the matriculation action in the student information system and ends with the awarding of a degree or discontinuation of an academic program. “Active” status does NOT include the following:

APPL (application)
ADMT (admit)
DEIN (intention to matriculate)
DISC (discontinuation)
COMPL (completion of program)

Students with three terms of inactivity and those not enrolled in their admit term are discontinued in the student information system roughly five days after the end of the add/drop period, which will impact active student reports.

If an advisor assignment is input into the Student Information System without including the student's plan code, it will lead to unexpected data results. For example, missing plan codes in the advisor assignment screens may lead to a student with two majors showing an advisor for only one major or a student with only program-level advisors appearing to have no advisor at all.

The data source requires a one-to-one match of active plan to advisor data entry for a student's active plans (major, certificate, or degree). If you receive advisor data inconsistent with your expectations, please check with the office maintaining advisor assignments regarding their standard data input procedure.

Admissions

Undergraduate Admissions and Graduate data sources are university-wide enterprise resources that are sourced from the PeopleSoft student information system. This data is copied, transformed, and loaded into the data warehouse nightly, and subsequently loaded onto the Tableau Server into two separate sources. Data available today reflects yesterday’s PeopleSoft data. New data entered in PeopleSoft today will be in student mart and data source and dashboard tomorrow.

Class Enrollment and Grades

Class Schedule

Class Schedule contains data pertinent to the term-by-term class schedules, such as day/time, location, instructor, prerequisites, class credit, seat reserve, textbook, and fee information. In addition to generating a class schedule report, it can produce course listings, room usage reports, final exam details, lists of classes for the school by instructor, etc.

Graduation

Graduation contains students' awarded degree information, as well as demographic and graduation GPA data. This data source contains the most recent census data for degrees. The Graduation source supports reporting on graduation rates, average time to graduate, GPA average and median for conferred degrees, graduation population demographics, etc.

Retention and Graduation

Coming soon!

Student Enrollment

Student Enrollment contains personal, academic, advisor, and tuition data for any student enrolled for the specific term within a snapshot. It could be used to trend in-state and out-of-state student enrollment and tuition dollars over the years, broken down by demographics and academic information.

Student Enrollment and Tuition Forecasts

Student Enrollment and Tuition Forecasts contains student enrollment, tuition, and credits, as well as budgets (forecasts). The data is budgeted for school, career level, load, residency, and tuition attributes.

Public

Student Data Sources