Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Description

The Student Enrollment and Tuition Forecasts and Actuals Basic dashboard offers summary level aggregation of student enrollment, tuition, and credits, as well as forecasts (budgets). The data is budgeted for school, career level, load, residency, and tuition attributes.

You may use this dashboard as a template to build or customize your own versions of the dashboards for your needs. Read here for custom views.

The Student Enrollment and Tuition Forecast and Actuals Basic dashboard has most recent data for 15 years, as of previous business day, as well as census date data, captured for the last 5 years. It also has monthly snapshots (as of month' last day) from the beginning of enrollment for a term and capped at the census date for that particular term, going back for 5 years.

This dashboard in NOT to be used for individual student enrollment analysis.

Key Business Questions

This dashboard can be used to answer different enrollment-related business questions, such as:

  • How many students are enrolled in a particular term? What is the tuition amount?

  • What were the enrollment and tuition projections and what is the variance?

  • What is the enrollment/tuition for online programs?

  • What is the full-time enrollment at my school, and what is the tuition credited?

Basic Usage

The Student Enrollment and Tuition Basic Dashboard has four separate tabs, which can be accessed from the top of the view:

Enrollment and Tuition by Academic Plan

This dashboard reports enrollment, tuition, and credits. It does not have forecasts. It reports by school, career level, academic plan, tuition division, residency, and load. You can also expand this report to report by Academic Sub Plan and Academic Program, if needed.

There is a number of drop down filters on the top of the dashboard. You must select Academic Term, Snapshot Type, and Snapshot Date filters. Snapshot Type and Snapshot Date are coupled filters, where you first select the Snapshot Type, and then select a corresponding Snapshot Date. Filter settings can be saved using a custom view.

  • Academic Term filter - limits data to students enrolled in the term selected. You can select only one term.

  • Snapshot Type filter - options are Most Recent, Term Census, and Monthly - allows you to choose a date of when enrollment data was captured. “Most Recent” filter captures data as of a prior business day. “Term Census” captures data at a census date of the Academic Term selected.

  • Snapshot Date - after you select a snapshot type, you must select a correct date in the Snapshot Date filter. For example, for Academic Term 2234 (Spring Term 2022-2023) and Term Census snapshot type will show you data as of 2/4/2023, whereas term 2234 and Most Recent snapshot type will show data as of yesterday. You will see multiple Snapshot Dates for Monthly snapshot type, as monthly snapshots are taken from time when initial enrollment for a term starts and ends before the term census date. It is important to select one date for Monthly snapshot, otherwise the report will show summed up data for all the dates shown in Snapshot Date drop down

We strongly recommend applying at least one of the filters to optimize performance. You can reset the filters by clicking on a Revert button.

In the top right of the dashboard, the “Number of Students” display shows the number of students for the selected filters. Each student is counted once. However, in the tables and charts, there may be more than one record per student, as some students are enrolled in multiple programs/plans.

Term GPA will be 0.000 for terms currently in session and the future terms; term GPA will have data after a term is over and grades are processed.

 What data fields are available in the table?

The list below shows fields visible in the table at the bottom of the dashboard. The Tableau Data Source offers many additional fields. Users can utilize Tableau’s Web Edit feature to customize the table and add new fields for their own purpose(s). Because you are reporting new columns vs applying filters, this needs to be done with Web Edit and cannot be done using the custom view functionality described above.

  • Student Last Name

  • Student First Name

  • EMPLID

  • Preferred Email

  • Academic Program

  • Academic Plan

  • Academic Plan Type

  • Academic Sub Plan

  • Academic Plan Type

  • Admit Term

  • IPEDS Level

  • IPEDS First Time

  • Full of Part Time

  • Full Time Dissertation

  • Age this Year

  • Expected Graduation Term

  • Degree Checkout Status

  • Residency Code

  • Citizenship Status

  • Citizenship Country

  • Ethnic Group Code

  • Gender

  • Sex

  • Cumulative GPA

  • Cumulative Units

  • Total Units Taken GPA

  • Credits Billed

  • Tuition Credited

  • Units in Progress GPA

  • Term GPA

The “Students per Program/Plan” visualization can be expanded to show totals for Academic Plan and Subplan levels. Click on the ➕ sign that appears when hover over the “Academic Program” heading. Click on the ➖ sign next to “Academic Program” to collapse headings. Expanding these views will result in students being counted in each plan enrolled, meaning that the sum of individual bars may exceed the actual number of students within a given program.

Back to Top

Enrolled Student Mailing List

This dashboard provides a list of enrolled students, their contact information, and restricted gender/ethnicity/first generation. Restricted fields will have data only for users who have Student Mart restricted access granted (for information about access, see the section on data access). This table lists each student once, even if a student is enrolled in multiple programs/plans. It can be used for mailing purposes, contact lists, or other student lists. The data captures students as of yesterday.

Back to Top

Enrollment Demographics

This dashboard shows geographic and demographic profile of students in your program/plan/subplan.

The Residency bar chart can be used as a filter for other bar charts and maps. It allows you to see numbers for residents only. Residents are students whose residence code is set to R. All students who are residents are considered to be PA residents, regardless of their home address.

Back to Top

Enrollment Tuition and Counts

This dashboard shows student enrollment and tuition for your school. You have an option to include/exclude College in High School and Cooperative Education. The dashboard excludes Pitt-Outlier (UOUT) Academic Program and Semester at Sea. The student data is included in counts only for primary plans and for students whos split ratio b

Back to Top

What is the source of this information?

The primary source of these data is the PeopleSoft Student system. This data is copied, transformed, and loaded into the data warehouse nightly, and subsequently loaded onto the Tableau Server as the Student Enrollment and Tuition Data Source. Data available today reflects yesterday’s PeopleSoft data. New data entered in PeopleSoft today will be in student mart, data source, and dashboard tomorrow.

For Cognos Users: this data source is a close replica of the existing Cognos “St Enrollment and Tuitoin Query Pkg” package and is built from the student data mart (UD_DATA).

How do I get access?

Anyone with access to Student Mart (ST) will have access to the Student Enrollment and Tuition Basic Dashboard. Users will only see their RC, unless otherwise approved on their Federated Authorization form.

To request access to the Student Mart, please fill out Student Mart Federated Authorization form. Please visit the Student Mart Security page for a summary of the Student Mart security principals, or the Federated Authorization Community page for step-by-step instructions and FAQs about how requests are routed.

Note: access to PeopleSoft is distinct from Student Mart and requires a separate request.

Special permission is required to see restricted fields: performance indicators, student demographics, student identifiers, and instructor demographics. To request access to the restricted fields, make sure you check the box for restricted data access and select restricted data along with your description of the relevant justification or business need:

Status

PRODUCTION

  • No labels