Find the Right Query

Tips:

• Select a Specialization As of Date that falls within the Academic Period of admission.
  • This is particularly important when looking back/forward in time.
• Filter Specialization Category to the following to reduce lines per student to Degree-Seeking Majors only:
  • Undergraduate Major, Undergraduate Pre-Major, Undergraduate Pre-Professional, Graduate Specialization, Law Major.   
• Filter Admission Status to Approved to view only admitted students.
• Filter Admission Code to ONLA to view only Accelerated Online students.
• Keep in mind that applications can be moved or changed, so pulling the data today (looking back at a year ago) will not pull the same results that would have been pulled had it been queried a year ago.
• The Enrolled marker key figure indicates that the student has a (not-cancelled) booking record for the term - this does not include transfer work.

Tips:

• Select a Specialization As of Date that falls within the Academic Period for Enrollment.
• This is particularly important when looking back/forward in time.
  Change Registration Status for past terms (or if a subsession has been completed) to Booked (1), Completed Successfully (2), Completed Unsuccessfully (3).
• Filter Specialization Category to the following to reduce lines per student to Degree-Seeking Majors only:
  • Undergraduate Major, Undergraduate Pre-Major, Undergraduate Pre-Professional, Graduate Specialization, Law Major.
  • For Accelerated Online students, leave this filter open (this is housed at the specialization level in this query, usually under a Track Specialization Category).
• Progress Classification is always current, regardless of the Academic Period selected on the variable screen.
• The Student Count does not include students who have only transfer work.
  

Tips:

• This query populates with those students eligible to enroll, as of current day, who have not enrolled.
  • Eligible to Enroll includes: Open matric (open study segment), not graduated or a graduate candidate for current/future term, not suspended.
• When a registration window opens up for an upcoming fall or spring term, the query will evaluate not enrolled for that newly opened term and no longer the current term.
• Filter Specialization Category to the following to reduce lines per student to Degree-Seeking Majors only:
  • Undergraduate Major, Undergraduate Pre-Major, Undergraduate Pre-Professional, Graduate Specialization, Law Major.
• Use the Academic Period Last Enrolled to narrow your stop out range of your student group.
• If a student has a Hold Affecting Enrollment (key figure) >=1, the student must take action before enrolling.

Tips:

• Select a Specialization As of Date that falls within the Academic Period you are interested in (if you are looking forward to a future term, you will need to adjust this date to reflect a date within the term to capture the students who will not have an open study segment until that term begins).
• Filter Specialization Category to the following to reduce lines per student to Degree-Seeking Majors only:
  • Undergraduate Major, Undergraduate Pre-Major, Undergraduate Pre-Professional, Graduate Specialization, Law Major.
  • For Accelerated Online students, leave this filter open (this is housed at the specialization level in this query, usually under a Track Specialization Category).
    

Tips:

• Select a Specialization As of Date that falls within the Academic Period you are interested in (if you are looking forward to a future term, you will need to adjust this date to reflect a date within the term to capture the students who will not have an open study segment until that term begins).
• Filter Specialization Category to the following to reduce lines per student to Degree-Seeking Majors only:
  • Undergraduate Major, Undergraduate Pre-Major, Undergraduate Pre-Professional, Graduate Specialization, Law Major.
  • For Accelerated Online students, leave this filter open (this is housed at the specialization level in this query, usually under a Track Specialization Category).
• If working under more than one Employee ID for advising duties, include all relevant (separated with a ;) in the Advisor field on variable screen.  

Tips:

• Note that Graduation Status will change depending on whether you are looking at current/future (Graduation Candidate) v. past (Graduated).
• Date of Conferment is the graduation date of the student.
• To see Accelerated Online, filter Delivery Mode (Specialization) to Online Accelerated Delivery.

Tips:

• Change Registration Status for past terms (or if a subsession has been completed) to Booked (1), Completed Successfully (2), Completed Unsuccessfully (3).
  
• Offering Org Unit (Course) is the organizational unit that offered the course.
  • Superior Org Unit can be selected through the Organizational Plan hierarchy on the variable screen while selecting Offering Org Unit (Course).
• Progress classification is always current regardless of the Academic Period (Enrollment) selected.

Tips:

• Filter Specialization Category to the following to reduce lines per student to Degree-Seeking Majors only:
  • Undergraduate Major, Undergraduate Pre-Major, Undergraduate Pre-Professional, Graduate Specialization, Law Major.   
    
• Superior Org Unit can be selected through the Organizational Plan hierarchy on the variable screen while selecting Offering Org Unit (Specialization).

Tips:

• You will only see data for courses in which you have been listed as the instructor for the course section in BW.
  • Note that only one instructor can be listed per course section in BW.