IT Connect
Information technology tools and resources at the UW

RPG Release: New Filters and Fields on Study Abroad Report

In July, we added the Study Abroad Students by Unit Report to the BI Portal. Following that release, we received feedback from many users on how to make the report better. Based on this user feedback, the Report Prioritization Group just released several updates to the report. Run the report to see for yourself: Study Abroad Students by Unit Report.

Change Summary:

Based on user requests, we added several new filters to the Study Abroad report.

  • Quarter Filter:
    • The filter allows you to narrow down to specific UW Quarters of interest. Since some study abroad programs span multiple quarters, the filter allows you to select multiple UW Quarters.
  • Class:
    • The filter allows a user to filter down to specific class levels. This filter is consistent with other academic reports.
  • Residency:
    • The filter allows a user to filter down to specific residency codes. This filter is consistent with other academic reports.
  • Ethnicity:
    • The filter allows a user to filter down to specific ethnicities. This filter is consistent with other academic reports.
  • Columns to Display
    • Similar to other academic reports, this filter allows a user to choose the columns they want to display in the report.

We also added several new columns to the report. You can find these fields in the Columns to Display dropdown:

  • Major:

    • Displays the student’s Major(s) in three columns.
  • Gender:
    • Displays the student’s gender as it displays in SDB.
  • Current Class:
    • Displays the student’s current class level.
  • Class During Study Abroad
    • Displays the the student’s class standing during the quarter that they studied abroad based on the Quarter filter selection.
  • Residency: Displays the student’s residency status as it appears on their student_1 record in SDB.
  • Ethnicity: Displays the student’s ethnicity. This field is consistent with other academic reports.

We also released a few other enhancements to the report including:

  • Updated Quarter Column Display:
    • Updated the formatting of the Quarter column to display a quarter name instead of number (e.g. “2019 Winter”)
  • Duration Filter Removed:
    • By request from the Study Abroad office, we removed the Duration Filter from the report.
  • Updated Report Formatting:

    • We updated the formatting of the report to be consistent with other BI Portal reports.

Questions and Feedback:

This report references many concepts like Study Abroad Student and Study Abroad Program. To get detailed definitions for these and other terms, please check out Knowledge Navigator!

As always, if you have any questions, please write help@uw.edu and put “RPG: Study Abroad Students Report” in the subject line.