Incoming International Students Report

This report was created for Business & Financial Services (BFS) to have access to an active list of admitted Non Resident students who have submitted a statement of intent to register (SIR). This data can be used to invite students to submit a GLACIER form. As the report provides live data, it may take a few seconds to load each time the report is opened or after a filter is selected.

Timing

The SIR deadline for Graduate Students is June 15 each calendar year. The report can be run after that date. Additionally, there tend to be a handful of exceptional late admits that can be captured by running the report once more after September 1. Any new students can be found by sorting on the SIR Date with a date after the last time the report was run.

Location and Instructions

The report is available in PowerBI (https://app.powerbi.com/home?experience=power-bi) and can be found under “My Apps” for those with access to the report. To add users to the BFS audience group, contact Melanie Hoven in GradDiv for approval. She can have a PBI programmer add the new user to the BFS audience for the this report.

To use the report to generate a list of incoming international students for a specific quarter, select the “Start Quarter” using the filter. This filtered list will provide all students who are scheduled to begin attending during that quarter by virtue of their application and positive response to statement of intent to registers (SIR). For example, for students who will start attending in Fall 2024, you would select Start Quarter 20234.

The list can then be downloaded into an Excel document.

To download a report:

1) click on the report name, “Incoming International Students”, and you will see the ellipsis (3 dots) to the right of the report header. Click the ellipsis and 2) select the Export data option.

3) In the pop-window, select Data with current layout and click the Export button.

Once the download is complete, the data file link will show at the bottom of the screen. Click the data file link to open. You can also find the file in your computer’s download folder.


To work with the data in Excel, you must first click Enable Editing. Also, note the Applied filters listed in the report. These are the filters that were applied to the data in the downloaded report.

 

If the data downloaded is not the data set expected, you can re-run the report by clicking the Data Reset to clear all filters and download the report again.

 

The data provided in report:

START YEAR – Academic year student will begin graduate program
START QUARTER – Academic quarter student will begin graduate program based on REG data (format: YYYYQ; Q4=Fall, Q1=Wtr, Q2=Spr, Q3=Smr)
APP YEAR – Academic year student submitted application for
APP QUARTER – Quarter student submitted application for (format: YYYYQ; Q4=Fall, Q1=Wtr, Q2=Spr, Q3=Smr)
DEFERRAL QUARTER - Quarter student requested admission deferral for (format: YYYYQ; Q4=Fall, Q1=Wtr, Q2=Spr, Q3=Smr)
STUDENT PERM - Perm number
STUDENT EMAIL - Email from SIR
MAJOR CODE – Graduate program major code
MAJOR NAME – Graduate program major
DEGREE OBJECTIVE – Graduate degree objective
SIR DATE – Date of SIR submission