Before You Begin:
For directions on opening the ssem2000 database please review the quicknote What is Banner Reporting -ssem2000? which can be found using this link: www.umflint.edu/helpdesk/articles/159.

Banner Reporting Time
Please be aware that reports could take up to 20 min to run.  During high volume times, such as the beginning and ends of the semesters, reports could take even longer do to the amount of reports being run acrossed campus. If you are experiencing report times of longer than 20 min (outside of high volume times) please contact the ITS HelpDesk at 810-766-6804 and a ticket will be placed. Student Information:

  1. Open the ssem2000 database
  2. Double-click on the Student Information form in the database window. You will be notified that the report data is current as of the moment it is run.
  3. Click OK. 
All options on the Student Information form require the user to select a term from the drop-down list provided. You will be prompted to login using your Banner ID and password before the term list will display.

Do not attempt to type a term code or to click on any report button prior to selecting a term from the list provided; otherwise, the form will not work properly and must be reset by clicking the Close Form button.
Report Information
For each of the Student Information report not marked as active, users have the option to print the report or download it to a file.  Users will see two columns of buttons in the Student Informtaion form. Both columns contain teh same reports.  The first column, titled Print Reports, will allow users to view the report on the screen and print it using the print icon on the toolbar.  The second column, titled Download Files, will produce the report in the form of a a text file saved on your local hard drive.  Those reports marked as active will be available in a downloadable format only.  Below are details about the various Student Information reports.


The following reports are available in the Student Information form as Printable Reports.

The following reports are available in Downloadable format in the Student Information form.

Report Descriptions
Registered Students by Major (Address/Phone/Email)
In this report, users can specify up to 3 major codes and retrieve an alphabetized list of all students in those majors who are registered for the specified term. 

On Screen View of the report output includes: Name, ID, Degree, Major(s), Cumulative Hours, Address, Phone Number, and Email Address.

Downloadable Version of this report output includes: Name, ID, Address, Phone, Residence Hall(RH) Address, Email, Level, Student Type, College(s), Degree(s), Major(s), Concentration(s), Minor(s), Educational Goal, Cumulative Hours, and Cumulative GPA.

To run the report:
  1. Click on Registered Students by Major (Address/Phone/Email List) to view the report on your screen, or click on Create File of Registered Students by Major (Address/Phone/Email) to save the report to a file.
  2. When prompted, enter the 1st major code (upper-case, e.g.: ENG) and click OK.
  3. When prompted, enter the 2nd major code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.
  4. When prompted, enter the 3rd major code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.
  5. The report will then begin to run.
  • Option A: If you chose to view the report, it will be displayed on the screen and can be printed using the print icon on the toolbar.
  • Option B: If you chose to create a file of the report, it will be saved to the location you specified.

-----------------------------------------------------------------------------------------------------------------------------

Registered Students by Major (Detailed)
In this report, users can specify up to 3 major codes and retrieve an alphabetized list of all students in those majors who are registered for the specified term. 

On Screen View of the report output includes ID, Name, Address, Phone Number, Birthdate, Ethnicity, Gender, Level, Student Type, Degree, Major(s), Concentration(s), Class Standing, Registered Term Hours, Total Earned Hours, Cumulative GPA, Educational Goal, and Email Address. 

Downloadable Version of this report output includes: Name, ID, Address, Phone, Residence Hall(RH) Address, Email, Level, Student Type, Expected Graduation Date, College(s), Degree(s), Major(s), Concentration(s), Minor(s), Educational Goal, Ethnicity, Birthdate, Gender, Class, Advisor, Term Credit Hours, Cumulative Hours, and Cumulative GPA.

Students are grouped by level, then name.

To run the report:

  1. Click on Registered Students by Major (Detailed List) to view the report on your screen, or click on Create File of Registered Students by Major (Detailed Info) to save the report to a file.
  2. When prompted, enter the 1st major code (upper-case, e.g.: ENG) and click OK.
  3. When prompted, enter the 2nd major code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.
  4. When prompted, enter the 3rd major code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.
  5. The report will then begin to run.
  • Option A: If you chose to view the report it will be displayed on the screen and can be printed using the print icon on the toolbar.
  • Option B: If you chose to create a file of the report, it will be saved to the location you specified.

