Bi-Portal Report Access | First Year Programs

If you prefer to stay connected with all or a subset of students, consider running a bi portal report. A popular report that we use to see first years is the "All Applicants" report.

First, please request access to the EDW.

Run Report (see picture below)

Select Report - All Applicants
Make sure application type is updated
Make sure application status is 15 or 16 (means that they have confirmed coming to UW)
1. Once school starts you will look for application status 12 - enrolled
Make sure "columns to display" everything is checked
Once you run the report you will want to remove the "majors to remove" that are listed below.

If you have additional questions about excel or pivot tables, please do not hesitate to reach out to LeAnne (ljwiles@uw.edu).

Majors to Remove

Remove the following Majors from your data - they are exchange and online students.

ECE

ECFS O

HIHME

ISS O

MEDXD

MEDXC

NURS

XAUP

XA&S

XBSAD

XDENT

XENGR

XENV

XLAW

XLIS

XMED

XNURS

XPBAF

XPHAR

XPHCM

XSOCW

First Year Programs

120 Mary Gates Hall Box 352825
Seattle, WA 98195-2825

Hours

Mary Gates Hall 120
Academic Year: Mon-Fri 8:30 a.m.– 4:30 p.m.
Summer: Mon-Thurs 7:30 a.m.– 4:30 p.m., Fri 8 a.m.–12 p.m.
Winter Break: Mon-Fri 8:30 a.m.–12:00 p.m.

Commuter and Transfer Commons (HUB 141)
Academic Year: Mon-Fri 8 a.m.–5 p.m.
Breaks & Summers: Closed

Closed during University holidays.

Phone

206-543-4905 (Voice)
206-207-5564 (Text)

Feedback

Provide FYP with anonymous feedback about our programs.
chat Submit feedback here

First Year Programs fosters a successful undergraduate student experience through strategic programming that focuses on positive academic transitions and the development of learning communities. Through partnerships with faculty, staff, alumni, and student leaders our programs create the space for students to define how they will engage, learn, and thrive at the University of Washington.

Connect

mail

Make a Gift Terms Privacy