IT Connect

Information technology tools and resources at the UW

Tag Archive for: RPG

Posts

Report Update: Undergraduates Eligible to Register

The Report Prioritization Group released important updates to the Undergraduates Eligible to Register Report. This post summarizes those changes.

Brief Summary:

Based on user feedback, we added a few new filters to the report, including:

  • Applied to Graduate filter
  • Include Requested Majors filter

We also updated the label for the following report filter:

  • “Include Applicants” filter was updated to read “Include New Confirmed”

Finally, we also updated the logic to:

  • Remove deceased students from the report population

Detailed Summary:

  1. The report was updated with a new filter that allows users to include or exclude students that have “applied to graduate”. By default the report will exclude students that have applied to graduate from the Eligible to Register population.
  2. By request, the report now filters out all deceased students from the report population.
  3. The “Include Applicants” filter was updated to read “Include New Confirmed” to clarify the filter’s meaning and purpose. The label changed, but the functionality and data did not. When a user selects “Yes”, the report includes undergraduates that have been granted admissions in the eligible quarter or 1 or 2 quarters back.
  4. The “Include Requested Majors” report filter was updated. The filter previously displayed the major that the student requested on their application (“Major Requested”). By request, the filter was updated to display the student’s “Intended Major” that they selected during registration. The report filter changed, but the student’s “Major Requested” information is not going away, and the data will still be displayed in the report. It’s important to note that these are different concepts at different points in the student lifecycle and therefore source different data. In the query, the report previously sourced only from the sr_adm_appl_req_col_major (the student’s requested major on their application), and now also includes data from student_1_pref_maj_abbr column (the student’s “intended major” selected during registration).

Questions?

If you have any questions, please write help@uw.edu and put “RPG: Undergraduates Eligible to Register Report” in the subject line.

Report Update: Undergraduates Eligible to Register

The Report Prioritization Group released an important update to the Undergraduates Eligible to Register Report. This post summarizes those changes as well as upcoming enhancements to the report.

Change Summary:

We recently updated the data source for the Undergraduates Eligible to Register report to a new table in the Enterprise Data Warehouse called “ACAD_dsetEligibleToRegister”. This update benefits users by getting the logic for identifying the report’s student population out of the report and into a table. This makes the report run faster, and enables data analysts with appropriate access to query the EDW to get the data directly (without having to recreate the report logic).

Impact:

There were no changes to the report filters or display. However, the report’s student population (see the definition for Eligible to Register) did change as a result of this update.

Before this update, for any given selected quarter, the report did not include students who had “applied to graduate”. Here “applied to graduate” means for instance, a student who applied to graduate in Autumn quarter would not be eligible to register in Autumn or future quarters.

That changed with this update. In the current version that is available on the BI Portal, students that have applied to graduate are included in the population.

What’s Next:

Based on initial feedback, this report needs to be updated to exclude students that have “applied to graduate”. The Enrollment Information Services Office is currently working on a solution, and we are planning to publish the updated report in early January.

Additionally, two other updates will be included in the next release:

- First, by request, the report will be updated to remove students that are deceased from the report’s population of students.

- Second, the “Include Requested Majors” filter will be updated. The filter currently displays the major that the student requested on their application (“Major Requested”). By request, the filter will be updated to display the student’s “Intended Major” that they selected during registration. The report filter is changing, but the student’s “Major Requested” is not going away, and the data will still be displayed in the report. 

Questions?

When the updated report is published to the BI Portal, you will receive an email update.

In the meantime, if you have any questions, please write help@uw.edu and put “RPG: Undergraduates Eligible to Register Report” in the subject line.