-----------------------------------------------------------------------------------------------------------------------------

Registered Students by Minor (Address/Phone/Email)
This report allows users to enter a minor code and retrieve an alphabetized list of all students with that minor who are registered for the specified term. 

On Screen View of the report output includes Name, ID, Degree, Cummulative Hours, Major(s), Minor(s), Address, Phone Number and E-mail Address.

Downloadable Version of this report output includes: Name, ID, Address, Phone, Residence Hall(RH) Address, Email, Level, Student Type, College(s), Degree(s), Major(s), Concentration(s), Minor(s), Educational Goal, Cumulative Hours, and Cumulative GPA.

To run the report:

  1. Click on Registered Students by MINOR (Address/Phone/E-mail List) to view the report on your screen, or click on Create File of Registered Students by Minor (Address/Phone/E-mail) to save the report to a file.
  2. When prompted, enter a minor code (upper-case, e.g.: ENG) and click OK.
  3. The report will then begin to run.
  • Option A: If you chose to view the report it will be displayed on the screen and can be printed using the print icon on the toolbar.
  • Option B: If you chose to create a file of the report, it will be saved to the location you specified.

-----------------------------------------------------------------------------------------------------------------------------

Registered Minority Students by Term
This report will retrieve an alphabetized list of all students registered for the specified term who have reported a minority ethnic status.

Output includes ID, name, address, phone number, birthdate, ethnicity, gender, level, student type, degree, class standing, registered term hours, total earned hours, cumulative GPA and email address. Students are grouped by ethnicity code.

To run the report:

  1. Click on Minority Students Registered for Term Report to view the report on your screen, or click on Create File of Minority Students to save the report to a file.
  2. The report will then begin to run.
  • Option A: If you chose to view the report it will be displayed on the screen and can be printed using the print icon on the toolbar.
  • Option B: If you chose to create a file of the report, it will be saved to the location you specified.

-----------------------------------------------------------------------------------------------------------------------------

Advising Report by Major
This report is intended for use with the web-based advisor holds process. It allows users to specify a major code and retrieve all students in that major who are eligible to enroll for the specified term (i.e., have attended courses in the past year). This list will correspond exactly with the group of students selected by the advisor hold process when applying holds by major.

On Screen View includes ID, name, level, student type, degree, total earned hours, cumulative GPA, primary advisor, and advisor hold information (department, user, reason and release date).

Downloadable Version of this report output includes: Name, ID, Address, Phone, Residence Hall(RH) Address, Email, Level, Student Type, Expected Graduation Date, College(s), Degree(s), Major(s), Concentration(s), Minor(s), Educational Goal, Ethnicity, Birthdate, Gender, Class, Advisor, Term Credit Hours, Cumulative Hours, and Cumulative GPA.

The printed report is alphabetized by name and grouped by level. 

To run the report:

  1. Click on Advising Report by Major to send the report directly to your printer, or click on Download Detailed Advising Report to save the report to a file.
  2. When prompted, enter a major code (upper-case, e.g.: ENG) and click OK.
  3. The report will then begin to run. 
  • Option A: If you chose to view the report it will be displayed on the screen and can be printed using teh print icon on the toolbar. 
  • Option B: If you chose to create a file of the report, it will be saved to the location you specified.

-----------------------------------------------------------------------------------------------------------------------------

Student Schedule Report
This report is a printer friendly version of the information on the student registration form. 

Output includes the student ID, name, course(s), course status(es) and credit hours.

To run the report:

  1. Click on Student Schedule to display the report on your screen
  2. When prompted, enter a Student’s UMID and click OK.social security number will not work
  3. The report will be displayed on the screen when it has completed and can be printed using the print icon on the toolbar.

-----------------------------------------------------------------------------------------------------------------------------

Registration Audit Report
This report is a printer friendly version of the information on the student registration audit form SFASTCA.

It is sorted by sequence number (chronologically). It shows all updates and attempts to update a student’s classes.

To run the report:
  1. Click on Registration Audit Report to view the report on your screen.
  2. When prompted, enter a Student’s UMID (social security number will not work) and click OK.

The report will displayed on the screen when it has completed and can be printed using the print icon on the toolbar.

