List of students who were registered in a college a previous term and their current term's program information. This report is limited to a specific college and student level. This report is sorted by current college code and student name. A total UIN count is also included.

Universes

EDW – STU Registration Complete
EDW – STU Registration Limited

Data Rules Related to this Report

  • Students need to fit the following criteria to be included in this report: (1) the same student level between terms, (2) registered for BOTH the current and previous terms, and (3) students that have NOT changed programs.
  • This report is created using the sub-query functionality. This report returns a list of student UINs that match the prompt values (previous term, student level and college code). The sub-query UIN list is then used as an input into the main query, pulling "current term" program information for the "previous term" list of students.
  • Due to the complexity of this report, average run time for this report is 10 - 15 minutes.
  • When creating lists of students, you must ALWAYS include the Person Confidentiality Indicator for FERPA restrictions. Consult your campus OAR office for FERPA policy and guidelines.

Report

Preveous_Student_Current_College