Admissions
Description
The Admissions Data Source underpins three separate dashboards with varying objectives: the Undergraduate Admissions, Graduate Admissions, and Admissions Lists dashboards.
The Undergraduate Admissions and Graduate Admissions dashboards support the high-level reporting needs of the University, focusing on the milestones reached by applicants over time, commonly known as the “admissions funnel.” They provide details for the admissions funnel and applicant pool profiles capturing admit, yield (deposit), enroll, and melt rates. As well, you can drill down into the academic and demographic profile of your applicant pool for the current admissions cycle. You may compare counts by "Admissions Week," "Term Census," and "Most Current." The dashboards were built to replicate the reporting out of the centralized Offices of the Provost and Admissions, with feedback gathered from admissions professionals throughout the University campuses.
The Admissions Lists dashboard was built to show aggregate lists of applications. It will aid in the creation of mailing lists, identifying groups of students, and quick searches for specific applications. Unlike the other admissions-related dashboards, this one shows information for each application in a single list. Therefore, an applicant who has submitted multiple applications may appear twice depending on the filters used to identify an applicant group.
Key Business Questions
The Undergraduate and Graduate Admissions dashboards can be used for answering a number of questions, such as:
Is our school trending above or below our application submissions compared to previous years?
What are the demographics of applicants associated with a specific school / degree program?
What does the admissions funnel look like for a specific population (by school, citizenship, residency, etc.)?
The Admissions List dashboard is helpful for answering questions such as:
Is our record maintenance consistent each term?
Which matriculated students have not enrolled yet for their admit term?
How can I spot check the status of applications for this upcoming term?
Can I get a mailing list for our communication campaigns (ex: closing the gap between admitted students and enrollment)?
Admissions Dashboards Usage Guide
The Undergraduate and Graduate Admissions dashboards function similarly with respect to their filtering capabilities and available views (Overview, Admissions Funnel Details, Academic Profile, and Demographic Profile).
Individuals may customize any of the dashboard tabs. For example, you can broaden the scope of terms, add demographic filter type, and more. Due to the complex nature of the admissions data source, we suggest reaching out to the Analytics Team, through a Help Desk ticket or an Analytics Doctor Appointment, if you have specific questions regarding customizations.
Note that some of the data fields are restricted. If you don't have access to restricted student mart data columns, these fields will appear as 'Null' or empty values. If access is needed, please see Federated Authorization.
Filters
For each dashboard within the Undergraduate and Graduate Admissions workbooks, you can improve the speed and performance by selecting your typical filters (school (program), comparison type, etc.) and saving it as a custom view. Click on the filter icon to reveal the menu. The filters will drill down to the admissions population you’d like to compare. Note that pre-filtering the population and saving this as a custom view will enhance performance speed.
Applicant vs. Application Counts
Because one applicant may submit any number of applications, the dashboards provide the data per applicant count and per application count. You may toggle between the applicant/application views as shown within the descriptions of the dashboard below.
Timing Matters!
When viewing admissions data, it’s important to consider both the the comparison type you’ve selected and the time of year. The admissions cycle and enrollment calendar follow different patterns, therefore you must keep in mind which comparison type you selected, where we are in the admissions cycle, and if the comparison type’s data overlaps with the enrollment calendar’s data. More details regarding about data snapshots are available here.
Viewing the comparison types below highlights important differences. Read through the image captions. With the examples' data update falling in December, enrollment data will look particularly strange and highlights the disconnect of admissions cycle to enrollment calendar.
Admissions Overview & Funnel Details
The Admissions Overview and Funnel Details tabs chart and count applications or applicants through the funnel stages: application, admit, deposited, and enrolled. Conversion rates are shown in a chart or table, allowing for quick visuals and calculations for reports and presentations. Both tabs provide three years of comparison that changes as you select different comparison types.
These dashboards provide information for three comparison years, the current admissions cycle and two years prior. The Overview tab charts applicant or application counts for a single comparison type at a time: ‘Week-to-week,’ ‘Term Census,’ and ‘Most Recent’ data comparisons. Meanwhile, the Funnel Details present all comparison types at once with calculations for admit, melt, and yield rates.
It is important to remember that both tabs present the most current data if the term census date has not been reached for the term in question. For the impact of your comparison type and the data upload date, see the Timing Matters section above.
Academic & Demographic Profiles
The Academic Profile tab provides a three-year comparison of applicants' test scores at the various stages of the admissions funnel. Like the other dashboards within the Admissions workbooks, you may select one of three comparison types: Admissions Week, Term Census, or Most Recent. Different from the other Admissions Dashboard tabs, the academic data exists per applicant and not per application. You can see below that there is not an option to toggle back and forth between applicant and application views.
The Demographic Profile tab provides visualizations of applicants or applications based on a selected status (admitted, deposited, etc.). Begin by filtering to a specific admit term and then setting the other filters to capture the population you’d like to review. This tab does not break down comparisons of terms or admissions years, instead you will see the most recent data based on the filter options and term you’ve selected.
Admissions Lists Dashboard
The Admissions Lists serve as a source for more detailed, per-application level of information. Viewing many lines of data at once is often useful for data clean-up and management of records maintenance practices. The Admissions Lists can also be used to review the status of admitted applicants, generate event invitation lists, and other tasks that may require applicant or student data before it is available in downstream information systems. Finally, these dashboards provide a searchable space the most recent data for specific applicants.
Individuals may customize any of the dashboard tabs. For example, you can broaden the scope of terms, add demographic filter type, and more. Due to the complex nature of the admissions data source, we suggest reaching out to the Analytics Team, through a Help Desk ticket or an Analytics Doctor Appointment, if you have specific questions regarding customizations.
Note that some of the data fields are restricted. If you don't have access to restricted student mart data columns, these fields will appear as 'Null' or empty values. If access is needed, please see Federated Authorization.
Graduate Admissions: Understanding Application Status
In an effort to standardize data entry and process for graduate admissions, the Office of the Provost provided guidelines to all graduate schools regarding the program action and program reason codes to use when creating and maintaining applicant records.
In summary, the guidelines are*:
This document outlines how Pitt schools must record graduate admissions decisions in PeopleSoft to ensure a complete and accurate applicant record. Applications are automatically loaded with an APPL status via the ABL integration, but all subsequent decisions must be entered manually. Every applicant record should follow a logical progression through admission, response, and matriculation stages, ending in either MATR (enrolled), WAPP (withdrawn/no response/deferred), or DENY. Schools are also responsible for cleaning up outstanding offers before a term begins and handling deferrals differently depending on whether the applicant has already been matriculated.
Applicant Status | Program Action Codes | Action Reason Codes - Description | Process |
|---|---|---|---|
On Waitlist | APPL | WLNR – Waitlist No Room | Manually added by School |
Not Offered Admission | DENY | DENY | Manually added by School |
To Receive Admission Offer | ADMT | PROV – Provisional | Manually added by School |
| ADMT | FULL - Full | Manually added by School |
Applicant Declines Offer | WAPP | ADMT – Admit Cancel | Auto-updated via student’s response in Campus Experience -OR- manually by school in edge case |
Applicant Accepts Offer | DEIN | Null-Intention to Matriculate | Auto-updated via student’s response in Campus Experience -OR- manually by school in edge case |
| MATR | null/blank – Matriculated | Manually added by School per their business process |
Student does not enroll, appears in Student Record (Program/Plan Stack) | DISC |
| Auto-updated via Registrar/PeopleSoft process that discontinues a term’s new MATR records that do not have an enrollment record, or has enrolled and dropped all classes. This process runs 5-6 days after the close of the add/drop period |
Applicant Does Not Respond to Offer | WAPP | NORE – No Response | Manually added by School before admit term start date |
Applicant Withdraws Application (Prior to Admissions Offer Recorded – ADMT or DENY) | WAPP | CAN – Applicant Withdrawal/Application Cancelled |
|
Deferred Admission (Prior to MATR) | WAPP | DEFR – Deferred | Manually added by School on original application |
Deferral After Matriculation | ADRV | MATR – Admission Revocation / Matriculation Withdrawal | Set by Registrar (via school-submitted IT Help Desk ticket. Must be submitted at least 10 business days before admit term start date; up to the discretion of the OUR) |
| DISC | Null – Discontinue | Auto-updated via Registrar/PeopleSoft process that discontinues a term’s new MATR records that do not have an enrollment record, or has enrolled and dropped all classes. This process runs 5-6 days after the close of the add/drop period |