The Following Reports are Only Available as Downloadable Documents:
Output for these Downloadable Reports Includes ID, Name, Address, Phone, Residence Hall(RH) Address, Email, Level, Student Type, Expected Graduation Date, College(s), Degree(s), Major(s), Concentrations(s), Minor(s), Educational Goal, Ethnicity, Gender, Cumulative Hours, Cummulative GPA.

-----------------------------------------------------------------------------------------------------------------------------

Active Students By Major (Detailed Information)

To run the report:
  1. Click on Active Students by Major (Detailed Info) 
  2. Choose a file type to export the report into. Click OK
  3. Enter a file name and choose a location to save the report to. Click OKYou will need to remember this location in order to find the file after the report is done compiling. 
  4. When prompted, enter the 1st major code (upper-case, e.g.: ENG) and click OK.
  5. When prompted, enter the 2nd major code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.
  6. When prompted, enter the 3rd major code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.
  7. The report will then begin to run. 
  8. Once the report is complete you will see a dialogue box that says " Export Complete" Click OK
  9.  You will now need to go to the location in which you saved the report in the first step and double click the file to open it.


-----------------------------------------------------------------------------------------------------------------------------

Active Students By Minor (Detailed Information)

To run the report:
  1. Click on Active Students by Minor 
  2. Choose a file type to export the report into. Click OK
  3. Enter a file name and choose a location to save the report to. Click OKYou will need to remember this location in order to find the file after the report is done compiling. 
  4. When prompted, enter the 1st minor code (upper-case, e.g.: ENG) and click OK.
  5. When prompted, enter the 2nd minor code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.
  6. When prompted, enter the 3rd minor code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.
  7. The report will then begin to run. 
  8. Once the report is complete you will see a dialogue box that says " Export Complete" Click OK
  9. You will now need to go to the location in which you saved the report in the first step and double click the file to open it.
-----------------------------------------------------------------------------------------------------------------------------

Active Students By Educational Goal

To run the report:
  1. Click on Active Students by Educational Goal
  2. Choose a file type to export the report into. Click OK
  3. Enter a file name and choose a location to save the report to. Click OKYou will need to remember this location in order to find the file after the report is done compiling. 
  4. When prompted, enter the 1st Educ. Goal code (upper-case, e.g.: ENG) and click OK. These codes can be located on the right side of main reports page. 
  5. When prompted, enter the 2nd Educ. Goal code (upper-case, e.g.: HIS) and click OK. Leave blank and click OK if no other major is desired.
  6. When prompted, enter the 3rd Educ. Goal code (upper-case, e.g.: SOC) and click OK. Leave blank and click OK if no other major is desired.
  7. The report will then begin to run. 
  8. Once the report is complete you will see a dialogue box that says " Export Complete" Click OK
  9. You will now need to go to the location in which you saved the report in the first step and double click the file to open it.
-----------------------------------------------------------------------------------------------------------------------------

Active Minority Students

To run the report:
  1. Click on Active Minority Students
  2. Choose a file type to export the report into. Click OK
  3. Enter a file name and choose a location to save the report to. Click OKYou will need to remember this location in order to find the file after the report is done compiling. 
  4. The report will then begin to run.
  5. Once the report is complete you will see a dialogue box that says " Export Complete" Click OK
  6. You will now need to go to the location in which you saved the report in the first step and double click the file to open it.
Active Students: Student has registered within the last year, or is eligible to register. It does not necessarily mean that the student is registered for the term selected.
Other Helpful Banner Reporting Articles
For more information on banner reporting please reference the articles linked below.  If what you are looking for is not found below and someone in your department can not provide you with your departments procedure for the task please contact the ITS HelpDesk at 810-766-6804 and we will do our best with getting you assistance with your task.

 Article Title

 Article Location

 What is Banner?  www.umflint.edu/helpdesk/articles/140
 What is Banner Reporting - ssem2000?  www.umflint.edu/helpdesk/articles/159  
 Banner Course Information Reports  www.umflint.edu/helpdesk/articles/71
 Banner Transcript Analysis Reports  www.umflint.edu/helpdesk/articles/73  
 Banner Graduation Information Reports  www.umflint.edu/helpdesk/articles/75